PostgreSQL Database Administrator (DBA)

Job Description for Postgres SME

Responsibilities:

We are seeking a PostgreSQL Subject Matter Expert (SME) with in-depth knowledge of PostgreSQL internals, and extensive hands-on experience with enterprise-level PostgreSQL implementations. The ideal candidate will provide expert guidance, drive best practices, and contribute to the optimization and scalability of our PostgreSQL database systems. The SME will be responsible for guiding complex database projects, offering strategic insights, and ensuring best practices are followed in all aspects of database management.

 Should be able to provide advanced expertise in PostgreSQL internals, including storage, indexing, query optimization, and memory management.  Provide expert advice on PostgreSQL architecture, design, and best practices to internal teams and stakeholders.

 Oversee the installation, configuration, upgrading, and maintenance of PostgreSQL databases and related applications.

 Lead and mentor development and database administration teams in PostgreSQL best practices and advanced features.

 Analyse and optimize database performance, including query tuning, indexing strategies, and hardware utilization.

 Design and implement high availability and disaster recovery solutions, such as replication, clustering, and failover strategies.

 Troubleshoot and resolve complex database issues, ensuring minimal downtime and optimal performance.

 Develop and enforce database standards, security policies, and compliance measures.

 Create and maintain detailed documentation on PostgreSQL database configurations, procedures, and architectural decisions.

 Develop automation scripts and tools to streamline database operations, including backups, maintenance, and monitoring.

 Mentor junior database professionals and provide training on advanced PostgreSQL topics.

 Stay current with PostgreSQL advancements and incorporate relevant technologies and methodologies to improve database systems.

 Actively participate in Postgres communities and forums for the contribution to the Postgres ecosystem.

Skills:

 Proven experience in designing and managing large-scale PostgreSQL databases.

 In-depth knowledge of PostgreSQL architecture, replication, partitioning, and indexing.

 Proficiency in SQL and PL/pgSQL programming.

 Strong understanding of database performance optimization techniques.

 Experience with database monitoring tools (e.g., pgAdmin, Datadog, Nagios).

 Familiarity with automation tools (e.g., Ansible, Terraform).

 Hands-on in data warehousing and ETL processes.

 Knowledge of data security best practices.

 Excellent problem-solving and analytical skills.

 Effective communication and interpersonal skills.

 Experience with cloud database platforms (e.g., AWS RDS, Azure Database for PostgreSQL).

 Familiarity with other database technologies (e.g., MySQL, Oracle) and data warehousing solutions.

 Knowledge of DevOps practices and CI/CD pipelines.

 Experience with automation tools and scripting languages (e.g., Python, Bash, Ansible). Qualifications: Education: Bachelor's or master's degree in computer science, Information Technology, or a related f ield.

Summary

 PostgreSQL Internals & Architecture: Deep expertise in PostgreSQL storage, indexing, query optimization, and memory management.

 Performance Optimization: Proficiency in query tuning, indexing strategies, and database performance optimization techniques.

 High Availability & Disaster Recovery: Experience with replication, clustering, and failover strategies for high availability.

 Automation & Scripting: Experience in automation tools (Ansible, Terraform) and scripting languages (Python, Bash).

 Cloud Platforms & DevOps: Experience with cloud database platforms (AWS RDS, Azure) and knowledge of DevOps practices and CI/CD pipelines.