Senior PostgreSQL DBA - Contract (1 Year)

BRYDON COMPANY
Plano, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 87K

Job location

Plano, United States of America

Tech stack

Audit Trail
Bash
Databases
Computer Engineering
Continuous Availability
Data Loss
Database Security
Debian Linux
Linux
Disaster Recovery
Python
PostgreSQL
MySQL
Nagios
Oracle Applications
Performance Tuning
Query Optimization
Role-Based Access Control
Reliability Engineering
Ansible
Prometheus
Standard Sql
Data Streaming
Backup and Restore
Zabbix
Scripting (Bash/Python/Go/Ruby)
Load Balancing
System Availability
Grafana
Database Optimization
Database Performance
Performance Monitor

Job description

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

Requirements

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

Benefits & conditions

$40 - $42 an hour - Contract

Apply for this position