Data Engineer- Oracle Golden Gate DBA

This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community.

Be part of a dynamic team where your distinctive skills will contribute to a winning culture and team.

As a Data Engineer III at JPMorgan Chase within the Digital Channels (Payment Technology) organization, you serve as a seasoned member of an agile team to design and deliver trusted data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. You are responsible for developing, testing, and maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm’s business objectives.

Job Responsibilities

1. Supports review of controls to ensure sufficient protection of enterprise data.
2. Advises and makes custom configuration changes in one to two tools to generate a product at the business or customer request.
3. Updates logical or physical data models based on new use cases.
4. Frequently uses SQL and understands NoSQL databases and their niche in the marketplace.
5. Adds to team culture of diversity, equity, inclusion, and respect.

Required Qualifications, Capabilities, And Skills

1. Strong hands-on experience in Oracle Golden Gate, should have in-depth knowledge and experience in setting up and troubleshooting Golden Gate.
2. Good PL/SQL knowledge and should have good experience in SQL scripting & shell scripting.
3. Well versed in Database Performance Tuning, OEM (AWR, ADDM, ASH reports) analysis, SQL Tuning/Optimization, analyzing Query execution plans.
4. Good experience in setting up Standby Databases/Data Guard configurations, SR/DR events coordination.
5. Experienced in Oracle to AWS Aurora/Postgres or other AWS DBs (NoSQL DBs) migrations.
6. Significant experience with statistical data analysis and ability to determine appropriate tools and data patterns to perform analysis.
7. Working understanding of NoSQL databases.
8. Good understanding of DB schema designs, table partitioning, Export/Import, Schema refreshes etc.