SUMMARY

• IBM Certified having over 7+ years of IT experience involving database administration at all phases of database development lifecycle i.e. design, development, implementation and maintenance and support of databases using DB2 V10.1/9.x/8.xon AIX, Linux, Solaris, HP - UX and Windows.
• Migrated or upgraded DB2 UDB databases and installing Fix Packs to keep DB2 at most recent level.
• Involved in the database and application design reviews and designed and built the physical database structures using the logical model.
• Database monitoring and tuning experience using Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Implemented MDCs, MQTs, Replicated MQTs and Statistical Views in the Data Warehouses and Marts for the optimal performance.
• Experience on Database Partitioning Feature (DPF) for maintaining very large databases.
• Setup HADR/HACMP 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.
• Experienced in database administration tasks like SQL coding, Stored Procedures, Triggers, Referential Integrity, Index strategies, and SQL Troubleshooting.
• Experienced in running DB2 utilities like EXPORT, IMPORT, LOAD, DB2MOVE, REORG, RUNSTATS and DB2LOOK.
• Extensive experience in writing Korn shell scripts to automate database maintenance activities.
• Opened PMR’s to get the resolution from IBM and collect the db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis and resolution.
• Proficient in scheduling/maintaining CRON/Autosys jobs based on application requirement.
• Excellent Interaction with clients, functional and business analysts and department Managers and different levels of users and developers and experience with Software Development Life Cycle.
• Experienced in educating and mentoring the users and developers about the DB2 best practices.
• Provide 24x7 on call support for databases supporting mission critical applications and off-hours maintenance.
• Excellent communication and interpersonal skills and being able to work independently with minimal or no guidance.

TECHNICAL SKILLS

RDBMS: DB2 UDB 10.x/9.x8.x/, SQL Server 2000/2005, Oracle 11g

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

Utilities/Tools: db2top, db2pd, db2batch, DB2 Performance Expert, Quest Central, Spotlight, BMC Patrol, IBM Query Patroller, TOAD, DB2 Connect, Event Monitor, Snapshot Monitor, TSM, Q-rep,Control-M, Data Propagator (DProp), Replication Center, IBM Optim Tools

Source Control: Manage Now, Rational ClearCase, MS VSS, SVN

Scripting/Languages: Shell Scripting (Bash, Korn), SQL Programming, PL/SQL, .NET, C, Java

ETL Tools: Informatica 8.6.1, SSIS, DataStage

Reporting Tools: Business Objects (BOXI R2), SSRS

Data Modeling: Erwin, IBM Infosphere Data Architect

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr. Database Administrator

Responsibilities:

• Manage production, staging, test and development DB2 UDB
• Migrate DB2 UDB databases on AIX from V9 to V10 and updated to a latest level by installing Fix Pack
• Assisted developers in creating stored procedures, functions, compiling and binding them to the database.
• Tuned databases using tools like snapshot monitor, visual explain, Index advisor, db2expln, db2exfmt etc
• Created multiple databases across different environments using Redirected Restore
• Developed scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS
• Regularly monitored databases for deadlocks, table spaces, long running queries using Snapshots and Event monitors
• Monitored database activity using BMC DBXray and setup threshold alarms using BMC Patrol
• Analyze, test and implement physical database design (including base definition, structure, documentation, requirements, operational guidelines) and supporting data warehousing applications
• Setup Replication between Operational Database and Reporting Database
• 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.
• Created multiple Buffer Pools for optimal performance and allocation of resources
• Configured database to enable I/O Parallelism and Intra-Parallelism for fast query retrieval and high performance
• Extensively worked with data movement utilities like import, export, load and db2move for data migration between databases
• Prepared backup and recovery strategies depending on SLA and implemented successfully
• Converted business process functions into user defined functions and procedures
• Provide on-call (24X7) support for all production databases

Environment: TRAC, MS Office, Putty, IBM DATA Studio 4.5.1, Oracle 12c, IBM Infosphere Optim Client 11.3, DB2 10, AIX6, SQL Server.

Confidential, Peoria, IL

DB2 Database Administrator

Responsibilities:

• Manage/Administer DB2 database instances. They are responsible for planning, implementing, maintaining 100s of enterprise level DB2 instances/databases.
• Install, maintain (fix apply or upgrade), configure, monitor, tune DB2 instances/DBs, diagnose problems, correct errors, manage security and backup/recover Databases.
• Run db2ckbkp utility to test the integrity of the backup image and check whether it can be restored
• Install and configure DB2 client on variety of application servers
• Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots
• Performed IBM migration from V9.1 to v10.5.
• Designed Database to utilize the Row Compression and built row compression for the Tables.
• Install and configure DB2 client on variety of application servers.
• Tune database and Database manager configuration for optimum performance.
• Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
• Stored procedure development and analysis for performance.
• Documented DB2 pureScale configuration topology and reviewed DB2pureScale Customer Worksheet and assist client team with completion of worksheet.
• Analyzed and monitored the entire system to pin point the performance bottlenecks using the tools like db2top, db2pd, vmstat and iostat.
• Remotely administer 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.
• Opened PMRs and SEV1 tickets with IBM DB2 problem determination teams when required.
• Highly involved in analyzing and tuning DB and DBM parameters, defining Registry variables for performance improvement

Environment: DB2 UDB 9.5/9.7/10.1/10.5.5 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM, pureScale.

Confidential, Atlanta, GA

DB2 Database Administrator

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.
• Install DB2 UDB on AIX. Created instances and databases on different servers and provided connectivity to development and production databases
• Determine project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of table spaces by setting up a threshold.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Work closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
• Create Range- partitioned Tables and specify ranges Creating Tables and Indexes.
• Tune database and Database manager configuration for optimum performance.
• Experimented with changing buffer pool and table space page size to improve time taken by ETL to build data marts.
• Planning and requesting needed resources to install both SAP and Non-SAP DB2 instances and/or databases.
• Opening SAP messages for issues and also opening connections for SAP.
• Creating EXPLAIN tables and running visual explain utility on SQL statements
• Created MDCs, MQTs and Replicated MQTs in the Data Warehouses and Marts for the optimal performance.
• Work heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central under high volume conditions to move data from Legacy systems.
• DB2 replication setup and administration experience.
• Performed memory management, tablespace management, space management, deep compression and database trouble shooting as and when required.
• Environment: DB2 UDB 9.5/9.7/10.1 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM, Quest Central, WAS server 6.0, Informatica, Q-rep,MQ.

Confidential, Philadelphia, PA

DB2 Database Administrator LUW

Responsibilities:

• Installed Product base codes and maintenance Fix Packs (full and alternate) and upgraded instances and databases regularly.
• Installed multiple DB2 copies on the same server to ensure the ability to run independent copies of DB2 products for different functions.
• Expertise in both In-place and side-by-side Migration of instances and databases.
• Expertise in Implementing LOGARCHMETH1, LOGARCHMETH2 & FAILARCHPATH to enable archival logging and Implications during recovery situations.
• Actively Monitored file systems for growth, added additional disk space for volume groups, created new file systems and allocate file systems to new databases.
• Used db2greg to remove DAS, DAS Service, Instance, DB2 service registry entries from Global Registry while uninstalling older versions of DB2.
• Proficiency in using SMIT for USERID/GROUP/FILE system administration.
• Opened PMR’s (Problem Management Request) to get the resolution from IBM and run db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis/resolution.
• Run db2mtrk to provide complete report of memory status, for instances, databases and agents.
• Run topas to check current CPU utilization, Memory usage and paging space.
• Installed and Upgraded DB2 Client on Servers/Workstations, Implemented DB2 Client on Desktops using SMS push and configured access to ODBC data-sources.
• Used the Design Advisor to migrate from a Single partition to a multi partition database, created table spaces and specified partition options for file import and bulk load target operators.
• Run the Design Advisor with the database partitioning feature specified for the db2advis command.
• Created and Monitored Users, authorities and responsibilities and password management.
• 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.
• Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORGCHK, REORG, REBIND, BACKUP, LOAD, PRUNING, TABLESPACE THRESHOLDS and other related to database activities and used cron for scheduling.
• Implemented Q-replication for High Availability.
• Worked extensively with restores, redirected restores and Unicode conversions.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Setup Federated Database environment between Databases by creating servers, wrappers, nicknames, User mappings and activated federated health indicators.
• Responsible for performance tuning, 24 x 7 support, analysis and resolution of database problems that occurs during the critical time processing.
• Environment: DB2 UDB 9.1/9.7 with DPF, AIX 5.3/6.1, Linux, Quest Central, BMC Tools, SQL Replication, ER/Studio, PureScale, DB2 Client, BMC Remedy,Q-rep,MQ.

Confidential

DB2 Database Administrator

Responsibilities:

• Manage production, staging, test and development DB2 UDB
• Migrate DB2 UDB databases on AIX from V8 to V9 and updated to a latest level by installing Fix Pack
• Assisted developers in creating stored procedures, functions, compiling and binding them to the database.
• Tuned databases using tools like snapshot monitor, visual explain, Index advisor, db2expln, db2exfmt etc
• Created multiple databases across different environments using Redirected Restore
• Developed scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS
• Regularly monitored databases for deadlocks, table spaces, long running queries using Snapshots and Event monitors
• Information transfer and mentoring on PureScale deployment standard and practices.
• Monitored database activity using BMC DBXray and setup threshold alarms using BMC Patrol
• Analyze, test and implement physical database design (including base definition, structure, documentation, requirements, operational guidelines) and supporting data warehousing applications
• Setup Replication between Operational Database and Reporting Database
• 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.
• Created multiple Buffer Pools for optimal performance and allocation of resources
• Configured database to enable I/O Parallelism and Intra-Parallelism for fast query retrieval and high performance
• Extensively worked with data movement utilities like import, export, load and db2move for data migration between databases
• Prepared backup and recovery strategies depending on SLA and implemented successfully
• Converted business process functions into user defined functions and procedures
• Provide on-call (24X7) support for all production databases

Environment: DB2 UDB 8.x/9.1, AIX 5.3, Linux, ERWIN 4.1,PureScale and Web Sphere 5.0

Confidential

DB2 Database Administrator

Responsibilities:

• Designed and Implemented Archival process to archive data from production to Archival database/on Demand.
• Created logical/physical data Model using Erwin for Archival Database and created the database with required DB objects for archiving Data from prod to Archival database/On Demand
• Analyzed the affected data for data warehousing reports
• Analyzed the objects to remove the dependency on other external databases
• Created Migration/Testing Strategy documents for UDB migration
• Analyzed the configuration for UDB databases like HEAPSORT, packages, locklist, etc.
• Analyzed all options for tables, Indexes, SQL Procedures, C procedures, Triggers, Views and migrated using IBM/Inbuilt tools from Mainframe ZOS to DB2 on Linux.
• Reference Data related Database Objects are identified and modified
• Created macros in Erwin for Triggers and History tables and reverse/forward engineered wherever required as a faster technique in migration
• Used federated data source in UDB procedures to access Sybase
• Performed Unit/Regression/System/Performance testing using IBM/Inbuilt tools
• Performance tuning of production database.
• Provide support for all prod environments and maintain the databases by running weekly maintenance jobs like REORG, RUNSTATS, and REORKCHK.
• Support for Database issues and set up database with data using load/Unload utilities in non prod Environment.
• Troubleshoot production issues
• Created best practices to follow daily, weekly, monthly to keep the database Health
• Created a new database model to store the production data statistics and database dictionary
• Environment: AIX 4.x and 5.x, Windows 2003 Advanced Servers, SYBASE, DB2 UDB V8.2 EEE and EE, UDB V8 ESE with DPF, Windows 2000, DB2 Connect Enterprise, DB2 utilities.