DB2 LUW Database Administrator
Core
Administer, maintain, monitor, and tune IBM DB2 LUW databases across production, test, and development environments, including installation, configuration, upgrades, patching, migrations, and high availability/disaster recovery solutions.
Role type
Senior DB2 LUW Database Administrator
Builds
High availability, disaster recovery, backup and recovery, and replication solutions for data warehouses and business-critical transactional systems
Domain
Enterprise IT / Database Administration
Required skills
IBM DB2 LUW 10.x/11.x administration, Linux administration, SQL development and optimization, performance tuning, backup and recovery strategies, HA/DR architectures, capacity planning, storage management, shell scripting (Bash, Korn Shell)
Preferred skills
Python or Perl scripting, IBM Power Systems/AIX environments, pureScale/DPF/HADR/TSA/PowerHA, Oracle database administration, SAN storage technologies, Middleware environments (WebSphere, WebLogic), DevOps and Infrastructure as Code practices
Technologies
IBM DB2 LUW, Linux, AIX, pureScale, DPF, HADR, TSA, PowerHA, WebSphere, WebLogic, SAN storage (IBM, NetApp, EMC)
Responsibilities
Administer, maintain, monitor, and tune IBM DB2 LUW databases across production, test, and development environments; Diagnose performance issues, tune SQL, and optimize queries; Design and implement high availability, disaster recovery, backup and recovery, and replication solutions; Manage partitioned and clustered DB2 environments (DPF, pureScale); Develop and maintain automation scripts for database administration and operational tasks; Take part in incident resolution, root cause analysis, and continuous service improvement
Seniority
Senior, hands-on IC