SUMMARY

• Around 8 years of IT experience involving database administration at all phases of software development lifecycle i.e. Architecture, Development, Analysis, Design, Testing, implementation and maintenance of databases using DB 2 10.5/10.1/9.7/9.5/9.1 to support applications on Unix, AIX, Linux, & Windows environments.
• Extensive experience supporting DB2 system administration with L2 & L3 activities, troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.
• Install/Configure/monitoring/troubleshooting the Q Replication for production databases
• Configure/monitoring/troubleshooting the SQL Replication for production databases
• Setup/monitoring/troubleshooting HADR to ensure High Availability.
• Expertise in Installing Base code/Latest Fix packs and maintaining DB2 environment.
• Proficient in implementing Replication, backup & recovery Strategies.
• Database utility experience including re - org, runstats, load, backup, restore and roll forward.
• Database monitoring and tuning experience using DB2’s Snapshot Monitor, Event Monitor, Explain plan, db2advis.
• Worked extensively on features of DB2 Connect, DB2 Client and IBM Web Sphere Federation Server.
• Skillful in handling IBM Federation server issues. Creating Wrappers, Server definitions, Nicknames, User Mapping, Federated procedures from Sybase, DB2, Oracle, SQL Server and all kinds of files.
• Effective communication capabilities and being able to work productively with multilevel personnel.
• Proficient in Scheduling/Maintaining CRON/Db2 administrative scheduler jobs based on application requirement.
• Provide 24x7 on call support for databases supporting online applications and off-hours maintenance.

TECHNICAL SKILLS

RDBMS: DB 2 10.5/10.1/9.7/9.5/9.1

Database Tools: DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation Server, IBM Data Studio, Quest Tools, Toad for DB2, OPTIM tool

Application Server: Web sphere 6.0/7.0/7.5, Apache Tomcat Server,IIS

Operating Systems: UNIX (AIX 6x/7x Linux, HP-UX), Windows XP/NT/2000

Scripting/Languages: Shell Scripting (Bash, Korn), DB2 SQL PL, T-SQL, SQL/PL.

Schedulers: Cron Jobs, Windows Scheduler, Db2 Administrative Scheduler

PROFESSIONAL EXPERIENCE

Confidential

Sr. DB2 PRODUCTION SUPPORT DBA

Responsibilities:

• Design, develop and maintain Production, staging, test and development DB2 databases on AIX/Linux platforms.
• Install and Configure the Q Replication(Uni directional/Bi directional/Peer to peer) for production databases.
• Complete end to end setup and maintenance of HADR environment.
• Develop specifications for building New/Cloned DB2 database servers to meet the application requirements, verifying and validating servers after the build.
• Develop guidelines for migrating databases to new servers/cloned servers and execute migrations. Install Product base codes, Fix Packs, apply Emergency Fixes, create/upgrade/drop instances/databases on database servers regularly as per business requirement and need.
• Perform both In-place and side-by-side Migration of instances and databases from v9.7 to v10.1 and 9.7 to 10.5
• Implement LOGARCHMETH1, LOGARCHMETH2 & FAILARCHPATH to enable archival logging and Implications during recovery situations.
• Build new/cloned DB2 Connect servers, install DB2 Connect software and apply Fix Packs.
• Install and Upgrade various versions of DB2 Client on Database Servers/Application servers/Workstations.
• Perform Disk management by Monitoring volume groups/file systems growth, add additional disk space to volume groups/ file systems, create new file systems and allocate file systems to new databases.
• Open PMR to get resolution from IBM and run db2support, DB2DART (to verify architectural correctness of databases and objects), utilize db2trc, clitrace, wire shark trace and JDBC trace for problem analysis/resolution.
• Run db2mtrk to provide complete report of memory status for instances/databases/agents, db2top and db2pd utilities to identify the cause of suboptimal performance and tuned databases.
• Create Automatic Storage Database, Self-Tuning Bufferpools, implement Self Tuning Memory Management (STMM) and performed several rounds of workload test and computed the configuration parameters to setup hard limits
• 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.
• Work extensively with backups (Offline and online), restores, redirected restores and Unicode conversions.
• Recover data to a prior point in time using ROLLFORWARD recovery.
• Uninstall old versions of DB2 software on database servers/DB2 Connect servers.
• Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.
• 24X7 Production DBA support for application development, deployment and support activities.

Environment: DB2 AESE Version 10.5.4/ 9.7/9.5. x/9.1.x, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, IBM Data Studio V2.2, Quest Central, Toad, and HP Service manager.

Confidential

Sr. DB2 PRODUCTION SUPPORT DBA

Responsibilities:

• Configuring and Troubleshooting in the Q replication environment set up.
• Installed DB2 UDB ESE and applying Fixpacks in AIX Operating System.
• Analysis and creation of new databases (analysis about available memory, database size, database & database manager configuration options).
• Table partition - Adding, dropping the existing partition.
• Creating Database objects according to Naming Conventions (tables, tablespace, schema, indexes, views, etc.).
• Creating and Managing Database user privileges (GRANT and REVOKE).
• Database Cloning - Across same platform using Redirected Restore.
• Ability to recover data within the timestamp.
• Data Movement Utilities(LOAD,Ingest,Import, Export & Db2move)
• Monitoring Database activities (free space in tablespace, snapshot monitor outputs, etc.).
• Having Good Knowledge on Trouble Shooting tools like db2dart and db2pd.
• Establishing connection to remote database using Catalog / Uncatalog databases and nodes.

Environment: DB2 AESE Version 10.5.4/ 9.7/9.5. x/9.1.x, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, IBM Data Studio V2.2, Quest Central, Toad, and HP Service manager.

Confidential

LEAD PRODUCTION SUPPORT DB2 DBA

Responsibilities:

• Troubleshooting in the SQL replication environment set up.
• Taking care of day to issues with the replication environment.
• Installed DB2 UDB ESE and applying Fixpacks in AIX Operating System.
• Analysis and creation of new databases (analysis about available memory, database size, database & database manager configuration options).
• Creating Database objects according to Naming Conventions (tables, tablespace, schema, indexes, views, etc).
• Creating and Managing Database user privileges (GRANT and REVOKE).
• Performed table space Re- Architecture.
• Database Cloning - Across same platform using Redirected Restore.
• Ability to recover data within the timestamp.
• Automated Database Maintenance utilities (REORG, REORGCHK, RUNSTATS, etc.)
• Data Movement Utilities(LOAD, Import, Export & Db2move)
• Monitoring Database activities (free space in tablespace, snapshot monitor outputs, etc.).
• Having Good Knowledge on Trouble Shooting tools like db2dart and db2pd.
• Establishing connection to remote database using Catalog / Uncatalog databases and nodes.
• Attending daily calls with offshore and onsite teams.