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 applications
• Deploying and supporting all aspects of application release code enhancements
• Supporting 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 Support
• Proactively monitoring of database performance, RMAN/EXPORT Backups, maintenance jobs and reporting using TOAD, OEM13c and/or Foglight tools
• Troubleshooting 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 Switchover
• Backup 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 Scheduler
• Working experience with encrypted wallets
• Prior experience of configuring Oracle databases on AWS, experience of configuring Oracle19c databases on Linux
• Prior 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.

Regards
Varma
732-338-7524