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