Description

Mandatory Requirements:

  • Fifteen or more years of experience serving in the capacity as an Oracle database administrator (DBA) supporting PeopleSoft Financials, CRM and/or HCM
  • Oracle Certified Master (OCM) certification
  • Experience working with Oracle version 19c
  • Three years or more experience with Oracle Cloud (OCI)
  • Three years or more experience with Exadata Machine Administration
  • Hands-on experience with Oracle Exadata, including configuration, monitoring, and maintenance
  • Proficiency in diagnosing and resolving issues related to Exadata performance, hardware, software, and connectivity
  • Familiarity with Exadata’s unique storage architecture, including storage optimization techniques
  • Understanding of networking concepts and protocols as they relate to Exadata
  • Ability to apply patches, updates, and security fixes to both the Oracle Database and Exadata software stack
  • Knowledge of security best practices for Exadata systems, including user access controls, encryption, and auditing
  • Experienced in Oracle Advanced Security (TDE)
  • Experienced in Data Guard setup, switchover, fail over and gap resolution
  • Twelve years of experience in backup, cloning and recovery strategies of at least 1 TB systems, including: RMAN and Filesystem clone, datapump
  • Twelve years of experience identifying problem SQL, analyzing execution plans, and developing tuning options
  • Twelve years of experience utilizing Oracle Enterprise Manager (OEM)
  • Experience with Automatic Storage Management (ASM) 16. Knowledge in Unix and Linux Operating Systems and scripting experience in these environments


Description of Engagement:

  • Support the database unit in the administration of Oracle databases
  • Upgrade databases to new versions
  • Patch databases quarterly and apply patches to resolve one off bug fixes
  • Conduct switchover or failover to Data Guard instances and gap resolution
  • Backup and recoveries of databases
  • Resolve performance issues
  • Writing and maintaining scripts used to support database systems
  • Database cloning
  • Creation of new databases
  • Ad hoc reporting
  • Work with Oracle support as necessary

Education

Any Graduate