SUMMARY

• Over 10.5 years of professional experience in Confidential DB2 LUW UDB with emphasis on Database Administration, Migration, Business Requirement Analysis, Application design, Testing, Implementation and Production support of critical OLTP, OLAP and Data warehouse environments.
• Confidential Certified Database Administrator on DB2 V9.1 and worked through all phases of system development life cycle.
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments.
• Extensive experience in logical and physical design of databases, performance tuning, database utilities, backup and recovery strategies, capacity planning, high availability, disaster recovery, database monitoring, troubleshooting, change and problem management and production support on 24/7 basis.
• Expertise in Deep Compression and Table Partitioning.
• Experience in resolving various database issues and bottlenecks by working directly with DB2 Development team.
• Extensive DB2 Connect, Websphere Federation Server experience with activities involving configuration and maintenance of wrappers, server definitions, user mappings and nicknames.
• Expertise in configuring HADR setup with TSA.
• Experience with Confidential DB2 Administration, Automation, Table Editor, SQL Performance Analyzer, Log Analysis, Query Monitor.
• Excellent knowledge of Database backup and recovery of very large databases, typically multi terabytes.
• Expert level troubleshooting knowledge of data warehouse type UDB databases.
• Expert level of performance and tuning skills related to UDB EEE/DPF databases.
• Excellent knowledge of UDB database/instance tuning, optimizing complex SQL statements for best possible performance. users on database methodologies. Responsible for refining the 'logical design' so that it can be translated into a specific data model and further refining the 'physical design' to meet system storage requirements. Planning data flows for a new or revised database.
• Extensive experience with Incident, Problem and Change managements.
• Extensive experience in writing database documentations including data standards, procedures and definitions for the data dictionary.
• Coordinate patch implementation and post patch testing/validation.
• Design a robust monitoring and event notification system utilizing existing monitoring software.
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges.

TECHNICAL SKILLS

RDBMS: DB2 LUW V8.2, V9.1, V9.5, V9.7. V10.1, V10.5, SQL Server 2005, Oracle 11g

Database Tools: DB2 Connect, Confidential Data Server client, Confidential Data studio, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, DB Artisan, TSM, db2haicu.

Programming/Scripting Languages: Shell Scripting, Perl Scripting, SQL

Operating Systems: AIX, RH Linux Advanced Server, Windows

PROFESSIONAL EXPERIENCE

Sr Consultant, DB2 UDB DBA

Confidential, Irving, TX

Responsibilities:

• Supporting DB2 UDB, Oracle and SQL server databases in data warehouse environment in Production, QA and development environments.
• Installing and setting up large databases on DPF (Database Partitioning Feature) environment.
• Installation, administration and 24/7 production support for OLTP and Data warehousing databases.
• In - Place and Side by Side Migration of DB2 UDB databases from V8.2 to V9.7 and V9.1 to V9.7 version databases.
• Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools.
• Develop backup and recovery solutions for databases especially very large databases depending on their RTO and RPO.
• Provide guidance and support to application developers on DB2 best practices during application development.
• Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.
• Performed Reorgchk, Reorg, Runstats and rebind as and when necessary to eliminate the defragmentation.
• Apply fix packs on quarterly basis on all regions of servers, monitor Confidential maintenance releases and communicate them to business.
• Designed and implemented backup and restore procedures.
• Coordinating with UNIX and Storage teams in Disaster Recovery exercises.
• Direct and Redirect Restore of databases on Single and Multi-partitioned database environments.
• Setting up HADR / TSA with db2haicu utility on V9.7 version.
• Worked with UNIX team in setting up HACMP environment for database servers.
• Recovery of database to PIT, EOF logs/ backup.
• Capacity planning and partition table/index for very large and fast growing tables.
• Coordinating with Business and Management to get downtime windows towards Enhanced application performance by running REORG and Runstats.
• Monitored databases using database monitors, snapshot monitoring and event monitoring. Generated reports of database structure using DB2LOOK.
• Created UDB instances and Databases in development environments. Provided full DBA supports during application life cycle, including database change requests and business processes analysis. Worked on database release changes and supported migration of release changes from test environments to pre-production and production environment
• Setting up Federated environment between DB2 UDB and Mainframe databases and DB2 UDB V9.7 and ORACLE 11g databases.
• Experience in problem analysis and troubleshooting database related issues. Provide performance tuning support to development teams in SQL Tuning and application monitoring.
• Monitoring db health, backup status and other basics db administration with SQL-server 2005 and Oracle 10g and 11g databases.

Sr. Consultant, DB2 UDB DBA

Confidential, Providence, RI

Responsibilities:

• Supported both data warehouse and OLTP databases in Production, Test and Development environments.
• Designed and implemented backup and restore procedures.
• Direct and Redirect Restore of databases.
• Extensively worked with ETL teams in fixing data issues and handling monthly data purges.
• Capacity planning for DPF databases of size 15TB.
• Converting Tablespaces from Regular to Large.
• Partition table/index for very large and fast growing tables
• Supported both data warehouse of 15+ TB size with DPF feature with 27 data partitions (3 Physical and 8 logical partitions on each server).
• Also supported OLTP databases along with a team of five. I have supported production, test and development environments.
• As part of DR test performed Restore of 15 TB database in DPF environment.
• 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.
• Created shell scripts to monitor file system/tablespaces usage and automatically notify DBA of database performance problems, resulting in increase of database availability.
• Created various shell scripts to automate database maintenance such as reorg/runstats and backup/restore/snapshot monitors.
• Performed Load, Import and Export Utilities.
• Performed backup and restore functions using TSM. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems.
• Worked on Table partitioning feature of DB2 V9.7 version for OLTP environment and improved performance of the queries.
• Provided full DBA supports during application life cycle, including database change requests and business processes analysis. Worked on database release changes and supported migration of release changes from test environments to QA and Production environment.

System Software Engineer

Confidential

Responsibilities:

• Worked on installation of different versions of DB2 UDB on AIX, Linux, Solaris, Windows
• Apply fix packs, monitor Confidential maintenance releases and communicate them to business.
• Installations, In-place and Side-by-Side Migrations of DB2 ESE.
• Wrote and implemented shell scripts to remove archived logs and backups older than specified days from disk after comparing with the tape.
• As part of FVT team wrote and implemented scripts to test functionality of Online Table Move and Schema Evolution features of DB2 V9.7 version.
• Applying Fixpacks to keep DB2 at the most current level.
• Analyze complex and long running SQL queries using Visual explain and other tools and optimize them using Design advisor and other tools
• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries.
• Developed a Tool that reads set of similar test cases and prepares Response file for Silent Install of DB2 and provides report of Testcases on various versions of supported UNIX/ Linux platforms.
• Managing DB2 UDB databases on 30 Unix servers, sizes up to a few hundreds GBytes. Troubleshoot all database related problems.
• Assisted developers with the performance test initiatives. Performed index analysis and made recommendations to development teams.
• Created UDB instances and Databases for both v8.2 and v9.x in Engineering, Test, QA, DR and PRODUCTION environments.
• Participated in IDUG Bangalore 2009 and gave presentation on Schema Evolution and Online Table Move features of DB2 V9.7.
• Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyze and make changes in the database.
• As maintenance activity performing Online and Offline Reorg on databases. Scheduling Weekly Runstats on tables to improve performance of queries on OLTP db tables.
• Setting up Federated environment between DB2 UDB and Mainframe databases.
• Be ON CALL and provide maintenance support for the production databases