SUMMARY

• 7+ years of IT experience involving database administration at all phases of software development lifecycle i.e. design, development, implementation and maintenance of databases using DB2 V7.x/8.x/ 9.1/9.5/9.7/10.1 to support applications on AIX, Linux, and Windows environments.
• Extensive experience supporting DB2 system administration, application development, troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.
• Expertise in installation of the IBM DB2 products and latest fix packs and maintaining DB2 environment including creating instances, databases, buffer pools, tablespaces and tables.
• Proficient in implementing backup and recovery strategies, developing Architecture for building a database by using tools like Erwin, ER/Studio.
• Worked on database utilities including re - org, runstats, rebind, export, import, load, backup, restore and roll forward utilities.
• Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Experience in DB2 compression to resolve unexpected data growth and save storage space.
• 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.
• Experience in HADR/HACMP setup between primary and secondary servers to ensure High Availability.
• Worked with third party utilities and tools like Quest Tools, IBM Data Studio, BMC Tools, DBArtisan, Toad, Performance Expert and Optim tools etc.
• Excellent communication capabilities and being able to work independently with minimal or no guidance.
• Extensive experience in writing Korn shell scripts and using AWK, SED, GAWK.
• Proficient in scheduling/maintaining CRON/Autosys jobs based on application requirement.
• Provide 24x7 on call support for databases supporting mission critical applications and off-hours maintenance.

TECHNICAL SKILLS

RDBMS: DB2 7.x/8.x/ 9.1/9.5/9.7/10.1, SQL Server 2005, Oracle 10g.

Operating Systems: UNIX (AIX 4.x/5.L,6.1 Linux),Windows XP/NT/2000/2008

Database Tools: DB2 Client, DB2 Connect, DB2 Replication Center, DB2 Federation Server, IBM Data Studio, BMC & Quest Tools, Toad, VERITAS NetBackup, IBM MTRK, DB2 Utilities, Optim tools

ETL Tools: Informatica 8.6.1, SSIS, Datastage

Reporting Tools: Business Objects (BOXI R2), SSRS

Application Servers: Web sphere 4.x/5.0/6.0, Apache Tomcat Server

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

Modeling: Erwin, IBM InfoSphere Data Architect

Query Software Tools: Advanced Query Tool v9

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

DB2 Database Administrator

Responsibilities:

• DB2 Database Administration on Linux, UNIX and AIX Platforms.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities. Migrated from V9.5, 9.7 to V10.1
• Explored new features of V10.1 and implemented the new features while migrating to the newer versions.
• DB2 connect Upgrade Project 10.1 rollout from from servers on DB2 connect versions on 9.5,9.7 to 10.1.
• This process contains collection of huge information and installing Extended insight and DB2 connect on several servers that are on old versions of DB2.
• Database Backup & Recovery (offline & online Backups - Full, Incremental & Delta Incremental). Database cloning using Redirected Restores.
• Disk Space Monitoring, Performance tuning, running the scripts such as db2purge, db2trimlogs etc., simply called as "cleaning and housekeeping"
• Automated backups (both online and offline), Reorgs, Runstats, Space moving db2diag.log, monitoring size of tablespaces by setting up a threshold.
• Moved the scripts to New Servers and Ran "FSUSAGE CNTL" to know the files usage using "df -h"
• Perform DB2 installation, configuration and install fixpaks to keep DB2 at most recent level on AIX, LINUX, Solaris servers including in HADR environment.
• Run REORGCHK which calculates statistics on the database to determine if tables or indexes, or both, need to be reorganized or cleaned up.
• Migrating scripts from one server to another using "SCP", modifying them and adding them to Crontab with minor code changes to make them run.
• BACKUP/RESTORE/UPGRADE on RRBUS servers(Reply Request BUS). Running db2iupgrade on 10.1 versions of the servers to upgrade the instance from previous or old versions.

Environment: DB2 ESE Version 9.7.x/9.5.x/9.7.x/10.1, AIX, LINUX, DB2 Connect V 9.7.

Confidential, Naperville, IL

Sr. DB2 Database Administrator

Responsibilities:

• DB2 Database HOT-STANDBY single partition Clustering on Windows environment on all the servers using DB2MSCS.cfg file
• Configuring all the necessary parameters in this file and running db2mscs -f: F:\db2mscs\db2mscs.cfg on the database servers.
• Running cluster group, cluster resource, Cluster group “available storage” /move:servername to move the storage from one server to the passive one
• Perform Downloading of DB2 software from IBM using the site number to get the user accessDB2 installation, configuration to keep DB2 at most recent level on Windows servers 2008 R2 edition.
• Creating the Instances and the databases, DB2icrt for the instances, db2 create db dbname automatic storage yes on path name for the database, set db2instance=instancename for setting up the instance
• Displaying and Setting up the environment variables using db2set - all and db2set db2param=value. Updating the instance and database configuration parameters dbm cfg and db cfg respectively.
• Solved the date issue which was by default as GB for the database to US using db2 bind @db2ubind.lst datetime Confidential blocking all grant public
• Where Confidential refers to format that is supported by the collection of db2 Utility packages. For example DEF, EUR, ISO, JIS, LOC, USA.
• Created Aliases, Foreign key scripts, Views for all the tables which have been created.
• Ran the existing Batch file Backup jobs, made the necessary modification before running those batch files.
• Ran db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.
• Calling the help desk and requesting them for the taskids for doing maintenance jobs and providing only the necessary grants for those ids and creating separate scripts as well for them to run instead of creating them manually.
• Used Advanced Query Tool for comparing the data after migrating it from one database to another one (helping the testing team also).
• Written a database configuration guide & TDD document which covers all the database activities including clustering setup which was the first time for the client.
• 24X7 Production DBA support for application development, deployment and support activities.

Environment: DB2 ESE Version 9.7.x/9.5.x/9.1.x/8.x, Windows Server 2008 R2 enterprise, Microsoft failover cluster Manager, Toad, Advanced Query Tool v9.

Confidential, Minneapolis, MN

Sr. DB2 Database Administrator

Responsibilities:

• Database design/analysis, support of development, test, staging, production database environments, installation, maintain, monitor, trouble shoot and configure complex DB2 LUW databases.
• Design and tune table spaces, buffer pools and dbm cfg parameters on DB2 servers to tune database performance according to periodic changes in use.
• Improve application performance by using various techniques like gathering data Purge requirements and create purge scripts, stored procedures, minimize lock contention by reducing lock-waits, lock timeouts and deadlocks.
• Use SYSPROC.ADMIN MOVE TABLE stored procedure to move a table while maintaining access to the old table while the move is being done.
• Implement data security guidelines while making data available to those authorized to have access. Manage DB2 security using OS groups and User ID, DB Authentication, DB Authorization and database object privileges.
• Perform DB2 installation, configuration and install fixpaks to keep DB2 at most recent level on AIX, LINUX, Solaris servers including in HADR environment.
• Install and configure DB2 client on variety of application servers.
• Created 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.
• Develop automated shell scripts for various database maintanence activities i.e. to monitor DMS tablespace usage, filesystems usage, to perform online/offline backups, runstats, reorgs.
• Usage of utilities Runstats, Reorgs on tables to claim space and improve performance, Export, import, load, db2move to move data between tables and output files, db2look to generate reports of database structure.
• Analyze SQL performance issues using db2expln(EXPLAIN), Index Advisor(db2advis) to predict performance gains from adding new indexes and based on that have made Index changes and recommend new MQTs, changes to SQL.
• Used third party vendor tools like Quest Central v 5.0, Toad, SPOT LIGHT for regular database administration. BMC tools to configure alerts for defined thresholds.
• Setup Federated Database environment between Databases by creating servers, wrappers, nicknames, User mappings
• 24X7 Production DBA support for application development, deployment and support activities.

Environment: DB2 ESE Version 9.7.x/9.5.x/9.1.x/8.x, AIX 6.1/5.3, DB2 Client 9.7.x/9.5.x/9.1.x, Informatica 8.6.1, Websphere, Shell Scripting, DB2 Optim tools

Confidential, Omaha, NE

DB2 DBA

Responsibilities:

• Designed, developed and maintained Production, staging, test and development DB2 databases on AIX and Windows platforms.
• Developed guidelines for migrating databases to new servers/cloned servers and execute migrations.
• Implemented LOGARCHMETH1, LOGARCHMETH2 & FAILARCHPATH to enable archival logging and Implications during recovery situations.
• Used db2greg tool to remove Instance, DAS, DAS Service, DB2 service registry entries from Global Registry on cloned servers while uninstalling older versions of DB2.
• Created/upgraded/migrated/dropped DB2 connect Instances, catalogued z/OS sub systems to allow mainframe access, catalogued DB2 LUW databases to allow database server access from DB2 Connect Gateway servers.
• Installed and upgraded various versions of DB2 Client on Database Servers/Application servers/Workstations.
• Performed Disk management by Monitoring volume groups/file systems growth, add additional disk space to tablespaces.
• Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
• Ran 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.
• 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.
• Worked extensively with backups (Offline and online), restores, redirected restores and Unicode conversions.
• Recover data to a prior point in time using ROLLFORWARD recovery.
• 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 ESE Version 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, BMC Patrol and HP Service manager.

Confidential, Cleveland, OH

DB2 DBA

Responsibilities:

• Responsible for software installation, database creation and maintenance, performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
• Installed DB2 software on AIX, Linux and Windows. Created instances and databases on different servers and provided connectivity to development and production databases
• Upgraded DB2 UDB instances from 32 bit to 64 bit and installation of latest Fix Pack.
• Created stored procedures, functions that cannot be migrated using MTK and compile, bind them to the databases.
• Developed Architecture for building a database by using tools like Erwin, ER/STUDIO.
• Designed Database to utilize the Row Compression and built row compression for the Tables.
• Determined project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.
• Run REORGCHK which calculates statistics on the database to determine if tables or indexes, or both, need to be reorganized or cleaned up.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of tablespaces by setting up a threshold.
• Ability to work through issues with IBM Technical support, Open PMR’s for problem resolution.
• Worked closely with Developers to create database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
• Created Range- partitioned Tables and specified ranges Creating Tables and Indexes.
• Experimented with changing buffer pool and tablespace page size to improve time taken by ETL to build data marts.
• Created EXPLAIN tables and running visual explain utility on SQL statements.
• Created MDC and MQT tables to improve query performance and reduce the overhead of data maintenance operations.
• Establish the environment to store XML data in DB2, Set up XQuery to retrieve documents from an XML column and create XML indexes for efficient retrieval of XML data.
• Worked heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central under high volume conditions to move data from Legacy systems.
• Remotely administered the production database 24/7 through VPN connection.
• This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.

Environment: DB2 UDB 8.x/9.1, SQL Server 2005, Oracle 10g, AIX 5.3, Linux, Windows Server 2003, ERWIN, ER/Studio, Quest Central, WAS server 6.0, IBM MTK, SSMA, Service center.

Confidential

DB2 SQL PL Developer

Responsibilities:

• DB2 UDB EE Database development and support.
• Altered tables and added check constraints and referential integrity.
• Created and maintained databases, tablespaces, tables, views, Stored Procedures, Triggers and indexes.
• Interact with business team and development teams for incorporating new functionality.
• Participated in enterprise-wide application and database production releases
• Developed shell scripts to handle DBA tasks and alerting systems.
• Documented plans and procedures in terms of backups, restores and disaster recovery.
• Checking the consistency of the databases using different db2 commands.
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Tuning application queries, databases and systems for best performance.
• Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots.

Environment: DB2 UDB V7.x, DB2 Connect, SQL Server 2000, AIX, Windows 2000, WIN NT, Web Sphere, Java 1.2, .Net, JSDK 2.0, JDBC, JavaScript, Apache Web Server EJB (J2EE), XML