For more details please connect with Omair Khan atExt 327 or email him at
Client: State of Texas
Job Title: Oracle DBA
Duration: 7 Months
Start Date: 20/01/2025
Location: Remote
Position Type: Contract
Interview Type: In person
Ceipal ID: STXORAC275OK
Required Qualifications:
- 8 Required Experience in Analyzing and evaluating application performance across multiple tiers
- 8 Required Experience with identification and solution implementation for performance and scalability bottlenecks and issues
- 8 Required Experience with Oracle wait interface and event analysis
- 8 Required Experience with Performance tuning of large Oracle databases in AWS (50 TB)
- 8 Required Experience with large Oracle Exadata databases and clusters
- 8 Required Experience with Single node nonExadata Database tuning
- 8 Required Experience with Linux shell scripting SQL tuning and session tracing.
- 8 Required Experience with AWR ASH ADDM generation and analysis
- 8 Required Experience with Oracle AWR Raw data analysis and interpretation.
- 8 Required Experience Extrapolating system behavior under representative load to predict system behavior under full load/stress.
- 8 Required Experience with Presenting complex results analysis and metrics to a diverse audience of technical and nontechnical personnel.
- 8 Required Experience with Troubleshooting performance bottlenecks and issues.
- 8 Required Knowledge of Oracle internals pertaining to database performance
- 8 Required Experience with understanding of application behavior performance and interaction patterns with DBs in relation to performance and scalability.
- 8 Required Experience with extrapolating application and data tier metrics to explain system behavior.
- 8 Required 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.
- 8 Required Experience working with multiple teams concurrently being able to prioritize and complete work on time with high quality
- 5 Preferred Experience on an agile sprint team
- 5 Preferred Experience with JIRA software
- 4 Preferred Bachelors degree in computer science Information Systems or Business or equivalent experience.
- 2 Preferred Prior experience with an HHS agency
- 2 Preferred Prior experience working with PII or PHI data
- 2 Preferred Prior experience working with HL7 data
- 2 Preferred Prior experience in the Healthcare Industry
Description:
Develops software solutions by studying information needs conferring with users and studying systems flow data usage and work processes. Investigates problem areas. Prepares and installs solutions by determining and designing system specifications standards and programming.
The Department of Information Resources (DIR) requires the services of One Performance engineer hereafter referred to as Worker who meets the general qualification of Developer 3 Emerging and the specifications outlined in this document for Health & Human Services Commission Social Services Applications team.
All work products resulting from the project shall be considered works made for hire and are the property of the HHSC. HHSC may include preselection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions which occur during the process of selecting a Worker(s).
- Analyzes and evaluates application system and ecosystem performance and scalability across multiple tiers with particular emphasis on the data tier in both cloud and onprem 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 nontechnical 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.
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR CA DE FL GA IL KY MD ME MI NC NJ NY OH OR PA SC TX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook: