Mainframe Systems Programmer/Mainframe ADABAS Administrator (DBA)

Mainframe Systems Programmer / DBA (Legacy Systems)
Job Type: W2 Contract
Contract Duration: 12 Months, Possible Extension 
Location: Los Angeles, California 90020
Work Setting: Hybrid
Pay Rate: $85.00 - $91.00/hr.

Position Overview

The Mainframe Systems Programmer/DBA is responsible for leading and supporting complex database upgrade projects, installation, modification, testing, implementation, maintenance, and enhancement of enterprise database and system software products. This role plans, installs, configures, tests, implements, and manages core database technologies that support organizational database architecture and business requirements.

Specialized titles may include, but are not limited to:

• DB2 Systems Programmer/DBA
• IMS Systems Programmer/DBA
• ADABAS/NATURAL Systems Programmer/DBA

Key Responsibilities

• Manage and administer enterprise database environments, including hierarchical, relational, and file-based databases such as IMS, DB2, and ADABAS.
• Plan, implement, and upgrade database environments according to established organizational standards.
• Monitor database health, performance, capacity, and storage utilization.
• Provide technical consulting and support to application development and operations teams.
• Perform maintenance and troubleshooting of production database systems.
• Conduct technical reviews of systems utilizing ADABAS, DB2, and IMS database management systems (DBMS).
• Evaluate and tune database management software to optimize performance and reliability.
• Collaborate with project teams to recommend database architectures and designs.
• Develop logical and physical database models and create physical database environments.
• Perform database capacity planning and forecasting.
• Develop and maintain database backup and recovery procedures.
• Support database replication, compression, partitioning, and reorganization activities.
• Monitor and optimize database performance and storage utilization.

Required Technical Skills

Mainframe Technologies

• IBM z/OS
• IMS
• DB2
• ADABAS
• SMP/E
• JCL
• IMS DB/DC
• CICS
• ACF2
• Assembler
• COBOL
• REXX
• IBM File Manager
• DELTA/IMS
• Natural / SuperNatural
• EntireX
• CA Spool
• IMS & DB2 BMC Tools
• N20/TRIM

Database Administration

• Database installation, configuration, maintenance, and upgrades
• Database performance monitoring and tuning
• Database backup and recovery
• Capacity planning and forecasting
• Database replication, compression, and partitioning
• Logical and physical database design
• Production database support and troubleshooting

Additional Required Skills

Cloud Database Administration

• Experience assessing, planning, and migrating databases to cloud environments
• Experience transferring, validating, and maintaining databases in cloud-based environments

Oracle Database Technologies

• Installation, configuration, and support of Oracle Enterprise Edition Database 19c and 21c on Linux platforms
• Administration and support of Oracle Application Express (APEX)
• Oracle Gateways connecting SQL Server, MySQL, and PostgreSQL databases
• Oracle Spatial implementation and support

SQL & Open-Source Databases

• Installation, configuration, and support of MySQL databases
• Installation, configuration, and support of PostgreSQL databases
• Installation, configuration, and support of Microsoft SQL Server environments

ETL & Scripting

• Development of ETL solutions utilizing:
  • SQLLoader
  • PL/SQL
  • Cron jobs and crontab
• ETL troubleshooting and support
• Windows Batch scripting
• Unix Shell scripting
• PL/SQL development and support

Required Experience

• Minimum 7 years of experience in Systems Programming and/or Database Administration.
• Minimum 3 years of experience serving in a lead or senior-level capacity.

Additional Experience

• 4+ years of Database Administration experience supporting Oracle, MySQL, PostgreSQL, and Microsoft SQL Server environments.
• 3+ years of experience transferring, validating, and maintaining databases within cloud environments.

Education

• Bachelor's degree in:
  • Information Technology
  • Computer Science
  • Engineering
  • Related technical discipline

#LI-MH1
#INDPRO