Lead Mainframe DB2 Database Administrator

FIS Global•Augusta, GA

4d•$111,650 - $189,810

About The Position

Plans Db2 for z/OS databases, including their definitions, structures, documentation, long-range requirements, operational guidelines, and protection. Ensures the accuracy, completeness, and availability of data using IBM support tools; establishes and maintains security and integrity controls; and formulates and monitors database management policies, procedures, and standards. Researches and resolves database issues and proposes and implements improvements to system performance and reliability. The Lead DBA has advanced knowledge of Db2 mechanics, communicates with IBM about DB2 issues, and mentors less experienced DBAs. The role tests database software, IBM utilities, and fixes in sandbox environments before production rollout; migrates tested and approved changes into production; develops database configurations and objects to meet business requirements; and works with application developers and technical support to apply best practices and mitigate risks. It also supports database availability, performance, recovery, troubleshooting, documentation, and team training. Participation in an on-call rotation and occasional outages is required.

Requirements

Typically, 8–10 years of relevant experience with Db2 for z/OS.
Experience installing, customizing, testing, and maintaining database systems in a production environment.
Critical thinking and a solution-oriented approach.
Initiative in taking on tasks and issues.
Ability to work independently and own assigned tasks.
Excellent written and verbal communication skills for collaboration with technical and application teams.

Nice To Haves

Bachelor's degree.
Db2 LUW experience.
Programming, operations, or technical support experience.

Responsibilities

Test database software, IBM utilities, and fixes in sandbox environments before production rollout; identify and resolve issues in sandbox and upper environments.
Migrate tested and approved database structures, utilities, and fixes to production.
Develop database configurations and objects according to business requirements and standards, and establish sandbox environments for testing.
Work with application developers and technical support to apply best practices and mitigate impacts or risks to user groups and database configurations.
Coach less experienced DBAs in routine and basic database administration tasks.
Schedule database tasks and ensure their completion.
Execute database recovery tasks during disaster recovery scenarios and exercises.
Improve the reliability and efficiency of database processes and services.
Monitor database performance and identify bottlenecks, including inefficient queries, inconsistent or corrupt indexes, and database design issues; recommend corrective actions.
Apply routine database tuning and optimization, including rebuilding indexes, and monitor database statistics on a regular schedule.
Troubleshoot application failures with the Applications Team, help develop solutions to reduce future failures, and support implementation of those solutions.
Produce and maintain operational database documentation, including disaster recovery, recovery presentation, naming standards, and performance and tuning documentation.
Train and familiarize less experienced team members with company policies and procedures, techniques, and current server and database configurations.
Participate in the on-call rotation and occasional outages.
Plan Db2 for z/OS databases and maintain data accuracy, completeness, availability, security, and integrity.
Research and resolve database issues and propose and implement performance and reliability enhancements.
Communicate with IBM on DB2 issues and mentor less experienced DBAs.