Database Administrator

JOB RESPONSIBILITIES

     Installation & configuration 

• Install, configure, and upgrade PostgreSQL and EDB Postgres servers across development, staging, and production environments. 
• Set up database instances, roles, permissions, and connection settings. 
• Configure and maintain connection pooling using Pgpool-II or PgBouncer, based on workload and architecture needs. 
• Design, deploy, and manage high-availability clusters using EDB Postgres Failover Manager (EFM). 
• Operate multi-node clusters with automated failover, load balancing, and query routing; validate failover readiness. 
• Configure and manage streaming and logical replication. 

• Monitor replication lag and maintain standby servers. 

  Performance tuning & optimization 

• Tune queries, indexes, and server configuration parameters (memory, checkpoints, WAL, autovacuum settings). 
• Analyze query plans (EXPLAIN/ANALYZE) to identify and resolve bottlenecks, locking, and slow queries. 
• Perform capacity planning and manage growth of the database estate. 
• Configure and tune autovacuum (thresholds, scale factors, cost limits, per-table overrides) to control table and index bloat. 
• Run manual VACUUM ANALYZE and VACUUM FULL based on need, managing the trade-off between space reclamation and locking impact. 
• Monitor dead tuples, transaction ID wraparound, and bloat, and act proactively to prevent performance degradation. 
• Design and implement table partitioning (range, list, hash) for large tables to improve performance and manageability. 
• Manage partition lifecycle — creating, attaching, detaching, and pruning partitions. 

• Optimize queries to benefit from partition pruning and maintain partitioned indexes. 

  Scheduled / off-hours maintenance 

• Plan and execute maintenance during night or low-traffic windows to minimize impact on production. 
• Perform data slimming — archiving, purging, or trimming obsolete data to control database size. 
• Run VACUUM ANALYZE or VACUUM FULL as required based on bloat and workload conditions. 
• Schedule reindexing and other heavy maintenance within approved windows. 
• Monitor index health and bloat, and perform reindexing (including REINDEX CONCURRENTLY) to restore performance. 

• Schedule reindexing to minimize impact on production workloads. 

  Backup & recovery (pgBackRest) 

• Design and manage backup strategies using pgBackRest — full, differential, and incremental backups. 
• Configure and maintain pgBackRest repositories (local and/or remote/offsite), retention policies, and WAL archiving. 

• Perform and regularly test point-in-time recovery (PITR) and restore procedures. 

  Security & compliance 

• Manage user access, roles, and privileges following least-privilege principles. 
• Apply security patches and enforce data protection and compliance requirements. 

• Audit database activity as required. 

  Monitoring & incident response

• Set up monitoring and alerting for availability, performance, replication, vacuum/bloat, and backup status. 

• Respond to incidents and perform root-cause analysis. 

  Collaboration 

• Work with developers to review schema design, queries, and data models. 
• Support application and infrastructure teams with database deployments and issues. 
• Document configurations, cluster architecture, backup/recovery procedures, and maintenance standards. 

JOB REQUIREMENTS

• Proven experience administering PostgreSQL and EDB Postgres in production. 
• Strong SQL and knowledge of database internals (query planning, indexing, MVCC, vacuum mechanics). 
• Hands-on experience with table partitioning, reindexing, and autovacuum tuning at scale. 
• Experience with connection pooling using Pgpool-II and/or PgBouncer. 
• Experience with EDB Postgres Failover Manager (EFM) and high-availability clusters. 
• Experience configuring and managing pgBackRest backup repositories and PITR. 
• Experience with streaming/logical replication and high availability. 
• Familiarity with Linux/Unix administration and shell scripting. 
• Willingness to perform scheduled maintenance during off-hours/night windows. 
• Understanding of monitoring tools and database security practices. 
• Relevant degree or equivalent experience; PostgreSQL/EDB certification a plus.