What are the responsibilities and job description for the Senior Oracle Database Administrator position at COGENT DATA SOLUTIONS LLC?
Position ID: 529501275R
Role: Oracle Database Administrator
Location: Hybrid - Austin, TX (Local to Texas)(On-site Every Wednesday)
Client Name: Texas Health and Human Services Commission
Job Qualifications/ Skills:
Minimum 9 Years of experience is mandatory
Description:
· 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.
· Generates and analyzes AWR, ASH and ADDM reports.
· Extrapolates system behavior under representative load to predict system behavior under full load/stress.
· Extrapolates system behavior from application and data tier metrics.
· Communicates complex results, analysis, and metrics to diverse technical and non-technical audience.
· Evaluates and predicts future performance needs based on application usage trends, traffic patterns, and growth projections.
· Conducts detailed root cause analysis (RCA) on performance issues to pinpoint the underlying cause of slowdowns or failures.
Roles and Responsibilities:
- Experience in Analyzing and evaluating application performance across multiple tiers
- Experience with identification and solution implementation for performance and scalability bottlenecks and issues
- Experience with Oracle wait interface and event analysis
- Experience with Performance tuning of large Oracle databases in AWS (50 TB)
- Experience with large Oracle Exadata databases and clusters
- Experience with Single node non-Exadata Database tuning
- Experience with Linux shell scripting, SQL tuning and session tracing.
- Experience with AWR, ASH, ADDM generation and analysis
- Experience with Oracle AWR Raw data analysis and interpretation.
- Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.
- Experience with Presenting complex results, analysis, and metrics to a diverse audience of technical and non-technical personnel.
- Experience with Troubleshooting performance bottlenecks and issues.
- Knowledge of Oracle internals pertaining to database performance
- Experience with understanding of application behavior, performance, and interaction patterns with DBs in relation to performance and scalability.
- Experience with extrapolating application and data tier metrics to explain system behavior.
- 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.
- Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality
- Experience on an agile sprint team
- Experience with JIRA software
- Bachelor's degree in computer science, Information Systems, or Business or equivalent experience.
- Prior experience with an HHS agency
- Prior experience working with PII or PHI data
- Prior experience working with HL7 data
- Prior experience in the Healthcare Industry
