> Markdown version of [/jobs/ext/2306234-mainframe-systems-programmer-mainframe-database-administrator](https://www.wearedevelopers.com/jobs/ext/2306234-mainframe-systems-programmer-mainframe-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Mainframe Systems Programmer/Mainframe Database Administrator - **Company:** TPI Global (formerly Tech Providers, Inc.) - **Location:** Los Angeles, United States - **Experience:** Experienced - **Contract:** Temporary to permanent - **Skills:** Adaptable Database Systems, Backup Devices, Customer Information Control System (CICS), Cloud Computing, COBOL (Programming Language), Databases, System Configuration, Cron, Data Transmissions, Extract Transform Load (ETL), Data Warehousing, IBM DB2, Database Design, Database Servers, Linux, Disaster Recovery, Oracle Application Express, Job Control Language (JCL), Rexx (Programming Language), IBM Information Management System, PostgreSQL, Unix Shell, Logical Databases, Mainframes, Microsoft SQL Server, MySQL, Operational Databases, Oracle Databases, Oracle (Applications), PL-SQL, System Programming, System Software, Web Applications, Batch Scripting, Z/OS, Apex Code, Oracle Enterprise Manager, Oracle SQL Loader, Database Performance, Backend, Database Replication, Legacy Systems - **Published:** August 30, 2026 - **Apply:** https://www.dice.com/job-detail/4de51e98-3631-499b-b6b6-406d30079cdb ## About the Role 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. 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. * Skills in assessing, planning and migrating DBs to Cloud Environment * Skills in transferring, validating and maintaining DBs in a Cloud environment * Skills in Installing, Configuring and Supporting Oracle Enterprise Edition Database 19c and 21c as a backend for both public facing web applications and internal data warehousing on Linux operating system. * Skills in Installing and configuring MySQL and PostgreSQL databases. * Skills in Installing and Supporting Microsoft SQL server instances. * knowledge in Configuring and supporting Oracle Application Express (APEX), Oracle gateways connecting SQL Server, MySQL and PostgreSQL server instances to the Oracle database. * knowledge in Oracle Spatial implementation and support. * Mastery in building custom extracts, transform and load (ETL) utilities with cron jobs and crontab, SQLLoader and PL/SQL. * Skills in Database Administration services such as patch install, cloning, backup and recovery of databases and script development (Windows Batch Script, Unix shell scripting and PL/SQL). * Skills in Troubleshooting and resolution of ETL Jobs * Skills in setting up connectivity to remote database servers using Stelo Data Replication software for full and incremental data transfer, monitoring and resolving issues., * 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. * 4+ years of DB Administration experience, specifically in a Oracle/MySQL/PostgreSQL/MS SQL Server environments. * 3+ years of experience in transferring, validating, maintaining DBs in cloud environment. * 5+ years of experience utilizing StarQuest Stelo Data Replication software. Education Required This classification requires the possession of a bachelor's degree in an IT-related or engineering field. ## 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. ## Related Videos - [From clicks to cribs - How to find your dream home with web scraping](https://www.wearedevelopers.com/videos/767-from-clicks-to-cribs-how-to-find-your-dream-home-with-web-scraping) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Is your backend a hodgepodge of queues, event stores and cron jobs? Durable Execution to the Rescue.](https://www.wearedevelopers.com/videos/744-is-your-backend-a-hodgepodge-of-queues-event-stores-and-cron-jobs-durable-execution-to-the-rescue) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)