Oracle DBA- W2 only

Oracle DBA- W2 only

Posted 1 week ago by 1751446650

Negotiable
Outside
Remote
USA

Summary: The Oracle DBA role involves installing, configuring, and maintaining Oracle databases in the cloud, with a focus on performance, availability, and security. The position requires advanced query tuning, management of production databases, and implementation of backup and recovery strategies. Additionally, the role includes collaboration with development teams and maintaining comprehensive documentation. The candidate should also provide expert-level support for Oracle 19c and later versions, with optional knowledge of Oracle 23ai features for future enhancements.

Key Responsibilities:

  • Install, configure, and maintain Oracle databases in cloud, ensuring optimal performance, availability, and security.
  • Perform advanced query tuning and optimization to enhance database performance and efficiency.
  • Manage and monitor production Oracle databases, ensuring high availability and disaster recovery readiness.
  • Implement and manage database backup and recovery strategies, including RMAN and Data Guard.
  • Develop and enforce database security policies, access controls, and auditing procedures.
  • Plan and execute migration of on-premise Oracle databases to Azure Cloud, ensuring data integrity and minimal downtime.
  • Provide expert-level support for Oracle 19c and later versions, including patching, upgrades, and troubleshooting.
  • Leverage knowledge of Oracle 23ai features for future database enhancements and migrations (optional).
  • Collaborate with development teams to optimize database design and application performance.
  • Monitor database health, troubleshoot issues, and implement proactive solutions to prevent outages.
  • Maintain comprehensive documentation for database configurations, procedures, and policies.
  • Review and provide critical logging aspects of database focusing on DB optimization, error logging, and ability to enhance performance for DB while on prem and on cloud post migration.

Key Skills:

  • Expertise in Oracle database installation, configuration, and maintenance.
  • Advanced query tuning and optimization skills.
  • Experience with RMAN and Data Guard for backup and recovery.
  • Knowledge of database security policies and access controls.
  • Experience with cloud migration, specifically to Azure Cloud.
  • Proficient in Oracle 19c and later versions.
  • Familiarity with Oracle 23ai features (optional).
  • Strong troubleshooting and problem-solving skills.
  • Ability to collaborate with development teams.
  • Excellent documentation skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Responsibilities

Install, configure, and maintain Oracle databases in cloud, ensuring optimal performance, availability, and security. Perform advanced query tuning and optimization to enhance database performance and efficiency.

Manage and monitor production Oracle databases, ensuring high availability and disaster recovery readiness. Implement and manage database backup and recovery strategies, including RMAN and Data Guard.

Develop and enforce database security policies, access controls, and auditing procedures.

Plan and execute migration of on-premise Oracle databases to Azure Cloud, ensuring data integrity and minimal downtime.

Provide expert-level support for Oracle 19c and later versions, including patching, upgrades, and troubleshooting. (Optional) Leverage knowledge of Oracle 23ai features for future database enhancements and migrations.

Collaborate with development teams to optimize database design and application performance. Monitor database health, troubleshoot issues, and implement proactive solutions to prevent outages.

Maintain comprehensive documentation for database configurations, procedures, and policies.

Review and provide critical logging aspects of database focusing on DB optimization, error logging, and ability to enhance performance for DB while on prem and on cloud post migration.