Mainframe DBA #26-21589

US Tech Solutions; Los Angeles (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

US Tech Solutions is seeking a Mainframe Systems Programmer/DBA to lead and support database upgrades, installations, configurations, testing, and maintenance. You will manage legacy and modern databases, support architecture, and provide guidance to engineering and operations teams.

The role requires strong ADABAS, DB2, IMS, and IBM z/OS skills, plus experience with ETL, replication, and cloud migrations. Hybrid onsite work two days weekly in Los Angeles area, with a focus on mainframe systems.

Qualifications

• 7+ years of experience as a Systems Programmer/DBA.
• 3+ years in a lead role.
• 4+ years of database administration with Oracle, MySQL, PostgreSQL, or MS SQL Server environments.
• 3+ years of cloud database migration/maintenance.
• 5+ years using StarQuest Stelo Data Replication.

Responsibilities

• Lead and/or support complex database upgrade, modification, installation, testing, implementation, maintenance, and enhancement projects.
• Plan, install, configure, test, implement, and manage core database and system software products.
• Manage and maintain legacy database environments including ADABAS, DB2, and IMS.
• Monitor database health, performance, capacity, and available space.
• Perform database reorganizations, replication, compression, partitioning, backup, and recovery activities.
• Develop logical and physical database designs and create physical databases.
• Provide database administration consulting to application/ops/dev teams, and recommend DBMS improvements.
• Evaluate and fine-tune existing DBMS software and recommend new technologies.
• Assess, plan, and migrate databases to cloud environments.
• Transfer, validate, maintain, and support databases in cloud environments.
• Install, configure, patch, clone, backup, recover, and troubleshoot databases.
• Support ETL processes and troubleshoot ETL jobs.
• Configure and support database connectivity and replication between remote environments.
• Monitor and troubleshoot StarQuest Stelo Data Replication for data transfers.

Skills

ADABAS

NATURAL

DB2

IMS

IBM z/OS

JCL

CICS

COBOL

SQL

Stelo Replication

Education

Bachelor's degree in IT/CS/Engineering

Tools

SMP/E

CA Spool

BMC IMS & DB2 Tools

N20/TRIM

StarQuest Stelo Data Replication

Job description

Duration: 12 Months

Schedule: 08:00 AM - 05:00 PM (2 days / week onsite)

Job Description

We are seeking a Mainframe Systems Programmer/Mainframe ADABAS Administrator (DBA) to lead and support complex database upgrade, installation, configuration, testing, implementation, maintenance, and enhancement activities. The candidate will manage legacy and modern database environments, support database architecture and business needs, and provide technical guidance to application and operations teams.

Responsibilities

• Lead and/or support complex database upgrade, modification, installation, testing, implementation, maintenance, and enhancement projects.
• Plan, install, configure, test, implement, and manage core database and system software products.
• Manage and maintain legacy database environments including ADABAS, DB2, and IMS.
• Monitor database health, performance, capacity, and available space.
• Perform database reorganizations, replication, compression, partitioning, backup, and recovery activities.
• Develop logical and physical database designs and create physical databases.
• Provide database administration consulting and technical recommendations to application, operations, and development teams.
• Evaluate and fine-tune existing DBMS software and provide recommendations for new database technologies.
• Assess, plan, and migrate databases to cloud environments.
• Transfer, validate, maintain, and support databases in cloud environments.
• Install, configure, patch, clone, back up, recover, and troubleshoot databases.
• Support ETL processes, develop custom ETL utilities, and troubleshoot ETL jobs.
• Configure and support database connectivity and replication between remote database environments.
• Monitor and troubleshoot StarQuest Stelo Data Replication for full and incremental data transfers.

Experience

• Minimum 7 years of experience as a Systems Programmer/DBA.
• Minimum 3 years of experience in a lead role.
• Minimum 4 years of database administration experience with Oracle, MySQL, PostgreSQL, and/or Microsoft SQL Server environments.
• Minimum 3 years of experience transferring, validating, and maintaining databases in cloud environments.
• Minimum 5 years of experience utilizing StarQuest Stelo Data Replication software.
• Experience supporting production database environments, database upgrades, performance monitoring, backup/recovery, and troubleshooting.

Skillsets

• Strong experience with ADABAS, NATURAL, DB2, IMS, and IBM z/OS.
• Experience with JCL, SMP/E, IMS DB/DC, CICS, ACF2, REXX, Assembler, COBOL, and IBM File Manager.
• Experience with DELTA/IMS, CA Spool, BMC IMS & DB2 Tools, and N20/TRIM.
• Strong database administration experience with Oracle Enterprise Edition 19c/21c, MySQL, PostgreSQL, and Microsoft SQL Server.
• Experience with Oracle APEX, Oracle Gateways, and Oracle Spatial.
• Strong knowledge of ETL, SQLLoader, PL/SQL, cron/crontab, Unix shell scripting, and Windows batch scripting.
• Experience with database replication, migration, backup/recovery, cloning, patching, capacity planning,
• partitioning, compression, and performance tuning.
• Experience troubleshooting ETL jobs and database connectivity issues.
• Experience with StarQuest Stelo Data Replication for full and incremental data transfers.

Education

• Bachelor's degree in Information Technology, Computer Science, Engineering, or a related IT/engineering field.

Additional Qualifications

• Strong analytical and troubleshooting skills with the ability to resolve complex database and systems issues.
• Ability to work with application development and operations teams on database architecture, design, and project planning.
• Experience supporting both legacy mainframe database environments and modern/cloud-based database platforms.
• Ability to lead complex database projects and provide technical recommendations to project and development teams.

About US Tech Solutions

US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.

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.

#ZR