Subject Matter Expert (Support&Ops)

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 pg Admin, 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

Other Requirements

null