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/OSSQL 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

Sr. DB2 Application Database Administrator

Responsibilities:

• Manage Benecard’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