Job Summary
Job Title: PostgreSQL Consultant
Job Summary: We are seeking an experienced PostgreSQL Consultant to join our team. As a PostgreSQL Consultant, you will work with clients to design, implement, and optimize PostgreSQL-based solutions. You will be responsible for ensuring seamless integration, scalability, and performance of PostgreSQL databases along with automation of repetitive tasks.
Key Responsibilities
- Collaborate with clients to understand their requirements and provide solutions using PostgreSQL features like replication, partitioning, and window functions
- Design, develop and implement highly available solutions using logical and streaming replication tools.
- Troubleshoot and resolve PostgreSQL-related issues using PostgreSQL logs, monitoring tools like pg_stat_statements, and performance metrics
- Develop and deliver PostgreSQL training and workshops covering topics like PostgreSQL security, backup and recovery, and scalability
- Stay up-to-date with PostgreSQL advancements and best practices, including new features and releases
Skill Requirements
- 8+ years of experience with PostgreSQL
- Strong understanding of PostgreSQL data modeling, indexing, query optimization, and performance tuning
- Experience with PostgreSQL deployment, scaling, security, and backup and recovery strategies
- Proficiency in PostgreSQL tools and frameworks like pgAdmin, psql, and PostgreSQL Extensions (e.g., PostGIS, TimescaleDB)
-Extensive experience of working with Linux- RHEL or Ubuntu for managing database servers
- Proficient with Shell scripting
- Strong problem-solving and communication skills
- Experience working with clients and teams
Nice to Have:
- Experience with MongoDB
- Knowledge of Ansible and PuppetDB
Knowledge of cloud platforms (e.g., AWS, Azure, Google Cloud) and PostgreSQL-as-a-Service offerings
- Certification in PostgreSQL or related technologies like PostgreSQL Certified Developer or PostgreSQL Certified DBA