Site Reliability Engineer-PostGres DBA

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. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" 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. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Administration on AWS Cloud (EC2, RDS & Aurora), S3 Backups, Replication. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Develop Stored Procedures and Database Triggers in support of application development. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Participate in application development projects and be responsible for the database architecture and design. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Participate in the creation of development, staging, and production database instances, and the migration from one environment to another. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Responsible for regular backups and recovery of databases. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Responsible for regular maintenance on databases (e.g., Vacuum, Re-indexing, Archiving). aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Responsible for pro-active remediation of database operational problems. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Responsible for Query tuning and preventative maintenance. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Support complex web-based applications. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" a successful Engineer will take steps on his or her own to isolate issues and resolve root cause through investigative analysis. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" 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. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Skills: aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" BS or Similar degree in Computer Science or related field. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Overall 8-10 years of relevant industry experience aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Experience working as PostGres DBA for highly available systems. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Experience working in AWS public cloud is must. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" 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. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Setup and configuration of PostgreSQL server including clustering on standalone servers and Cloud aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Security and authentication (User management / Encryption) aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Monitor and evaluate database performance and adjust database configuration as appropriate aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Participate in disaster recovery design, testing and execution aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Provide subject matter expertise for PostGres DB to team. aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Experience in automating SRE Database tasks aria-hidden="true" style="font-variant-ligatures:normal; font-variant-caps:normal; orphans:2; text-align:start; widows:2; -webkit-text-stroke-width:0px; text-decoration-thickness:initial; text-decoration-style:initial; text-decoration-color:initial; word-spacing:0px" Excellent oral and written communication in English With regards Naveen | Sr. Talent Acquisition Rootshell Enterprise Technologies Inc. Direct: | Office: +1 Ext.: 5023 | www.rootshellinc.com