SUMMARY

• DB2 UDB/AIX/LINUX Administrator wif over 7 years of IT experience wif expertise as a Data Architect and Database Administrator on both OLAP and OLTP systems.
• Strong technical skills working as a DB2/UDB 9.7 DBA. Data architect capable in all phases of development and operations.
• Performing Database Analysis, Database Design, Creation, Performance Tuning, Security, Backup and Recovery, Installation and Upgrades.

PROFESSIONAL EXPERIENCE

Confidential, Waltham MA

Db2 UDB Database Administrator

Responsibilities:

• Installed and configured several DB2 9.5 DPF instances.
• Designed and Implemented the backup and recovery strategies for DB2 landscapes (Sandbox,Dev, Training, QAS and Production).
• Worked on Disaster Recovery and High Availabilty on Active - Active cluster mode using Db2 agents.
• Configured and performed daily Database backups on several Database servers in VLDB environment.
• Performed and actively monitored daily database house keeping jobs on DEV/TRN/QAS/PRD servers.
• Monitored the performance of productions servers on a daily basis and worked wif the development team through the issues to approach stability.
• Created physical data model using Erwin.
• Generated and maintained DDL’s from the data model and executed it across several database landscapes.
• Tuned and assigned bufferpools to largely growing table spaces in the databases depending on the tablespace growth to optimize database I/O operation.
• Worked on expensive SQL, Locks, database error longs, and Memory analysis.
• Established and Maintained DBA monitoring and reporting standards to ensure compliance wif applications at service levels.
• Managed Primary and standby databases in HADR environment using Confidential SUSE HA agents
• Created and maintained partition by range tables to store quarterly sales data.
• Used DB2 native utilities like db2pd, db2dart, to monitor and tune databases.
• Used DB2 Performance optimizer to monitor system performance, SQL activity tracing, file system maintenance.
• Used DB2 performance monitor to create event exceptions especially on application lock time out and deadlocks.
• Performed DB migration from Db2 V9.5 to Db2 9.7.
• Performed Pre/Post DB migration steps for a consistent database environment.
• Providing support to various SAP components including SolMan, CRM 7.0, JCRM7.0, ECC6.0, BINetWeaver 7.0, Portal 7.1, PI 7.1, CE 7.1, MDM7.1, BI JAVA.
• Used db2advis to recreate and tune indices against largely growing tables in the database.
• Managed and maintained appropriate database users profile by assigning them to proper groups/roles and giving access to appropriate views/ user defined tables.
• Executed performance traces on database servers during on/off peak hours to analyse system bottlenecks.
• Created physical data base model using ERWIN.
• Designed data marts for Enterprise data warehouse.
• Designed Perl /Ksh scripting to define database house keeping jobs.
• Created event monitors on database server instances to monitor application deadlocks and time outs.
• Performed routine database health checks on production servers and coordinated wif the application / OS team to facilitate changes.
• Designed and Performed database recovery strategies in development and sandbox environments to initiate database refreshes.
• Executed DB2trc to gather information for long and expensive SQL’s
• Scheduled several database house-keeping jobs using crontab facility.
• Worked on MQT and MDC and index creations for DPF database instances.
• Provided performance monitoring during all phases of the Application’s development lifecycle.
• Coordinated wif the onsite Data Center to include and configure the sizing of appropriate file systems on AIX servers.
• Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration.
• Performed database migration of instances and databases from 9.5 to 9.7 LUW.
• Installed fix pack and patch upgrades for DB2 UDB 9.7.
• Configured STMM for DB2 9.5/9.7s LUW on AIX for optimized performance.
• Worked wif the Incident and Change control management team to facilitate production deployments and provide post production support.
• Assisted users to install Db2 runtime client at their work stations and make connection to DB2 server instances.
• Performed Q-Replication on unidirectional mode among source and target servers on several tables.
• Worked wif the MQ team members to configure the Q managers and Q subscriptions.
• Provided database and SQL Tuning expertise wif recommendations to application developers, vendors and other core Application teams
• Created and tuned bufferpools on a DPF environment by assigning certain table spaces based on date volume and I/O operation.
• Created and maintained several table spaces and tables in DPF database environment.
• Performed table space size analysis post major Insert/Update/Delete and schedule database housekeeping jobs to integrate the changes.
• Acted as a main point of contact on rotation basis responsible for onsite DBA support to critical production issues.
• Created and maintained Instances, databases, table spaces, schemas (both administrative and development) in DB2UDB for developers.
• Installed and configured new DB2 subsystems on AIX
• Setup and modified database manager configuration parameters and database configuration parameters post migration from V 9.5 to V 9.7.
• Configured active/standby database clusters and HACMP resources for HADR on Db2 9.5 using smitty
• Worked on Data modeling (logical and physical data modeling using ERWIN).
• Experimented wif Indexes and employed Index Advisor to improve user report and speed ETL runtime.
• Used REORGCHK, REORG and RUNSTATS to further performance goals.
• Designed ERD’s using ERWIN.
• Responsible for backup, restore and migrating data between different databases/servers.
• Performed Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Set up DB2 UDB/AIX production and development environments.
• Database maintenance for development, and synchronizing it wif the production database.
• Database Clean up (development database) scripts (Unix Shell Scripts, Cron, & SQL) for automated clean up every week.

Confidential, MA

SAP UDB DB2 DBA

Responsibilities/Deliverables:

• Working as SAP Basis/DB2(9.7) DBA wif a 7-person Basis Team both on-shore and off-shore toprovide a 24x7 support to SAP operation (total of 56 SAP instances using DB2 running on56 servers) .
• Installing and configuring several SAP Landscapes including SolMan, CRM 7.0, JCRM7.0,ECC6.0, BI NetWeaver 7.0, Portal 7.1, PI 7.1, CE 7.1, MDM7.1, BI JAVA 7.0.
• Designing and Implementing the backup and recovery strategies for SAP landscapes (Sandbox,Dev, Training, QAS and Production).
• Configuring and performing daily Database backups on 56 SAP / database servers.
• Performing daily database house keeping jobs on DEV/TRN/QAS/PRD servers.
• Installed and Configured sap router to establish connection between local and remote SAP routers.
• Providing support to various SAP components including SolMan, CRM 7.0, JCRM7.0, ECC6.0, BINetWeaver 7.0, Portal 7.1, PI 7.1, CE 7.1, MDM7.1, BI JAVA.
• Proven expertise working wif DBA Cockpit.
• Worked on ABAP stack and Dual Stack archiving.
• Scheduled archiving jobs to clean up the mass data from the system.
• Performed database housekeeping jobs post archiving jobs to update the system.
• Prepared and published DB2 Installation/update plans and documents.
• Monitoring the performance of SAP PRD servers on a daily basis.
• Managing and Maintaining appropriate users profile by assigning them to proper groups/roles.
• Executing different kind of developer traces related to performance to analyse system bottlenecks.
• Working wif HA Implementation team to design and implement an active-active High Availability
• Clustering on SAP Systems(DB2(9.7) and SAP agents) using SLES HA Solution in QAS andPRD.
• Coordinating wif the Data Center Monitoring Team to include and configure SAP Filesystems and critical processes in the daily monitoring list.
• Using DBA Cockpit utility to monitor and tune the database in a daily fashion.
• Installed and configured CCMS agents on central systems to assign and manage automatic reaction for key processes on the servers.
• Monitoring SAP Servers daily on DEV/TRN/QAS/SBX/PRD using CCMS agents, Nimbus/Netcool and Perl/Shell Scripting.
• Installing and configuring SAPRouter for OSS connections between SAP and ACS SAP servers.
• Opening and maintaining OSS connections across all ACS SAP servers.
• Working wif SAP closely to fine tune the DBM, DB and environment configuration parameters for go live check
• Working wif SAP to support Pre/Post GO-LIVE checks on the Production System.
• Monitoring 56 HA SAP DB2 (9.7) Database Instances using DBA cockpit and other DB2- nativeutilites.
• Using SAP MDM Data Manager v 7.1 and SAP MDM Data Console to archive, un archive, load,unload, maintain and configure MDM Repositories.
• Importing ABAP/JAVA and NWDI transports in DEV/QAS/PRD.
• Working on BMC Incident and Change control management process to facilitate production deployments and providing post production support.
• Worked on ABAP stack and Dual Stack archiving.
• Worked wif the DB Enterprise team to design and implement HA solution on databases.
• Worked wif the Data center team to provide DR strategies.
• Scheduled archiving jobs to clean up the mass data from the system.
• Tuned and maintained bufferpools to optimize I/O operation against databases
• Performed database housekeeping jobs post archiving jobs to update the system.
• Creating and maintaining a heterogeneous Database connections and Data sources between

PROFESSIONAL EXPERIENCE

Confidential, MA

AIX - DB2 UDB Database Administrator

Responsibilities/Deliverables:

• Installed, configured and maintained DB2 database (500 GB) in AIX platform.
• Responsible to provide support to development team to develop New Account Opening and Online Account Opening applications and perform replication in cross platform (DB2 v9.5 - SQL SERVER 2005 Enterprise Edition) and maintain the database environment in daily fashion.
• Managed OLTP database for development activities to develop NAO and OAO applications in IBM Web sphere 6.0 Platform.
• Designed triggers for Data REPLICATION process from DB2 to SQL Server to capture delta changes in the database.
• Configured several Client workstations wif DB2 UDB ESE and Express C 9.5 for developers using response files / unattended installations.
• Configured and maintained Instances, Databases, Table spaces, Buffer pools in Windows and Unix environments.
• Configured OLEDB/ODBC driver to support various autantication types of DB2 and establishing the connection among databases.
• Migrated DB2 from version 8.2 to version 9.5 in AIX platform.
• Performed Pre and Post migration tasks by configuring database and instance management files.
• Configured Linked Server for pulling up the data from IBM DB2 v 9.5 to SQL SERVER using SERVER ENCRYPT mechanism.
• Performed Redirected Restore of the database to support table space container resizing.
• Monitored hit ratios for buffer pools, package cache, catalog cache using DB ARTISAN on a daily basis.
• Wrote Stored Procedures to support Application development activities.
• Used IBM Rational Architect suite to create and modify database domain models including table spaces and buffer pools and database partition groups.
• Resolved deadlocks by configuring DLCHKTIME, LOCKTIMEOUT, LOCKLIST, MAXLOCKS parameters.
• Configured the database monitor switches for DB (SYSADM, SYSMON) group to run the regular snapshots.
• Took daily Snapshots at regular intervals on applications, table spaces, buffer pools, dynamic SQL statements.
• Managed instance profile securities and user access to several database environments like Integration, Pre-Production and Production.
• Configured the DB2GOV configuration file to make it work wif the DB2 Query Patroller.
• Created Table Event Deadlock Monitors for monitoring and resolving deadlocks in databases.
• Configured WAS Server Application settings to support various ISOLATION levels in Application to minimize deadlocks.
• Shell scripting to automate the various phases of build deployment procedure for NAO/OAO application development.
• Wrote BATCH Scripts for WINDOWS environment to automate database deployment for application development.
• Performed PRE and POST deployment tasks after upgrading the UDB database FIXPACK level to 3a from 2a.
• Scheduled AIX CRON jobs for REORGCHK, REORG and RUNSTATS, Online/Offline BACKUP and DATA ARCHIVING.
• Configured database diagnostic logs, error logs, active and archived log space.
• Commissioned DB2 environment and registry variables to avoid Stale Connection Problems.
• Responsible for performing online and offline backup, restore and migrating data between different databases/servers.
• Used DB2 Visual Explain utility to create/analyze access plans and tweaked the DML’s accordingly.
• Performed Database sizing, tablespaces, indexing and log spaces design & implementation work.
• Prepared and deployed the DDL and DML scripts-build at regular basis to support NAO/OAO development activities.
• Configured DB2 Connect to integrate data from client server including Workgroup and LAN based architecture.
• Created the Partition by Range tables for Audit Logging Activities/Fraud Logging Activities.
• Performed Disaster Recovery Planning for the database using HADR methodology.
• Commissioned Production Database for Beta release of NAO and OAO applications.
• Managed diagnostic logs, error logs, active and archived log space requirements.
• Designed Indexes and employed Index Advisor to improve user report and speed ETL runtime.
• Worked on XML Query/XQUERY for Audit logging and Development activities.
• Performed Reverse Engineering of the Database Domain Model from database schema using Rational Data Architect.
• Management of multiple schemas in Integration/Preprod/Prod environments.
• Monitoring the applications connected to the database to evaluate the workload.
• Used DB2LOOK Utility to generate DDL for several database objects in a specific schema.
• Used DB2PD for database and instance level monitoring and tuned the database accordingly.
• Used IMPORT, EXPORT, LOAD utility to populate staging and production tables.
• Configured DB2GOV daemon property file to govern application loads at instance and database level.
• Administered AIX for Database maintenance activities.
• Used DB2 Query patroller to intercept queries and bench marked the results wif the DB2 Governor.
• Created and altered DMS table spaces and added/modified containers.
• Used DB2GOV utility using NICE to set the priority of the applications at database level.
• Monitored Table space and Buffer pools usage/hit ratios by running specific snapshots and modifying it.
• Configured DB2GOV utility rule to set the maximum number of rows selected and idle time and locks held for applications connected to the database for specific authorization ids.
• Used DB Visualizer 6.0 for database monitoring activities and provided support to development teams to use it.

Confidential, NYC, NY

RSolaris DB2 UDB Database Administrator

Responsibilities/Deliverables:

• Responsible to take care of DB2 database wif 3.2 TB in R/3 and BW environments on Solaris 9. I was also responsible to provide support to DBG SAP Basis team in performing day to day database activities.
• Worked on R/3 and BW environment (Development/Testing and Production).
• Supported database activities in implementing Dual Landscape in Production and Development phases.
• Maintained Instances, databases, table spaces, in DB2UDB for developers.
• Installed new DB2 subsystems on Solaris SAP based environments.
• Setup and modified database manager configuration parameters and database configuration parameters.
• Supported R/3 and B/W teams in performing day to day activities.
• Cleaned up Transaction log as and when needed.
• Used DBA cockpit to monitor and tune Staging and production Database in a daily fashion.
• Supported High Availability in Production and Quality Analyst Testing Environment through Failover Schemes.
• Performed Data modeling (logical and physical data modeling using ERWIN).
• Experimented wif Indexes and employed Index Advisor to improve user report and speed ETL runtime.
• Used REORGCHK, REORG and RUNSTATS to optimize system performance.
• Designed ERD’s using ERWIN.
• Migrated databases from V 8.2 to V 9.2 in UNIX environment.
• Tweaked the Instance level and Database level configuration parameters to optimize the system performance.
• Responsible for backup, restore and migrating data between different databases/servers.
• Executed shell scripts to perform redundant data base activities.
• Administered user groups to execute certain fenced routines and functions
• Performed Database sizing, table spaces, indexes and log spaces design & implementation.
• Provided Database security & Audit Design, test & implementation.
• Set up DB2 UDB/Solaris production and development environments.
• Database maintenance for development, and synchronizing it wif the production database.
• Administered Solaris for Database boxes.

Confidential

AIX- DB2 UDB Developer

Responsibilities/Deliverables:

• Installed, configured and provided support to production and development side using a 1.5 TB DB2UDB v 8.2 Enterprise Edition for AIX 4L .
• Also developed shell scripts for installing DB2 software, configuring instances, creating databases.
• Troubleshot and fixed both development and operational systems (Development/Testing and Production).
• Created and maintained Instances, databases, tablespaces, schemas (both administrative and development) in DB2UDB for developers.
• Setup and modified database manager configuration parameters and database configuration parameters.
• Worked wif Logical and physical data modeling group.
• Designed Data modeling (logical and physical data modeling using ERWIN).
• Experimented wif Indexes and employed Index Advisor to improve user report and speed ETL runtime.
• Used REORGCHK, REORG and RUNSTATS to further performance goals.
• Designed ERD’s using ERWIN.
• Analyzed user requirements to design star schema to implement Data Mart.
• Responsible for backup, restore and migrating data between different databases/servers.
• Worked on Database maintenance (Production 24 x 7) for web applications
• Performed Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Provided Database security & Audit Design, test & implementation.
• Set up DB2 UDB/AIX production and development environments.
• Database maintenance for development, and synchronizing it wif the production database.
• Database House keeping jobs (development database) scripts (Unix Shell Scripts, Cron, & SQL) for automated clean up every week.
• Administered AIX, Windows for Database boxes.