DB2 DBA

DB2 DBA

Shift: 17:30 IST to 2:20 AM IST

Hybrid/Remote

Total relevant exp: 10 Years

Relevant Exp : 10 Years

Required Technical and Professional Experience

• Around 10 Years of Experience in Mainframe DB2 Database administration.
• Responsibilities for this job role include, but are not limited to, installation and maintenance of the databases, DB2 upgrades and patches checkouts, performance and capacity monitoring & management, and security compliance.
• Monitoring health check jobs like Image copy, Runstats, DDL$DML reports.
• Rebalancing of Partitions.
• Space Management and Monitoring.
• Performed End-to-End Release activities
• Creating and scheduling utilities like COPY, Reorg, RUNSTATS and QUIESCE.
• Running Adhoc Reorgs, Runstats and Rebinds in Productions Environment.

o Implementing and scheduling production DB2 jobs.

o Monitoring on daily, weekly and monthly batch cycles.

• Handling Technical Lead role(ISMEs)and knowledge across mainframe platforms

Preferred Skills and Experience

•Bachelor’s degree in computer science or a related field.

•Housekeeping and Maintenance of files owned by DB2 Database.

•Tuning of Databases and DB parameters

•Tablespace Migration.

•Provided 24*7 production support on rotation basis