SUMMARY

• More than 7 years of IT experience with database administration including design, development, implement and maintenance and support of databases using DB2 V8.x/ 9.1/9.5/ 9.7/10.1/10.5 on AIX, Linux, Solaris and Windows.
• 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 with third party tools like Quest Tools, IBM Data Studio, BMC Tools, DBArtisan, Toad, Performance Expert and Optim tools etc.
• Implemented MDCs, MQTs, Replicated MQTs and Statistical Views in the Data Warehouses and Marts for the optimal performance.
• Involved in the database and application design reviews and designed and built the physical database structures using the logical model.
• Experience on Database Partitioning Feature (DPF) for maintaining very large databases.
• Experienced in setting up the High Availability environments with HADR/HACMP between primary and standby servers
• Experienced in database administration tasks like Stored Procedures, Triggers, Referential Integrity and SQL tuning.
• Worked on database utilities including re - org, runstats, rebind, export, import, load, backup, restore and roll forward utilities.
• Extensive experience in writing Korn shell scripts to automate database maintenance activities.
• Experienced in working with IBM tech support by creating PMR’s to get the resolution from IBM and collect the db2support, DB2DART and db2trc for problem analysis and resolution.
• Proficient in scheduling/maintaining the jobs based on application requirement in the UNIX or other schedulers like Cron, Autosys and Control-M
• 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.
• Possessed the experience in leading and mentoring the team when required.

TECHNICAL SKILLS

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

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

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

ETL Tools: Informatica 8.6.1, SSIS, Datastage

Reporting Tools: Business Objects (BOXI R2), SSRS

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

Languages: Shell Scripting, DB2 SQL PL, T-SQL, SQL/PL, .NET, C

Modeling: Erwin, IBM InfoSphere Data Architect

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. 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 and created instances and databases on different servers and provided connectivity to development and production databases
• Experienced in analyzing and tuning DB and DBM parameters, defining Registry variables for performance improvement..
• Determine project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.
• Run db2ckbkp utility to test the integrity of the backup image and check whether it can be restored
• 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.
• Worked closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
• Created 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.
• Created EXPLAIN tables and running visual explain utility on SQL statements
• Created MQT tables to improve query performance and reduce the overhead of data maintenance operations.
• Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
• Worked heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central under high volume conditions to move data from Legacy systems.
• Developed scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS
• 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.

Environment: DB2 UDB 9.7/10.1/10.5 , AIX 6.1/7.1, Linux, ERWIN, ER/Studio, TSM, Quest Central, WAS server 6.0, Informatica

Confidential, San Antonio, TX

DB2 Database Administrator

Responsibilities:

• Providing the support for the databases, analyzing the database health and performance using the automated scripts and providing solution in case of any discrepancy.
• Providing the support for the application team by monitoring the databases during the new code releases and implementing the database level changes.
• Handling the capacity planning requirements for the production databases by procuring the minimum storage required.
• Monitored the performance by creating snapshots for slow running queries and analyzed the SQL access paths for checking the performance
• Coordinated with the system administrators regarding the OS patching maintenance tasks and DB2 installations and migrations activities.
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle.
• Experienced in benchmarking the performance of the complex queries using snapshots and administrative views.
• Working towards the service improvement tasks by automation and proactive monitoring
• Experienced in working on ETL batch jobs and troubleshooting the data movement issues.
• Worked with Application Owners and Developers for the functionality testing of the applications
• Create MQT tables to improve query performance and reduce the overhead of resource intensive aggregate operations.
• Setting up HADR environments on the DB2 servers using db2haicu and Tivoli System Automation on Multi-platforms.
• Remotely administered and supported the production databases 24/7. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.
• Opened multiple PMR tickets for the upgrade and performance issues and worked with the IBM support team for performance impacts and other issues

Environment: DB2 UDB 9.1/9.7 with DPF, AIX 5.3/6.1, Linux, Quest Central, BMC Tools, SQL Replication, ER/Studio, DBArtisan, DB2 Client, BMC Remedy

Confidential, Neenah, WI

DB2 Database Administrator

Responsibilities:

• Installed multiple DB2 copies on the same server to ensure the ability to run independent copies of DB2 products for different functions.
• Installed Product base codes and maintenance Fix Packs (full and alternate) and upgraded instances and databases regularly.
• 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.
• 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.
• 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.5/9.7 ESE, AIX 5.3, Linux, ERWIN, ER/Studio, TSM, Q-Replication, Quest Central, WAS server 6.0

Confidential

DB2 SQL 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

Environment: DB2 UDB V8.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