Oracle Production Support DBA

Please share a suitable profile if you've. Please send your resume to Varma@hermitageinfotech.com or call Varma at 732-593-8453 Extension 202 for any questions or call 732-231-6194 directly. Please mention your visa status, current location, minimum expected salary, and availability to start a new project.

Position is a hybrid with on-site and remote support after hours and scheduled weekends as needed. Normal work hours will be Monday-Friday 10a-6p.

Its a Mid level Oracle DBA

Responsibilities for the Oracle Production Support DBA include:

Production DBA for OLTP and Data Warehouse Production applicationsDeploying and supporting all aspects of application release code enhancementsSupporting Oracle 19c installations on Windows and Unix in a multi-tenant environment and apply quarterly Security patches/bug fixes.Creating and working SR requests with Oracle SupportProactively monitoring of database performance, RMAN/EXPORT Backups, maintenance jobs and reporting using TOAD, OEM13c and/or Foglight toolsTroubleshooting and diagnosing IIS application pool connectivity issues surrounding 'inactive and dropped sessions.Maintaining, patching, and rebuilding Data Guard - physical standby databases (on-prem and Cloud hybrid)Disaster recovery installation and support and testing different scenarios; like a Failover or SwitchoverBackup Strategies and cloning databases using RMAN "active duplicate" and multi-tenant "hot cloning."Proactive database monitoring and performance tuning of; tables, indexes, materialized views, scheduled jobs, packages, procedures, and functions.Must have skills for the Oracle Product Support DBA include:

• 8-10 years of experience with large OLTP and DSS databases

• Strong production support DBA experience

• Hands-on DBA experience with databases that support IIS web applications.

• Experience with installation, testing and staging Oracle Quarterly security patches on Windows and Linux using Opatch utility.

• Installation and configuration of SQL Server gateways on Oracle19c.

• Installation, configuration, and patching Oracle client and ODAC versions

• Experience maintaining and monitoring database storage structures (datafiles, tablespaces, tables, indexes, Mviews)

• Experience monitoring and managing production users and security.

• Experience managing database backups, developing, and performing test recoveries.

• Working experience of all RMAN, configurations, creating jobs and levels of backups and use of Catalog

• Working experience of configuring, rebuilding and failover for on-prem and cloud hybrid Physical Standby DataGuard

• Working experience of DR strategies; Failover, Switchover to an on-prem or cloud replication

• Working experience of Golden Gate Replication configurations, support, and setup, as well as configuring and maintaining Golden Gate one-way and bi-directional replication environments

• Good understanding of 'Data at Rest' and 'Data in Transit' protocols (including TDE)

• Understanding of Centrally Managed Users (CMU) concepts including 'generic wallets'

• Experience with monitoring tools; TOAD, OEM13c, Foglight (includes setup, patch maintenance, modifying/adding alerts and reports.

Expensive knowledge of Materialized Views refresh options and Oracle Job SchedulerWorking experience with encrypted walletsPrior experience of configuring Oracle databases on AWS, experience of configuring Oracle19c databases on LinuxPrior experience of SQL Server 2017 - 2022 and Replication/Failover is a plus.Prior knowledge of Postgres is a plus.Working knowledge of Cognos App/Reporting server is a plus.Working knowledge of KRONOS software installations is a plus.

RegardsVarma732-338-7524