PROFESSIONAL SUMMARY

• 11+ years of IT experience with emphasis on all aspects of Database Administration, development, migration, Business Requirements Analysis, Application design, testing, implementation, Performance Tuning and maintenance of databases using DB2 UDB EE and EEE (DPF) to support highly transactional OLTP and Complex DataWarehouse Applications and Reports on LUW Platforms.
• Migrated DB2 UDB databases across several versions and installed fixpacks to keep DB2 at most recent level.
• Good Application DBA experience on DB2 v8, v9, v10 on z/OS platforms. Created and Altered database Objects, Monitored and tuned Applications to optimize performance.
• Extensive experience in setting up and maintaining HADR databases. Installed and configured TSA to Automate the failover of HADR databases using db2haicu utility.
• Excellent Communication skills and able to effectively communicate to people at various levels.
• Develop and Implemented Enterprise wide Backup and Recovery strategy for both partitioned and non - partitioned environment by understanding Business and Application Rules.
• Altered db and dbm cfg parameters to tune the database and Applications to optimize performance.
• Expertise in database utilities like REORG and RUNSTATS to maintain performance improvements at all times. Used LOAD, IMPORT, EXPORT, DB2MOVE utilities to move data across environments or tables or different data sources.
• Migrated databases using backup and redirected restores and also Using Federated Cursor load and Db2 Cross Loader Utility to migrate data across the db2 family where backup and restore are not supported.
• Performed routine healthchecks of databases in question using shell scripts to capture OS and Db2 Monitor data into files and Provide Health Check documentation of bottlenecks found and recommendations to improve performance.
• Used db2exfmt and db2batch utilities to analyze Access Plans and gather Performance Metrics of Queries in a UOW.
• Good Understanding of Storage Management of SAN, NAS and RAID Architecture. Worked with RAID 10, RAID 5 and SSD disks.
• Explored and Implemented new features of updated versions like Range Partitioning, Data and Index Compression, XML Data Types, CTE’s and implemented it to improve performance.
• Coordinated with the developers in creating stored procedures, functions, compiling and binding them to the database.
• Pro-Actively identify risks and problems involved with existing/new database design and come up with Optimal Solution and communicate it across the Team.
• Experience in implementing SQL Replication and CDC between Operational and Reporting Databases Using Infoshpere Data Replication.
• Supported Application Development team in cases of unplanned outages and Migration/Implementation of Database Objects.
• Good knowledge of Health Plan Data Models(HPDM), Enterprise Data Models, Data Dictionary, Domains, Star schema, dimensional Data Models and Metadata management.
• Rotate off-hours support on evenings and weekends as required by project teams, including pager and cell phone support.

TECHNICAL SKILLS

RDBMS: DB2 UDB LUW 7.x, 8.1, 9.1, 9.5, 9.7,10.1, DB2 v8, v9, v10 on z/OS, SQL Server 2000

Database Tools: IIDR V10.2.1, Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Data Architect, DProp, DB2 Replication Center, DB2 Relational connect, DB2 connect, BMC Tools and Quest Tools, VERITAS NetBackup, TSM, Db2 Federated Server, Db2 Information Integrator, Spatial Extender, DB2 Content Manager,DB2 Query Patroller, DB2 Governor

Application Server: Web sphere 4.x/5.0

Operating Systems: SLES 10, 11 SP x, UNIX (AIX 7.1, 5.x, Linux, Sun Solaris 5.9, HP-UX), Windows XP/NT/2000, OS/390, z/OS

Scripting/Languages: Shell Scripting, Korn, Perl Scripting, AWK, SED, SQL Programming, PL/SQL, JAVA, C, C++

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. DB2 Database Administrator

Responsibilities:

• Design, develop and Maintain Confidential ’s Criminal Data Warehouses and Real Time Crime Centre environments.
• Migrated several DB2 for LUW databases across multiple versions starting from v8.2 to v10.1 and applied latest fixpacks. Supported 70+ Db2 UDB (LUW) development, test and production databases.
• Created and Altered database objects in the OLTP Db2 on Mainframes (z/OS) environment to implement new releases.
• Used Federated cursor load and DB2 Cross Loader utility to move data across DB2 Family of data sources. Used export, import, load utilities using ixf file formats to move data across Db2 Family of data sources.
• Handled a crucial role in the Data Team as a Senior DBA involving Data Architect, ETL, Data Analysts, DBA’s to resolve critical design and performance issues.
• Migrated non-partitioned warehouse to v9.7 BCU partitioned (DPF) environment consisting of 20 physical Nodes and 74 Logical partitions to consolidate and support 50+ TB of data.
• Setup HADR and TSA cluster and Automated the failover of DB2 9.7 HADR using db2haicu utility in a zLinux environment.
• Maintain several Range Partitioned Tables to enable Partition Elimination in Access Plans to improve performance. Improved the performance of Searches in Real Time Crime Centre by implementing combination of MDC’s and Range Partitioned Tables.
• Performed routine database Health Checks Using Shell scripts to gather monitor data and generate a Health Check report to identify bottlenecks and Recommend Improvements.
• Installed and Customized the configuration of DB2 Performance Expert for LUW to take snapshots in periodic intervals and tune database for optimal performance.
• Automated the Generation of Database Performance reports from DB2 Performance Expert and later from Optim Performance Manager to customer to ensure customer satisfaction about database performance.
• Customized the configuration of DB2 WorkLoad Manager for LUW to control the flow of queries and setup Thresholds to hold and kill process consuming lot of resources.
• Installed and Customized the configuration of DB2 Query Patroller for LUW to control the workload and the flow of queries by Creating Query Classes and setting up Thresholds.
• Installed and Customized the configuration of DB2 Governor for LUW to kill idle applications and long running queries.
• Maintain Production database Health by running RUNSTATS, REORGCHK and REORG Utility.
• Implemented data and index compression while migrating to newer versions.
• Redistributed Data Partition Groups if data is not evenly distributed among Data partitions.
• Created physical Database Design as a Database Engineer and implemented DPF, Table Range partitioning and MDC for optimal performance. Used replicated MQT’s to ensure collocated joins.
• Create Automatic Storage Database, Self Tuning Bufferpools, implemented Self Tuning Memory Management and performed several rounds of workload test and computed the configuration parameters to setup hard limits.
• Given technical Powerpoint presentation to the Technical Team about new products/ features of DB2 in order to educate them and help them implementing in their environment.
• Installed and setup DB2 Spatial Extender and DB2 Geodetic Extender to manage geospatial information referenced by longitude-latitude coordinates.
• Tuned Complex Cognos reports to improve elapsed times by careful physical database design and tuned ETL workflows to improve Insert Performance.
• Communicated with BCU support and IBM Support to research on unknown outages.
• Used top, topas, db2top and db2pd utility to identify the cause of suboptimal performance and tuned databases.
• Setup DB2 federated environment between database environments to access data among database servers.
• Performed proof of concept testing and documented all activities performed for reference.

Environment: IBM SMART ANALYTICS SYSTEM 5600 R3, Infoshpere Warehouse 10.1, Optim Performance Manager 5.2, DB2 UDB for LUW Infosphere Warehouse Edition V9.7, Balanced Configuration Unit (BCU), DB2 LUW v10.1/v9.7/v9.5/v9.1/v8.2, DB2 v10 on z/OS, TSA Cluster v3.1, HADR, Advanced Query Tool (AQT), AIX 7.1, SLES 10, SLES 11, Applications Manager, ERWin, Datawarehouse, Informatica, Cognos 8.2, 8.4, 10,Websphere Application Servers, DB2 Spatial Extender, Change Data Capture (CDC), Infosphere Data Replication 10.2.1, Shell Scripting

Confidential, MN

Sr. DB2 Application Database Administrator

Responsibilities:

• Manage Confidential’s Healthcare development, test, staging and production Db2 databases on z/OS and LUW environment.
• Installed DB2 Connect on Gateways in order to set up connectivity among Db2 subsystems in a Data Sharing Group.
• Have written complex federated stored procedures involving complex SQL and multiple Data Sources like Sybase, DB2 on z/OS, triggers and User Defined functions to implement complex Business Logic.
• Extensively Used OMEGAMON XE Monitoring tool to monitor the performance of SQL Queries and generated reports for Buffer pool Usage over a period of time.
• Implemented exception event processing through Omegamon XE to monitor Deadlocks, Timeouts, EDM pool full, Authorization failure and indoubt Thread Commits.
• Used IBM Optimization Centre to setup Monitor profiles and tune complex SQL queries.
• Created Databases, Storage Groups, Bufferpools, Tablespaces, DPSI and NPSI Indexes on DB2 Subsystems.
• Created and Maintained Logical Data Models, Physical Data Models and Generated Database scripts to create Database environment.
• Deleted instances from Global Registry using db2greg while uninstalling older versions of DB2.
• Explored new features of V9.5 and implemented the new features while migrating to the newer versions.
• Migrated older version of DB2 UDB Database to Db2 9.5 to keep Db2 at the most recent level.
• Improving the quality of the operational environment by reducing or eliminating unplanned outages, defects, and problems, and by increasing reliability, availability and performance.
• Executed Topas to monitor the resource usage of active processes connected to the server.
• Create MDC and MQT tables to improve query performance and reduce the overhead of data maintenance operations.
• Establish the environment to store XML data in DB2, Set up XQuery to retrieve documents from an XML column and create XML indexes for efficient retrieval of XML data.
• Set up Federated Database environment among DB2 UDB, Sybase, SQL Server Databases by creating servers, wrappers, nicknames and User mappings.
• Setup HADR between primary and standby servers to ensure High Availability.
• Used Spotlight to monitor transactions executing against Db2 on LUW Databases.
• Recovered Tablespaces to a certain Point in Time (PIT) as required by the application.
• Configured and tuned database and database manager configuration parameters for optimal performance.
• Provide on-call (24X7) support for all databases and document all the issues encountered when on-call.

Environment: Db2 9.1 on z/OS, DB2 Admin Client, IBM Optimization Centre for DB2 for z OS, IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, DB2 on LUW 9.1,9.5 Fixpak 3, IBM Rational Data Architect v7

Confidential, Bentonville, AR

Sr. DB2 UDB Database Administrator

Responsibilities:

• Manage Thrivent Information Warehouse client’s production, staging, and test and development DB2 for LUW database.
• Supported as a Onsite Coordinator and have lead a team of DBA’s offshore.
• Setup DPROP for Staging Tables to be replicated from Mainframes through Replication Centre. Troubleshooting Replication Apply Control Servers in case of errors.
• Design and implement the proof of concept on development environments.
• Identify performance issues involved with existing/new stored procedures and come up with Optimal Solution and indexing.
• Involved with the Merge and Consolidation process of stage, accredited, data warehouse Databases into one Database in a EEE environment of 4 physical nodes and 10 logical nodes. Have written necessary scripts for the migration process.
• Applied Latest Fixpaks and created Database, Data Partition Groups, Bufferpools, Tablespaces and various objects.
• Worked on table’s range partitioning and Database partitioning.
• Worked on developing a process of Rotating Union All Partitioning of Tables and developed an archive strategy to archive History Data based on Table Constraints on the Database Side where the application development team were developing an ETL process to do the same and saved time of development and extra overhead on the system.
• Migrated the DPROP Targets in Staging to Logical UNION ALL Partitioning.
• Created Subscription sets using Replication Centre to replicate the changes from DB2 on z/OS to staging tables in Unix.
• Expert in Data definition Language(DDL) on creating or altering Database Objects, Well skilled with Summary Tables, MQT and MDC Tables.
• Refreshed production data to test environment for testing purposes as required by the testing Team.
• Documented a process of Designing Star schema and Dimensional Data Models for data warehousing as well as Converting a Logical Model to put in Physical Database from ER/Studio.
• Worked closely with the Design of Database to utilize the Row Compression and built row compression for the Tables during Migration and before deployment.
• Worked heavily with data movement utilities IMPORT, LOAD, db2move and EXPORT under high volume conditions.
• Written Complex SQL queries for reporting and tuning Complex SQL Joins by using Quest Central and coming up with the Optimal Solution.
• Worked on tuning database and Database manager configuration for optimum performance to support ETL applications. Worked on tuning Long Running Queries using db2batch and EXPLAIN.
• Used NFS File system for backups and User Exit for archival logging and TSM to archive the History.
• Provide on-call (24X7) support for all production databases and document all the issues encountered when on-call.

Environment: DB2 UDB for LUW v8.x/9.1 DWE Fixpak 3 with DPF, Quest Central, Foglight, AIX 5.4, Linux 2.6, Shared NFS Filesystem, Linux, ER/Studio, TSM, Replication Centre- SQL Replication, Informatica PowerCentre 8.0, IBM p5 575 Server, DS4500,TSA

Confidential, Benton Harbor, MI

DB2 UDB Database Administrator

Responsibilities:

• Recovered db2 for LUW databases after crash from backups stored in TSM until time required.
• Restored db2 for LUW databases from one box to another using Cold or Hot Backups and rolling forward logs as required.
• Backed up databases frequently depending upon the type like Prod, QA, and Test. scheduling them via Crontab.
• Migration of DB2 V7 to V9 using a step of migrating to V8.switching DB2 UDB instance between 32 bit and 64 bit to migrate.
• Installated DB2 UDB on LUW and applied fixpak’s to keep DB2 UDB at the most recent level
• Applying fixpaks, pre installation and post installation steps, binding after fixpaks.
• Uninstall Fixpaks to improve performance in certain situations.
• Monitoring any log job failures, instances going down, Backup failures,
• Reorgs, Runstats on tables to claim space and improve performance.
• Presenting GCM tickets for QRB approval if Production. Also QA in some environments.
• Coordinated with SAP Basis on production issues for stopping SAP.
• Space management of tablespace usage and attending to them whenever required.
• Setting Up a Federated System to Access DB2 Family Data Sources either for local databases on same box or across different boxes.
• PMR with IBM, FTP to IBM, collecting db2support to send to IBM.
• Grant/revoke permissions on schemas, tables, tablespaces etc.
• Change date format to ISO format on a database using db2ubind.
• Used tools viz., db2expln, db2trc, db2look, db2pd etc..,
• Create and setting up event monitors.
• Checking dbdiag.log for investigating problems.
• Configuring and fine tuning DB2 DBM and DB configuration parameters for better response throughputs.
• Regular MOB activity (Space management, Log Jobs, Log Archiving etc)

Environment: DB2 UDB for LUW, V8, V7,DPF, Quest central, Spotlight

Confidential

DB2 UDB Database Administrator

Responsibilities:

• Manage Confidential’s internal production, staging, test and development DB2 UDB databases
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis on SQL Server 2000.
• Performed all responsibilities of an Application DBA involved with the DDL statements to create, modify or Alter Database Objects and also involved with performance tuning of complex SQL Queries.
• Tuned LOCKLIST parameter and Upgraded DB2 UDB instance from 32 bit to 64 bit and installation of latest FixPak.
• Supported Migration of Oracle Database to DB2 UDB Using IBM Migration Toolkit.
• Converted Stored Procedures and Triggers from Oracle to DB2 UDB.
• Created/Altered database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc).
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of tablespaces by setting up a threshold
• Worked heavily with data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions
• Developed groups of Views organized by multiple table schemas which allow different sets of users to selectively access different subsets of data by different naming conventions, but allow all users access to the same underlying physical data. Supported this on the security level by developing GRANT scripts to allow only appropriate user’s access to certain Views
• Demonstrated ability in database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance
• Creating EXPLAIN tables and running visual explain utility on sql statements
• Tuned database and Database manager configuration for optimum performance. Experimented with changing buffer pool and table space page size to improve time taken by ETL to build data marts
• Performed database loads and unloads.
• Supported PeopleSoft Applications in a DB2 UDB EEE Environment.
• Used TSM for backups and User Exit for archival logging
• Provide on-call (24X7) support for all production databases

Environment: DB2 UDB for LUW v8.1 Fixpak 16, AIX 5.2, Sun Solaris 5.9,Oracle 10g,IBM Migration Toolkit 2.0, Erwin, Windows Clustered Server 5.0, Linux, PeopleSoft Version 8.0, TSM, SQL Server 2000 Enterprise Version, Quest Central, Toad,