Database Performance Engineer Apply
<p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b>Role: Database Performance Engineer</b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b>Location: Austin, TX (Day1 Onsite)</b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"> </p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b>Client: TechM//Apple</b></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"> </span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start; margin-bottom:16px"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b>Description:</b><br /> <span style="background:yellow">Looking for a Performance Tuning Database Engineer who can help tune.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="text-align:start"><span style="font-size:small"><span style="color:#222222"><span style="font-family:Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"><span style="white-space:normal"><span style="background-color:#ffffff"><span style="text-decoration-thickness:initial"><span style="text-decoration-style:initial"><span style="text-decoration-color:initial"><b>Roles & Responsibilities</b><br /> 1. Identify areas of performance improvement in different SQL & NoSQL database technologies<br /> 2. Performance analyze the environment and identify bottlenecks due to network, storage and Operating system with end to end Root cause analysis<br /> 3. Collect and analyze database metrics collected during Performance Load testing and report/highlight issues, if any<br /> 4. Identify ways to pull database related metrics like CPU, Memory, IO Latencies,<br /> 5. Perform database level tracing and analyze trace files<br /> 6. Perform log analysis for different datastore technologies to identify issues and solve them<br /> 7. Open case or issues with vendor companies and provide clear issue details<br /> 8. Carry technical discussion with cross functional teams and work on resolving database issues<br /> 9. Perform Technical POCs with new diverse database technologies<br /> 10. Perform effective communication with the team over collaborative tools like Slack, write descriptive emails and present to the team<br /> <br /> <br /> <b>Technical Skill Set required</b><br /> 1. Knowledge of AWS services, Minimum 1 to 2 years of experience working on AWS services mentioned below:<br /> * EC2 - Security groups, AutoScaling Groups<br /> * IAM<br /> * S3<br /> * Route53<br /> * EBS<br /> * Cloudformation<br /> * RDS Oracle, Postgres<br /> * KMS<br /> 2. Architectural knowledge about Oracle database and respective components & functionality<br /> 3. Experience with performance tuning SQL queries<br /> 4. Analyzing and recommending improvement by reading Oracle database performance reports like ADDM, AWR etc.<br /> 5. Knowledge of basic OS commands to identify CPU & memory bottlenecks/issues as well as network & storage level latencies<br /> 6. Clear understanding of database fundamentals and architecture for RDBMS databases<br /> 7. Fundamental knowledge of heterogenous database types like MongoDB, Couchbase, Cassandra is a big plus<br /> 8. Experience with Data Visualization & Dash-boarding tools like: Tableau, Splunk is a huge plus<br /> 9. Experience working with either Ansible, Java, GoLang, Groovy or similar language is a plus</span></span></span></span></span></span></span></span></span></span></span></p>
