Sr. Oracle DBA - Oracle Goldengate, Oracle Enterprise Manager Suite

State of Ohio - DCY - Sr. Oracle DBA - Oracle Goldengate, Oracle Enterprise Manager Suite - 768222

Job Duties:

· Assessment of database architecture with recommended strategies, refinements, modifications, and support according to industry standards.

· Assessment and recommendation of Oracle database environments for upgrades and maintenance plans.

· Lead the database upgrade process based on the major version release schedule.

· Recommendations for updates to the detailed design specifications for storage and network configurations required to support several database environments

· Lead in installation/upgrade, mentoring and configuration of Oracle Database, Real Application Cluster Software, Active Data Guard and Advanced Compression for several applications

· Install, Configure and administer Oracle Enterprise Manager.

· Install, configure and administer Oracle RAC DBs version and above, including the design, configuration and operation of n-node clusters, data recovery, and user/group/role definition.

· 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

· 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 and Lead in trouble shooting production issues and application performance issues.

· Review and assess the backup and recovery strategy currently implement for production and non-production databases and come up with recommendations and Lead in implementing the recommendations.

· Work with a development team and leading in tuning applications for better performance.

· Lead ODJFS IT Staff in documenting all database environments and any other tasks assigned as needed based on project needs.

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.

Required Experience:

· 8 years experience as a Oracle database administrator

· 5 years of experience as a Oracle database administrator using AIX (version 7.x or higher) operating system environment

· 6 years of experience in setting up/building and configuring Oracle RAC

· 8 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

· 4 years of experience in using/setting up and configuring of physical standby/logical database/data guard

· 2 year of experience in Active Data Guard (ADG) and data guard broker

· 8 years experience in database performance tuning and application SQL tuning out of which at least 3 years of experience in Oracle RAC environment.

· 6 years experience is using Oracle ASM out of which at 4 years of experience in RAC environment.

· 7 plus years experience and knowledge in supporting applications system development life cycle.

· 7 plus years of experience in performing database upgrade/patches out of which 3 years of experience in Oracle or RAC (primarily in place upgrade/patches Release updates).

· 3 years experience in data modeling and application database design

· 3 years experience in writing PL/SQL code.

· 6 years experience writing scripts in AIX operating system environment (UNIX /Shell).

· 5 years experience working within an AIX operating system environment or higher

· 5 year of experience in using snapshot cloning technology using Oracle ACFS with Oracle RAC & Standby database based database is preferable.

· At least 9 years experience in Oracle Enterprise Manager Suite, Grid Control tool, TOAD Tool/Oracle SQL Developer / any other comparable tool

· Must be able to use Microsoft Project, Word, PowerPoint and other Microsoft office tool suite

Compensation: $80.00 per hour

About SR International INC.

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.

Who We Are

We Are Leading IT Based Solution Providers

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.

Our Vision.

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.

Career At SR International

At SR International, we treat our consultants like family. Our business and our reputation have been built and maintained by quality resources working onboard, so it’s important for us to maintain the quality resource pool.