SUMMARY:

• 8+ years of IT industry experience in DB2 UDB Database Administration & Infrastructure Services with good knowledge & Exposure towards AIX, Windows.
• Managed Both SAP & Non SAP Databases of more than 20TB Database size.
• Key Skills: DB2 UDB DBA, SQL DBA, Infrastructure Management, ITIL\ITSM Methodologies, Practice Building, Competency Development, Project Management, Team Building, Team Leadership, Product Development.
• Hands on Experience in migrating DB2 UDB databases from old to newer versions (V9.1, v.9.5 to v.9.7, 10.1, 10.5) and applying FIXPAKS to keep DB2 at most recent level.
• Experience in Capacity planning, Backup, Restore and log Shipping. Conduct RCA for Database outages.
• Experience in using DB2 Movement Utilities like Export, Import, Load and db2move.
• Creation of user roles and granting/ revoking necessary permissions to users and roles.
• Work with the application development teams in fine - tuning of Queries, tuning performance of Queries\Jobs.
• Experience in setting up and maintaining disaster recovery methods High availability disaster recovery (HADR).
• Good experience in creating DB2 database data objects like table spaces, tables, Views and Indexes.
• Highly involved in performance tuning like performing REORGS, RUNSTATS on the database tables frequently and tuning SQL Queries.
• Monitored databases using snapshot and event monitoring for troubleshooting.
• Experience in requirement analysis, coding and testing various modules of SDLC.
• Involved in all phases of the project (Requirements, Designing, unit testing and defect fixing)
• Monitoring and resolving Blocking/deadlock issues.
• Good knowledge on Support guidelines and SLA deadlines.
• Exhibits strong teamwork and individual drive - highly motivated, articulate and eager to learn, Good Communication and Interpersonal skills.
• Involved in Query tuning \Performance tuning.
• Experience in database backup online, Offline backup, Snapshot backup, flash copy backup.
• Implemented standby database for high availability using HADR utility.
• Troubleshoot production DB2 issues and problems (db2diag.log, db2 traces).
• Provided on-call 24/7 DB2 DBA support for DB2 production environments.

TECHNICAL SKILLS:

Database: DB2 UDB 9.x, 10.x SQL Server

Database Tools: DB2 Data Studio, DB2 Connect & Query AnalyzerOperating System: AIX, Windows, Linux.

Ticketing Tools: Service Now, Maximo, Remedy

Monitoring Tools: Tivoli Monitoring

Languages: Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

DB2 LUW Database Administrator

Responsibilities:

• Involved in building new instance Database, Database Objects and users creation.
• Good Exposure in DB2 UDB Installations, Configurations and Administration on Aix, windows machines.
• Managing 200 database instances and 500 databases
• Migration and Up-gradation (Fix Packs) on existing database servers.
• Hands on experience in maintaining DMS Table spaces, Tables in DB2 databases running on UNIX platforms.
• Experience in implementing Backup and Recovery strategies.
• Good Experience on restoring the database from one AIX server to another AIX server using Redirect Restore method.
• Expertise in using DB2 Movement Utilities like Export, Import, Load and db2move.
• Expertise in getting entire DDL’s for a database using db2look and creating those objects structure in Target database based on the DDL script.
• Hands on experience in cataloging the Data Bases.
• Experience in using DB2 Maintenance Utilities like Reorgchk, Reorgs and Runstats.
• SQL Query Tuning using db2advisor, db2explain and db2exfmt tools.
• Troubleshooting database issues using db2diag, db2pd, db2top, Snapshot and event monitors.
• Worked with IBM support in various occasions by raising PMR and collected info using db2support to assist in troubleshooting.
• Primary Knowledge on HADR (High Availability Disaster Recovery).
• Good knowledge on Incident / Problem and Change management process as ITIL framework.
• Experience on preparing project related documents, Knowledge Articles.
• Tuning of db and dbm configuration parameters.
• Created views and granted privileges to the users as required to their access.
• Good experience in 24/7 production environment support and involved in on call support on rotation basis.
• Resolution for the user queries for all above tasks and application errors, which are affected due to database, level issues in day-to-day basis.
• Resolving locking issues at the application, by giving recommendations to make changes in the application to reduce/avoid deadlocks and lock timeout.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Involved in building new instance Database, Database Objects and users creation.
• Managed both SAP & Non SAP Databases. Managed 300 instances and 620 databases, Database size varied from 10 GB to 25Tb.
• Expertise in getting entire DDL’s for a database using db2look and creating those objects structure in Target database based on the DDL script.
• Handle Database Refreshes and respond to the DB related requests and Updates of operational procedure documents as necessary.
• Experience in Flash copy backup and flash copy restores Activities.
• Optimize SQL queries and analyze database performance issues
• Database Installation, upgrade and fix pack implementations
• Experience in using DB2 Maintenance Utilities like Reorgs and Runstats.
• Analyze production failures and slow performance by db2 diagnosis tool such as db2top, db2pd and by snapshots
• Participate in Cluster failover exercise and support database availability
• Research and analyze database solutions for proposed business requirements with all alternative solutions in research labs.
• Work with IBM lab via PMR for any production issue
• Install db2 software and db2 client software
• Experience in implementing Backup and Recovery strategies.
• Hands on experience in cataloging the Data Bases.
• Troubleshooting database issues using db2diag, db2pd, db2top, Snapshots and event monitors.
• Good knowledge on Incident / Problem and Change management process as ITIL framework.
• Experience on preparing project related documents, SOPS.
• Created views and granted privileges to the users as required to their access.
• Good experience in 24*7 production environment support and involved in on call support on rotation basis.
• Resolving locking issues at the application, by giving recommendations to make changes in the application to reduce/avoid deadlocks and lock timeout.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
• Managed SAP & NON SAP Databases. Managed 120 instances and 140 databases
• Creating and Monitoring Users, authorities and responsibilities and password management.
• Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities.
• Monitored and managed disk space, I/O contention.
• Designed and implemented backup and restore procedures.
• Monitored databases using database monitors, snapshot monitoring and event monitoring.
• Generated reports of database structure using DB2LOOK Utility.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Implementing capacity planning and partition table/index for very large and fast growing tables.
• SQL tuning and query optimization.
• Tuned application, database and system for best performance.
• Day-to-day attending to the user queries in sorting out database problems.
• Coordinating with user departments and attending their requirements for smooth functioning.
• Upgraded instances regularly with latest fix packs and alternate fix packs.
• Worked extensively with restores, redirected restores.

Confidential

DB2 LUW Database Administrator

Responsibilities:

• Recovering DB2 databases whenever necessary.
• Creation of DB2 objects like table spaces, tables, indexes and views.
• Managed 100 instances and 130 databases. Database size varied from 20GB to 20TB.
• Troubleshoot production DB2 issues and problems (db2diag.log, db2 traces).
• Automated the health check for various databases.
• Monitors replication server health, Database tuning and recommends system configuration changes to enhance the performance
• Handle Database Refreshes and respond to the DB related requests and Updates of operational procedure documents as necessary.
• Conduct root cause analysis for all database outages.
• Perform administration tasks such as database backup and restoration, Monitoring database health in terms of memory, CPU utilization, disk space, and security.
• Identifies bottlenecks in conjunction with application development team, attends and resolves batch abends.
• Monitors replication server health, Database tuning and recommends system configuration changes to enhance the performance.
• Responsible for running optimizer plans for slow performing queries, running trace and create standard reports on query performance and Database recovery
• Perform both functional and performance/stress testing for the stored procedures created and database objects and generating load and will tune the databases accordingly and will move the code to production environment.