Consultant
COOLSOFT, Columbus, OH, United States
Job Title
Consultant
Job Location Downtown Columbus, OH
Job Type Contract
Duration 2 Months
Compensation DOE
Description We are seeking an experienced database administrator who will drive high-caliber database design, solution delivery, and support in a fast-paced and collaborative environment. The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well‑managed excellence.
Responsibilities
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.
EOE Protected Veterans/Disability
#J-18808-Ljbffr
Job Location Downtown Columbus, OH
Job Type Contract
Duration 2 Months
Compensation DOE
Description We are seeking an experienced database administrator who will drive high-caliber database design, solution delivery, and support in a fast-paced and collaborative environment. The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well‑managed excellence.
Responsibilities
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.
EOE Protected Veterans/Disability
#J-18808-Ljbffr