Senior Oracle Database Administrator

Job Description

As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues.

• Excellent understanding, installing, administering and working knowledge of Oracle 12c through 19c databases
• Experience in configuring and managing Oracle RAC, Clusterware, Grid infrastructure, Oracle ASM, OEM and Shareplex, STRIIM/GoldenGate
• Hands-on with Oracle Database migration/upgrade using different methodologies Data Pump & RMAN Transportable Tablespaces.
• Hands-on database performance troubleshooting skills.
• DB Performance tuning skills are must.
• Experience with Perl, Unix Shell Scripting, and Python for custom monitoring and automation
• Experience with RMAN database backup and recovery
• Hands-on with CDB & PDB architecture, design and implementation.
• Experience with migration of Oracle Databases from On-premise to cloud.
• Experience in defining security standards and supporting security audits.
• Experience with DataGuard setup and management.
• Experience with Oracle Enterprise Manager (OEM), OEM Target Discovery, Agent installation, configure metrics and alerts.
• Good to have exposure in security skillset like TDE, AVDF, Data masking etc.
• Installing GoldenGate software and management processes; these are done in conjunction with the DBA team, as the duties are intentionally segregated
• Upgrading and/or patching GoldenGate versions (i.e., regular life-cycle management)
• Assisting in troubleshooting golden gate replication issues
• Configuring replications (Extract, Pump and Replicate processes), as requested by Solutions projects, including scoping, design and implementation
• Participating in the scope, design and implementation of Solutions projects
• Monitoring replications, performance and overall system health
• Tuning performance to ensure synchronization rates meet business requirements
• Applying changes to replications, such as table or column adds
• Refreshing data in target systems, along with the Database team when databases are refreshed or recovered.
• Troubleshooting the recovery of failed replications/synchronizations in order to catch up on the backlog of data in a reasonable amount of time.
• Strong troubleshooting abilities are an absolute must, and may require working with the Server and Storage teams in addition to database, Information Management, etc.
  
  
  

Career Level - IC3

Responsibilities

As a Senior Systems Engineer, you will interface with the customer's IT staff on a regular basis. Either at the client's site or from a remote location, you will be responsible for resolution of moderately complex technical problems related to the installation, recommended maintenance and use and repair/workarounds for Oracle products. You should be highly experienced in some Oracle products and several platforms that are being supported. You will be expected to work with only general guidance from management while advising management on progress/status.

• Excellent understanding, installing, administering and working knowledge of Oracle 12c through 19c databases
• Experience in configuring and managing Oracle RAC, Clusterware, Grid infrastructure, Oracle ASM, OEM and Shareplex, STRIIM/GoldenGate
• Hands-on with Oracle Database migration/upgrade using different methodologies Data Pump & RMAN Transportable Tablespaces.
• Hands-on database performance troubleshooting skills.
• DB Performance tuning skills are must.
• Experience with Perl, Unix Shell Scripting, and Python for custom monitoring and automation
• Experience with RMAN database backup and recovery
• Hands-on with CDB & PDB architecture, design and implementation.
• Experience with migration of Oracle Databases from On-premise to cloud.
• Experience in defining security standards and supporting security audits.
• Experience with DataGuard setup and management.
• Experience with Oracle Enterprise Manager (OEM), OEM Target Discovery, Agent installation, configure metrics and alerts.
• Good to have exposure in security skillset like TDE, AVDF, Data masking etc.
• Installing GoldenGate software and management processes; these are done in conjunction with the DBA team, as the duties are intentionally segregated
• Upgrading and/or patching GoldenGate versions (i.e., regular life-cycle management)
• Assisting in troubleshooting golden gate replication issues
• Configuring replications (Extract, Pump and Replicate processes), as requested by Solutions projects, including scoping, design and implementation
• Participating in the scope, design and implementation of Solutions projects
• Monitoring replications, performance and overall system health
• Tuning performance to ensure synchronization rates meet business requirements
• Applying changes to replications, such as table or column adds
• Refreshing data in target systems, along with the Database team when databases are refreshed or recovered.
• Troubleshooting the recovery of failed replications/synchronizations in order to catch up on the backlog of data in a reasonable amount of time.
• Strong troubleshooting abilities are an absolute must, and may require working with the Server and Storage teams in addition to database, Information Management, etc.
  
  
  

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [email protected] or by calling +1 888 404 2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.