View all jobs

Oracle Production Support DBA

Philadephia, PA
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.


Share This Job

Powered by