Lead Mainframe DB2 Database Administrator
About The Position
The Lead Mainframe DB2 Database Administrator plans and administers Db2 for z/OS databases, including their definitions, structures, documentation, long-range requirements, operational guidelines, and protections. The role ensures the accuracy, completeness, availability, security, and integrity of data; develops and monitors database-management policies and standards; improves system performance and reliability; and researches and resolves database issues. The Lead DBA brings deep knowledge of Db2 internals, communicates with IBM about Db2 issues, and mentors less experienced DBAs. The position tests database software, IBM utilities, and fixes in sandbox environments before production deployment; creates database configurations and objects to meet business requirements; and works with application developers and technical support to apply best practices and reduce risk. It schedules database tasks, performs recovery during disaster recovery scenarios and exercises, monitors performance and availability, tunes databases, troubleshoots application failures, and maintains operational documentation. The role also trains and familiarizes team members with company policies, procedures, techniques, and current configurations. Participation in an on-call rotation and occasional outages is required.
Requirements
- Typically 8–10 years of relevant experience in 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 across 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; identify and resolve issues in sandbox and upper environments; and migrate tested and approved items to production.
- Develop database configurations and create database objects according to business requirements and standards, including in sandbox environments used for testing.
- Work with application developers and technical support to apply best practices and mitigate potential impacts or risks to users and other database configurations.
- Coach less experienced DBAs as they begin routine and basic database administration tasks.
- Schedule database tasks and ensure they are completed properly.
- Execute database recovery tasks during disaster recovery scenarios and exercises.
- Improve the reliability and efficiency of database processes and services.
- Monitor database performance and availability, identify bottlenecks, and recommend corrective actions.
- Apply routine database tuning and optimization, including rebuilding indexes, and regularly monitor database statistics.
- Troubleshoot application failures with the Applications Team, help develop solutions to prevent 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 an on-call rotation and occasional outages.
- Communicate with IBM regarding Db2 issues and mentor less experienced DBAs by sharing knowledge of Db2 internals.
Benefits
- Competitive salary and benefits.
- Always-on learning and development.
- Collaborative work environment.
- Opportunities to give back.
- A voice in the future of fintech.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
