Apply on Employer Site

Nexlogica · 2 months ago

Mainframe Systems Programmer - Senior Level

Downey, CA

Full-time

Onsite

Senior Level

7+ years exp

Nexlogica is seeking a Senior Mainframe Systems Programmer to lead and support complex database upgrade projects and manage core database products. The role involves planning, installing, configuring, and maintaining database systems in alignment with the County's architecture and business needs.

Cloud ComputingConsultingSoftwareWeb Design

Responsibilities

Lead and/or support complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products

Plan, install, configure, test, implement and manage core database products, software products in support of the County’s database architecture and business needs

Manage different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS)

Plan and upgrade the database environments on a County-established basis; verify the health of all the databases

Provide database administration technical consulting for application and operations teams for the purpose of project planning/development

Perform maintenance on production database systems

Conduct technical reviews for existing systems that utilize one of the following database management systems (DBMS): ADABAS, DB2 or IMS

Perform evaluations for the purposes of selecting new or fine-tuning existing DBMS software

Consult with project development teams to provide recommendations on database design

Develop logical and physical database designs

Create overviews of logical database designs

Create physical databases

Conduct database capacity planning

Develop and use backup and recovery procedures for databases

Monitor database performance

Monitor database space

Conduct database reorganizations, replication, compression and partitioning

Qualification

DB2IMSADABASZ/OSSMP/EJCLCICSACF2AssemblerCOBOLREXXIBM FILE MANAGERDELTA/IMSNATURALSUPERNATENTIREXCA SPOOLIMS & DB2 BMC ToolsN20/TRIM

Required

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

Possession of a bachelor's degree in an IT-related or Computer Science field

Management of different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS)

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

Database partitioning

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