DB2 DBA
Core
Support administration of DB2 for z/OS, Linux, and Windows, focusing on performance tuning, backup/recovery, disaster recovery, and data modeling.
Role type
Senior DB2 Database Administrator
Builds
Production database environments and recovery processes
Domain
Enterprise Data Management / Mainframe & Distributed Systems
Required skills
DB2 for z/OS, DB2 on Linux/Unix/Windows, DRDA/ODBC/JCBC connections, Data modeling (ERWin), SQL coding, Change control processes
Preferred skills
SQL coding in Java/COBOL, XML, Dimensional Modeling, Cognos BI, InfoSphere DataStage, SQL Server, Sybase, Scripting languages (Rexx, Bash, BAT)
Responsibilities
Analyze access patterns for performance tuning, create and test backup/recovery processes, design disaster recovery plans, participate in data modeling sessions, create DDL for DB2 objects, assist with application diagnostics, manage change control for DB2 objects, train staff on DB2 usage
Seniority
Senior, hands-on IC