Job Title: Oracle 19c Database Administrator (MidLevel)
Duration: 6 Months
Start Date: ASAP
Location: Philadelphia PA
Interview Type: Web Interview and/or Inperson
Requirement ID: SPAORAC612BR
Description:
We are seeking an Oracle DBA (19c) with 810 years of experience with large OLTP and DSS databases providing 7x24 hour support for databases that host multiple IIS web applications.
Note: Position is a hybrid with onsite and remote support after hours and scheduled weekends as needed. Normal work hours will be MondayFriday 10a6p.
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 multitenant 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 OEM 13c 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 (onprem 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 multitenant hot cloning.
- Proactive database monitoring and performance tuning of; tables indexes materialized views scheduled jobs packages procedures and functions.
Required Skills:
- 810 years of experience with large OLTP and DSS databases.
- Strong production support DBA experience.
- Handson 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 Oracle 19c.
- 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 onprem and cloud hybrid Physical Standby DataGuard.
- Working experience of DR strategies; Failover Switchover to an onprem or cloud replication.
- Working experience of Golden Gate Replication configurations support and setup as well as configuring and maintaining Golden Gate oneway and bidirectional 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 Oracle 19c databases on Linux.
- Prior experience of SQL Serverand 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.
Why V Group Inc.
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the State of NY CT PA MD MN NC GA FL IL CO CA NM MI MS OH OR TN VA VT WA WI and WY.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter: