DB2 Mainframe DBA

Must have: DB2, development experience, DBA experience, performance tuning and optimization , we are innovating the next generation of data solutions and capabilities to help our customers achieve a lifetime of financial security. As a Senior DB2 Z DBA within our Workplace Data Operations team, this role will be focused on collaborating with a team of senior database administrators in the development of modern architectures to enable our data-driven digital business. You will help define our data strategies, grow our capabilities. Responsibilities: • Creates schemas and sub-schemas in consultation with application project team. • Submits recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery specifications. • Proposes detailed specifications and flowcharts and coordinates installation of revised or new database systems. • Sets up and performs backup, recovery, and Stats Updates procedures. • Works with relevant staff, to identify and transform business requirements into physical data models. • Performs monitoring and tuning for performance, and recommends Application database enhancements. • Develops transaction logging and security features. • Understands and uses normalization methods and design methodologies. • Develops, documents, and enforces the standards, security procedures, and controls for access to ensure integrity of the database system. • Works with system engineers or application developer to evaluate and implement technical enhancements. Qualifications: • Bachelor’s degree in computer science, software engineering, or related field • Five years of collective experience as a Senior DB2 Z DBA with Version 9,10.11, & 12 • Experience with Online utilities, indexing strategies, index management and statistics for 500 million+ row tables. • Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools. • Attention to detail and results oriented, with a strong customer focus. • The ability to work within a team environment. • Problem-solving and communication skills. Preferred Qualifications: • Working knowledge BMC Monitoring Tools • Knowledge of AWS and Azure (Azure SQL and DW) platforms, • Knowledge of IDAA