Mainframe Systems Programmer/DBA

Nexlogica; California (MO); Hybrid; USD 90,000 - 130,000; Full time

Job summary

A technology solutions provider is seeking a skilled Mainframe Programmer to lead database upgrade projects and manage core database products. The ideal candidate will have over 7 years of experience in Systems Programming/DBA roles, with a strong background in IBM technologies and DBMS such as DB2 and ADABAS. Responsibilities include database administration, performance monitoring, and providing technical consulting for application teams. This position offers a hybrid work model in California.

Qualifications

• Minimum of seven years of experience as a Systems Programmer/DBA.
• At least three years in a lead role.
• 4+ years of DB Administration experience with Oracle/MySQL/PostgreSQL.

Responsibilities

• Lead and support complex database upgrade projects.
• Manage core database products and support business needs.
• Conduct database performance monitoring and administration.

Skills

IBM: Z/OS

IMS

DB2

ADABAS

SMP/E

JCL

CICS

ACF2

ASSEMBLER/COBOL/REXX

Oracle

Education

Bachelor’s degree in IT-related or engineering field

Tools

Oracle Enterprise Edition Database 19c

MySQL

PostgreSQL

Microsoft SQL Server

Job description

Job ID# 10276 – Posted 6/09/2023 – Hybrid, Los Angeles, CA

Position Description

A Mainframe Programmer is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products. This classification must plan, install, configure, test, implement and manage core database products, software products in support of the County’s database architecture and business needs. Special organizational or functional industry position titles for Systems Programmer/DBA include, but are not limited to, DB2 Systems Programmer/DBA, IMS Systems Programmer/DBA and ADABAS/NATURAL Systems Programmer/DBA.

Skills Required

The Mainframe Programmer/DBA for Legacy Systems manages different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS), and is responsible for planning and upgrading the database environments on a County-established basis; verifying the health of all the databases; database administration technical consulting for application and operations teams for the purpose of project planning/development; maintenance on production database systems; performance of technical reviews for existing systems that utilize one of the following database management systems (DBMS): ADABAS, DB2 or IMS; performance of evaluations for the purposes of selecting new or fine-tuning existing DBMS software; consultation with project development teams to provide recommendations on database design; development of logical and physical database designs; creation of overviews of logical database designs; creation of physical databases; database capacity planning; development and use of backup and recovery procedures for databases; database performance monitoring; database space monitoring; database reorganizations; database replication; database compression and database partitioning. The following technology skill sets are required to perform in this classification. 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.

Skills Preferred

• 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).
• Troubleshooting and resolution of ETL Jobs

Experience Required

This classification must have 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.

Experience Preferred

Must have 4+ years of DB Administration experience, specifically in a Oracle/MySQL/PostgreSQL environments.

Education Required

This classification requires the possession of a bachelor’s degree in an IT-related or engineering field.

Notes

• Nexlogica reserves the right to contact only selected candidates.

Apply Now

View All Positions