Site Reliability Engineer-PostGres DBA

Hello All,

Greetings from Rootshell Inc..

About Rootshell

Rootshell Enterprise Technologies Inc. is a recognized provider of professional IT Consulting services in the US. We are actively seeking Site Reliability Engineer - PostGres DBA for one of our direct client in Dallas, TX Please share your resume with current location & full contact info.

Role

Site Reliability Engineer - PostGres DBA

Location

Dallas, TX

Salary

$130k to 150k

Duration

Long term

Your Responsibilities

• Responsible for the 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