Sr. Oracle RAC Database Administrator

S R International•Columbys, OH

21h•Hybrid

About The Position

The Department of Children and Youth (DCY) IT organization is 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. SR International has been a leading name among the IT consulting companies with offices in US and India. For past 16 years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers. Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter. Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.

Requirements

Extensive work experience in Oracle RAC Database Administration on a very large database environment
Strong hands-on experience with Oracle 19c container and pluggable databases
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
Extensive experience in Shell & SQL and PL/SQL scripting
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
Excellent communication skills, customer service and client management skills
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
5 years of experience setting up/building and configuring Oracle RAC out of which 3 years on 19c
5 years of experience 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
5 years of experience in Active Data Guard (ADG) and data guard broker out of which at least 1 year of experience in using with 19c
5 years of experience in database performance tuning and application SQL tuning out of which at least 4 years of experience in Oracle RAC environment (version 19c)
5 years of experience in using Oracle ASM out of which at 4 years of experience in RAC environment with version 19c
5 years of experience in performing database upgrade/patches out of which 3 years of experience in Oracle 19c RAC (primarily in place upgrade/patches Release updates)
5 years of experience writing scripts in AIX operating system environment (UNIX /Shell)
5 years of experience working within an AIX 7.x operating system environment or higher
2 years of experience in implementing ExaCC/OCI various features like Resource provisioning, zdm migration, Observability, Performance Diagnostics, database backup and Recovery, Capacity Planning and security & Compliance
2 years of experience in data modeling and application database design
2 years of experience in writing PL/SQL code
2 years of experience in implementing TDE, Transparent sensitive data protection (TSDP) using Data redaction and VPD

Nice To Haves

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
Using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database (version 12c/19c) based database is preferable

Responsibilities

Install, configure, and administer Oracle RAC DBs version 19c and above, including the design, configuration and operation of n-node clusters and data recovery
Configure Physical standby databases and perform switchover/failover activities
Troubleshoot standby and switchover issues
Perform configuration management, performance tuning and administration of mission critical production databases
Perform Installation/Patching/Upgrade of the OEM, database software on AIX platform
Perform RMAN backup and recovery of the Oracle Database
Perform database 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
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
Lead in trouble shooting production issues and application performance issues
Work with development team and leading in tuning applications for better performance