Job Description

Handles and leads the most complex or critical data/database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling.

• Design database environments and create databases.
• Design, develop, test, deploy and maintain database objects.
• Design, develop, test, deploy and maintain database security and audit solutions.
• Design, develop, test, deploy and maintain database recovery solutions.
• Execute data recovery.
• Manage database performance, capacity, and availability.
• DBMS software implementation, upgrade, patching.
• Diagnose and resolve performance issues. Provides expertise in database tuning including table partitioning strategies.
• Works with the application team to identify and tune long running SQL statements.
• Consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/database architecture and management strategies.
• Provide advice to business and technical personnel on data analysis principles, methods and trends.
• Design complex Data Transformation Strategies for Business Intelligence or Data Migration.

Qualifications

Skills and Requirements:

• DB2 for z/OS v10, 11 experience required.
• DB2 Data Replication experience is a plus.
• DB2 HADR experience. DB2 Pacemaker experience is a plus.
• DB2 Automatic Storage experience required.
• JCL, COBOL, CICS, VSAM.
• Working in a ServiceNow environment is a plus.
• Experience working with VLDB databases including partitioning required.
• Excellent written and verbal communications skills required.
• DB2 Certification is a plus.