DB2 Database Specialist

Specialist - Software Engineering

Creating and managing DB2 objects like Databases Tablespace Tables and Indexes in Production and Development regions

Maintaining database standards and naming conventions

Bindrebind plan and packages

Data maintenance using DB2 utilities Load Unload Reorg and Runstats

Tablespace conversion from Simple Segmented and Partitioned type to UTS

Provide 247 Oncall support for production system on rotation basis to handle DB2 job abends and issues

Maintaining DB2 image copies and recovery JCLs to ensure proper backup and recovery

Health check of application databases in DB2 system

Data refresh activities in Test environment

Granting and revoking privileges on DB2 objects for application users

Identifying and optimizing SQL queries to improve application performance

Support the application teams to resolve the DB2 related issues

Support for DB2 upgrade maintenance activities and DR and perform checkouts from DBA end