Senior Oracle Database Administrator

Cognisol Global Solutions LLC; St. Louis (MO); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading global solutions company seeks a Senior Oracle Database Administrator to manage mission-critical Oracle database environments, including Exadata systems. The ideal candidate will have extensive DBA experience, focusing on performance tuning, backup strategies, and compliance with organizational standards.

Qualifications

• 8+ years of hands-on experience in Oracle database administration.
• At least 2 years with Exadata systems.
• Experience in performance tuning and high-availability environments.

Responsibilities

• Oversee installation, configuration, administration, and maintenance of Oracle databases.
• Manage Oracle Exadata systems ensuring optimal performance and availability.
• Design and implement backup and recovery strategies using RMAN and Data Guard.

Skills

Oracle RAC

ASM

Data Guard

RMAN

Shell scripting

PL/SQL

Linux/Unix administration

Education

Oracle Certified Professional (OCP) Oracle Database 19c or later

Oracle Exadata Database Machine Implementation Specialist

Oracle Certified Expert (OCE) Real Application Clusters and Grid Infrastructure Administration

ITIL Foundation or equivalent

Job description

About the job Senior Oracle Database Administrator

Role: Senior Oracle Database Administrator

Location: St. Louis, MO (Onsite)
Preferred within 50 miles

10 + years of experience

Job Description:

We are seeking a highly skilled and experienced Senior Oracle Database Administrator (DBA) to join our IT infrastructure team. The ideal candidate will be responsible for the administration, performance, and reliability of mission-critical Oracle database environments, including Exadata systems.

Key Responsibilities:
1. Oracle Database Management Oversee the installation, configuration, administration, and maintenance of Oracle databases across production, test, and development environments.
2. Patch Management & Upgrades Plan and execute Oracle database patching, version upgrades, and migrations while ensuring minimal downtime and adherence to compliance standards.
3. Exadata Administration Manage and support Oracle Exadata systems, including cell servers, storage servers, and Infiniband networks, ensuring optimal performance and availability.
4. Performance Tuning Monitor, diagnose, and resolve performance issues through in-depth analysis, query optimization, and resource management.
5. Backup & Recovery Design, implement, and test robust backup and recovery strategies using RMAN and Data Guard to ensure data integrity and disaster readiness.
6. Security & Compliance Ensure database security, access control, and compliance with organizational policies and industry standards (e.g., SOX, GDPR).
7. Automation & Scripting Develop and maintain scripts for automation of routine tasks, monitoring, and reporting using Shell, PL/SQL, and other tools.
8. High Availability & DR Design and manage high availability (HA) and disaster recovery (DR) solutions, including RAC, Data Guard, and GoldenGate as applicable.
9. Monitoring & Alerting Implement and manage monitoring tools to proactively identify and address database performance and availability issues.
10. Collaboration & Mentoring Work closely with application teams, infrastructure teams, and vendors; provide guidance and mentorship to junior DBAs.

Experience:
8+ years of hands-on experience in Oracle database administration, including at least 2 years with Exadata systems.
Proven track record of performance tuning and managing high-availability database environments.

Certifications (preferred):
Oracle Certified Professional (OCP) Oracle Database 19c or later
Oracle Exadata Database Machine Implementation Specialist
Oracle Certified Expert (OCE) Real Application Clusters and Grid Infrastructure Administration
ITIL Foundation or equivalent (for understanding of IT service management processes)

Technical Skills:
Strong expertise in Oracle RAC, ASM, Data Guard, RMAN, OEM Cloud Control.
Proficient in Shell scripting, PL/SQL, and Linux/Unix administration.
Familiarity with Oracle Cloud Infrastructure (OCI) or other cloud platforms is a plus.