SUMMARY

• Over 9+ years of IT experience as a Database Architect primarily in the Database Administration, Management, Design, Modeling and Maintenance and support of IBM I, DB2 UDB EE/EEE databases on AIX, Sun Solaris, HP - UX and Windows NT/2000 environments.
• Extensive database experience using DB2 UDB ESE /8.x/9.x on UNIX (Solaris, Linux), DB2 on OS/400. Strong experience in Database Administration, Architecture, and Data Modeler.
• Extensive experience in Database design, Data analysis, development, performance tuning, monitoring and application support.
• Expert in installation, configuration, upgrades and database design (both physical and logical).
• Done large implementations of OLAP environments using DB2 DWE, to facilitate report generation of DB2 queries for the Business Intelligence teams. Strong working experience with SAP environment.

TECHNICAL SKILLS

OS: -AIX 6.1/5.3/4.3, Solaris 2.8/2.7, OS/400 Linux 8.x/7.x and Windows Servers (NT 4.0, 2000, 2003)

RDBMS: DB2 V9.7,V9.5, V8.2 ESE, EEE and all Earlier Versions DB2/400, DB2,Oracle /9i/10g.

Languages: C,C++,JAVA, and PL/SQL, T-SQL.

Tools: Command line Processor, DB2 Development Workbench, Visual Explain, Health Center, Design Adviser, Stored Procedure Builder, DPROPR, Configuration advisor, DB2 Utilities, DB2 Connect, INAV,I-Doctor,TAATOOL,MIMIX,Control Center,Query Patroller, Business Objects, Cognos, Crystal Reports, Erwin, BMC,, SQL*Loader, Export/Import, Server Manager, Quest Central, Veritas Volume Manager, ER/Studio and Qrep.

Application Servers: IBM Web Sphere and Web Logic Web Servers IIS, Apache HTTP Server.

PROFESSIONAL EXPERIENCE

Confidential, Columbus

DB2 Data Base Administrator

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 on Linux operating systems and Data Server Client.
• Developed, managed and monitored databases on Production, Testing and Development environments.
• Build new instances and database for new KANA project test and Prod environments.
• Used db2look, db2move, import/export and load utilities to move structure and data between different environments.
• Performed troubleshooting and provided problem resolution of database issues.
• Wrote shell scripts to take Backup and also to do Runstats and Reorg on the tables and indexes.
• Supported High Availability in Production and Quality Analyst Testing Environment through Failover Schemes
• Used DB2/UDB Snapshot and Event monitors to monitor the database for application performance.
• Worked closely with development and testing teams and Unix Administrator.
• Worked with IBM Support (PMR) to resolve database issues and communicated with them to resolve database and SQL performance issues.
• Worked with our database team to find a way to maintain proactively all the major databases, and cutting down the performance issue more than 20% .
• Represent the database team on numerous customer project engagements as a subject matter expert (SME).
• Responsible for Audit inquiries, manage risk, and pro-actively manage security exposures.
• Responsible for documenting deployment and operational standards.
• Plan, document and implement database based infrastructure changes.
• Provided On call Support 24/7 to ensure the database is good and also supported project related work during the weekends for Dev, UAT, Prod and DR environments.

Environment: DB2 v9.7.0.3,HADR,OPM, Qrep, UNIX Shell Scripts (Ksh).

Confidential, San Jose

DB2 Data Base Administrator

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 and V8.2 on Linux operating systems for the Upgrade project from V8.2 to V9.7 fp5
• Created best practices to follow daily, weekly, monthly to keep up the database Health.
• Provide support for all 12 non prod and prod environments and also maintain the databases by running weekly maintenance jobs like REORG, RUNSTATS, and REORKCHK.
• Created AIX Korn shall scripts to collect bufferpools and tablespaces utilization data on a regular basis to calculate DB2 UDB and system performance trends.
• Physical Database design for optimum performance including tablespaces (tables/indexes) and log spaces design & implementation.
• Created AIX Korn shell scripts to collect production databases comparative resource utilization metrics on DB2 V.8.2 and DB2 V.9.7 environment.
• Worked with application team closely to change the database manager setting on DB2 V.9.7 to get the optimal output for their application transaction query after migration.

Environment: DB2 Enterprise Server Edition V9.7 & V8.2, Quest Central, Dbvisualizer,DB2 Connect, QMF for Windows 8.2, UNIX Shell Scripts (Ksh),SAP.

Confidential, PA

IBM DB2 Data Base Administrator

Responsibilities:

• Installed DB2 Enterprise Server Edition V9.7 on Linux and created new instances and database .
• Coordinated with vendor support to apply database patches.
• Created AIX Korn shell scripts to collect production databases comparative resource utilization metrics on DB2 V.9.7 environment..
• Backup & Recovery procedures Design, Test & implementation using Shell Scripts & SQL.
• Rewrite all the broken Backup & Restore shell Scripts & SQL.
• Cleaned up Transaction log as and when needed.
• Perform daily db2 operations according to the business requirements.

Environment: DB2 V9.7, Quest Central, Dbvisualizer,DB2 Connect, UNIX Shell Scripts (Ksh).

Confidential, FL

IBM i DB2 Data Base Administrator

Responsibilities:

• Total responsibility for managing DB2 vldb production, test, and staging environments for high profile IBM client in the capacity of IBM WW DBA Solutions Center client- dedicated DBA team technical lead.
• Disney DB2 assets managed include production (400tb), DR (500tb), HA (500tb) and subordinate environments used for testing and staging activities.
• Total responsibility for managing 4- member dedicated team resources. Shared responsibility for routine database maintenance and 24/7 on- call support within team paradigm.
• Routine tasks include database schema, tables, indexes, stored procedures, journaling, and authority management.
• Diagnose and resolve database performance issues in real time.
• Key contributor for Disaster Recovery process testing and validation.
• Coordinating performance agendas with client, scheduling implementations per systems and resource availability.
• Worked on multiple data refresh and application rollouts for new Property Management System.
• Involved with the Vision Mimix replication team and went through 7006 MIMIX Admin training to perform various tasks on OS V6R1 and OS V5R4.
• Demonstrated leadership and technical competency in over 24 months on the account.

Environment: DB2 for i5/OS- V7R1,V6R1,V5R4 INAV,I-Doctor,TAATOOL,MIMIX,SAP.

Confidential, TX

Sr. DBA

Responsibilities:

• Write design specifications, security plans, data migration plans, and Architecture guidelines..
• Data migration from DB2 on i5/OS. V.5.3.0, to Oracle 10g R2.
• Data formatting, transformation of DDL/SQL in DB2 on i5/OS. V.5.3.0, to Oracle 10g R2.
• Generated ERDs for the database using ER/Studio.
• Optimize SQL statements automatically through SQL rewrite and indexing by using Toad.
• Manage database storage in Oracle.
• Used SQL*Plus to execute command and interact with the oracle database.
• Logical Design and Physical Design of the database.

Environment: V5R4 V5R3,iSeries Navigator, Job Watcher, Pex Analyzer, Heap analyzer, Oracle 10g R2, SQL*Loader, Content Manager, ER/Studio, SQL*Plus, Toad.

Confidential, Herndon, VA

Responsibilities:

• Responsible for Analysis, design, creation, implementation of database.
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) .
• Database maintenance for development, and synchronizing it with the production database.
• Implementation of Database Clean up script on database for automated clean up every two weeks.
• Have done data load, and updating of the underlying table well within one hour for 2,800,000 rows.

Environment: UNIX (AIX), DB2 V7&V8, Data Warehouse, Erwin, (DpropR), DBArtisan.

Confidential, Boston, MA

DBA

Responsibilities:

• Performed Overall Database Management and Quality Assurance.
• Data Architecture, Data Modeling, getting specifications from business analysts and Marketing groups
• Setup and modified database manager configuration parameters and database configuration parameters.
• Performed Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Maintained Instances, databases, table spaces, in DB2UDB for developers.
• Installed Fix Pack and kept DB2 at most recent level to overcome application issues and utilize new functionalities
• Performed Database restoration from crash recovery using point-in-time restore roll forward recovery
• Performed Data modeling (logical and physical data modeling using ERWIN)
• Used REORGCHK, REORG and RUNSTATS to optimize system performance
• Performed backup, restore and migrating data between different databases/servers.

Environment: DB2 UDB 8.2/9.2, Data warehouse edition, Quest Central, Erwin, Windows, DB2 Connect version 9, Cognos, Informatica, Data stage.

Confidential, NY

Responsibilities:

• Designed and Implemented Archival process to archive data from production to Archival database/onDemand.
• Created logical/physical data Model using Erwin for Archival Database and created the database with required DB objects for archiving Data from prod to Archival database/OnDemand
• Analyzed the affected data for data warehousing reports
• Interact with the Users for the requirements gathering/Functional & UAT Testing Migration Projects.
• Created Migration/Testing Strategy documents for UDB migration
• Analyzed the configuration for UDB databases like HEAPSORT, packages, locklist, etc.

Environment: AIX 4.x and 5.x, Windows 2003 Advanced Servers, DB2 V8 ESE .

Confidential, San Jose, CA

DB2 UDB DBA

Responsibilities:

• Analysis, Data architecture, design, creation, implementation of 300GB databases.
• Database security test & implementation users, roles, and privileges.
• Database Reorgs to reduce disk fragmentation and improve performance.
• Have done tuning (SQL, application, Memory). Achieved significant gains in the performance of SQL queries against the database.
• Set up DB2 UDB buffer pools and tablespaces proactive performance monitoring procedures using DB2 snapshots.
• Analyzed tables/indexes statistics.
• Conducted tuning and performance studies using the BMC dbxray product.

Environment: DB2 UDB 7.1/7.2, Erwin, BMC,AIX 4.3,Websphere, UNIX Shell Scripts (Ksh), Verities volume manager.

Confidential

Responsibilities:

• Reference Data related Database Objects are identified and modified
• Involved in the mappings of SQL Server Database and Flat Files.
• Performed Unit/Regression/System/Performance testing using IBM/Inbuilt tools.
• Performance tuning of production database.
• Support for Database issues and set up database with data using load/Unload utilities in non prod Environment.
• Monitor usage of temp space, database space, CPU usage and wrote many reports.
• Involved in tuning of SQL queries. And recommended indexes/optimal strategies for queries/jobs that run long.

Environment: DB2 UDB, Erwin, BMC Solaris 2.7, AIX 4.3, Rational Rose, Java.