Site Reliability Engineer - PostgreSQL

Date Posted: 05/19/2026

Hiring Organization:
Rose International

Position Number: 501405

Job Title:

Site Reliability Engineer – PostgreSQL

Job Location:

Plano, TX, USA, 75074

Work Model:
Hybrid (Onsite 3 days per week)

Shift: Standard business hours

Employment Type:

Temporary (Full‑time, 13 months)

Hourly Rate: $38.00 – $40.00

Location requirement:
Only qualified SRE‑Postgre

SQL candidates located near Plano, TX will be considered due to the position requiring an on‑site presence.

We are seeking an experienced Site Reliability Engineer (SRE) to join our Data Center Engineering team. This role requires a technically strong and operationally mature engineer who will help design, scale, and maintain the reliability of our physical and virtual data center infrastructure. As a Level 3 SRE, you will be a technical leader responsible for ensuring system uptime, optimizing capacity and performance, and contributing to long‑term infrastructure resiliency.

• Bachelor’s degree in computer engineering, electrical engineering, information technology, or a related technical field.

• 4‑7 years of experience in database administration and operations.
• Experience participating in or leading incident response and postmortem analysis processes.
• Previous exposure to hybrid environments integrating on‑premises data centers with public or private cloud platforms.
• Experienced Postgre
  
  SQL Database Administrator managing production and non‑production Postgre
  
  SQL environments.
• Skilled in backup and recovery, replication, performance tuning, and high availability.
• Proven ability to troubleshoot critical issues, automate DBA tasks, and ensure database reliability.
• 4+ years of hands‑on Postgre
  
  SQL administration experience.
• Strong SQL and PL/pgSQL expertise; experience with database optimization and indexing.
• Hands‑on experience with backup, recovery, and HA solutions.
• Strong proficiency in Linux and Debian environments.
• Proficiency in scripting for database automation.
• Excellent analytical, problem‑solving, and troubleshooting skills.
• Strong communication skills for cross‑team collaboration.

• Understanding of Oracle and MySQL databases is a plus, but not mandatory.

• Design, implement, and maintain Postgre
  
  SQL databases, including schema design, indexing strategies, query optimization, logical/physical replication, hot standby failover, and load balancing.
• Develop and execute backup and recovery strategies, including , , WAL archiving, point‑in‑time recovery (PITR), and disaster recovery planning.
• Monitor and optimize database performance, resource utilization, and storage growth using _statements, EXPLAIN ANALYZE, , and Prometheus/Grafana dashboards; proactively troubleshoot performance bottlenecks.
• Ensure database security through role‑based access control (RBAC), audit logging with pgaudit, and compliance with regulatory standards.
• Implement high availability (HA) and disaster recovery (DR) solutions using Patroni, streaming replication, synchronous/asynchronous replication, and failover orchestration.
• Plan and execute database version upgrades and apply security or performance patches with minimal downtime, ensuring data integrity and compatibility checks.
• Collaborate with application teams, BI developers, and ETL engineers to support data pipelines, optimizing queries, and workflow performance.
• Implement monitoring and alerting solutions using Prometheus, Grafana, Zabbix, or Nagios to track database health, query latency, and resource usage.
• Manage database user accounts, roles, and privileges to enforce security policies and regulatory compliance, including sudo/OS‑level permissions for critical operations.
• Conduct capacity planning, workload forecasting, and index/partition tuning to handle anticipated growth and high‑concurrency workloads.
• Automate database maintenance tasks using Python, Bash, or Ansible scripts, including schema migrations, routine checks, and patch deployment.
• Document procedures, configurations, operational runbooks, and Postgre
  
  SQL best practices for team knowledge sharing.
• Mentor and guide team members on Postgre
  
  SQ…