Oracle 19c Database Administrator

2 weeks ago


Philadelphia, United States VGroup Inc Full time
Job DescriptionJob 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: www.vgroupinc.com
LinkedIn: www.linkedin.com/company/v-group/
Facebook: www.facebook.com/VGroupIT
Twitter: www.twitter.com/vgroupinc



  • Philadelphia, United States V Group Inc. Full time

    Job Title: Oracle 19c Database Administrator (Mid-Level)Duration: 6+ MonthsStart Date: ASAPLocation: Philadelphia, PAInterview Type: Web Interview and/or In-personRequirement ID: SPA_ORAC612_BRDescription: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...


  • Philadelphia, United States V Group Inc. Full time

    Job Title: Oracle 19c Database Administrator (Mid-Level)Duration: 6+ MonthsStart Date: ASAPLocation: Philadelphia, PAInterview Type: Web Interview and/or In-personRequirement ID: SPA_ORAC612_BRDescription: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...


  • Philadelphia, United States Software Methods, Incorporated Full time

    Software Methods is seeking a Mid-level Oracle Database Administrator for a 24+ month contract opportunity at our client in Center City Philadelphia, PA. This opportunity supports normal work hours as well as after hours and scheduled weekends as needed. Normal work hours are Monday-Friday 10am-6pm EST.We are seeking a hands-on experienced Oracle Production...


  • Philadelphia, United States GreenXT Full time

    GreenXT is seeking an **Oracle Database Administrator** to support their Navy customer. **About GreenXT** - GreenXT is comprised of technical and business leaders. We hire intelligent, hardworking, and dedicated people who not only possess the desire to learn and improve their skills but want to contribute to the design and development of innovative...


  • Philadelphia, United States GreenXT Full time

    GreenXT is seeking an **Oracle Database Administrator** to support their Navy customer. **About GreenXT** - GreenXT is comprised of technical and business leaders. We hire intelligent, hardworking, and dedicated people who not only possess the desire to learn and improve their skills but want to contribute to the design and development of innovative...


  • Philadelphia, United States JPC Partners Full time

    JPC Partners is looking for a DBA (Oracle / MS SQL) that will focus on database administration and engineering in a Linux, VMware and Windows server environments. Responsibilities: Day to day administration and maintenance of ORACLE databases 12c and 19 Monitoring and support of the ORACLE database infrastructure to ensure optimum performance,...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management and Administration:Lead the management and administration of databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Oversee database performance tuning and optimization...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management and Administration:Lead the management and administration of databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Oversee database performance tuning and optimization...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Architecture and Design:Lead the design and architecture of complex database solutions, including database schemas, tables, views, and stored procedures, to meet business requirements and support application development initiatives.Collaborate with development teams to ensure optimal...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Architecture and Design:Lead the design and architecture of complex database solutions, including database schemas, tables, views, and stored procedures, to meet business requirements and support application development initiatives.Collaborate with development teams to ensure optimal...


  • Philadelphia, United States Philadelphia Gas Works Full time

    Responsibilities Include: Act as a contact for Oracle, Noetix and Spreadsheet Server end-users on program functionality, processes, Oracle Service Request (SR), troubleshoots, analyzes, and develops solutions to user issues; assist in the development of and facilitates customized one-onone and in-house classroom training courses. Assist the Oracle...


  • Philadelphia, United States Philadelphia Gas Works Full time

    Responsibilities Include: Act as a contact for Oracle, Noetix and Spreadsheet Server end-users on program functionality, processes, Oracle Service Request (SR), troubleshoots, analyzes, and develops solutions to user issues; assist in the development of and facilitates customized one-onone and in-house classroom training courses. Assist the Oracle...


  • Philadelphia, United States FutureNET Full time

    Job DescriptionJob DescriptionSeeking hands-on experienced Oracle Production Support DBA with 8-10 years of experience with large OLTP and DSS databases providing 7x24 hour support for databases that host multiple IIS web applications. Must be flexible to work nights and weekends with prior knowledge of scheduled work. Must be organized have good...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management:Manage and administer databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Monitor database performance and proactively identify and resolve performance issues,...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Management:Manage and administer databases, including installation, configuration, and maintenance of database management systems (DBMS) such as MySQL, Microsoft SQL Server, Oracle, or PostgreSQL.Monitor database performance and proactively identify and resolve performance issues,...

  • Database Administrator

    2 months ago


    Philadelphia, United States Tri-Force Consulting Services, Inc. Full time

    Job Description Title: Database Administrator Location: Philadelphia, PA Duration: 12 Months Client: City of Philadelphia *** This is the onsite position from day one. Job Description. Statement of Work: The ideal candidate will act as a supportive onsite role to the PPD Platform Engineering team with primary focus for performing highly...


  • Philadelphia, United States Tri-Force Consulting Services, Inc. Full time

    Job Description Title: Database Administrator Location: Philadelphia, PA Duration: 12 Months Client: City of Philadelphia *** This is the onsite position from day one. Job Description. Statement of Work: The ideal candidate will act as a supportive onsite role to the PPD Platform Engineering team with primary focus for performing highly...


  • Philadelphia, United States Philadelphia Gas Works Full time

    Overview: **Overview**: **Philadelphia** Gas Works** **Looking for a challenge and ready to light up your career?** The **Philadelphia Gas Works (PGW)** is the largest municipally-owned gas utility in the nation, supplying gas service in the City of Philadelphia to over 500,000 customers. From its humble beginnings in 1836, PGW has grown into the large,...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Maintenance:Assist in performing routine maintenance tasks such as backups, restores, and updates on databases.Learn and become familiar with database management systems (DBMS) and related tools used within the organization.Monitor database performance and assist in troubleshooting...


  • Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Database Maintenance:Assist in performing routine maintenance tasks such as backups, restores, and updates on databases.Learn and become familiar with database management systems (DBMS) and related tools used within the organization.Monitor database performance and assist in troubleshooting...