Job Summary
We are looking for a highly skilled PostgreSQL SME with deep expertise in PostgreSQL internals, performance tuning, high availability, and enterprise-scale database architecture. The ideal candidate will lead complex database initiatives, provide technical guidance, and ensure optimal performance, reliability, and scalability of PostgreSQL environments.
Key Responsibilities
- Provide advanced expertise in PostgreSQL internals including storage, indexing, query planning, and memory management.
- Architect, design, and implement scalable PostgreSQL solutions for enterprise applications.
- Oversee installation, configuration, upgrades, and ongoing maintenance of PostgreSQL databases.
- Lead performance tuning, query optimization, and indexing strategy initiatives.
- Design and implement High Availability and Disaster Recovery solutions (replication, clustering, failover).
- Troubleshoot and resolve complex database issues to ensure minimal downtime.
- Create and enforce database standards, security, and compliance policies.
- Develop automation scripts for monitoring, backups, and maintenance tasks (Python, Bash, Ansible).
- Provide mentorship and technical guidance to development and DBA teams.
- Stay updated with PostgreSQL advancements and incorporate improvements where relevant.
- Prepare and maintain detailed documentation on architecture, configurations, and best practices.
- Participate in PostgreSQL community discussions, forums, or open-source contributions (preferred).
Required Skills & Experience
- Proven experience managing and architecting large-scale PostgreSQL databases.
- Strong understanding of PostgreSQL architecture, replication, partitioning, and indexing.
- Expertise in performance tuning, query optimization, and troubleshooting.
- Hands-on experience with SQL, PL/pgSQL, and database scripting.
- Experience with monitoring tools (pgAdmin, Datadog, Nagios, etc.).
- Strong knowledge of high availability and disaster recovery mechanisms.
- Experience with automation tools: Ansible, Terraform.
- Experience working on ETL, data warehousing, and data pipelines.
- Good understanding of data security and compliance standards.
- Strong analytical, problem-solving, and communication skills.
Preferred Skills
- Experience with AWS RDS, Azure Database for PostgreSQL, or other cloud platforms.
- Knowledge of DevOps practices and CI/CD pipelines.
- Familiarity with other databases (MySQL, Oracle, etc.).
- Strong scripting skills (Python, Bash).
Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.