Senior DB2z Database Administrator (DBA)
3B Staffing LLC, Boston, MA, United States
We're seeking a
Senior DB2z Database Administrator (DBA)
to join a large enterprise mainframe team supporting mission-critical Tier 1 and Tier 2 applications. The ideal candidate will bring deep technical expertise in DB2z on z/OS, performance tuning, automation, and mainframe data replication, along with experience supporting high-availability environments.
DB2z on z/OS, DB2 Data Sharing, IIDR (SQL & Q Replication), IDAA, performance tuning, automation (JCL/REXX scripting), Omegamon, Query Monitor, capacity planning, backup/recovery, and mainframe production support.
Interview Process:
1 Round Location:
Remote Required Qualifications:
10+ years of experience as a Mainframe DB2z DBA in large-scale enterprise environments. Strong experience with DB2 Data Sharing,
IIDR (SQL Replication and Q Replication), and IDAA. Solid understanding of performance tuning, query optimization, and system automation. Proven experience supporting production-critical workloads and performing root cause analysis. Preferred Qualifications: Experience with Zowe and Admin Foundation for DB2. Familiarity with IDMS and ServiceNow. Experience in automation, scripting, and capacity management in complex environments. Key Responsibilities: Execute DDL and DML requests for application and business teams across production, test, and development environments. Develop and maintain JCL and REXX scripts to manage, monitor, and automate database activities and reporting. Configure and support data replication between DB2 subsystems (QRep/SQLRep). Monitor database and SQL performance using Omegamon and Query Monitor, optimizing tablespaces, indexes, and access paths. Review and tune Db2 package access paths, including use of hints and optimization techniques. Perform database capacity planning, data growth analysis, and system maintenance. Design and implement database backup and recovery strategies. Manage IDAA setup, tables, and data synchronization. Participate in a 24/7 on-call rotation for production support. Design, implement, and maintain database security controls and documentation. Prepare and execute disaster recovery plans to meet RPO/RTO targets. Automate recurring operational tasks to improve efficiency. Plan and execute Db2 software upgrade and patching activities. Education: Bachelor's Degree preferred (or equivalent professional experience).
Senior DB2z Database Administrator (DBA)
to join a large enterprise mainframe team supporting mission-critical Tier 1 and Tier 2 applications. The ideal candidate will bring deep technical expertise in DB2z on z/OS, performance tuning, automation, and mainframe data replication, along with experience supporting high-availability environments.
DB2z on z/OS, DB2 Data Sharing, IIDR (SQL & Q Replication), IDAA, performance tuning, automation (JCL/REXX scripting), Omegamon, Query Monitor, capacity planning, backup/recovery, and mainframe production support.
Interview Process:
1 Round Location:
Remote Required Qualifications:
10+ years of experience as a Mainframe DB2z DBA in large-scale enterprise environments. Strong experience with DB2 Data Sharing,
IIDR (SQL Replication and Q Replication), and IDAA. Solid understanding of performance tuning, query optimization, and system automation. Proven experience supporting production-critical workloads and performing root cause analysis. Preferred Qualifications: Experience with Zowe and Admin Foundation for DB2. Familiarity with IDMS and ServiceNow. Experience in automation, scripting, and capacity management in complex environments. Key Responsibilities: Execute DDL and DML requests for application and business teams across production, test, and development environments. Develop and maintain JCL and REXX scripts to manage, monitor, and automate database activities and reporting. Configure and support data replication between DB2 subsystems (QRep/SQLRep). Monitor database and SQL performance using Omegamon and Query Monitor, optimizing tablespaces, indexes, and access paths. Review and tune Db2 package access paths, including use of hints and optimization techniques. Perform database capacity planning, data growth analysis, and system maintenance. Design and implement database backup and recovery strategies. Manage IDAA setup, tables, and data synchronization. Participate in a 24/7 on-call rotation for production support. Design, implement, and maintain database security controls and documentation. Prepare and execute disaster recovery plans to meet RPO/RTO targets. Automate recurring operational tasks to improve efficiency. Plan and execute Db2 software upgrade and patching activities. Education: Bachelor's Degree preferred (or equivalent professional experience).