DB2 DBA
Resume:
Katakam Naveen Kumar Email id: adc6pc@r.postjobfree.com
Associate Consultant (DB2 UDB DBA) Contact # +91-988-***-****
Work Experience & Career Summary:
Overall experience: ~8 years
Having 5+ years of experience in DB2 UDB Administration
~3 years of experience in ITIL Incident & Change Management.
•Expertise in Installations, Configurations and Administration of DB2 UDB DB2 V10.1, V10.5 & v11.1
•Competent in upgrading DB2 UDB and Fix Pack installation.
•DB2 UDB Database Administration related support to all Development, Staging and Production environments.
•Proficient in using data movement utilities like Export, Import and Load to data transfer.
•Perform Database Refresh, Tables Refresh as per the requirement from application users.
•Provide optimum performance of queries by updating the STATS and remove fragmentation including space reclamation using REORGS.
•Good Experience in developing DB2 Backup and Recovery scripts.
•Expertise in management of HADR - TSA in DB2.
•Experience in SQL Performance Tuning apart from I/O and Memory Tuning.
•Expertise in Implementing the Cron Jobs for Scheduling Backup, Load…etc.
•Provide 24x7 support on shift rotation basis and attending to user & customer calls when required.
•Worked with various teams and coordinated well to reach the business SLAs.
Technical Expertise:
Database
IBM® DB2 UDB V11.1, 10.5, V10.1, v9.7
Languages
SQL, Shell Scripting
Storage Domains
TSM, EMC, Networker
Operating Systems
Red Hat Linux, AIX, Windows 98/2000/NT/XP
Ticketing Tool
Service-Now, BMC Remedy
Other tools
CyberArk, DSM, Maestro, Tkman
Education & Trainings:
Bachelor of Technology from Institute of Aeronautical Engineering, Hyderabad.
Trained on DB technologies: IBM DB2 LUW v10.5, IBM DB2 on z/OS, PostgreSQL.
Trained on ITIL v3 Foundation.
Work Experience:
Working as a Database Administrator in Capgemini Technology Services India Limited, from
May-2019 to Till date.
Worked as a Database Administrator & ITIL Analyst in Genpact, Hyderabad from June-2012 to May -2019
• Database Administrator from March-2015 to May-2019
• ITIL Analyst from June 2012 to Feb-2015
Projects and Assignments: (1)
Project Name : Metropolitan Life Insurance Company
Role : DB2 UDB DBA
Team Size : 17
Environment : DB2 v11 FP 4, LINUX & AIX
Responsibilities:
Perform database maintenance activities such as backup, reorg & runstats.
Install new FixPack versions and configurations & upgrading the database with new version.
Perform Load operations, Cross environment loads using Load cursor/Pipe Load.
Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
Troubleshoot on the issues reported such as Patrol alerts and Maestro Abends.
Provide optimum performance of queries by updating the STATS and remove fragmentation including space reclamation using REORGS.
Perform Database Refresh, Tables Refresh as per the requirement from application users.
Refresh the databases from PROD to Non-PROD servers.
Handling performance & long running query issues & monitoring high log utilization.
Monitoring in maintenance of HADR on PROD environments.
Involved in DR test activity.
Implemented HADR Failover/ Fail back testing on quarterly basis on all prod systems.
Monitoring the databases for locks, deadlock and transaction log full errors.
Troubleshoot on the issues reported such as Patrol alerts and Maestro Abends.
Promote Stored Procedures, execute DML & DDL scripts.
Management of Database user privileges appropriately.
Prepare Monthly Incident Analysis report and share it to client.
Projects and Assignments: (2)
Project Name : The Coca Cola Company
Role : DB2 LUW DBA
Team Size : 12
Environment : DB2 v11 FP3, LINUX, SAP Basis Netweaver 6.x
Responsibilities:
Handled DB2 version upgrades from 9.7, 10.1, 10.5 to 11 along with FixPack upgrades.
Creation of the databases and objects as per client requirement.
As part of Access Management, provided required grants to user to access the DB objects.
Regular Database Maintenance using scripts scheduled via CRONTAB and TWS.
Configure DB2-TSM, backup, recovery, log archival to TSM / EMC Data Domain.
Monitored the DB backups and prepared a Monthly Database Backup trend graphical presentation and shared the same with client.
Expertise in generating data definition language using DB2LOOK command from existing Database and creating the same objects in newly created databases.
Using Data movement utilities for exporting and importing data.
SAP system refresh/copy Production to Test thru redirected restore.
Hands on experience in Capacity forecasting on all prod databases. Analyzing the growth rate of DB and following up with Unix team to get additional disk space.
Exposure on management of HADR - TSA in DB2 on PROD environments.
Handling performance issues & responding to request on long running queries & monitoring high log utilization.
Involved in Change Management lifecycle ensuring business SLAs are met.
24 X 7 availability making sure immediate response is given.
Attending customer calls to discuss ongoing activities/issues.
Apart from the regular technical duties, was also an Audit SPOC for the account, handling and maintaining all the required documents and presenting to the auditors.
Experience as an ITIL Analyst:
Project Names : GE, eBay
Role : Incident Manager and Change Coordinator
•Worked as an ITIL Incident Manager focusing on Major Incidents.
•Restored the service operation back to normal as quickly as possible to minimize the impact to business operations.
•Made sure all the INCs meet the business SLAs when a critical incident is being reported.
•Facilitated the resolution of high severity incidents (P1, P2) via technical conference bridge lines.
•Made sure all the required technical teams are involved during the Critical bridge calls and drive the bridge until the issue is fixed.
•Being a Change Coordinator, coordinated the Change Maintenance window with the change implementers.
•Completed ITIL v3 Foundation Certification.
Contact this candidate