SUMMARY:

• IT experience wif Database Administration at all phases of software development lifecycle i.e. Development, Analysis, Design, Testing, installation, Configuration, migration, Implementation, maintenance tuning, Security, backup, recovery and replication for various applications.
• Worked as a DB2 UDB V8.1, V9.1, V9.5, V9.7 and V10.1, V10.5 Database administrator on UNIX, LINUX and Windows platforms, wif expertise in online transaction processing and multi­user systems involving large and distributed databases.
• Involved extensively in Installation and Configuration, upgrading, and troubleshooting DB2 databases.
• Skilled in database administration tasks like SQL coding, Relational Design, Referential Integrity, Index strategies, and SQL Troubleshooting Using DB2 UDB.
• Migrated DB2 UDB databases from old to newer versions and applying FIXPACKS to keep DB2 at most recent level.
• Experienced in OLTP & OLAP database environments which include Single Partitioned and MultiPartitioned Databases (DPF) and Q Replication.
• Involved in Installation/upgrade of both SAP and NONSAP DB2 instances/Databases.
• Perform AUDIT on teh Databases to give users bare minimum privileges on teh Database and Database objects.
• Running utilities like COPY, LOAD, IMPORT, EXPORT, REORG, RUNSTATS, REBIND.
• Experience in installing, restoring and managing systems, databases, tables and indexes and multiple instances of DB2
• HADR, HACMP implementation for disaster recovery and upgrade schedules on teh following operating systems Linux, UNIX, Windows and SAP environments.
• Disaster recovery planning and execution, knowledge of DBA Design.
• Writing & executing UNIX based automation scripts (Perl, ksh, bash etc).
• Knowledge of UNIX based DB2 tools and utilities and Tivoli Storage Manager, NetBackup and WebSphere.
• Run CLI, DB2, JDBC traces on all DB2 Clients and Connects, Explain, db2advis, Db2exfmt, db2expln, reorgchk, reorg, runstats, db2rbind.
• HACMP­Create fail over disaster recovery procedures.
• Test and evaluate new software products in test regions and cut over to production environments.
• Perform software migration from one version to another and create, update instances, catalogs, databases execute load, delete and backups.
• Expertise in handling DB2 UDB security, establishing replication between servers, Capacity Planning, Backup and Restore, shipping archival logs, Corruption and Recovery, Managing login/permissions.
• Expertise in SQL and Dynamic SQL programming ­ Functions, Stored Procedures and Triggers
• Knowledge wif carving and implementing Backup/Recovery strategies for clients to have desired recovery models.
• Exposure to HA setups like Clustering, HADR, TSA for automatic failover etc.
• Setting up monitoring for teh database like Snapshots, Event monitoring, Traces, etc.
• Strong analytical ability, communication skills and problem solving capability.
• Versatile, flexible and ability to work on multiple assignments in given time frame.

TECHNICAL SKILLS:

• DB2 UDB EEE/V8V9/V10.x
• Command Center
• Control Center, Quest Spotlight
• Quest Foglight
• Quest Central
• Citrix, WIN SCP
• TEXT PAD, ERWIN
• WLM, MS Office
• Putty and TOAD

PROFESSIONAL EXPERIENCE:

Confidential - Dublin, OH

DB2 LUW Database Administrator

Responsibilities:

• Installed, Configured and upgraded DB2 server software and related products.
• Troubleshot day­to­day problems encountered on production, development and test database environment.
• Set up and upgraded many databases from V9.1 FP5 to V9.7 FP3a to V10.5 (Single instance & HADR), V9.7 FP7 to V10.1 (DPF).
• Managing project transition, client handling, POC, Training and setting up DBA team for newly acquired DB2 Environment.
• Evaluate system performance, adjusting values for database parameters and configuring metrics for alerts.
• Involved in DB2 UDB support, Physical Database design, installations, security, integrity, Backup & Recovery.
• Provided primary database administrative and Architect support for DB2 UDB databases in AIX & Linux using TSM.
• Extensively involved in performance tuning, recommending SQL queries for better performance using snapshot monitor, visual explain, index advisor, db2expln, db2exfmt,db2look.
• Enhancing application performance by running RUNSTATS, REORGCHK and REORG utilities.
• Designed, implemented and administered DB2 UDB for development, test and production environments.
• Developed and implemented standards to create databases and various database objects
• Managed database loading, migrating and maintaining data wif LOAD, EXPORT, and IMPORT DB2LOOK.
• Put cron job scheduling daily based for Backup, HADR monitoring, Size of filesystem, snapshot and runstats scripts
• Took online and offline backups using Netbackup media server and performed direct and redirect restores.
• Requested enhancement organic growth space addition for file system and raw devices to UNIX group.
• Analyzed and performed tablespace reclaim as and when required and enabled adaptive compression.
• Cataloged multiple instances and configuring connectivity to databases from remote clients
• Tuned Database Manager configuration parameters as needed
• Bind teh server DB2 utilities to teh databases
• Tuned DBM configuration parameters and DB cfg parameters
• Drop and add users, logins, aliases, and groups to teh databases and granting/revoking permissions on Database objects.
• Setting up HADR clusters for high availability and TSA for automatic failover and involved in upgrading to latest TSA version online.
• Supported linux, unix server patching and SAP firmware upgrades in rolling fashion wifout downtime.
• Extensively involved in Application Support, Design, User Administration, Security, Performance Tuning, Optimization and Backup/Recovery
• Used different monitoring tools like confio, solarwinds, splunk and performed real time monitoring for lockwaits using event monitor,DB2TOP.
• Raised PMR and worked wif IBM closely for different issues like application slowness, high DB response time APARs.
• Supported On call weekly based 24/7.

Environment: DB2 UDB v10.x, 9.x, AIX 7.x & 6.x,REDHAT LINUX, eCOMM, Pharma and Medical SAP systems, NETBACKUP, IBM DSM, DBI Brother Panther for DB2 Performance, Quest Toad, SOLARWINDS, CONFIO, SPLUNK.

Fepoc CareFirst - Washington, DC

Sr.DB2 UDB Administrator

Responsibilities:

• Installing DB2 UDB ESE on AIX, upgrading to latest fix pack versions, db2 instances setup and migrating instances, databases on UDB ESE and AESE server.
• Migrated Development (DEV), Test (UAT) and production (PROD) databases from DB2 9.7 FP 4 to DB2 10.5 FP 6.
• Exposure to z/OS mainframes to DB2 LUW migration.
• Performing SAP System copy using DB2 redirected restore process and renaming of tablespace
• Creating/modifying korn shell scripts for database log pruning, backup/restore of db2 databases and updating db2 registry parameter for start/stop for AWS migrated servers.
• Using DBA Cockpit to troubleshoot and improve database performance by changing db2 database manager, database parameters
• Creating scripts to monitor tablespace thresholds, deadlocks, lock waits using snapshot monitors, event monitors and DB2 administrative views
• Setting up all DB2 systems for backup/restore and log file management using TSM, TSM for ERP scheduled via TSM scheduler
• Setting up weekly runstats, monthly re­org of tables using scripts in crontab.
• Performing database restores from crash recovery, using point­in­time recovery, roll forward recovery during disaster recovery
• User management and granting/revoking required privileges on teh DB instance.
• Performance tuning of long running processes, SQL queries using DB2 explain tool and providing optimized access plan for applications and recommending indexes.
• Diagnosing and troubleshooting db2 diagnostic notification and diaglog, collecting db2support and db2fodc logs for IBM PMR.
• Monitoring of alerts for file system monitoring and database monitoring in daily reports

Environment: IBM DB2 V 9.5, 9.7,10.1, 10.5, IBM Data studio, AIX 5.x, 6.x, PVCS, Informatica, Toad, NetWorker, TSM.

Confidential - Columbia, MD

DB2 LUW Database Administrator

Responsibilities:

• Carried out knowledge transfer (KT) from teh client DB2 team, documented teh process and procedures and educated teh offshore team.
• Carried out day to day work wif client team which involves tickets, production support, project work, process improvement and teh role of application DBA.
• Actively involved in figuring out teh qualifying problems for IBM PMR, following up wif teh vendors and teh teams involved.
• Transferred technical knowledge to two administrative personnel through providing onsite training, detailed best practice documentation, architecture, and procedures for DB2 systems.
• Solving teh user access and security group issues.
• Documenting teh standards followed by teh YUM team and maintaining teh version updates along wif teh process improvements being carried out.
• Provided inputs and implemented many process improvements like Backup Strategy and Schedule, Script modifications and standardization, naming standards, Table/Tablespaces restructuring, Maintenance activities/schedule, Performance tunings, database Creation, etc.
• Used load, import and export utilities for moving data to files and from files. Used db2advis, db2batch, db2expln, and db2exfmt for tuning queries.
• Supported new environment creation starting from capacity planning, structure layout, instance creation, group/user set up, database creation, object creation and followed by supporting teh tuning andPerformance monitoring for teh application teams.
• Set up and monitored Disaster Recovery boxes and HADR for critical databases.
• Performed on call duties for SQL Server and DB2 databases.
• Supported multi-application databases for SQL Server.
• Performed daily activities like Database Creation, User access, Scheduling, Job set up, Backups/ restores, etc.
• Supported linux,unix patches and application maintenance downtimes.
• Monitoring multiple alerts and notification from over 60 applications and 400 databases.
• Provided 24x7 support for production databases.

Environment: DB2 UDB v 8.2/v 9.7, Dprop, UNIX(AIX), Toad, Quest Central, Quest Spotlight, SSMS, SQL Server(MSSQL) 2005/2008/2008 R2.

Confidential - Washington, DC

DB2DBA consultant

Responsibilities:

• Worked on creating Staples internal portal, which is live now and TEMPhas replaced teh existing home portal. Created teh environment from teh scratch which consists of 54 Databases.
• Compressed 100s of multi 100 GB tables and was able to save more than 8 TB of space from teh EDW (data warehouse).
• Upgraded many Fix Packs in version 8 and 9.
• Supported v 9.1 to v 9.5 migration.
• Created backup and recovery strategy and implemented and schedules teh activities.
• Supported many development projects which include creating teh tables, views, indexes, stored procedures and triggers in both OLTP and OLAP environments.
• Intensively worked on DB performance tuning and dealing wif STMM, AUTO MAINT, Health Monitors, etc.
• Was involved in deploying Stored Procedures using Developer Work Bench.
• Created Backup Reporting model to send daily detailed reports to teh team about teh success and failure wif teh failure reason.
• Created and scheduled automated REORG/RUNSTATS scripts to perform automatic maintenance activities on different environments depending on teh system needs.
• Handled On­line Backups, On­line reorgs wifout bringing teh database down.
• Used EXPORT, IMPORT and LOAD utilities and moved data between tables and output files.
• Created Development environment for staging and implemented it into teh test and production environments.
• Configured database for optimal performance and developed backup and recovery strategies.
• Performed Disaster Recovery tests for production environments.
• Familiar wif different utilities like DB2TOP, SMITTY, DB2LOOK, etc.
• Dealt wif different issued regarding FS usage, Grants, Profiles, Variables, etc.
• Worked wif IBM to open PMRs and found solutions for different priority issues. dis included performing diagnostic tests, data collection and sending it to teh IBM.
• Encountered many APARs in teh environment and worked wif teh DB and application teams along wif IBM to implement teh hot fixes/FPs and then monitor teh performance.
• Worked wif DAs and used forward/reverse engineering from Erwin to update teh model or DB.
• Involved in reducing HWM and free teh space and add it to teh File System.
• Proficient wif required UNIX commands and scripting.
• Worked in teh Onsite/Offshore model.

Environment: DB2 UDB v8.1, v8.2, v9.1, v9.5, v9.7,DPF, SQL Server, Informatica, Microstrategy, UNIX (AIX), Linux.

Confidential

DB2 DBA consultant

Responsibilities:

• DDL implementation and changes for database objects.
• Maintaining database backup and recovery and other scheduled tasks.
• Worked on explain, db2advis, taking snapshots, running list applications, checking teh memory, backups and restores etc.
• Regular auditing of teh database for user access to ensure teh security.
• Supported FP and version upgrades.
• Worked wif teh application teams to tune teh SQLs and DB.
• DB2 UDB EE Database administration and support.
• Experience in database restores and disaster recovery.
• Logical and Physical Database design.
• Altered tables and added check constraints and referential integrity.
• Created and maintained databases, tablespaces, tables, views, and indexes.
• Prepared and implemented standard recovery procedures for data recovery.
• Gained experience wif scripting to create automated jobs for DB maintenance.
• Involved in data modeling (Logical/Physical database design) & design including data marts.
• Monitored and analyzed DB2DIAG logs.
• Involved in day to day database administration tasks like running reorgs, runstats, import and export.

Environment: DB2 UDB v7, Sybase, 11.0, Oracle, Windows, AIX (UNIX)