Mainframe Systems Programmer/DBA

Skills Required

• IBM: Z/OS, IMS, DB2, ADABAS, SMP/E, JCL, IMS DB/DC, CICS, ACF2, ASSEMBLER/COBOL/REXX, IBM FILE MANAGER, DELTA/IMS, NATURAL/ SUPERNAT, ENTIREX, CA SPOOL, IMS & DB2 BMC Tools, N20/TRIM.
• Install, Configure and Support Oracle Enterprise Edition Database 19c as a backend for both public facing web applications and internal data warehousing on Linux operating system.
• Install and configure MySQL and PostgreSQL databases.
• Install and Support Microsoft SQL server instances.
• Configure and support Oracle gateways connecting SQL Server, MySQL and PostgreSQL server instances to the Oracle database.
• Oracle Spatial implementation and support.
• Build custom extract, transform and load (ETL) utilities with Crons, SQLLoader and PL/SQL.
• Provide Database Administration services such as patch install, cloning, backup and recovery of databases and script development (Unix shell scripting and PL/SQL).
• Troubleshoot and resolution of ETL Jobs.

Experience Required

• A minimum of seven (7) years of experience as a Systems Programming/DBA, with at least three (3) years of that experience in a lead role.
• A minimum of four (4) years of DB Administration experience, specifically in a Oracle/MySQL/PostgreSQL environments.

Education Required

A bachelor’s degree in an IT-related or engineering field.