Oracle database administrator Job at V Group Inc, Philadelphia, PA

ZzA2dG9teFRzSDIvV2hsbW81TEhqc0Rrenc9PQ==
  • V Group Inc
  • Philadelphia, PA

Job Description

Job Title: Oracle 19c Database Administrator (Mid-Level)

Duration: 6+ Months

Start Date: ASAP

Location: Philadelphia, PA

Interview Type: Web Interview and/or In-person

Requirement ID: SPA_ORAC612_BR



Description:
We are seeking an Oracle DBA (19c) with 8-10 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 on-site and remote support after hours and scheduled weekends as needed. Normal work hours will be Monday-Friday 10a-6p.



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, 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 (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.



Required Skills:

  • 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 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 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 Oracle 19c 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.



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:

Report this job
  • Dice Id: 10112072a
  • Position Id: 2024-22053

Job Tags

Contract work, Work experience placement, Immediate start, Remote job, Weekend work, Monday to Friday,

Similar Jobs

The Lactation Network

IT Help Desk Technician Job at The Lactation Network

 ...Do you enjoy jumping in to help team members solve IT problems? Are you driven to change the standard...  ...Lactation Network is hiring an IT Help Desk Technician . This person will play a...  ...expect from us ~ Unlimited PTO. We work hard. Were passionate about what were... 

CORNETT

Web Development Intern Job at CORNETT

 ...Cornett, Lexington's largest ad agency, is looking for a web development intern to join the team part-time for the fall or spring semester. The ideal candidate knows HTML & CSS and has a desire to learn more through hands-on experience. They may be self-taught, completed... 

Amazon

Amazon Fulfillment Center Warehouse Associate Job at Amazon

 ...Amazon Fulfillment Center Warehouse Associate Job Overview Youll be part of the...  ...merch, make-on-demand, customer returns, Prime Now, and general fulfillment. You will be...  ..., for our super-fast (2-hour or less) delivery service. Duties & Responsibilities... 

McLarty Daniel Chevrolet

Automotive Parts Manager Job at McLarty Daniel Chevrolet

Position: Parts ManagerWe are looking for a parts manager with attention to detail to be responsible for managing inventory. The parts...  ...experience in a relevant field such as manufacturing or the automotive industry.* Attention to detail.* Knowledge of inventory monitoring... 

Brinks

Director of Security Job at Brinks

 ...about our future. Learn why so many people have made the choice to join our team and stay here. Job Title Director of Security Job Description Brinks Global Services is a division of Brinks Inc, the worlds premier provider of secure logistics and security...