SUMMARY

• Around 9 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 V8.x/9.1/9.5/9.7 on AIX, Redhat Linux, Unix, Solaris, DB2 LUW, HP - UX, LDAP, HANA and Windows.
• Migrated or upgraded DB2 UDB and DB2 HADR 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 Toad and Quest Tools, IBM Data Studio, BMC Tools and Optim tools etc.
• Experienced in database administration tasks like SQL coding, SQL servers, 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 8.x/ 9.1/9.5/9.7/10.1 , BMC IMS, Oracle, SQL Server 2000/2005/2008

Operating Systems: AIX 5.3, 5.L, 6.1, Linux, Solaris, HP-UX, Windows XP/NT

Utilities/Tools: db2top, db2pd, db2batch, DB2 Performance Expert, Quest Central, Spotlight, BMC Patrol, IBM Query Patroller, TOAD, DB2 Connect, Event Monitor, Snapshot Monitor, TSM, Control-M, Data Propagator (DProp), Replication Center, IBM Optim ToolsSource Control Manage Now, Rational ClearCase, MS VSS, SVN

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

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, Cincinnati OH

Sr. DB2 UDB 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.
• Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks
• Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes).
• Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers and experience with Software Development Life Cycle
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Evaluated and examined disk space allocation in PROD environments on an ongoing basis to ensure sufficient disk space to cover the size increase of PROD/DR databases.
• Install and configure DB2 UDB new releases, upgrades, and patches.
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases
• Prepared test environments and performed data refresh
• Designed, debugged and implemented stored procedures and triggers
• Involved in capacity planning and storage management along with the system administrator.
• Proactively monitored and performed daily maintenance activities
• Development, performance monitoring and tuning for UDB 9.1
• Provide onsite support for all database administration work that has been handed over to offshore team
• Perform database software installations including and database creation and configuration
• Database Backup/Recovery of databases, including Redirected Restore.
• Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions
• Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
• Implement and test HADR performance for production environments.
• Taking Snapshots and gathering other information related to the database and the system during stress tests or performance tuning
• 24X7 on-call support and problem resolution.

Confidential, Northbrook, IL

Sr. DB2 UDB Database Administrator

Responsibilities:

• Providing the support for the critical databases, analyzing the database health and performance using the automated scripts and providing solution in case of any discrepancy.
• Installed DB2 UDB 9.1 with FixPak on AIX. Created new instances and databases. Worked with Unix team to upgrade AIX release level.
• 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
• Coordinating with offshore and client Onsite SMEs thru the weekly meetings on the new tasks and activities
• Coordinated with the system administrators regarding the OS patching maintenance tasks and DB2 installations and migrations activities.
• Experienced in benchmarking the performance of the complex queries using snapshots and administrative views.
• Hands on Experience in disk management and performance tuning
• Knowledge of Data Studio, DB2TOP, DB2PD, Monitor Traces knowledge and DB2 Pure Scale high
• Hands on experience in setting up backup and recovery strategies using legato NMDA and SRDF
• Working towards the service improvement tasks by automation and proactive monitoring
• Experienced in working on ETL batch jobs and troubleshooting the data movement issues.
• Experience working in DB2 Performance Expert
• 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 IBM 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.5/9.7 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM,Q-Replication, Quest Central, WAS server 6.0, Informatica

Confidential, Neenah, WI

Sr. DB2 UDB Database Administrator

Responsibilities:

• Install DB2 UDB on AIX. Created instances and databases on different servers and provided connectivity to development and production databases
• Initiated and executed maintenance schedules for production performance monitoring
• Seamlessly instituted new IMS Databases and DB2 Table
• Proactively participated in DR exercises
• Gave application support and facilitated training to the Development Group
• Provided on-call support in collaboration with operation's staff
• Create stored procedures, functions which cannot be migrated using MTK and compile, bind them to the databases.
• 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.
• Work closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
• 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.
• Create 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.
• Work heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central under high volume conditions to move data from Legacy systems.
• Develop 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.
• Create and Configure alerts, define counters and thresholds for alerts.

Environment: DB2 UDB 9.5/9.7 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM,Q-Replication, Quest Central, WAS server 6.0, Informatica

Confidential, Auburn Hills, MI

Sr. DB2 UDB Database Administrator

Responsibilities:

• Responsibilities include installation, performance monitoring and tuning, troubleshooting DB2 UDB/AIX databases, using Visual Explain, event monitors, snapshots, setting DB2 configuration parameters to maximize performance, backups, and reorgs etc. Assist Very large operational environment where I am part of a team responsible for day to day support of databases in a high volume mission critical environment.
• 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 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.
• 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 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.
• Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
• 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.
• 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 8.x/9.1 with DPF, AIX 5.3, Linux, Quest Central, BMC Tools, Q-Replication, SQL Replication, ER/Studio, DBArtisan, WSFS, DB2 Client, BMC Remedy

Confidential, Dublin, OH

DB2 Database Administrator

Responsibilities:

• Manage production, staging, test and development DB2 UDB
• Migrate DB2 UDB databases on AIX from V7 to V8 and updated to a latest level by installing Fix Pack
• 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
• 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
• 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.1 Fix Pack 9a, AIX 5.2, Linux, ERWIN 4.1 and Web Sphere 5.0

Confidential, Chicago, IL

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.
• 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 V7.2 EEE and EE, UDB V8 ESE with DPF, Windows 2000, DB2 Connect Enterprise, DB2 utilities.

Confidential

DB2 SQL PL Developer

Responsibilites:

• 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 V8.x, DB2 Connect, DB2/ZOS, 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