Senior Oracle Database Administrator (DBA)

Senior Oracle Database Administrator (DBA)

Posted 1 week ago by 1753421916

Apply
Negotiable
Outside
Remote
USA
Apply
Agile Scrum Master (ASM) Application Development Automatic Storage Management Automation Business Continuity And Disaster Recovery Computer Science Database Administration Database Management Database Systems Database Upgrades Disaster Recovery Information Technology Life Cycle Planning Management Mobile Application Development Operating Systems Oracle Database Administration (DBA) Oracle Databases Oracle Data Guard Oracle Rac Oracle SQL Developer Original Equipment Manufacturer Performance Tuning Recovery Manager (RMAN) Software Development SQL (Programming Language) Stakeholder Management Storage Management Unix

Summary: The Senior Oracle Database Administrator (DBA) role involves managing, maintaining, and optimizing complex Oracle database environments, requiring extensive expertise in Oracle technologies such as RAC, ASM, and Data Guard. The position demands a hands-on approach to database administration and support throughout the application development lifecycle. The ideal candidate will have a strong background in AIX environments and a commitment to best practices in database management. This is a remote position with a focus on high availability and disaster recovery solutions.

Key Responsibilities:

  • Oversee the daily operations, maintenance, and health of critical Oracle database systems.
  • Conduct in-depth database and application SQL performance tuning, with significant experience optimizing performance in Oracle Real Application Clusters (RAC) environments.
  • Design, implement, and manage comprehensive backup and recovery strategies utilizing the full functionality of Oracle RMAN.
  • Plan, execute, and validate database upgrades and patching activities, particularly focusing on in-place upgrades and release updates within Oracle and RAC environments.
  • Implement, configure, and manage Oracle Data Guard solutions, including physical and logical standby databases, and maintain Active Data Guard (ADG) and Data Guard Broker configurations.
  • Set up, build, configure, and administer Oracle Real Application Clusters (RAC) and manage storage using Oracle Automatic Storage Management (ASM).
  • Administer Oracle databases effectively within an AIX operating system environment (version 7.x or higher) and develop robust UNIX/Shell scripts for automation and administrative tasks.
  • Provide expert database administration support throughout the entire application system development life cycle.
  • Utilize and manage database operations using tools such as Oracle Enterprise Manager (OEM) Suite, Grid Control, TOAD, Oracle SQL Developer, and other comparable tools.
  • Work with snapshot cloning technology using Oracle ACFS with Oracle RAC and Standby database-based databases.

Key Skills:

  • 9+ Years of experience as an Oracle Database Administrator.
  • 8+ Years of experience in using the full functionality of RMAN backup utility.
  • 8+ Years of experience in database performance tuning and application SQL tuning, with at least 3 years of that experience in an Oracle RAC environment.
  • 8+ Years of experience and knowledge in supporting the applications system development life cycle.
  • 7+ Years of experience in performing database upgrades/patches, with 3 years focused on in-place upgrades/patches and release updates in Oracle or RAC.
  • 7+ Years of experience as an Oracle Database Administrator using AIX (version 7.x or higher) operating system environment.
  • 6+ Years of experience using Oracle ASM, with at least 4 years in a RAC environment.
  • 6+ Years of experience writing scripts in an AIX operating system environment (UNIX /Shell).
  • 5+ Years of experience in setting up/building and configuring Oracle RAC.
  • 5+ Years of experience in using/setting up and configuring physical standby/logical database/Data Guard.
  • 4+ Years of experience in Active Data Guard (ADG) and Data Guard Broker.
  • Preferable: 6+ years of experience in using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database-based databases.
  • Proficiency in Oracle Enterprise Manager Suite, Grid Control, TOAD Tool/Oracle SQL Developer, or comparable tools.
  • Strong command of Oracle database versions relevant to enterprise environments.
  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: Senior Oracle Database Administrator (DBA)

Location: Remote

Company: State of Ohio

Job Summary: We are seeking a highly experienced and technically proficient Senior Oracle Database Administrator to manage, maintain, and optimize our complex Oracle database environments. The ideal candidate will possess deep expertise across various Oracle technologies, including RAC, ASM, Data Guard, and performance tuning, with a strong background in AIX environments. This role requires a hands-on approach to database administration, a commitment to best practices, and the ability to support the full application development lifecycle.

Key Responsibilities:

  • Database Administration & Management: Oversee the daily operations, maintenance, and health of critical Oracle database systems.
  • Performance Tuning: Conduct in-depth database and application SQL performance tuning, with significant experience optimizing performance in Oracle Real Application Clusters (RAC) environments.
  • Backup & Recovery: Design, implement, and manage comprehensive backup and recovery strategies utilizing the full functionality of Oracle RMAN.
  • Upgrades & Patching: Plan, execute, and validate database upgrades and patching activities, particularly focusing on in-place upgrades and release updates within Oracle and RAC environments.
  • High Availability & Disaster Recovery: Implement, configure, and manage Oracle Data Guard solutions, including physical and logical standby databases, and maintain Active Data Guard (ADG) and Data Guard Broker configurations.
  • Oracle RAC & ASM Management: Set up, build, configure, and administer Oracle Real Application Clusters (RAC) and manage storage using Oracle Automatic Storage Management (ASM).
  • Operating System & Scripting: Administer Oracle databases effectively within an AIX operating system environment (version 7.x or higher) and develop robust UNIX/Shell scripts for automation and administrative tasks.
  • SDLC Support: Provide expert database administration support throughout the entire application system development life cycle.
  • Tool Proficiency: Utilize and manage database operations using tools such as Oracle Enterprise Manager (OEM) Suite, Grid Control, TOAD, Oracle SQL Developer, and other comparable tools.
  • Advanced Features (Preferable): Work with snapshot cloning technology using Oracle ACFS with Oracle RAC and Standby database-based databases.

Required Qualifications:

  • Experience:
    • 9+ Years of experience as an Oracle Database Administrator.
    • 8+ Years of experience in using the full functionality of RMAN backup utility.
    • 8+ Years of experience in database performance tuning and application SQL tuning, with at least 3 years of that experience in an Oracle RAC environment.
    • 8+ Years of experience and knowledge in supporting the applications system development life cycle.
    • 7+ Years of experience in performing database upgrades/patches, with 3 years focused on in-place upgrades/patches and release updates in Oracle or RAC.
    • 7+ Years of experience as an Oracle Database Administrator using AIX (version 7.x or higher) operating system environment.
    • 6+ Years of experience using Oracle ASM, with at least 4 years in a RAC environment.
    • 6+ Years of experience writing scripts in an AIX operating system environment (UNIX /Shell).
    • 5+ Years of experience in setting up/building and configuring Oracle RAC.
    • 5+ Years of experience in using/setting up and configuring physical standby/logical database/Data Guard.
    • 4+ Years of experience in Active Data Guard (ADG) and Data Guard Broker.
    • Preferable: 6+ years of experience in using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database-based databases.
  • Technical Skills:
    • Proficiency in Oracle Enterprise Manager Suite, Grid Control, TOAD Tool/Oracle SQL Developer, or comparable tools.
    • Strong command of Oracle database versions relevant to enterprise environments.
  • Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).

Desired Skills & Attributes:

  • Strong analytical and problem-solving skills with a meticulous attention to detail.
  • Excellent communication and interpersonal skills, capable of collaborating effectively with development teams, infrastructure teams, and stakeholders.
  • Ability to work independently and as part of a team in a fast-paced, dynamic environment.
  • Proactive approach to database health, security, and performance.
Apply
Similar Jobs
Loading data...