Postgres DBA

Job Description: 

We are looking for an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize PostgreSQL database environments. The ideal candidate will have strong expertise in database administration, performance tuning, backup and recovery, database security, high availability, and troubleshooting. The role involves ensuring database availability, reliability, scalability, and performance while supporting application development and production operations.

Key Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL database servers.
• Perform database administration activities, including database creation, configuration, user management, and access control.
• Monitor database performance and optimize SQL queries, indexes, execution plans, and database configurations.
• Implement and manage database backup, recovery, and disaster recovery strategies.
• Configure and maintain high availability and replication solutions, including streaming replication and failover.
• Perform routine database health checks, capacity planning, and performance monitoring.
• Troubleshoot database issues, locks, deadlocks, connection problems, and performance bottlenecks.
• Manage database security, roles, privileges, authentication, and auditing.
• Support database migrations, version upgrades, patching, and schema changes.
• Work closely with developers to review SQL queries, database schemas, indexing strategies, and application performance.
• Monitor database availability and ensure compliance with operational standards and SLAs.
• Automate routine DBA tasks using scripting and database administration tools.
• Maintain database documentation, operational procedures, and recovery plans.
• Participate in production support, incident management, root cause analysis, and problem resolution.
• Support cloud-based PostgreSQL deployments, where applicable.

Required Technical Skills

• Strong hands-on experience in PostgreSQL database administration.
• Good understanding of PostgreSQL architecture, configuration, and internal processes.
• Expertise in SQL, PL/pgSQL, query optimization, and execution plan analysis using EXPLAIN and EXPLAIN ANALYZE .
• Experience with indexing strategies, partitioning, vacuuming, autovacuum, and statistics management.
• Hands-on experience with database backup and recovery using tools such as pg_dump , pg_restore , and pg_basebackup .
• Knowledge of replication, high availability, failover, and disaster recovery.
• Experience with PostgreSQL monitoring and performance tuning.
• Strong understanding of database security, roles, privileges, and access management.
• Experience with Linux/Unix environments and shell scripting.
• Familiarity with database connection management, connection pooling, and resource utilization.
• Experience with database upgrades, patching, migration, and troubleshooting.

Preferred Skills

• Experience with cloud-managed PostgreSQL services such as Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL for PostgreSQL.
• Knowledge of PostgreSQL clustering and HA tools such as Patroni, repmgr, or PgBouncer.
• Experience with monitoring tools such as pgstatstatements, Prometheus, Grafana, or other database monitoring solutions.
• Familiarity with automation tools, configuration management, and scripting using Python or Bash.
• Understanding of database replication across environments and disaster recovery planning.
• Experience supporting large-scale, high-transaction production databases.
• Knowledge of database security best practices and compliance requirements.

Educational Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.