Mainframe DBA #26-21589

Los Angeles, CA

$95–$99 Per Hour
Quick Apply

Today

Job Description

(Hybrid)
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.

#LI-AS140

#ZR

Numbers & Facts

Location	Los Angeles, CA
Salary	$95–$99 Per Hour

Skills

ACF2 (Access Control Facility 2)unmatched
Adabasunmatched
Analysis Skillsunmatched
Capacity Managementunmatched
Cloningunmatched
Cloud Computingunmatched
Cobol Programming Languageunmatched
Computer Scienceunmatched
Cron Job Schedulingunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Architectureunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Database Management Software/Systems (DBMS)unmatched
Database Replicationunmatched
Database Technologyunmatched
File Managementunmatched
IBM CICS (Customer Information Control System)unmatched
IBM DB2unmatched
IBM IMS Databaseunmatched
IBM Product Familyunmatched
IBM Rexx Programming Languageunmatched
IBM z-OS Operating Systemunmatched
IMS DB/DCunmatched
IP Multimedia System (IMS)unmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
JCL (Job Control Language)unmatched
Leadershipunmatched
Mainframe Computerunmatched
Microsoft SQL Serverunmatched
MySQLunmatched
Oracleunmatched
Oracle DBA (Database Administrator)unmatched
Oracle PL-SQLunmatched
Performance Analysisunmatched
Performance Tuning/Optimizationunmatched
PostgreSQLunmatched
Production Supportunmatched
Production Systemsunmatched
Project Developmentunmatched
Project Planningunmatched
Scripting (Scripting Languages)unmatched
Software Developmentunmatched
Software Patchesunmatched
Symmetric MultiProcessing (SMP) Computingunmatched
System Migrationunmatched
Systems/Internals Programmingunmatched
Technical Consultingunmatched
Technical Leadershipunmatched
Testingunmatched
Unix Shell Programmingunmatched
Windows PowerShellunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

Mainframe DBA #26-21589

Job Description

Numbers & Facts

Skills

Be found by employers

Level up your application

Professional resume templates

Free resume builder