Senior Mainframe DBA & Cloud-Ready Data Architect

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

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.