Oracle DBA

Oracle DBA

Posted 4 days ago by 1754034555

Negotiable
Outside
Remote
USA

Summary: The Oracle DBA role involves monitoring and maintaining Oracle production databases to ensure high availability and performance. The position requires troubleshooting database issues, performing routine maintenance, and collaborating with various teams to optimize database operations. Candidates should have extensive experience in Oracle database management and be capable of automating tasks and implementing security measures. This is a remote position based in the USA, classified as outside IR35.

Key Responsibilities:

  • Monitor and maintain Oracle production databases (versions 12c/19c/21c) to ensure high availability and performance.
  • Troubleshoot and resolve database performance issues, outages, and errors.
  • Perform routine health checks, maintenance, patching, and upgrades in production environments.
  • Handle backup and recovery using RMAN and other tools; ensure disaster recovery plans are in place and tested.
  • Support high-availability solutions including Oracle RAC, Data Guard, and ASM.
  • Manage incident and problem tickets; provide root cause analysis and resolution in a timely manner.
  • Work closely with application developers, infrastructure teams, and business users to ensure efficient database operations.
  • Automate routine DBA tasks using PL/SQL, Shell scripts, or Python.
  • Perform capacity planning and space management.
  • Implement and maintain database security, auditing, and user access controls.
  • Maintain up-to-date documentation for processes and configurations.

Key Skills:

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 5+ years of experience as an Oracle DBA, with at least 3 years in production support.
  • Strong knowledge of Oracle RDBMS architecture, performance tuning, and diagnostics.
  • Proficient in SQL, PL/SQL, and Unix/Linux shell scripting.
  • Experience with tools like OEM (Oracle Enterprise Manager), AWR, ADDM, TKPROF, and Statspack.
  • Familiar with Oracle RAC, ASM, RMAN, Data Guard, and GoldenGate.
  • Experience in working within ITIL-based support frameworks (Incident, Change, Problem Management).
  • Ability to participate in a 24x7 on-call rotation and respond to production issues promptly.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Role : Oracle DBA

Location Remote ( USA)

Type : CTH

JD :

Key Responsibilities:

  • Monitor and maintain Oracle production databases (versions 12c/19c/21c) to ensure high availability and performance.
  • Troubleshoot and resolve database performance issues, outages, and errors.
  • Perform routine health checks, maintenance, patching, and upgrades in production environments.
  • Handle backup and recovery using RMAN and other tools; ensure disaster recovery plans are in place and tested.
  • Support high-availability solutions including Oracle RAC, Data Guard, and ASM.
  • Manage incident and problem tickets; provide root cause analysis and resolution in a timely manner.
  • Work closely with application developers, infrastructure teams, and business users to ensure efficient database operations.
  • Automate routine DBA tasks using PL/SQL, Shell scripts, or Python.
  • Perform capacity planning and space management.
  • Implement and maintain database security, auditing, and user access controls.
  • Maintain up-to-date documentation for processes and configurations.

Required Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 5+ years of experience as an Oracle DBA, with at least 3 years in production support.
  • Strong knowledge of Oracle RDBMS architecture, performance tuning, and diagnostics.
  • Proficient in SQL, PL/SQL, and Unix/Linux shell scripting.
  • Experience with tools like OEM (Oracle Enterprise Manager), AWR, ADDM, TKPROF, and Statspack.
  • Familiar with Oracle RAC, ASM, RMAN, Data Guard, and GoldenGate.
  • Experience in working within ITIL-based support frameworks (Incident, Change, Problem Management).
  • Ability to participate in a 24x7 on-call rotation and respond to production issues promptly.

Skills:

Exposure to cloud platforms like Oracle Cloud (OCI), AWS RDS for Oracle, or Azure.

Experience with DevOps tools (Ansible, Jenkins, Terraform) for database deployment and automation.

Understanding of regulatory compliance standards (e.g., SOX, HIPAA, GDPR).

Certifications: Oracle Certified Professional (OCP) is a plus.

Strong analytical and troubleshooting skills.

Effective communication and collaboration with cross-functional teams.

Ability to work in a fast-paced production environment with minimal supervision.

Strong attention to detail and commitment to uptime and reliability.