SUMMARY

• Senior Database Administrator specialized in IBM DB2 UDB and Oracle with 9 years of experience.
• Experienced in ecommerce, Financial and Banking services.
• Well versed with DB2 LUW v 8.2/ 9.1/9.5/9.7/10.5 Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery and day - to-day database monitoring activities.
• Experienced in automation of database maintenance activities, upgrading DB2 versions and data migration among versions.
• Experience in HADR, clustering, Mirroring, Backup compression, work load manager, Auditing and Policy Based Management.
• Adept in using utilities like db2dart, Event Monitors, db2top, db2expln, db2exfmt, work load manager for monitoring database performances and Replication -
• Redirect restore, Q replication and SQL replication.
• Performance tuning of SQL queries using AppDynamics, Quest Central, ITM,Zabbix, Optim and query plans.
• Identify Potential risk and defects in the database systems/code, objects, processes and provide long term solutions.
• Experienced in schedulers like Control M and Crontab.

TECHNICAL SKILLS

Operating Systems: AIX 7/6.1/5.3, Solaris 5.8, Windows 2000, Windows XP/VISTA/7

Languages, Packages: Shell Scripting, AWK, SED, MS Visio, Lotus Notes, MS Office XP

DBMS: DB2 LUW (EE and EEE) v10.5,v9.7, v9.1, v8.2, Oracle 10g/11g, Netezza

Special Software/Tools: Toad and Quest Central, ER studio 9, BMC Patrol, IBM personal communication, IBM data studio, Data migratory tool, Visual Explain

PROFESSIONAL EXPERIENCE

Senior DB2 LUW Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Data Migration of v9.1 databases to v9.7.
• Design and implementation of high availability solutions.
• Installation and upgrade of databases to new fixpacks.
• Implementation of multiple databases required for the Lab testing using workload partitioning (WPARs) and logical partitioning (LPARs).
• Capacity planning for new OLTP databases required for the ARLM testing and support.
• Documentation for the Gold copy processes required as part of the replication and migration of databases.
• Trained offshore resources on DB2 v9.7 and project specifications.
• Automated multiple maintenance jobs in order to optimize database performance.
• Support and resolve incidents on production environment as per the SLAs and monitoring database performance testing of application loads/batches.
• Instance and database monitoring and tuning experience using the AppD,ITM,DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.

Environment: DB2 LUW V 9.1/9.5/9.7/10.5 (HADR), AIX 7, AppD, ITM, Zabbix, Optim

Senior DB2 Database Administrator

Confidential, Phoenix, AZ

Responsibilities:

• Database design, customization and administration of Web sphere provided tables, performed Data Modeling tasks and designed Entity Relationship Diagrams using ERstudio 9.
• Capacity planning and SAN estimation for OLTP and OLAP database environments.
• Owned administration and maintenance of high availability solutions e.g. Bi-directional Q replication and HADR.
• Tuned HADR through updates to OS, DB and TCP/IP parameters for improved performance.
• Involved in design meetings for new products/non-standard requirements which included design and implementation of star/snowflake schemas, Hash partitioning, Range partitioning, MDCs, MQTs.
• Setup db2 governor and WLM for controlling database resource usage and collecting statistics.
• Created and maintained system documentation of best database procedures, practices and standards.
• Conducted performance tuning on Shop Small (application for shopping at local small businesses) to drive response time down by 55% through use of DB2 utilities.
• Troubleshoot post migration issues related to backup, TSM, resource utilization, locking and various performance related bottlenecks for applications using OS and DB monitoring tools like nmon, topas, vmstat, CPU and I/O snapshots, DB2TOP, DB2PD and SQL snapshots etc.
• Mentored junior DBAs in the team on DB2 and Oracle concepts and helped them understand customer procedures and guidelines.

Environment: DB2 LUW V 8.1/9.1/9.5/9.7 (DPF/HADR), AIX, Solaris, Linux, Netezza(v7), BMC Patrol, Quest, Optim

Database Administrator

Confidential

Responsibilities:

• Instance and database creation and configuration (including auto-configure) in non-partitioned and partitioned database servers.
• Table and index design in EE and DPF environment for optimal performance.
• Performance tuning and optimization of poorly performing procedures and troubleshooting issues related to resource bottlenecks.
• Reviewed production database and dbm settings and provided recommendation for database configuration changes to improve performance.
• Creation and Administration of users, roles and assignment of profiles.
• Performed user managed backups, logical backups using export, import, datapump and RMAN backups.
• Assisted developers with the performance test initiatives. Performed index analysis and made recommendations to development teams.

Environment: Oracle 10g, DB2 UDB v8.2/v9.1 (DPF), Windows 2000, Lotus Notes, Visual Explain, OEM, solaris,, SQL/PL, ERstudio 9