EXPERIENCE SUMMARY:

• About 07+ years of diversified experience in Design, Implementation and Production support for DB2 UDB Databases for OLTP & Data warehouse databases.
• Extensive experience on ESE Releases of DB2 V8,V9,V9.5,V9.7 &10.1
• Performed migration from versions V8.x to V9.x,V9.x to V10.1 fix packs.
• Extensive experience in carrying out DB2 Database Administration activities on AIX / LINUX involving development, database design, modeling and tuning, query optimization, back - up and recovery, space management and security maintenance.
• Proven ability to create, administer and migrate and effectively performance tune over 700 database / client servers on a 24X7 basis in a high availability environment.
• Thorough knowledge on maintaining data integrity and security in production and test databases.
• Worked with a wide range of utilities which includes BACKUP, RESTORE, RUNSTATS, REORGS, EXPORT, IMPORT and LOADS.
• Provided on call support (24X7) for all database issues on rotation basis.
• Extensive experience in DB2 Database and SQL Tuning.
• Involved in design, development and deployment of DB2 Stored Procedures and Functions to supplement translated procedures forLinux, UNIX and Windows platforms.
• Set up DB2 HADR with DB2HAICU/TSA to provide High Availability solution in AIX DB2 UDB environment.
• Extensively used DB2 V10.1 features like adaptive compression, Multi temperature storage, Ingest utility etc.
• Worked with third Party utilities and tools like QUEST tools,IBM data studio,BMC tools, Toad,Optim tools etc.
• Good experience in maintenance utilities such as BACKUP, RESTORE, RUNSTATS, REORGS, EXPORT, IMPORT and LOADS.
• Provided Assistance for database developers in tuning Complex sql using DB2EXPLN and DB2ADVIS.
• Implemented Database Partitioning, Table Partitioning and Archival logging in DB2 UDB.
• Experience in implementing Backup and Recovery Strategies with Tivoli Storage Manager(TSM).
• Performed workload management in enterprise warehouses using Query Patroller, WLM.
• Experience in Using iostat,vmstat,db2top,nmon to recognize the processes that degrade the performance of the server.
• Exposure to Third party tools such as QUEST CENTRAL, TOAD, FOG LIGHT and SPOT LIGHT, PERFORMANCE EXPERT.
• Experience in handling PMR’s with IBM support team.
• Good team player having good Communication and excellent Inter-personal skills and being able to work independently with minimal or no guidance.
• Open to training, accepts challenges in new areas, dedicated for excellent Performance, proven track records.

TECHNICAL SKILLS:

Operating Systems: z/OS, AIX, UNIX, Linux, Windows XP/Vista/7

Databases: DB2 UDB V8.1, V9.1, V9.5, V9.7, V10.1, Postgres, MySQL

Tools: Quest Central, Toad, Query patroller, Quest Optimizer, Control center, Command center, CLP, BMC Remedy, performance expert, WLM, Infosphere Change data capture, Optim Performance Manager, Data studio, OPTIM TOOL for LUW

Service Management Tools: HP service manager, Track

Scripting: Shell, Perl

PROFESSIONAL EXPERIENCE:

Confidential

DB2 LUW DBA on SAP Systems, SAP HANA DBA

Responsibilities:

• Responsible for the standards, design and implementation of the physical data storage, maintenance, access, security administration, performance and data integrity of assigned databases.
• Creating database schemas and sub-schemas to support the physical database model.
• Developing, monitoring, and maintaining backup and recovery for assigned databases to include the appropriate transaction logging.
• Directing junior team members in database creation, database backup and D/R processing.
• Working with application programmers, data analysts, business user personnel and project managers to develop the physical database design, make recommendations and design referential integrity.
• Developing data and user capacity requirements, developing user access requirements, and disaster recovery requirements.
• Writing Structured Query Language (SQL) code, stored procedures and other data access methods based on application requirements.
• Performing database performance monitoring and analysis and proactively implementing needed adjustments, including reorganizing database structures and data.
• Researching and/or developing utilities for monitoring and evaluating database performance.
• Working with other technical support groups to determine appropriate disk platforms, disk configuration, operating system kernel settings and database engine configurations.
• Working with application programmers, security administrators and network administrators to configure the appropriate user connectivity path and allocate the appropriate data security and user access roles.
• Providing support to application programmers through analysis, recommendations and data refreshes as requested for database access and performance problems.
• Maintaining documentation of backup and recovery procedures of the physical data storage and logical data design for assigned databases.
• Providing Database Security setup and maintenance for the protection of data.
• Working with and following design guideline for Multi-Dimensional Clustering in OLAP environments.
• Performing OS and Database tuning including resource and configuration of environmental and database identifying and remediation of performance bottlenecks and response times.

Confidential

DB2 LUW DBA

Responsibilities:

• Managing over 300 DB2 UDB databases on 585 servers and responsible for companywide migrations from V 9.x to V 10.x and all fix pack installations
• Installed DB2 UDB Fix Packs and special builds on DB2 UDB Database.
• Working closely with IBM thru PMR to resolve any issues
• Troubleshot day-to-day problems encountered on production, development and test database environment
• Installed an IBM developed special build to rectify high level usage of FCM buffers.
• Implemented Database Partitioning feature (DPF).
• Implemented range partition on the tables to enhance performance and automated roll in and roll out tasks
• Upgrading non-partitioned database to a partitioned database by creating new partitions to the existing database.
• Created multiple DB2 instances and Database for Testing & Evaluation for Production.
• Installed and Configured DB2 UDB Client to enable Remote access for applications and Remote administration for Database. Created DB2 connections through application areas to connect DB2 Database.
• Used db2autoconfigure option to do the initial configuration of the database and Instance parameters.
• User/Group creation and maintaining their permissions and authorities along with database security and password management.
• Configured database for optimal performance and developed backup and recovery strategies.
• Automated Pre-installation, Upgrade and Post-Installation activities using shell scripts.

Confidential

DB2 LUW DBA

Responsibilities:

• Physical design and creating database objects in DB2.
• Involved in day-to-day database administration and support for production, staging and Test environments.
• Deploying all the Database changes across all the environments.
• Maintaining data integrity and security.
• Deploying Stored Procedures in different environments.
• Involved in tunig, which includes making recommendations on code improvement on existing legacy system
• Involved in creating database Snapshots during the performance testing
• Coordinating with other groups while fixing the problem
• Providing on call support (24X7) for all database issues
• Physical Design and database Maintenance.
• Applying changes to the database based on the data model changes using DMCM ( Data Model Change Management )
• Set up and configuring DB2 HADR to provide High Availability solution in Linux DB2 UDB environment.
• Troubleshooting HADR disconnection issues and configuration issues.
• Written shell scripts to monitor HADR and its log gap timely.
• Recommend indexes for queries that run long and tune SQL queries using db2expln and db2advis.
• SQL and Q replication support activities
• Database & SQL Tuning

Confidential

DB2 LUW DBA

Responsibilities:

• Managing 100 DB2 UDB databases on 60 servers and responsible for companywide migrations from V 8x to V 9x and all fix pack installations
• Attending Change request meetings and analyze the database impacts
• Troubleshot day-to-day problems encountered on production, development and test database environment
• Planned and Implemented Backup Schedule strategy, Archive log strategy
• Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORGCHK,REORG, REBIND, BACKUP, LOAD, PRUNING, TABLESPACE THRESHOLDS, Partition Maintenance and other related to database activities and used Cron for scheduling.
• Refreshed various environments from production upon demand.
• Daily monitoring of Archive log files, database backup operation and health alerts along with space management for tablespaces and log files.
• Monitor the database for space utilization and increase the size of DMS tablespace by increasing the size of the containers and also by adding new containers.
• Recommend indexes for queries that run long and tune SQL queries using db2expln and db2advis.
• Working closely with IBM thru PMR to resolve any issues.
• Created tables in partitioned databases with appropriate partitioned keys.
• Capacity planning and monitoring the growth of databases.
• Implemented database federation between various DB2 systems. In this case implemented federation to integrate data between production and Non-Prod environments.
• Creation of Materialized query tables MQT’s.
• Implemented range partition on the tables to enhance performance.
• Extensively used hash partitioning, range partitioning, roll in and roll out data techniques
• Monitor the server for CPU, IO and page space utilization using native OS tools.
• Monitor the memory usage at Instance, Database, Application and agent level using db2mtrk utility and escalate if needed.
• Written shell scripts for automating DBA Maintenance jobs.
• Created documents for the best practices to follow daily, weekly, monthly to keep the database Health.
• Provide after hours on-call support for critical database issues.

Confidential

DB2 LUW DBA

Responsibilities:

• Involved in day-to-day database administration and support for production, staging, test and development
• Setup DB2 Connect to provide access to Mainframe data.
• DB2 Database creation and Object maintenance on AIX / LINUX servers.
• Cataloging Databases on Application servers.
• Modified the SQL scripts for tables and store procedures
• Coordinating with other groups while fixing the problem when site goes down
• Providing on call support (24X7) for all database issues
• Code Optimization & SQL Tuning
• Providing uninterrupted support for Critical Test Environments, Development and Disaster Recovery Systems.
• Daily monitoring of Archive log files, database backup operation and health alerts along with space management for tables paces and log files.
• Granting various Authorizations to different users/Groups.
• Determine need for DB2 UDB utilities (i.e. REORG, RUNSTATS) develop and implement to enhance performance.