SUMMARY:

• Over 7 years of professional and progressive experience in IBM DB2 UDB with emphasis on Database Administration, development, migration, Business Requirement Analysis, Application design, testing, implementation and production support of critical OLTP, OLAP and Data warehouse environments.
• IBM Certified Advanced Database Administrator on DB2 V9.7 has undertaken several IBM DB2 training courses and has worked through all phases of system development life cycle.
• Expertise in configuring 2-node, 3-node HADR setup with TSA using different tie-breakers from scratch to Production implementation.
• 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 collecting, analyzing and performing system level tuning of databases.
• 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
• Extensive experience with Incident, Problem and Change managements.
• 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

EDUCATION:

• Bachelor of Engineering

IBM DB2 TRAINING COURSES

DB2 CERTIFICATIONS

TECHNICAL SKILLS:

• RDBMS: DB2 LUW V9.7, V9.5, V9.1, V8.2, V8.1, V7, SQL Server, Oracle, MS Access.
• Database Tools: Websphere Federation Server, Information Integrator, Data Joiner, DB2 Connect, Tivoli System Automation for Multiplatforms, IBM Data Server client, IBM Data studio, Quest Tools, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, svmon, Veritas Netbackup, BMC Patrol, Erwin, Power Designer, DB Artisan, TSM, Wireshark, and Veritas.
• Operating System: AIX 6.1/5.3/5.x/4.3.x, Solaris 2.6/2.7/8, RH Linux Advanced Server 2.1, 3.0, Windows 2000/ NT 4.0, Windows 95
• Programming and Scripting Languages: Shell Scripting, Perl Scripting, AWK, SED, SQL, Visual Basic, C, C++
• ETL, and Other Softwares: Data Staging, Informatica V8.1/7.1, Abinitio 2.15/2.14, Data mirror Transformation Server, QMF
• Business Intelligence Tools: Crystal Reports, Cognos, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential,Moline, IL (April ’08 – Till Date)
Sr.DB2 LUW DBA

Confidential,is the leading manufacturer of agricultural machinery in the world. The company is also a leading supplier of construction, forestry and turf care equipment.

I supported both data warehouse of 15+ TB size and also OLTP databases along with a team of five. I have supported production, certification, test and development environments.

• Design, Architecture and support of HADR for mission critical applications using DB2 HADR with TSA. This includes design of 2 node cluster with NFS tiebreaker and 3 node cluster with a 3rd node arbitrator.
• Subject Matter Expert for DB2 HADR.
• Installation, administration and 24/7 production support for OLTP and Data warehousing databases.
• Design and implementation of star/snowflake schemas, Hash partitioning, Range partitioning, MDCs, MQTs as part of data warehouse implementation.
• Installations, In-place and Side-by-Side Migrations of DB2 ESE and DPF databases.
• Installation, Migration and administration of DB2 Websphere Federation Server (Information Integrator) which is used to access data sources Oracle, MS SQL Server,

Sybase etc and DB2 Connect gateways used to access DB2 ZOS Subsystems.

• Developed database performance matrix and use them to evaluate database performance and implemented advanced performance tuning strategies for databases based on the workload.
• Analyze complex and long running SQL queries using Visual explain and other tools and optimize them using Design advisor and other tools.
• Extensively worked with ETL teams in fixing data issues and handling monthly data purges.
• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries.
• Wrote and implemented shell scripts to remove archived logs and backups older than specified days from disk after comparing with the tape, collect top users of CPU, memory and paging space, audit volume groups for disk space and alert if falls under a threshold, force applications idle than specified time on gateways and so on.
• Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools.
• Worked Extensively with System and storage administrator to gather and understand collected performance stats info and tune the database server accordingly.
• Implementation of DB2 STMM in OLTP Environment which provides the ability to DB2 to tune most memory related parameters itself.
• Develop backup and recovery solutions for databases especially very large databases depending on their RTO and RPO.
• Implemented usage of SAN Media Server for Very large database backups/restores.
• Provide guidance and support to application developers on DB2 best practices during application development.
• Extend File systems and volume groups per requirement.
• Applying Fixpaks to keep DB2 at the most current level.
• 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.
• Configured LDAP for authentication on various environments.
• Opened several SEV1 PMRs with IBM to troubleshoot and resolve critical issues.

ENVIRONMENT: DB2 ESE 9.7/9.5/9.1, DB2 UDB DPF 9.5/9.1, SAN Media Server, HADR, TSAMP, Websphere Federation Server V9.5, DB2 Connect, BMC Patrol, NAS, Informatica, Wireshark

Confidential,Windsor, CT (June ’07 – April ’08)
DB2 UDB DBA

Description:
Confidential,offer a comprehensive array of financial services to retail and institutional clients, which includes annuities, retirement plans, life insurance, mutual funds, managed accounts, alternative investments, direct banking, institutional investment management, employee benefits, financial planning, and reinsurance.

I supported data warehouse of 12+ TB size along with a team of six. I have supported Production, Acceptance, QA and development environment.

• Worked on installation of different versions of DB2 UDB on AIX 5.3
• Apply fix packs, monitor IBM maintenance releases and communicate them to business.
• Developed scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, I/O, Disk Space, and Projected utilization based on future business requirements.
• Developed database security strategy to provide access to large number of users in production environment.
• Generated and implemented DDL for several projects from the logical model using Erwin Data modeling.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
• Involved in ETL design, architecture, and performance tuning including load strategies.
• Created, maintained, and monitored onsite archive, recovery and data retention strategy for all databases servers. Create, maintain, and monitor backup jobs; Ensure backup jobs are able to support of documented SLAs. Maintain archival strategy, logging strategy for point in time recovery.
• Coordinating with the development team for coding static SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analyzing with SQL Visual Explains output.
• Maintain documentation of database infrastructure and software assets.
• Provided 24X7 on call support for production servers.

ENVIRONMENT: DB2 EE/EEE V 9.1, 8.x, 7.x, Web sphere, Solaris, AIX 5.3, Informatica Power Center, SAN, Clustered Environment, Information Integrator V8, Quest Central and HADR.

Confidential,Boston, MA (Feb ’07 to June ’07)
DB2 UDB DBA

Confidential,will be transferring its current trade processing, settlement instruction and reconciliation processing to IBT. This Processing will be both for custody and non-custody accounts. The objective of this project is to seamlessly migrate the newly acquired Eaton Vance middle and back office processing to IBT.
Responsibilities:

• Developed and maintained production, staging, test and development V 8.2 DB2 UDB ESE databases on AIX, Solaris and Windows
• 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
• Creating and Monitoring Users, authorities and responsibilities and password management
• Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities
• Monitored and managed disk space, I/O contention
• Setup Replication between Operational Database and Reporting Database
• Designed and implemented backup and restore procedures
• Monitored databases using database monitors, snapshot monitoring and event monitoring
• Generated reports of database structure using DB2LOOK Utility
• Recovered data to a prior point in time using ROLLFORWARD command
• Implementing capacity planning and partition table/index for very large and fast growing tables
• Experienced in writing SQL queries, Packages and triggers.
• Coordinating with the development team for coding static SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analyzing with SQL Visual Explains output.
• Tuned application, database and system for best performance
• Day-to-day attending to the user queries in sorting out database problems
• Coordinating with user departments and attending their requirements for smooth functioning
• Developed document that provides an overview of the physical and logical design of the database environment implemented for IBM internal projects.
• Upgraded instances regularly with latest fixpaks and alternate fixpaks
• Worked extensively with restores, redirected restores and Unicode conversions
• Setup and monitored replication between operational database and reporting database

ENVIRONMENT: DB2 UDB EEE V 8.x, 7.x, AIX 4.3, Solaris, Windows Clustered Server 5.0, Dprop, TSM, BMC Patrol

Confidential,Dedham, MA (May ‘06 – Feb ‘07)
DB2 UDB DBA
Description: Confidential,the operations of a group of affiliated regional property/causality insurers and provides processing services for other companies.
I supported data warehouse of 4+ TB size along with a team of four. I have supported production, test, and development environment.

Responsibilities:

• Worked on installation of different versions of DB2 UDB on AIX 5.
• Worked on installation of Query Patroller, Profile setup in QP, defining classes, managing queries and collecting statistics using QP.
• Apply fixpacks, monitor IBM maintenance releases and communicate them to business.
• Developed scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, I/O, Disk Space, and Projected utilization based on future business requirements.
• Developed database security strategy to provide access to large number of users in production environment.
• Generated and implemented DDL for several projects from the logical model using Erwin Data modeling.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
• Involved in ETL design, architecture, and performance tuning including load strategies.
• Created, maintained, and monitored onsite archive, recovery and data retention strategy for all databases servers. Create, maintain, and monitor backup jobs; Ensure backup jobs are able to support of documented SLAs. Maintain archival strategy, logging strategy for point in time recovery.
• Coordinating with the development team for coding static SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. Has experience working and analyzing with SQL Visual Explains output.
• Maintain documentation of database infrastructure and software assets.
• Provided 24X7 on call support for production servers.

ENVIRONMENT: DB2 EEE V 7.1, Web sphere, AIX 5.1, Informatica Power Center, windows NT/XP, Server, Power Builder, SAN, Clustered Environment, and HADR.

Confidential,Hyderabad (Feb ‘04 to May ‘06)
Data Analyst
Confidential,is a website hosting company located in Hyderabad, India. They provide Internet based end-to-end solutions that enable small and medium sized enterprises to build, promote, manage and profit from their online presence.

Responsibilities:

• Created and maintained documentations such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects
• Involved in gathering requirements to develop PL/SQL procedures, triggers, and functions for an instant messaging applications.
• Developed and tested PL/SQL packages, procedures and triggers to support web based application.
• Developed SQL scripts to test procedures using SQL.
• Responsible for documentation for all procedures.
• Provide modifications and enhancements to the procedures as necessary.
• Involved in Writing of SQL queries for posting and retrieving of data from database.

ENVIRONMENT: DB2 UDB, Oracle 8i, Solaris, PL/SQL, HTML, Rational Rose, SQL Navigator4.5, MS-EXCEL, MS-WORD