What are the responsibilities and job description for the Zos DB2 DBA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Smart TechLink Solutions Inc., is seeking the following. Apply via Dice today!
Job Title: z/OS DB2 DBA with SQL Experience Location: Marysville OH (4 day onsite) Job Summary:
We are seeking an experienced z/OS DB2 DBA with strong SQL expertise to support enterprise mainframe database environments. The ideal candidate will be responsible for DB2 database administration, performance tuning, troubleshooting, backup & recovery, and supporting mission-critical applications running on IBM z/OS systems.
Key Responsibilities:
Job Title: z/OS DB2 DBA with SQL Experience Location: Marysville OH (4 day onsite) Job Summary:
We are seeking an experienced z/OS DB2 DBA with strong SQL expertise to support enterprise mainframe database environments. The ideal candidate will be responsible for DB2 database administration, performance tuning, troubleshooting, backup & recovery, and supporting mission-critical applications running on IBM z/OS systems.
Key Responsibilities:
- Administer and maintain DB2 databases on IBM z/OS platform
- Perform database installation, configuration, upgrades, and migrations
- Monitor database performance and implement tuning recommendations
- Develop, optimize, and troubleshoot complex SQL queries and stored procedures
- Handle backup, recovery, disaster recovery, and database security activities
- Support application teams with database design and SQL optimization
- Perform space management, reorgs, runstats, and utility management
- Troubleshoot database-related issues and provide root cause analysis
- Work with developers, infrastructure, and support teams for production deployments
- Ensure database availability, integrity, and compliance with organizational standards
- Strong experience with DB2 Database Administration on z/OS
- Hands-on experience with SQL query development and performance tuning
- Knowledge of DB2 utilities (REORG, RUNSTATS, COPY, LOAD, RECOVER)
- Experience with JCL, TSO/ISPF, SDSF, and mainframe environments
- Familiarity with database backup/recovery strategies
- Experience with production support and incident management
- Understanding of database security and access management
- Strong troubleshooting and analytical skills
- Experience with IBM tools and mainframe performance monitoring tools
- Knowledge of stored procedures, triggers, and database automation
- Exposure to Agile/Scrum methodology
- Banking or financial domain experience preferred
- 5 years of DB2 z/OS DBA experience
- Bachelor's degree in Computer Science, IT, or related field