Db2 DBA with 11 years of experience

7/2018 – offen

CAI Info India Pvt Ltd July 18 – Till Date
Technical Lead – DB2
Client – Chubb’s Insurance
Platform: AIX , MS Windows
Tools : Db2, PerfAnalyst, Filenet, Autosys , Shell Scripting

Responsibilities:

• DB2 fix pack and database upgrades; client installations
• Monitoring and administration of DB2 LUW Versions 9.5 to 11.1
• Performing backups and restores
• Automation of DBA functions via scripting
• Participating in on-call rotation and working in shifts.
• Generating and analyzing db snapshots and provide performance guidance
• Stored Procedures for transformation and processing data.
• Capacity planning and Storage design [bufferpool sizing, tablespace partition groups depending on containers’ design, partitioning keys implementation, MDC organize by columns etc]
• Performance monitoring, lock analysis, transaction analysis, statement analysis using db2top

Datenbankadministration, Datenbankentwicklung, DB2, SQL, Incident Management, ITIL