SUMMARY:

• Over 9 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation and maintenance of databases using DB2 UDB ESE, WSE, EEE on Linux, UNIX and Windows Platforms
• 8 years of rich experience in Database Administration using DB2 UDB and with strong business knowledge of Healthcare, Financial, Insurance, Retail and Manufacturing projects
• Basic Knowledge on ORACLE.
• Expertise in Support activities including installation, Upgrades, configuration and successful deployment of changes across all environments
• Upgrades DB2 UDB databases and applying fix packs to keep DB2 at most recent level
• Experience in implementing Replication, Log shipping, HADR, DPF, Backup and Recovery strategies and developing Architecture for building a database by using tools like Toad and HPSM and writing necessary Shell, Perl scripts
• Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery, DPF, tablespaces and integration of database applications
• Experience in Configuring IBM Web Sphere and IBM Info Sphere resources, including JDBC providers, JDBC data sources and connection pooling. involved in flash copy recovery for databases in huge size
• Actively Involved in design/configuring databases on HADR - TSA and HADR-HACMP clusters
• Experienced setting up the DB & Instance Configuration Parameters as per the needs and recommendations
• Experience in Running utilities like COPY, LOAD, IMPORT, EXPORT, REORG, RUNSTATS, REBIND
• Experience in DB Refresh from production to QA and DEV and TEST environment
• Experience in problem analysis and troubleshooting database related issues. Provide performance tuning support to development teams for resolving issues with space usage, stored procedures, SQL Tuning and application monitoring
• Design and implement all the latest features of DB2 V9.1, V9.5, V10.1 and V10.5 DATA and INDEX COMPRESSION with REORG, Range-Partitioning, SYSIBMADM views, DPF etc.
• Migrated version upgrades database from lower versions of DB2 UDB, From V9.1 to 9.5 and 9.5 to 9.7 and 9.7 to 10.5
• Experience Database refresh from production to Development, UAT and SAT using Redirected restores.
• Extensively Used Export, Import & cursor Load for data movement from one environment database to another environment and within the database as required.
• Utilized data definition language using Db2look while setting up new database environments.
• Experienced in Setting up HADR and Database partitioning and Cataloging Databases on various nodes
• Extensively used db2pd, db2top, db2diag and snapshot monitors to determine the database problems.
• Tuning of SQL Queries using db2expln and db2advis tools in improving the Query response time.
• Create PMRs with IBM in case of any software and problems issues with DB2 UDB
• Excellent analytical and functional skills with strong communication and interpersonal skills.
• Provided production support for critical applications running on 24/7 basis
• Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges

TECHNICAL SKILLS:

RDMS: DB2 UDB LUW v8.1, 9.1, 9.5, 9.7 and 10.1, 10.5, 11.1

Operating System: Linux (Redhat), AIX 5L, SUN Solaris, HP/UX and Windows (2000, 2003).

Database Tools: DB2 connect, BMC Patrol, Quest Central for DB2, Toad for DB2, Control Center, Visual Explain

Hardware: IBM RS/6000 SP, IBM ES/9000, IBM 3090, IBM PC s, MS IIS, and Storage Area Network (SAN) EMC/DMX, Tivoli Storage Manager

Web Servers: IBM Web sphere, Web logic, IBM Info Sphere

Software Packages: Lotus Notes, MS Office XP, MS Visio

Tools: Remedy, HPSM, ESP, TWS, Toad, ERWIN

Programming and Scripting Languages: Shell Scripting, SQL Server 2007, BASE SAS

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Environment:, DB2 UDB V10.5, 11.1 Aix 6.1, Linux, Tririga, HADR

DB2 UDB DBA Consultant

Responsibilities:

• Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments
• DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments on LUW.
• Expertise on creating the new database and maintaining database objects.
• Expertise on Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Expertise in using DB2 Movement Utilities like Look, Export, Import Load and db2move.
• Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database.
• Create DB2 database online/offline backups (INCREMENTAL & INCREMENTAL DELTA).
• Backup & Recovery of Database (Regular & Redirect restore), online database backup, archived log files and Offline.
• Perform DB Refresh from production to QA and DEV and TEST environment.
• Actively Involved in design/configuring databases on HADR with TSA.
• Implemented DB2 Security, Locking and Concurrency Control using Isolation levels.
• Experience on maintaining Database Manager and Database Configuration Parameters.
• Extensive experience in working with db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise, db2explain, db2diag, db2look, db2move & db2relocatedb
• Create and deploy CRs for DB stability & application release.
• Provide database solutions to developers and customers.
• Writing and testing shell scripts for automating database activities
• Monitoring the database on regular basis for performance and other issues
• Tuning of DB and DBM configuration parameters
• Opening PMR with IBM through phone or tickets in case of Database failures or any support required & driving them to closure.
• Troubleshoot root cause of database issues and recommend solutions or workaround.
• Providing weekend on call support

Confidential,

Environment: DB2 UDB V9.5, 9.7, 10.1, 10.5, 11.1 Aix 6.1, Solaris, Linux, SAS, ESP, TWS, DPF, HADR

Senior DB2 UDB DBA

Responsibilities:

• Gathering User Requirements, Database Design & System Testing, Performance Tuning, Database Migration, Upgrades Implementation and Maintenance of DB2 UDB on AIX and UNIX platform.
• Supervised production line to ensure production orders were completed on a timely basis
• Monitored progress and tracked it and motivated team members to meet production goals
• Implemented Optimization Techniques for New and Existing Applications.
• Managed the monthly loading of a SAS/DB2 UDB data warehouse application of more than 15TB database in DPF. The load consisted of more than 900 separate jobs with complicated dependencies in a TWS and ESP scheduling environment.
• Migrated version upgrades DB2 UDB databases from v 9.5 to 9.7 and v9.7 to 10.5
• Tuned DB and DBM configuration parameters for better performance
• Data refresh from production to Development and UAT and involved in RFS activities
• Setup maintenance jobs like backup, reorg, reorgchk for various databases using Shell scripts
• Assisting application teams with all DB2 issues and questions during ON and OFF peak hours
• Configuring Database (DB2) to IBM WebSphere and infospehre Process Server and ran the db2 scripts to create databases, tables, schemas for Process Server.
• Applied fix upgrades on servers and clients to keep the databases up and running with the latest level of fix packs version required
• Created database objects like tables and tablespaces and granted privileges to the users as required to their access
• Used load, import and export utilities for moving data to files and from files. Used db2advis, db2batch, db2expln, and db2exfmt for tuning queries
• Monitoring daily and weekly jobs and takes preventive measures against failures
• Extend the TableSpaces & File System Space Management.
• Executed the SQL Scripts for all the ETL’s
• Create PMRs with IBM in case of any software issues with DB2
• Granting, revoking appropriate database access for users and groups.
• Monitoring of databases using snapshots, event monitors and third party tools like BMC Patrol
• Taking full Online and Offline backup of 15TB database level backup and restores
• Provided 24x7 supports for production databases.

Confidential Environment: DB2 UDB V9.5, 9.7, 10.1, 10.5, 11.1 Aix 6.1, Solaris, Linux, SAS, ESP, TWS, DPF, HADR

Senior DB2 UDB DBA

Responsibilities:

• Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments in DPF
• Reviewed existing database and the system to improve the database parameters in production environment.
• Creation of Database Objects Tables, Table spaces, Indexes and Storage group
• Created Buffer Pool objects to cache database data pages in memory and reduce the physical I/O access to disks
• Extensively involved in performance tuning, recommending SQL queries for better performance using snapshot monitor, visual explain, index advisor, db2expln, db2exfmt.
• Developed automated scripts using Unix Shell and Perl for performing runstats, reorg, rebind, backup, load, export and other related to database activities
• Handled On-line Backups, On-line reorgs without bringing the database down
• Used EXPORT, IMPORT and LOAD utilities and moved data between tables and output files
• Configuring Database (DB2) to WebSphere Process Server and ran the db2 scripts to create databases, tables, schemas for Process Server.
• Created Development environment for staging and implemented it into the test and production environments.
• Configured database for optimal performance and developed backup and recovery strategies.
• Performed Disaster Recovery tests for production environments.
• Participated in performance test, stress test, capacity test for new releases and new upgrade databases.
• Created IBM problem tickets, applied and installed recommended changes.
• Granting and revoking the access to users and groups on the database and database objects.
• Assisted application teams with all DB2 issues and questions during ON and OFF peak hours.
• Implemented Clustered databases for providing 24/7 primary database and standby database using HACMP.
• Monitoring and providing 24x7 support for production databases

ConfidentialEnvironment: DB2 UDB v8.1, 9.1, 9.5, 9.7 Aix 6.1, Solaris, Linux, windows, HADR, Replication

DB2 UDB DBA

Responsibilities:

• DB2 UDB ESE Database administration and support, Installation of DB2 servers and Applying FP’s upgrades as per the requirement.
• Provided support for the DB2 Data Movement utilities like Export, Import & Load.
• Monitoring the scheduled jobs like backups, data loads etc
• Data refresh restore database from production to Development UAT and Test Environment
• Worked with db2look and db2top tools
• Enabling & Disabling HADR for DB’s based on the requirement.
• To be involved in routine database administration activities such as granting user privileges
• Developed shell scripts to handle DBA tasks like tablespaces and backup alerting systems
• Checking the consistency of the databases using different db2 commands
• Extend the Table Space & File System Space Management.
• Tuning of databases using db2expln and db2advis tools in case of performance issues
• Analyzing and implementing DB2 reorg utility based on the need for database reorganization
• Worked with development team provided SQL queries scripts
• Provided support for Application and development Team members to enhance query performance
• Create PMRs with IBM in case of any software issues with DB2
• Providing 24* 7 supports for critical applications