DB2 Database Administrator
About The Position
The DB2 Database Administrator will administer, maintain, and optimize enterprise DB2 databases, primarily DB2 for z/OS in a mainframe environment, supporting production and test environments and healthcare operations. The role focuses on database availability, security, performance, capacity, recovery, governance, and reliable application support. The position also works with application teams, supports organizational standards and training, and contributes to operational improvement and project initiatives. The role is office-based and requires the candidate to be a U.S. citizen because of contractual and access requirements. A physical work site is required. Travel is listed as 0%–25%. After-hours and weekend support may be required for on-call duties, database refreshes, testing, upgrades, and other off-hour assignments.
Requirements
- U.S. citizenship is required due to contractual and access requirements.
- High school diploma or GED.
- 1–3 years of experience in Information Technology.
- Ability to provide after-hours and weekend support as required.
Nice To Haves
- Vendor DBA certifications for the relevant DBMS.
- Health insurance business knowledge.
Responsibilities
- Administer, maintain, and support DB2 databases across production and test environments.
- Design, create, modify, and maintain database objects, including tablespaces, tables, indexes, views, packages, and plans.
- Create, develop, and review physical data models and ensure database designs comply with standards and procedures.
- Implement database changes, upgrades, patches, and releases using change-management and peer-review processes.
- Support capacity planning, database growth management, and storage utilization forecasting.
- Monitor and tune database and SQL performance, and establish automated monitoring for space and availability conditions.
- Conduct impact analyses and technical reviews for database enhancements and production rollouts.
- Lead incident resolution, root-cause analysis, and problem management for application and database availability and service-level issues.
- Execute and test database backups, disaster recovery plans, and recovery strategies.
- Perform functional testing and validation after maintenance, upgrades, and infrastructure changes.
- Ensure compliance with organizational policies, regulatory requirements, audit controls, database governance, and technical standards.
- Provide database implementation support, technical consulting, SQL optimization, and DBMS/platform assistance to application staff and business areas.
- Contact vendor support when needed to assist with application development and client problem resolution.
- Provide after-hours and weekend on-call support, including database refreshes, testing, upgrades, and other off-hour assignments.
- Participate in release planning, deployment, and post-implementation validation.
- Develop and maintain automation scripts and utilities to improve operational efficiency.
- Maintain technical standards, procedures, documentation, and operational runbooks.
- Train and mentor application developers and team members on technology, shared data resources, standards, and best practices.
- Participate in intra- and inter-departmental initiatives and in testing and recommending tools and utilities.
- Maintain external professional contacts to stay informed about industry trends and best practices.
- Perform other duties as assigned or requested.
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
Entry Level
Education Level
High school or GED
