Mainframe DB2 DBA

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., * 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.

• 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.