SUMMARY

• 7 years of IT experience with emphasis on Database Administration, development, migration, Business Requirements Analysis, Capacity Planning, Application design, testing, implementation and maintenance of databases using DB2 LUWon Linux, UNIX and Windows Platforms with strong business knowledge of Financial and Manufacturing projects.
• Worked through all phases of system/Software development life cycle (SDLC).
• Expertise in development support activities including installation, configuration and successful deployment of database schema and other changes across all environments.
• Experience in upgrading DB2 UDB databases and applying fixpacks to keep DB2at most recent level. Upgraded numerous databases from V8 toV9.1, V9.1 to V9.5, V9.7 and V9.7 to V10.1.
• Provided production support for critical applications running on 24/7 basis.
• Experience in implementing Backup and Recovery strategies using RTO (Recovery Time Objective) and RPO (Recovery Point Objective).
• Very good experience in running utilities like LOAD, IMPORT, EXPORT, DB2MOVE, INGEST, REORG, RUNSTATS, REBIND.
• Worked with third party tools like Tivoli Storage Manager (TSM), IBM OPTIM Performance Manager (OPM), BMC Change Manager, Toad and DB Artisan.
• Used SSISfor data migration and data cleansing.
• Experience in Database maintenance, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Proficient in writing Korn shell scripts for various kinds of administration and maintenance tasks.
• Familiar with ERWIN data model tools.
• Administration of databases, storage groups, tablespaces, tables, views, indexes and referential integrity.
• Experience with data warehousing and concepts of star schema, MDC, and Table Partitioning concepts.
• Worked on DPF Environment with database size of 20+ TB with 34 DB Partitions on 5 AIX servers.
• Knowledge of database configuration using Infosphere Balanced Warehouse concepts and IBM DB2 ISAS (IBM Smart Analytics System).
• Experience in setting up federation between DB2 and other RDBMS like Informix and Oracle databases.
• Knowledge of Purescale and HADR Environments.
• Experience with Range Partitioned tables, Multi - Dimensional Clustering Tables and Union ALL views.
• Experience with HADR. Experience with start HADR, stop HADR, TAKEOVER HADR Commands and also Monitored HADR status using db2pd and using database snapshot commands.
• Experience in using db2top, db2pd, SYSIBMADM views and other V9.7 table functions and MON GET functions.
• Very good experience with LINUX and UNIX (AIX and Solaris) operating systems.
• Managed database security, Creating and assigning appropriate roles and privileges to users depending on the user activity, setting up DB2 AUDIT and knowledge of Row and Column Access controls (RCAC).
• Knowledge of DB2 Work Load Management (WLM).
• Excellent analytical and functional skills with strong communication and interpersonal skills.
• Willing to learn and adapt to new challenges
• Good communication skills, self-motivated with a high degree of attention, a good Team Player, committed to work.
• Chaired various Implementation Project Kick-off, Status meetings and responsible for providing backlog and scrum update to product owner.
• Managed global team of size 20 plus in 24x7 environment and Escalation point for issues
• Supported managers in building, growing globally distributed teams, prioritizing and performing daily activities in respective regions by providing status reports to Senior management, providing feedback to employees
• Involved in Staff augmentation by conducting interviews and organizing in-house trainings at team
• Handle project budgets and client invoicing; Maintain detailed plan, outlook, and actual values to accurately track and report on project budgets by way of building and maintaining dash boards.

TECHNICAL SKILLS

RDBMS: DB2 LUW on 8.x,9.x and 10.x, SQL Server 2005 and 2008, Oracle

Database Tools: DB2 Data Studio, DB2 Connect, Fog Light and Spot Light, DB2 Governor and Query Patroller, DB2 Replication Center

Operating System: Microsoft Windows, Red Hat and SUSE Linux, IBM AIX, Solaris

Ticketing Tools: CA Global Service Desk, Remedy, Service Now, Heat

Languages: T-SQL, SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Consultant 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.
• 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.
• Participating in the design and model review calls for DB objects.
• Worked on new Application projects (New business dashboard, Choice Dashboard) and multiple maintenance projects
• Creation of DB objects like table spaces, tables, indexes, foreign keys as per client standards and their regular maintenance in partitioned and non-partitioned environments and migrating them from lower environments to Production.
• Regular database tuning activities during the initial phases of the project so as to improve throughput and meet SLAs.
• Worked on migrating multiple Databases from 9.7 to 10.5.4 in new DPF architecture using redirect restore and Admin move utility.
• Extensive usage of DB2 data movement utilities like export, import and cursor load to load/unload data in test regions, and load business data in production servers.
• 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.x and10x
• 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.
• Using software packages (e.g.,BMCPatrol) and/or local scripts, monitor performance, DB2UDB Data Warehouse database parameters and tune as required.
• 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.

Environment: DB2 9.x, 10.x, IBM Data Studio, Toad, Quest Central

Confidential, Jersey City, NJ

DB2 LUW/UDB DBA

Responsibilities:

• DB2 DBA on ISAS - DPF Linux 2.0 & DWH supporting Global Enterprise Data Warehouse.
• Involved in DB2 UDB support, Physical Database design, installations, security, integrity, Backup & Recovery.
• Migrated many databases from V9.1 FP5 to V9.7 FP3a (DPF), V9.7 FP8 to V10.1 (DPF).
• Managing project transition, client handling, POC, Training and setting up DBA team for DB2 with Teradata.
• Working on complete set-up of Data warehousing Tools like Appfluent, Informatica Repository etc. on DB2.
• Space allocation, new user set-up, Roles, Tools set-up etc. for Teradata 15 using Viewpoint, Teradata Studio,QL Assistant. Great understanding of Terata SQL Stored procedure, DDLs, DMLs, SMAs, etc.
• Strategic Incident Management planning, Change Management Planning, Major Incident outage, ITIL, Highly Reliable Organization Implementation ( HRO ), DB2 to Teradata Data Movement using DBSynch.Complete DB2 BLU Set-up and ure.
• Using ETL on HADOOP (1Petabyte) and Data Movement from HADOOP to DB2 using Pipe Loader.
• Provided DBA support for various applications on AIX and Linux.
• Designed and implemented the test cases for capacity testing.
• Tuned DBM, DB Configuration parameters and Registry variables for optimal database performance.
• Involved in database sizing estimates for the new projects in pipeline.
• Extensively worked with designing and developing optimal process for data extraction, transformation, loading, integrating data in warehouse Environment.
• Provide database size estimates at each stage of implementations and suggest solutions for optimizing ETL (Ab Initio) process.
• Extensively involved in data maintenance activities like REORG, RUNSTATS, LOAD, INGEST, IMPORT and EXPORT.
• Wrote many korn shell scripts for automating many manual tasks.
• Migrated the databases from existing IBM P 570 Servers to IBM P 770 Servers.
• Worked with the SAN administrators to design the physical storage.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Warehouse. Developed, deployed and monitoredSSISPackages
• Worked closely with Application teams in tuning SQL queries performing badly in terms of elapsed time and CPU and also implemented MQT's, Replicated MQT's, Statistical Views, created appropriate indexes and thus improved the performance of the queries.
• Created V9.7 Locking event Monitors for analysis of Lock-waits and deadlocks.
• Extensively used query tuning related tools like db2exfmt, db2advis and db2batch for improving query performance.
• Worked on Attaching and detaching table partitions for Range Partitioned tables.
• Implemented DDL and DML changes in the database using new features of V9.5/V9.7/V10.1.
• Worked with ETL teams to develop the patterns for data movements and loading data into Data warehouse environments.
• Migrated databases from one datacenter to another datacenter using redirected restores.

Environment: DB2 ISAS (9.7) LUW on Linux 2.0, 72 Physical Nodes, 22 Hosts, Dprop, DB2 BLU (10.5)

Confidential, Moline, IL

DB2 Midrange DBA

Responsibilities:

• Providing UDBDB2DBAsupport for many productions and testing environments.
• Checking the consistency of the databases using differentdb2commands
• Migration of databases from V8 to V9.5 FP1.
• Migration of Clients fromdb2V8.1 to V9.5 FP1 on Datastage (ETL) and Websphere (APPLICATION) servers
• Implemented UNION ALL views for improving the OLAP queries
• Worked on IBM Infosphere Federation server creating Nick names
• Wrote many korn Shell scripts to automate many of the day to day processes.
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold (70%).
• Creating and Monitoring Users, authorities and responsibilities and password management
• Creating, altering of the different types of tablespaces, bufferpools and creating schemas as per the user requirements.
• Created AIX Korn shell scripts to collect bufferpools and tablespaces utilization data on a regular basis to calculateDB2UDB and system performance trends.
• Created Problem Management Tickets (PMR) with IBM and solved numerous issues and even applied new patches.
• Created event monitors, snapshots analyzing the event monitor data for effective database tuning.
• Restored databases in between all the environments as per the requirement, till point in time recovery and to end of logs. Also implemented redirected restore using the V9 automatically generated restore script.
• Discussed with the development teams about the poorly performing queries and improved the performance of such long running queries.
• Monitored the BUFFERPOOL HIT RATIO on a regular basis and modified the bufferpool pages as necessarily.
• Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
• 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.
• Cataloging different databases on different servers.
• Designed and developedSSIS(ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Requested System Administrators for creation of new Volume groups and file systems for creating new database and Tablespaces in the designated way.
• Implemented INCREMENTAL BACKUP and RESTORE process in numerous Environments.
• Improved the performance of long running SQL's by taking the db2expln and visual explain, and analyzing the access plan and taking necessary steps based on the access path.

Environment: DB2 UDB EE V 8.1 fp14, V 9.5 fp1, V9.7 FP1, AIX (5.3), Solaris 10, TSM, Java, WebSphere 5.1.

Confidential

Database Administrator

Responsibilities:

• AdministrationDB2V9.5 databases onLUWplatform
• Developed and maintained production, test and developmentDB2UDB databases on AIX, Solaris and Windows.
• Created and maintained databases, table-spaces, tables, views, nicknames and indexes.
• Migration of databases from V8 to V9.5.
• Identify and tune long running SQLs
• Created new partitions for V9.5 Range partitioned tables using ATTACH PARTITION of ALTER TABLE Statement.
• Extensively involved in SQL Query Tuning including Decision Supporting Queries and Federated Queries and recommending SQL queries for better performance using snapshot monitor, index advisor, db2expln, db2exfmt.
• Implemented the database backups, restores and disaster recovery.
• Coordinated with business team and application teams for incorporating new functionality and implementing the updates.
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Generated reports of database statistics using DB2LOOK Utility.
• Recovered data to a prior point in time using ROLLFORWARD command.
• Developed logical and physical tables design using Erwin Data modeler.
• Identified and eliminated unused indexes in the databases Using DB2PD tool and improving the performance of the databases.
• Monitored databases using database monitors, snapshot monitoring and event monitoring.
• Granting and revoking the access to users and groups on the database and database objects.
• Assisted application teams with allDB2issues and questions during ON and OFF peak hours.

Environment: DB2 for LUW 8.x, 9.x, AIX, Linux

Confidential

Software Engineer

Responsibilities:

• 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 8.x, 9.x, AIX, Linux