Senior PostgreSQL DBA - Contract (1 Year)

This is a senior Site Reliability Engineering role at a Tier-1 North American telecommunications provider. The team maintains the PostgreSQL database infrastructure powering the company’s modern application platforms - ensuring continuous availability, performance, and zero data loss for millions of subscribers. The engineer owns HA architecture, replication, backup/recovery, and observability for production PostgreSQL environments., * Design, implement, and maintain PostgreSQL databases - schema design, indexing strategies, query optimization, logical/physical replication, hot standby failover, and load balancing

• Develop and execute backup and recovery strategies: pg_dump, pg_basebackup, WAL archiving, point-in-time recovery (PITR), and disaster recovery planning
• Monitor and optimize database performance using pg_stat_statements, EXPLAIN ANALYZE, pg_top, and Prometheus/Grafana dashboards; proactively troubleshoot bottlenecks
• Implement high availability and DR solutions using Patroni, streaming replication, synchronous/asynchronous replication, and failover orchestration
• Plan and execute database version upgrades and security/performance patches with minimal downtime
• Implement monitoring and alerting using Prometheus, Grafana, Zabbix, or Nagios for database health, query latency, and resource usage
• Automate DBA maintenance using Python, Bash, or Ansible - schema migrations, routine checks, patch deployment
• Ensure database security through RBAC, audit logging with pgaudit, and regulatory compliance
• Mentor and guide junior team members on PostgreSQL internals, replication setups, and performance tuning

Do you have experience in System performance monitoring?, * 4+ years of hands-on PostgreSQL administration experience in production environments

• Strong SQL and PL/pgSQL expertise; experience with query optimization and indexing strategies
• Proven experience with Patroni, streaming replication, and high-availability architectures
• Backup and recovery expertise: pg_dump, pg_basebackup, WAL archiving, and PITR
• Monitoring stack experience: Prometheus, Grafana, pg_stat_statements
• Strong Linux/Debian proficiency - the primary operating environment
• Scripting proficiency: Python, Bash, or Ansible for DBA automation
• Understanding of pgaudit, RBAC, and database security/compliance practices
• Bachelor’s degree in Computer Engineering, Electrical Engineering, IT, or related field
• Oracle or MySQL familiarity is a plus but not required

$40 - $42 an hour - Contract