Why This Role Stands Out
This remote Mainframe DB2 DBA role offers significant opportunities to hone your expertise in complex database environments, including VLDB partitioning and performance tuning. You'll thrive here if you are a seasoned professional with experience in DB2 z/OS, JCL, and CICS, eager to contribute to critical database initiatives. Apply now to leverage your skills and advance your career in a flexible, impactful position.
Quick Overview
Job Description
Mainframe DB2 DBA – DB2 z/OS
We are seeking a highly experienced Mainframe DB2 DBA to lead complex database management, architecture, performance tuning, recovery, security, and migration initiatives in an enterprise environment.
Key Responsibilities
- Design, develop, test, deploy, and maintain DB2 database environments and objects.
- Perform DB2 database administration, performance tuning, capacity planning, and availability management.
- Manage database recovery, backup/recovery solutions, security, auditing, and disaster recovery.
- Perform DB2 software implementation, upgrades, patching, and troubleshooting.
- Tune complex SQL and work with application teams to resolve long-running SQL and performance issues.
- Design table partitioning strategies for very large databases (VLDB).
- Develop data transformation and data migration/data mapping strategies.
- Support DB2 architecture, data integration, database modernization, and enterprise-level database initiatives.
- Provide technical leadership, mentoring, documentation, and production support.
- Work with application teams, client DBAs, vendors, and external consultants on complex database issues.
- Support and upgrade DB2 on z/OS environments.
Required Skills
- DB2 for z/OS v10/v11 – strong hands-on experience.
- Strong DB2 DBA / database administration experience.
- DB2 Data Replication experience.
- DB2 HADR experience.
- DB2 Pacemaker experience is a plus.
- DB2 Automatic Storage experience.
- Strong knowledge of JCL, COBOL, CICS, and VSAM.
- Experience with VLDB databases and partitioning.
- Strong DB2 performance tuning, SQL tuning, recovery, and troubleshooting.
- Experience with database architecture, migration, data modeling, and integration.
- Strong written and verbal communication skills.
- DB2 Certification is a plus.
- Experience working in a ServiceNow environment is a plus.
Senior/Mainframe DB2 DBA with deep DB2 z/OS experience and hands-on expertise in DB2 replication, HADR, recovery, performance tuning, VLDB/partitioning, JCL, and enterprise mainframe
Similar jobs
- SJ
Kubernetes Tech Lead
NewSelby Jennings
Manhattan, NY🇺🇸Hybrid17 hours agoAWSBashJava+3Technology - AT
Security Engineer
NewAivanta Tech Inc
Seattle, WA🇺🇸Hybrid17 hours agoMicroservicesBashLLM+2Technology - GS
Help Desk Analyst (Hybrid Onsite)
NewGSK Solutions Inc.
Trenton, NJ🇺🇸€18/hrHybrid17 hours agoActive DirectoryMicrosoft ExcelTechnology - SY
Junior Java Software Engineer [$248k/yr+] TS/SCI-FS Poly with Security Clearance
NewSYSTOLIC
Annapolis Junction, MD🇺🇸Hybrid17 hours agoDockerMicroservicesEncryption+8Technology - SS
Controls and QA Analyst
NewSouthern Scripts
St. Louis, Missouri🇺🇸Hybrid32 minutes agoHIPAATechnology - MS
Intern - AI Solutions Engineer
NewMidland States Bank
Saint Louis, Missouri🇺🇸Hybrid32 minutes agoSQLMicrosoft ExcelPythonTechnology - AH
Epic Certified EHR Systems Analyst III (EpicCare Ambulatory)
NewAdventist Health
Auburn, California🇺🇸Remote32 minutes agoTechnology - AD
CPI Data Center Project Manager, US-West CPI
NewAmazon Data Services, Inc.
Boardman, Oregon🇺🇸$111.1k/yrHybrid32 minutes agoAWSTechnology - TR
Acquisition Integration Advisor - Salesforce Ecosystem
NewTransunion
Chicago, Illinois🇺🇸$100.1k/yrHybrid32 minutes agoSalesforceCRMTechnology - JM
J.P. Morgan Wealth Management - Senior Product Associate, Service Desktop
NewJ.P. Morgan
Plano, Texas🇺🇸On-site32 minutes agoSalesforceSnowflakeTableau+7Technology - SO
Senior Vulnerability Management Analyst
NewSystem One
Birmingham, Alabama🇺🇸Hybrid32 minutes agoAWSComplianceMicrosoft Excel+2Technology - JM
Senior Lead Infrastructure Engineer (Corporate Structure - Infrastructure Platforms)
NewJ.P. Morgan
Plano, Texas🇺🇸On-site32 minutes agoGCPAWSEncryption+6Technology