Tech Stack
CloudOraclePostgresPythonSQL
About the role
- Design and develop database replication systems, processes and enhancements for company's complex high traffic, business critical mainframe and non-mainframe database systems.
- Lead the design of replication solutions to deliver data to our clients reporting, event management and other critical live data targets.
- Develop solutions and processes for reliable and stable data replication, using IBM's Infosphere Data Replication (IIDR) and Change Data Capture (CDC) technology
- Assist with the implementation of new or additional replication technology to improve infrastructure service locally and remotely.
- Lead small, moderately complex projects or working on complex tasks that require a high degree of judgement, resourcefulness, and self-initiative.
- Demonstrate specialized expertise to evaluate wide-ranging and complex issues and develop creative solutions.
- Recommend new procedures.
Requirements
- 5+ years of overall IT experience in mainframe and open database technologies, with 3+ years on IBM Infosphere Data Replication/CDC
- Working knowledge of replication on Db2 for z/OS, Db2 LUW, Oracle, SQL Server, and cloud based database components and concepts
- Mastery of IBM Infosphere Data Replication on mainframe and non-mainframe systems
- Ability to analyze, diagnose and resolve database replication issues and assist applications teams with replication issues
- Experience in evaluating, designing, and deploying high performance replication designs
- Experience managing and migrating database replication change requests from client teams
- Ability to analyze, test, and recommend new database replication features, functionality, and products
- Ability to support replication tasks for database recoveries and support Disaster Recovery
- Excellent communication skills, written and interpersonal
- Desired: Experience with IBM IIDR/CDC Access Manager and Management Console
- Desired: Experience with IBM Db2 for z/OS Version 13
- Desired: Experience with open databases such as Oracle, SQL Server, Db2 LUW
- Desired: Experience with PostgreSQL Databases
- Desired: Experience with mainframe data integration with cloud and other open environments
- Desired: REXX, ISPF, CLIST, Python or other automation development skills/experience