Senior Oracle Cloud DBA
American Business Solutions, Columbus, OH, United States
Overview:
Engagement Type
Contract
The Senior Oracle DBA will perform the following duties:
- Extensive work experience in Oracle RAC Database
Administration on a very large database environment.
- Install, configure, and administer Oracle RAC DBs version
19c and above, including the design, configuration and operation of n-node
clusters and data recovery.
- Strong hands-on experience with Oracle 19c container and
pluggable databases.
- Configure Physical standby databases and perform
switchover/failover activities. Troubleshoot standby and switchover issues.
- Configuration management, performance tuning and
administration of mission critical production databases
- 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.
- Perform Schema level and Table level data refreshes from
Production to Non-Production environments using Data pump EXPDP/IMPDP.
- Must have experience on configuration of ACFS snapshot
clone process
- Experience in setting up Active Data guard with Cascaded
standby database setup
- Extensive experience in setting up and Managing High
Availability, Disaster Recovery solutions
- Must have Database migration methods such as ZDM,
Goldengate, RMAN duplicate and RMAN backup, restore and recovery and Data pump
- Experience working in Oracle Data Warehouse
- Strong experience to Various Oracle Cloud Database
services (OCI) and ExaCC highly preferable, specially Resource provisioning,
zdm migration, Observability, Performance Diagnostics, Capacity Planning and
security & Compliance
- Extensive experience in Shell & SQL and PL/SQL
scripting
- Monitor database activities such as Backup, Error Logs,
Space, Object, Performance, User and Session monitoring for proper capacity and
availability.
- Provide non-production and production support and Lead in
trouble shooting production issues and application performance issues..
- 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 option (ASO) like Encryption TDE, Data Redaction, VPD,
Unified Auditing, data classification and security preventive techniques
including data encryption at reset and in-flight.
- Well experienced on Oracle Goldengate 19c or higher
- Work with development team and leading in tuning
applications for better performance.
- Excellent communication skills, customer service and
client management skills.
Required Experience:
-8 years of experience as an Oracle database administrator
out of which at least 4 years on 19c.
-5 years of experience:
as an Oracle database administrator using AIX (version 7.x
or higher) operating system environment out of which at least 2 years with 19c.
setting up/building and configuring Oracle RAC out of which
3 years on 19c.
in using the full functionality of RMAN backup utility (ex.
full back up, incremental back up, cloning, restore/recovery) out of which at
least 2 years of experience in using RMAN utility with 19c.
in Active Data Guard (ADG) and data guard broker out of
which at least 1 year of experience in using with 19c.
in database performance tuning and application SQL tuning
out of which at least 4 years of experience in Oracle RAC environment (version
19c).
in using Oracle ASM out of which at 4 years of experience in
RAC environment with version 19c.
in performing database upgrade/patches out of which 3 years
of experience in Oracle 19c RAC (primarily in place upgrade/patches Release
updates).
writing scripts in AIX operating system environment (UNIX
/Shell).
working within an AIX 7.x operating system environment or
higher
-2 years of experience:
in implementing ExaCC/OCI varoious features like Resource
provisioning, zdm migration, Observability, Performance Diagnostics, database
backup and Recovery, Capacity Planning and security & Compliance
in data modeling and application database design
in writing PL/SQL code.
using snapshot cloning technology using Oracle ACFS with
Oracle RAC & Standby database (version 12c/19c) based database is
preferable.
implementing TDE, Transparent sensitive data protection
(TSDP) using Data redaction and VPD Required/Desired Skills
Skill Required/Desired Amount of Experience 8 years of experience as an Oracle database administrator Required 8.0 Years 4 years on 19c Required 4.0 Years Oracle database administrator using AIX (version 7.x or higher) operating system environment out of which at least 2 years with 19c. Required 5.0 Years setting up/building and configuring Oracle RAC out of which 3 years on 19c. Required 5.0 Years full functionality of RMAN backup utility (ex. full back up, incremental back up, cloning, restore/recovery) out of which at least 2 years 19c Required 5.0 Years Active Data Guard (ADG) and data guard broker out of which at least 1 year of experience in using with 19c. Required 5.0 Years working within an AIX 7.x operating system environment or higher Required 5.0 Years ExaCC/OCI varoious features like Resource provisioning, zdm migration, Observability, Performance Diagnostics, database backup and Recovery, Capacity Required 2.0 Years snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database (version 12c/19c) based database is preferable. Required 2.0 Years writing PL/SQL code. Required 2.0 Years
Skills:
8 years of experience as an Oracle database administrator,4 years on 19c,Oracle database administrator using AIX (version 7.x or higher) operating system environment out of which at least 2 years with 19c.,setting up/building and configuring Oracle RAC out of which 3 years on 19c.,full functionality of RMAN backup utility (ex. full back up,incremental back up,cloning,restore/recovery) out of which at least 2 years 19c,Active Data Guard (ADG) and data guard broker out of which at least 1 year of experience in using with 19c.,working within an AIX 7.x operating system environment or higher,ExaCC/OCI varoious features like Resource provisioning,zdm migration,Observability,Performance Diagnostics,database backup and Recovery,Capacity,snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database (version 12c/19c) based database is preferable.,writing PL/SQL code.
Engagement Type
Contract
The Senior Oracle DBA will perform the following duties:
- Extensive work experience in Oracle RAC Database
Administration on a very large database environment.
- Install, configure, and administer Oracle RAC DBs version
19c and above, including the design, configuration and operation of n-node
clusters and data recovery.
- Strong hands-on experience with Oracle 19c container and
pluggable databases.
- Configure Physical standby databases and perform
switchover/failover activities. Troubleshoot standby and switchover issues.
- Configuration management, performance tuning and
administration of mission critical production databases
- 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.
- Perform Schema level and Table level data refreshes from
Production to Non-Production environments using Data pump EXPDP/IMPDP.
- Must have experience on configuration of ACFS snapshot
clone process
- Experience in setting up Active Data guard with Cascaded
standby database setup
- Extensive experience in setting up and Managing High
Availability, Disaster Recovery solutions
- Must have Database migration methods such as ZDM,
Goldengate, RMAN duplicate and RMAN backup, restore and recovery and Data pump
- Experience working in Oracle Data Warehouse
- Strong experience to Various Oracle Cloud Database
services (OCI) and ExaCC highly preferable, specially Resource provisioning,
zdm migration, Observability, Performance Diagnostics, Capacity Planning and
security & Compliance
- Extensive experience in Shell & SQL and PL/SQL
scripting
- Monitor database activities such as Backup, Error Logs,
Space, Object, Performance, User and Session monitoring for proper capacity and
availability.
- Provide non-production and production support and Lead in
trouble shooting production issues and application performance issues..
- 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 option (ASO) like Encryption TDE, Data Redaction, VPD,
Unified Auditing, data classification and security preventive techniques
including data encryption at reset and in-flight.
- Well experienced on Oracle Goldengate 19c or higher
- Work with development team and leading in tuning
applications for better performance.
- Excellent communication skills, customer service and
client management skills.
Required Experience:
-8 years of experience as an Oracle database administrator
out of which at least 4 years on 19c.
-5 years of experience:
as an Oracle database administrator using AIX (version 7.x
or higher) operating system environment out of which at least 2 years with 19c.
setting up/building and configuring Oracle RAC out of which
3 years on 19c.
in using the full functionality of RMAN backup utility (ex.
full back up, incremental back up, cloning, restore/recovery) out of which at
least 2 years of experience in using RMAN utility with 19c.
in Active Data Guard (ADG) and data guard broker out of
which at least 1 year of experience in using with 19c.
in database performance tuning and application SQL tuning
out of which at least 4 years of experience in Oracle RAC environment (version
19c).
in using Oracle ASM out of which at 4 years of experience in
RAC environment with version 19c.
in performing database upgrade/patches out of which 3 years
of experience in Oracle 19c RAC (primarily in place upgrade/patches Release
updates).
writing scripts in AIX operating system environment (UNIX
/Shell).
working within an AIX 7.x operating system environment or
higher
-2 years of experience:
in implementing ExaCC/OCI varoious features like Resource
provisioning, zdm migration, Observability, Performance Diagnostics, database
backup and Recovery, Capacity Planning and security & Compliance
in data modeling and application database design
in writing PL/SQL code.
using snapshot cloning technology using Oracle ACFS with
Oracle RAC & Standby database (version 12c/19c) based database is
preferable.
implementing TDE, Transparent sensitive data protection
(TSDP) using Data redaction and VPD Required/Desired Skills
Skill Required/Desired Amount of Experience 8 years of experience as an Oracle database administrator Required 8.0 Years 4 years on 19c Required 4.0 Years Oracle database administrator using AIX (version 7.x or higher) operating system environment out of which at least 2 years with 19c. Required 5.0 Years setting up/building and configuring Oracle RAC out of which 3 years on 19c. Required 5.0 Years full functionality of RMAN backup utility (ex. full back up, incremental back up, cloning, restore/recovery) out of which at least 2 years 19c Required 5.0 Years Active Data Guard (ADG) and data guard broker out of which at least 1 year of experience in using with 19c. Required 5.0 Years working within an AIX 7.x operating system environment or higher Required 5.0 Years ExaCC/OCI varoious features like Resource provisioning, zdm migration, Observability, Performance Diagnostics, database backup and Recovery, Capacity Required 2.0 Years snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database (version 12c/19c) based database is preferable. Required 2.0 Years writing PL/SQL code. Required 2.0 Years
Skills:
8 years of experience as an Oracle database administrator,4 years on 19c,Oracle database administrator using AIX (version 7.x or higher) operating system environment out of which at least 2 years with 19c.,setting up/building and configuring Oracle RAC out of which 3 years on 19c.,full functionality of RMAN backup utility (ex. full back up,incremental back up,cloning,restore/recovery) out of which at least 2 years 19c,Active Data Guard (ADG) and data guard broker out of which at least 1 year of experience in using with 19c.,working within an AIX 7.x operating system environment or higher,ExaCC/OCI varoious features like Resource provisioning,zdm migration,Observability,Performance Diagnostics,database backup and Recovery,Capacity,snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database (version 12c/19c) based database is preferable.,writing PL/SQL code.