Fifth Third Bank Lead Database Administrator in Cincinnati, Ohio
Fifth Third Bank is one of the top-performing banks in the country, with a heritage that spans more than 150 years. We've staked our claim on looking at things differently to making banking a Fifth Third Better. This applies to our relationships with customers and employees alike.
We employ about 18,000 people, and what we offer is:
# A chance for employees to build their future, with supportive career development and financial wellness programs.
# An environment where we win together. We celebrate achievement and work collaboratively. We're also a three-time Gallup Great Workplace honoree.
# An invitation to impact lives in a positive and lasting way. Everything we do is geared toward improving lives. That's fun and exciting.
It comes down to the fact that Fifth Third is a warm and caring place to with which to grow # as a customer or as a team member.
Information Technology's vision is to be recognized as an industry-leading services company by efficiently delivering solutions and services our customers can rely on. We strive to create a business-focused team that drives significant value for the Company while building customer-centric service delivery models through the integration of technologies, data, and processes. Our customers' trust is earned through the effective delivery of resilient, secure products and services while balancing business needs with industry and regulatory requirements.
Fifth Third Information Technology is comprised of several areas including: Commercial IT, Consumer IT, Payments IT, Infrastructure IT, Enterprise and Corporate Applications as well as IT Security and Risk.
This is a Lead DB2 DBA (DB2 Mainframe) position, responsible for supporting the organization's DB2z databases and ensuring their performance, availability, and security. The Lead is viewed as an expert in the administration and support of database technology. The candidate is expected to communicate common goals and direction for the team and also provide superior technical leadership.
DUTIES & RESPONSIBILITIES:
- Responsible for database design, development and administration of large scale Operational, OLTP and
analytical data structures including logical and physical design
Provide SQL performance tuning on both OLTP and Data warehouse environments
Optimize DB2 resource utilization by tuning queries, recommending indexes, and configuring database parameters
-Provide data migration support
-Provide trend analysis to management team to enable them to make informed decisions regarding resource management
-Lead, mentor and/or provide guidance to less experienced database analysts where applicable including guidance for troubleshooting escalated issues
-Partner with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control
-Provide on call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel
-Analyze Key Performance Metrics and make recommendations for improvements
-Provide input on the selection and implementation of all database administration tools
-Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery)
-Enhance site monitoring to improve availability and performance
-Perform database capacity planning and trend analysis
-Deploy database changes in strict accordance with change management policies and procedures
-Interact and coordinate work with System Administrators, Project Managers and fellow team members to support various project requests
MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:
-Bachelor's degree in CS/MIS or equivalent experience
-Minimum of 6 years of heavy DB2z database administration experience and production support
-Requiring DB2z V11 experience
-Not required but prefer DB2 V11 or V10 database certification
-Experience working with very large database partitioning
-Experience working with large systems in data sharing sysplex environment
-Preferred experience in data modeling with Star Schema and Operational Data Store concepts
-Experience with evaluating and consolidating database workloads to maximize hardware resources
-Experience working with IBM Admin tool suite, Query Monitor, and Omegamon (DB2 PE)
-In-depth knowledge of DB2 utilities such as LOAD, UNLOAD, RUNSTAT, REORG, COPY, COPYTOCOPY, MERGECOPY, MODIFY and SPUFI.
-Working knowledge of IDAA
-Solid understanding of DB2 client tools such as DB2 Connect and Visual Explain
-Hands on experience with performance tuning of complex SQLs
-Experience with DB2 Stored Procedures (SQL and COBOL)
-Prefer experience with IBM Optim Move for DB2
-Prefer experience with Erwin or RDA data modeling tools
-Prefer that the candidate has worked in an onshore/offshore model
-Candidate must have excellent communication skills
Fifth Third Bank is proud to have an engaged and inclusive culture and to promote and ensure equal employment opportunity in all employment decisions regardless of race, color, gender, national origin, religion, age, disability, sexual orientation, gender identity, military status, veteran status or any other legally protected status.