Job Details

ID #49540119
State New York
City New york city
Job type Contract
Salary USD $72 - $84 per hour 72 - 84 per hour
Source QED National
Showed 2023-03-25
Date 2023-03-24
Deadline 2023-05-23
Category Et cetera
Create resume

Oracle DBA

New York, New york city, 10008 New york city USA

Vacancy expired!

A leading utility provider located in New York, NY is looking for an Oracle DBA for a 12+ month contract.

Some onsite work is required throughout the life of the contract, and is likely to increase over time. Local candidates only

To be considered for this position, the client has advised that upon placement, consultants will be required to wear a mask under certain circumstances, show proof of full vaccination or submit on a weekly basis proof of a negative COVID-19 PCR diagnostic test

Requirements and skills

  • Seeking a highly motivated DBA with extensive knowledge of Oracle GoldenGate and related technologies.
  • Candidates should have 5 or more years' experience, and should have worked in a team environment on systems that have moved to production. As part of the dedicated support team, the candidate will administer databases and Golden Gate (e.g. Oracle RDBMS 11gR2, 12c, and19c), and perform all duties related to on-going operations of the database infrastructure running on Linux/UNIX operating systems.
  • Experience with RDBMS 11gR2, 12c, and 19c Oracle databases and GoldenGate 19.x, and 21.x
  • Must understand java runtime concepts such as heap memory, thread dumps, garbage collection, etc.
  • Capacity to embrace change and quickly adapt to new situations, changes in direction, and altering priorities
  • Ability to demonstrate critical thinking, providing options, recommendations, and additional actions relating to resolving issues, mitigating risks, and resolving escalated items
  • Able to produce statistical data/charts/graphs
  • Experience working with Linux/UNIX environments required
  • Ability to distinguish between critical and non-critical issues; strong problem-solving skills.

Basic Qualifications for Consideration

  • Degree in Information Systems or Computer Science, or equivalent combination of education and experience
  • Minimum 5 years of experience with Oracle Database Administration
  • Minimum 5 years of experience with Oracle Grid Infrastructure and RAC databases
  • Minimum 5 years of experience with Oracle CDC based change capture and apply
  • Minimum 3 years of experience with Golden Gate
  • Experience with high availability and failover concepts and implementation
  • Strong understanding in PL/SQL and SQL and able to write SQL query
  • Ability to understand and interface with infrastructure and Development organizations and internal business owners
  • Oracle Automatic Storage Management (ASM) and Oracle Automatic Storage Management Cluster File System (ACFS) experience

Preferred Skills

  • Utility experience is desirable

Responsibilities

  • The candidate will be responsible for the GoldenGate portion of the company's Data Hub, enabling streaming of data from critical systems to where it is needed.
  • Install and configure Oracle Grid Infrastructure and RAC databases
  • Install and configure Oracle 21c Golden Gate for Oracle 19c database replication
  • Configure unidirectional and bidirectional replication
  • Setup GoldenGate for Zero Downtime Upgrades
  • Explain the difference between classic vs integrated capture
  • Improve Golden Gate performance and troubleshoot common issues
  • Configure high availability using Oracle Golden Gate
  • Perform Oracle Golden Gate upgrade
  • Configure Oracle to MS SQL Server replication
  • Configure MS-SQL Server to Oracle replication
  • Configure Monitoring alerts from GG Home
  • Support Disaster Recovery Planning and Testing
  • Investigate and troubleshoot tickets by querying database and viewing server logs
  • Identify issue trends and develop ways to prevent future occurrences

About us: QED National is a leading IT consulting, solutions and staff augmentation firm, serving both the public and private sectors for over 29 years. Headquartered in midtown Manhattan, QED National's team is comprised of the brightest minds in the industry with the skills to solve the most complex technological problems.

Vacancy expired!

Subscribe Report job