Oracle Database Engineer

Job Title: Oracle Database Engineer

Location: Austin, TX

Onsite/Remote/Hybrid: Hybrid

Duration: 5 months with possible further extension

Responsibilities:
• Analyzes and evaluates application, system and ecosystem performance and scalability across multiple tiers with particular emphasis on the data tier in both cloud and on-prem environments.
• Identifies performance and scalability bottlenecks and issues and propose solutions to resolve the same.
• Simulates user/system traffic/load using scripts or other mechanisms, measure, evaluate and analyze component behavior.
• Optimizes code, queries, and system configurations to improve response time, scalability, and resource efficiency (CPU, memory, I/O).
• Analyzes and interprets Oracle wait events, AWR Raw data and trace and correlate observations and analysis to system behavior.

Mandatory Skills:

1. 8 Years of Experience in Analyzing and evaluating application performance across multiple tiers

2. 8 Years of Experience with identification and solution implementation for performance and scalability bottlenecks and issues

3. 8 Years of Experience with Oracle wait interface and event analysis

4. 8 Years of Experience with Performance tuning of large Oracle databases in AWS (50+ TB)

5. 8 Years of Experience with large Oracle Exadata databases and clusters

6. 8 Years of Experience with Single node non-Exadata Database tuning

7. 8 Years of Experience with Linux shell scripting, SQL tuning and session tracing.

8. 8 Years of Experience with AWR, ASH, ADDM generation and analysis

9. 8 Years of Experience with Oracle AWR Raw data analysis and interpretation.

10. 8 Years of Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.

11. 8 Years of Experience with Troubleshooting performance bottlenecks and issues.

12. 8 years of experience with Oracle internals pertaining to database performance

13. 8 Years of Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.

14. 8 Years of Experience with extrapolating application and data tier metrics to explain system behavior.

15. 8 Years of Experience with Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

Desirable Skills:

1. 5 Years of Experience on an agile sprint team

2. 5 Years of Experience with JIRA software

3. 4 Years of Bachelor's degree in2 Years of Prior experience working with PII or PHI data

4. 2 Years of Prior experience working with HL7 data

5. 2 Years of Prior experience in the Healthcare Industry