We have an senior Oracle DBA for cutting-edge software company focused on providing next-generation core administration and care coordination for transformative health plans. The Performance DBA will work closely with our Engineering team to optimize the performance of our software.
Rate Range: $70/hour to $90/hour; The rate may be negotiable based on experience, education, geographic location, and other factors.
Please note that all candidates must be on a W/2 and due to scope of the project-US citizens and Green Card Holders will only be accepted at this point.
Responsibilities:
- Throughout the development life cycle, collaborate with our product engineering teams to:
- Advise as to data models that allow for efficient query execution
- Analyze and optimize SQL statement execution plans
- Optimize use of database resources and features
- Analyze the effects of application changes on database performance, and make tuning recommendations
- Ensure successful application and database implementations
- Provide database expertise to project teams to maximize system availability, efficiency, and security
- Monitor performance testing systems and perform in-depth diagnosis and troubleshooting of performance
- Advise as to optimal OS and storage configuration of Linux servers to support Oracle databases
- Analyze database system and query performance, and perform triage and resolution, in response to performance-related product incidents
- Support DBA utilities, reorgs, index builds, exports and imports, and DBA tools (e.g. Oracle Enterprise Manager)
- Interact with key stakeholders including Cloud Operations, Information Security, Professional Services, and support teams for service request fulfilment, implementations, and operational support related to database services
Required Experience, Skills, and Behaviors:
- 10+ years of experience administering Oracle databases
- Experience administering SQL Server databases a plus
- Proficiency in methodically troubleshooting complex issues
- In-depth understanding of Oracle internals -- memory pools, wait events, locks, latches, enqueues, etc.
- Proficiency in analyzing execution plans and tuning queries
- Proficiency with Oracle Enterprise Manager, running and analyzing AWR, ADDM, and ASH reports
- Skilled in the process of data modeling designed for high throughput and low latency
- Experience analyzing and optimizing database solutions for multi-terabyte databases.
- Experience in Unix/Linux operating systems and understanding of optimal OS configuration (e.g. kernel parameters, IO subsystem) as relates to Oracle Database
- Hands-on experience in terms of planning, installing, configuring, maintaining and troubleshooting issues is a plus
- Experience in shell scripting
- Working knowledge of database tools and solutions, operational processes, and compliance mandates
- Awareness of database trends and products
- The ability to work in a highly collaborative fashion with both the Engineering and Operations teams
- Adherence to clear and respectful communication
Equal Opportunity Employer/Veterans/Disabled
Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.
To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy.
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
· The California Fair Chance Act
· Los Angeles City Fair Chance Ordinance
· Los Angeles County Fair Chance Ordinance for Employers
· San Francisco Fair Chance Ordinance
