Database Administrator
Send a job offer directly to this candidate
Software professional with 16 years of experience in database administration and development.
Over 16 years of experience in IT Industry DB2 administration and DB2 Developer with proven track record in Analysis, Design, Documentation, Development, and Implementation of Database projects.
Experience in managing of mid-size team ( 10 people).
Extensive experience in creating and manipulating Tables, Tablespace, SQL queries, Views, Synonyms, Index, Stored Procedures, Functions and Packages. Implement structure changes for all environments. Performing DML, DDL and DCL activities based on the request for the DB2 subsystems.
Extensively involved in performing Query Optimization and SQL Tuning for better performance Generate Performance report and generate various traces for various Db2 subsystem.
Handling DB2 job abends and Utilities related issues for DB2 subsystem.
Work and monitor DB2 space management and Change management activity using DB2 Admin tool
Responsible for deliverables with zero defects. Handling Root Cause Analysis activity for production critical issues. Raise PMR to IBM by sharing logs for some critical issues.
Performed offline weekly Backup and have experience in using Export, Import, Run stats, Reorg and monitoring activity on Z/OS.
Experience in working with End Users and effectively coordinated with onsite and offshore teams. Supporting migration from one version to next version.
Team Building activity. Communicating with onsite Team. Review of each deliverable.
As a Team Lead , Conducted Technical Interview & Training for new team members. Performed Trend analysis for Incident and server performance.
Cobol program, Stored procedures, and REXX programming.
IIDR DB2 replication SQL Replication & CDC replication.
Masters in computer science from Banaras Hindu University