Senior PostgreSQL DBA Contract (1 Year)

Senior PostgreSQL DBA•Contract (1 Year) Brydon Gama Plano, TX Job Details Contract $40•$42 an hour 19 hours ago Qualifications Data replication Database compliance measures Linux support Ansible Database backup and recovery IT system monitoring Data recovery Database security hardening Database security management Infrastructure architecture design SQL Database server management SRE Data access controls implementation Data backup Network monitoring tools Electrical Engineering Linux administration Python Database replication implementation System performance monitoring Full Job Description

ROLE OVERVIEW

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.

WHAT YOU'LL DO

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

WHAT WE'RE LOOKING FOR

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

Pay:

$40.00•$42.00 per hour

Work Location:

Hybrid remote in Plano, TX