SUMMARY:

• Over 9+ years of IT experience as a Database Architect primarily in the Database Administration, Management, Design, Modeling and Maintenance and support of Confidential 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: Confidential 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 Confidential 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

Confidential 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

DB2 Data Base Administrator

Responsibilities:

• Total responsibility for managing DB2 vldb production, test, and staging environments for high profile Confidential client in the capacity of Confidential 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 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

DBA

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

DBA

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

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

DBA

Responsibilities:

• 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 Confidential /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.