ADABAS/CICS/IMS Systems Programmer/DBA # 26-24822

Us Tech Solutions; Downey (CA); On-site; USD 272,214,000 - 283,675,000; Full time

Job summary

US Tech Solutions in Downey, CA is seeking a Mainframe Systems Programmer/DBA to lead and support complex database upgrades and related tasks. You will plan, install, configure, test, implement and manage core database products to support the County’s architecture and business needs.

The role requires 7+ years of Systems Programming/DBA experience, including 3+ years in a lead position, with deep knowledge of DB2, IMS, ADABAS, CICS and related mainframe tools.

Qualifications

• This position requires a minimum of seven years of Systems Programming/DBA experience.
• This includes at least three years in a lead role.
• Bachelor's degree in IT-related or engineering field is required.

Responsibilities

• Lead or support complex database upgrade projects and related tasks.
• Plan, install, configure, test, implement and manage core DBMS products.
• Provide database administration consulting for planning and operations teams.
• Maintain and optimize production database systems.
• Perform database design, capacity planning, backup and recovery procedures.

Skills

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

NATSECURITY

Education

Bachelor's degree in IT/engineering

Tools

DBMS: DB2/IMS/ADABAS

Mainframe Tools: SMP/E

Job description

$95-$99 per hour

Downey, CA

Contract

Duration: 12 Months

Schedule: 08:00 AM – 05:00 PM

Job Description:

• A Mainframe Systems Programmer/DBA 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.

Responsibilities:

• The Mainframe Systems 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.

Experience:

• 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.

Skillsets:

• 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.


• IMS DB/DC CICS ADABAS NATURAL N2O TRIM NATSECURITY.

Education:

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

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement: By applying, you acknowledge that AI-assisted tools may be used during hiring.

#LI-AS140