Senior Mainframe Developer

Cloud Analytics Technologies, LLC; Salt Lake City (UT); On-site; USD 110,000 - 170,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Mainframe DB2 DBA to ensure performance, availability, security, and reliability of IBM DB2 for z/OS environments. You will work with application teams, architects, QA, DevOps, offshore resources, and business stakeholders to design, administer, tune, and support large-scale production databases powering core applications.

You will design databases, implement table spaces, tune SQL, review RTS, and manage backup, recovery, and security

Qualifications

• Bachelor's degree in computer science, Information Systems, Computer Engineering, or related field; equivalent experience considered.
• 6+ years of hands-on experience in Mainframe Database Administration.
• Strong expertise in IBM DB2 for z/OS administration and support.
• Experience with DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Experience tuning SQL and resolving access path and performance issues.

Responsibilities

• Design, create, and maintain DB2 databases, tablespaces, indexes, views, storage groups, and related objects.
• Translate logical data models into efficient physical database designs.
• Execute DDL implementations and manage schema changes through complex ALTER activities.
• Implement and maintain Universal Table Spaces (PBG/PBR).
• Design indexing strategies to optimize access paths and overall database performance.
• Analyze, troubleshoot, and resolve DB2 performance issues.
• Monitor SQL performance, locking conflicts, buffer pools, and access path efficiencies.
• Review EXPLAIN output and recommend performance improvements.
• Optimize complex SQL queries to reduce CPU consumption and improve application response times.
• Leverage Real Time Statistics (RTS) to proactively manage database health.
• Execute and monitor DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Manage VSAM datasets, storage allocation, PRIQTY, and SECQTY settings.
• Develop and maintain JCL and REXX automation scripts.
• Support production incidents, perform root cause analysis, and drive issue resolution.
• Manage DB2 command-level operations and database statuses.
• Administer DB2 security through GRANT and REVOKE processes.
• Support audit, compliance, and enterprise security standards.
• Develop and execute backup, recovery, and disaster recovery strategies.
• Manage image copies, logs, and restoration procedures.
• Participate in production readiness reviews and recovery testing exercises.
• Serve as the primary onsite DB2 DBA point of contact.
• Collaborate with developers, architects, SMEs, QA teams, and offshore resources.
• Provide technical mentorship and knowledge transfer to team members.
• Support releases, deployments, upgrades, and modernization initiatives.
• Document operational procedures, recovery plans, and database standards.

Skills

6+ years Mainframe DBA

DB2 z/OS

COBOL

JCL

CICS

VSAM

Offshore coordination

Production environments

Education

Bachelor's degree in CS/IS/CE or related field

Tools

DB2 RUNSTATS

DB2 REORG

DB2 COPY

DB2 RECOVER

DB2 LOAD

DB2 UNLOAD

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Summary:
We are looking for an experienced Mainframe DB2 DBA to join our enterprise database team. In this role, you will be responsible for ensuring the performance, availability, security, and reliability of mission-critical IBM DB2 for z/OS environments. You will work closely with application teams, architects, QA, DevOps, offshore resources, and business stakeholders to design, administer, tune, and support large-scale production databases that power core business applications.
Database Design & Administration:

• Design, create, and maintain DB2 databases, tablespaces, indexes, views, storage groups, and related objects.
• Translate logical data models into efficient physical database designs.
• Execute DDL implementations and manage schema changes through complex ALTER activities.
• Implement and maintain Universal Table Spaces (PBG/PBR).
• Design indexing strategies to optimize access paths and overall database performance.

Performance Tuning & Optimization:

• Analyze, troubleshoot, and resolve DB2 performance issues.
• Monitor SQL performance, locking conflicts, buffer pools, and access path efficiencies.
• Review EXPLAIN output and recommend performance improvements.
• Optimize complex SQL queries to reduce CPU consumption and improve application response times.
• Leverage Real Time Statistics (RTS) to proactively manage database health.

Production Support & Operations:

• Execute and monitor DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Manage VSAM datasets, storage allocation, PRIQTY, and SECQTY settings.
• Develop and maintain JCL and REXX automation scripts.
• Support production incidents, perform root cause analysis, and drive issue resolution.
• Manage DB2 command-level operations and database statuses.

Security, Backup & Recovery:

• Administer DB2 security through GRANT and REVOKE processes.
• Support audit, compliance, and enterprise security standards.
• Develop and execute backup, recovery, and disaster recovery strategies.
• Manage image copies, logs, and restoration procedures.
• Participate in production readiness reviews and recovery testing exercises.
• Serve as the primary onsite DB2 DBA point of contact.
• Collaborate with developers, architects, SMEs, QA teams, and offshore resources.
• Provide technical mentorship and knowledge transfer to team members.
• Support releases, deployments, upgrades, and modernization initiatives.
• Document operational procedures, recovery plans, and database standards.

Minimum Qualifications:

• Bachelor's degree in computer science, Information Systems, Computer Engineering, or related field; equivalent experience considered.
• 6+ years of hands‑on experience in Mainframe Database Administration.
• Strong expertise in IBM DB2 for z/OS administration and support.
• Experience with DB2 utilities including RUNSTATS, REORG, COPY, RECOVER, LOAD, and UNLOAD.
• Experience tuning SQL and resolving access path and performance issues.
• Working knowledge of COBOL, JCL, CICS, and VSAM .
• Experience supporting multiple enterprise applications in large production environments.
• Experience coordinating with offshore teams and providing technical guidance.

Preferred Qualifications:

• Experience with Endevor .
• Exposure to mainframe debugging and diagnostic tools.
• Experience supporting large‑scale modernization or database transformation programs.
• Knowledge of automation, scripting, monitoring, and continuous improvement practices.
• Consulting or customer‑facing experience in enterprise technology environments

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom‑made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry‑leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with‑it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: