Lead Senior Oracle DBA
3B Staffing LLC, Columbus, OH, United States
Lead Senior Oracle DBA
Candidate Requirements: • Extensive work experience in Oracle RAC Database Administration. • Comprehensive background in administration of Oracle Enterprise Manager and physical DBA support in a complex environment. • Database skills must include Installation/Patching/Upgrade of the OEM, database software on AIX platform, RMAN backup and recovery of the Oracle Database, performance tuning, migration, data guard replication, configuration and security administration. • Must have experience in configuration of ACFS snapshot clone process • Experience in setting up Active Data guard with Cascaded standby database setup • Good understanding of the Linux/UNIX environments. • Work experience with OLTP, OLAP, Staging, and Data warehouse configuration. • Highly specialized in Oracle Enterprise Manager 13c with installation, configuration of emails, alerts and Metric extensions. • Highly specialized in Oracle 19c RAC Database Administration and Technical Architecture, including but not limited to database administration, ASM Storage, SCAN Listener, GDS, Gateway, RMAN backup and recovery, Performance Tuning, Database Refreshes from Prod to Lower Environments. • Expert experience on architecting and implementing Oracle Advanced Security options (ASO) like Encryption TDE, Data Redaction, Unified Auditing, data classification and security preventive techniques. • Well experienced on Oracle Goldengate • Strong fundamentals in all aspects of DBA responsibilities. • Excellent communication skills, customer service and client management skills. • Experience of CI/CD database deployment process • Experience managing Databases in the Cloud is a strong plus. Experience in Oracle Enterprise Manager Suite, Grid Control tool, TOAD Tool/Oracle SQL Developer / any other comparable tool Required 9 Experience as a Oracle database administrator Required 8 Experience in using the full functionality of RMAN backup utility Required 8 Experience in database performance tuning and application SQL tuning out of which at least 3 years of experience in Oracle RAC environment. Required 8 Experience and knowledge in supporting applications system development life cycle. Required 7 Experience in performing database upgrade/patches out of which 3 years of experience in Oracle or RAC (primarily in place upgrade/patches Release upd Required 7 Experience as a Oracle database administrator using AIX (version 7.x or higher) operating system environment . Required 5 Experience in setting up/building and configuring Oracle RAC Required 6 Experience is using Oracle ASM out of which at 4 years of experience in RAC environment. Required 6 Experience writing scripts in AIX operating system environment (UNIX /Shell). Required 6 Experience in using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database based database is preferable. Required 5 Experience in using/setting up and configuring of physical standby/logical database/data guard Required 4 Experience in Active Data Guard (ADG) and data guard broker Required 2
Candidate Requirements: • Extensive work experience in Oracle RAC Database Administration. • Comprehensive background in administration of Oracle Enterprise Manager and physical DBA support in a complex environment. • Database skills must include Installation/Patching/Upgrade of the OEM, database software on AIX platform, RMAN backup and recovery of the Oracle Database, performance tuning, migration, data guard replication, configuration and security administration. • Must have experience in configuration of ACFS snapshot clone process • Experience in setting up Active Data guard with Cascaded standby database setup • Good understanding of the Linux/UNIX environments. • Work experience with OLTP, OLAP, Staging, and Data warehouse configuration. • Highly specialized in Oracle Enterprise Manager 13c with installation, configuration of emails, alerts and Metric extensions. • Highly specialized in Oracle 19c RAC Database Administration and Technical Architecture, including but not limited to database administration, ASM Storage, SCAN Listener, GDS, Gateway, RMAN backup and recovery, Performance Tuning, Database Refreshes from Prod to Lower Environments. • Expert experience on architecting and implementing Oracle Advanced Security options (ASO) like Encryption TDE, Data Redaction, Unified Auditing, data classification and security preventive techniques. • Well experienced on Oracle Goldengate • Strong fundamentals in all aspects of DBA responsibilities. • Excellent communication skills, customer service and client management skills. • Experience of CI/CD database deployment process • Experience managing Databases in the Cloud is a strong plus. Experience in Oracle Enterprise Manager Suite, Grid Control tool, TOAD Tool/Oracle SQL Developer / any other comparable tool Required 9 Experience as a Oracle database administrator Required 8 Experience in using the full functionality of RMAN backup utility Required 8 Experience in database performance tuning and application SQL tuning out of which at least 3 years of experience in Oracle RAC environment. Required 8 Experience and knowledge in supporting applications system development life cycle. Required 7 Experience in performing database upgrade/patches out of which 3 years of experience in Oracle or RAC (primarily in place upgrade/patches Release upd Required 7 Experience as a Oracle database administrator using AIX (version 7.x or higher) operating system environment . Required 5 Experience in setting up/building and configuring Oracle RAC Required 6 Experience is using Oracle ASM out of which at 4 years of experience in RAC environment. Required 6 Experience writing scripts in AIX operating system environment (UNIX /Shell). Required 6 Experience in using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database based database is preferable. Required 5 Experience in using/setting up and configuring of physical standby/logical database/data guard Required 4 Experience in Active Data Guard (ADG) and data guard broker Required 2