Site Reliability Engineer-PostGres DBA
Listed on 2026-07-01
-
IT/Tech
Database Administrator, Cloud Computing: Infrastructure & Operations
Site Reliability Engineer
- Post Gres DBA
Rootshell Enterprise Technologies Inc. is a recognized provider of professional IT Consulting services in the US. We are actively seeking a Site Reliability Engineer
- Post Gres DBA for one of our direct clients in Dallas, TX.
Location:
Dallas, TX
Salary: $130k to 150k
Duration:
Long term
Responsibilities include monitoring and uptime of all production and non-production databases. Strive to improve the stability, security, efficiency, scalability, and availability of production systems by applying software engineering practices and by implementing database monitors and alerts. Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Administration on AWS Cloud (EC2, RDS & Aurora), S3 Backups, Replication. Develop Stored Procedures and Database Triggers in support of application development. Participate in application development projects and be responsible for the database architecture and design. Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Responsible for regular backups and recovery of databases. Responsible for regular maintenance on databases (e.g., Vacuum, Re-indexing, Archiving). Responsible for pro-active remediation of database operational problems. Responsible for query tuning and preventative maintenance. Support complex web-based applications.
A successful Engineer will take steps on his or her own to isolate issues and resolve root cause through investigative analysis. The Engineer should be an independent problem-solver who is focused and capable of exhibiting deftness to handle multiple simultaneous competing priorities and deliver solutions in a timely manner.
Skills:
BS or similar degree in Computer Science or related field. Overall 8-10 years of relevant industry experience. Experience working as Post Gres DBA for highly available systems. Experience working in AWS public cloud is must. Must have thorough understanding and experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
Setup and configuration of PostgreSQL server including clustering on standalone servers and Cloud Security and authentication (User management / Encryption). Monitor and evaluate database performance and adjust database configuration as appropriate. Participate in disaster recovery design, testing and execution. Provide subject matter expertise for Post Gres DB to team. Experience in automating SRE Database tasks. Excellent oral and written communication in English.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).