Hello All,
Greetings from Rootshell Inc..
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
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 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 PostGres 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 PostGres DB to team.
Experience in automating SRE Database tasks
Excellent oral and written communication in English
With regards
Naveen | Sr. Talent Acquisition
Rootshell Enterprise Technologies Inc.
Direct: 650-212-5354 | Office: +1 408 239 4600 Ext.: 5023
Naveen@rootshellinc.com | www.rootshellinc.com