> Markdown version of [/jobs/ext/1767541-data-designer-administrator-mainframe-dba](https://www.wearedevelopers.com/jobs/ext/1767541-data-designer-administrator-mainframe-dba). 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). --- # Data Designer & Administrator / Mainframe DBA - **Company:** HTC Global Services, Inc. - **Location:** Bloomington, IL, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Databases, Data Conversion, Data Integration, Extract Transform Load (ETL), Data Security, IBM DB2, Database Queries, Database Security, IBM Information Management System, PostgreSQL, Mainframes, Z/OS, Database Optimization, Database Performance, Physical Data Models, Database Tools and Utilities - **Published:** July 7, 2026 - **Apply:** https://www.juju.com/job/00000000gejj4l ## About the Role We are seeking a strong and experienced Mainframe DB2 DBA with hands-on expertise managing highly critical databases across multiple environments. The ideal candidate will have experience working with multiple teams, supporting database availability, performance, and operational stability in both production and non-production environments., + Strong hands-on experience with Mainframe DB2 on z/OS. + Experience maintaining highly critical databases across multiple environments. + Experience working with multiple teams and stakeholders. + Strong experience with database performance tuning and optimization. + Experience supporting database maintenance, data movement, and production support activities. + IMS DB experience or exposure is preferred. + Exposure or experience with PostgreSQL is a plus. + Ability to work in high-visibility and high-pressure environments while ensuring database availability across production and test environments. + Excellent communication skills. + Flexibility to adapt to new technologies as required. ## Description + Create and maintain DB2 databases, tables, and physical data models. + Develop, maintain, and support DB2 database maintenance jobs. + Review SQL statements and recommend or create indexes to optimize performance. + Review and support LOAD/UNLOAD processes and jobs. + Review and support data movement processes across environments. + Provide technical support and guidance to application teams on DB2-related topics. + Investigate and resolve database-related production and non-production issues. + Analyze and resolve database performance issues through tuning and optimization. + Provide guidance and support for data access requests and database governance activities. IMS DB (Good to Have) + Create, maintain, and update IMS Database Description (DBD) definitions. + Create and maintain Program Specification Block (PSB) definitions. + Add databases to the Database Utility Generator (DUG) to enable test database creation. + Design, develop, and maintain database maintenance, backup, recovery, and utility job flows. + Implement new database objects based on business and application requirements. + Modify existing database objects to support application enhancements and infrastructure changes. + Investigate and resolve production incidents and database-related issues. + Troubleshoot and resolve database issues in development, test, and QA environments. + Analyze and resolve IMS database performance issues. + Monitor database space utilization and capacity and support growth planning. + Provide technical consultation and support to application analysts and development teams. + Review, support, and advise on data movement, migration, and data conversion activities. PostgreSQL (Optional) + Create and maintain PostgreSQL databases, tables, and physical data models. + Review SQL statements and implement indexing strategies to improve database performance. + Review and optimize data movement and data integration processes. + Provide technical guidance and support to application teams on PostgreSQL-related topics. + Investigate, analyze, and resolve database performance issues. + Provide guidance on data access requests and database security procedures. + Coordinate with other teams for requests requiring approvals, governance, or infrastructure support. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) ## Related Articles - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)