JOBSEARCHER

Mainframe DB2 DBA

JD: Mainframe DB2 DBA
Location: Onshore
Job Description
Essential Job Functions: Handles and leads the most complex or critical data/database management initiatives that typically involve multipledisciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or datamodelingdesign 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 SW implementation, upgrade, patching· Diagnoses and resolves performance issues. Provides expertise in database tuning including table partitioningstrategies,. 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 andenterprise-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... Lead complex Model Conversion (Data Mapping) to produce a Data Dictionary and data mapping matrixbetween the external software and the internal database for business function replacement,. Develop and maintain database support documentation... Serves as a consultant on technological advancements, Provides oversight, mentoring and leadership to lessexperienced staff... Responsible for providing hands-on experience technical support for assessing, architecting, and upgrading DB2databases. Work with external consultants and services to request services and support. Work with on premises and client DBA staff Develops customer technology solutions using various industry products and technologies... Engages in technical problem solving across multiple technologies; often needs to develop new methods toapply to the situation.
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 Service Now environment is a plus.. Experience working with VLDB databases including partitioning required,. Excellent written and verbal communications skills required.. DB2 Certification is a plus