DB2 DBA Supporting Application
Core
Optimizing SQL queries, assisting in database design, troubleshooting issues, and supporting DB2 database changes across the development lifecycle for applications.
Role type
DB2 Database Administrator (Application Support)
Builds
Application database performance and stability
Domain
Mainframe / Enterprise Database
Required skills
SQL query optimization, DB2 database design, database troubleshooting, environment migration coordination, performance tuning (tablespaces, statistics, buffer pools), DB2 best practices guidance, test data preparation
Preferred skills
JCL (Job Control Language), VSAM and mainframe storage concepts, database utilities and tools, backup and recovery procedures
Technologies
DB2, JCL, VSAM
Responsibilities
Reviewing and optimizing SQL queries, assisting in database design, troubleshooting database issues, supporting database changes through the development lifecycle, monitoring and tuning application database performance, providing guidance on DB2 best practices, supporting application testing activities
Seniority
Mid-Senior, hands-on IC
