We are seeking a highly skilled Senior Oracle Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the design, implementation, administration, and maintenance of Oracle databases. This role requires expertise in database performance tuning, high availability, security, and disaster recovery. The Senior Oracle DBA will work closely with developers, system administrators, and business stakeholders to ensure database systems are optimized, secure, and aligned with business needs.
Key Responsibilities:
Database Administration & Maintenance
- Install, configure, and upgrade Oracle databases (including RAC, ASM, and Data Guard).
- Monitor and optimize database performance, ensuring high availability and reliability.
- Perform backup, recovery, and disaster recovery planning using RMAN and other tools.
- Troubleshoot database-related issues, working closely with application and infrastructure teams.
Performance Tuning & Optimization
- Identify and resolve performance bottlenecks using tools like AWR, ADDM, and SQL Tuning Advisor.
- Optimize SQL queries and database indexing strategies for improved performance.
- Implement partitioning, compression, and other techniques to enhance efficiency.
Security & Compliance
- Implement database security policies, user access controls, and encryption techniques.
- Conduct regular security audits and vulnerability assessments.
High Availability & Disaster Recovery
- Configure and manage Oracle RAC, Data Guard, and GoldenGate for HA and replication.
- Develop and test disaster recovery plans, ensuring minimal downtime in case of failures.
Automation & Scripting
- Develop scripts using Shell, PL/SQL, or Python for database automation and monitoring.
- Implement Infrastructure as Code (IaC) solutions for database provisioning and maintenance.
Collaboration & Documentation
- Work with developers to optimize database schemas and queries.
- Document database architecture, configurations, and standard operating procedures.
- Provide mentorship and guidance to junior DBAs and support teams.
Qualifications & Requirements:
- Bachelor’s degree in a related discipline and 4 years’ experience in a related field. The right candidate could also have a different combination, such as a master’s degree and 2 years’ experience; a Ph.D. and up to 1 year of experience; or 8 years’ experience in a related field.
- Expertise in Oracle Cloud Infrastructure, Oracle 19c/21c, Oracle RAC, ASM, Data Guard, and Exadata.
- Strong knowledge of SQL, PL/SQL, and performance tuning techniques.
- Experience with Oracle Enterprise Manager (OEM) for monitoring and administration.
- Hands-on experience with Unix/Linux environments and shell scripting.
- Strong troubleshooting and problem-solving skills.
Preferred Skills:
• Knowledge of DevOps tools (Ansible, Terraform) for database automation.
• Exposure to NoSQL or other RDBMS (PostgreSQL, MySQL) is an advantage.
- Certifications such as Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) are a plus.
Drug Testing:
To be employed in this role, you'll need to clear a pre-employment drug test. Cox Automotive does not currently administer a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.
Compensation:
Compensation includes a base salary in the range of $101,500.00 - $169,100.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.
Benefits:
The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company’s needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.
EOE, including disability/vets
