SUMMARY

• Experience in DATABASE ADMINISTRATION with MySQL, Microsoft SQLSERVER, Oracle and DB2 LUW on operating systems like LINUX, AIX, SOLARIS and WINDOWS.
• Over 12 years of extensive experience with IBM’s DB2 LUW, from Versions 7.1 through 11.1, and well versed with most DB2 LUW features.
• Apart from the normal database administration, have designed and implemented migrations, replications, proof of concepts and benchmark testing. Have performed homogeneous and heterogeneous replications.
• Experience with logical and physical design of a database.
• Experience in Data Modeling using data Modelers, Star Schema, Fact & Dimensions tables, Physical & logical data modeling.
• Experience with Data Modeling tools such as ER/Studio, ERwin Enterprise Data Modeler.
• Experience with Relational Database Management Systems such as Microsoft SQLSERVER, MySQL, Oracle, & DB2 LUW.
• Experience with DB2 LUW Purescale configuration and maintenance
• DATABASE ADMINISTRATION tasks such as creation, maintenance, backup, recovery strategies, performance monitoring, tuning, problem identification and resolution.
• Have designed and implemented test cases for capacity testing.
• Provided support for HADR databases, including setup, maintenance, rolling upgrades and automation using TSA.
• Worked on federation between DB2 databases, configured data sources and wrappers, created nicknames, usermappings etc.
• Proactively monitored databases using various tools db2pd, db2top, sysibmadm and mon get functions etc.
• Experience with ETL packages development using SSIS
• Experience with SQL Performance tuning
• Experience to access SQLSERVER and DB2 LUW Databases.
• Good understanding on SAP architecture and experience supporting SAP applications.
• Good understanding of various SANs, LUN allocation and handling IO bottlenecks.
• Worked on various High availability solutions like HADR and HACMP.
• Experience in writing SQL stored procedures and triggers.
• Experience with Shell Scripting using Korn, Perl, Sed, Awk, etc
• Experience in design and implementation of data replication on homogeneous and heterogeneous environments like WINDOWS, Linux, Solaris, and AIX.
• Installation of DB2 LUW UDB EE/non - DPF and EEE/DPF on LINUX, AIX, SOLARIS and WINDOWS
• Excellent analytical and functional skills with strong communication and interpersonal skills. Actively involved in the full project life cycle, user requirements to implementation. Willing to learn and adapt to new challenges.

TECHNICAL SKILLS

Hardware: IBM mainframe ES/9000, IBM 3090, PC/AT, Pentium machines; IBM RS/6000, OS/390, AS/400, Z/OS, AIX 4.3.2, AIX 5.3, AIX 6.1, SP2, SUN SOLARIS V 5.6, IBM P690, EMC, IBM SHARK, Windows Server 2003, Windows Server 2008 R2.

Databases: DB2 LUW UDB EE, EEE versions 7.X, 8.X, V9.X, V10.X, and V11.1, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Microsoft SQLSERVER 2005, Microsoft SQL Server 2008, 2008 R2, 2012, 2014.

GUIs: Visual Basic 5.0, Control Center, SQLSERVER enterprise manager, Visual explain, DJRA on DATAJOINER, QUEST CENTRAL 1.0C13., VMSA., DBVisualizer v5.0, TOAD for DB2 v2.5, Erwin Data Modeler v 4.1.4.3907 , PowerDesigner 15.0, UML, Enterprise Architect 7.5, Microsoft SQL Server Management Studio v10.50, Microsoft SQL Server Management Studio 17, Microsoft Visual Studio 2010, Microsoft Visual Studio 2015, Microsoft Power BI v2.45.4704, Microsoft Azure Portal, MS Visio, MS Office, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Database Administrator

Responsibilities:

• Provided DB2 LUW, MySQL, & MS SQL Server Database administration & support
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Worked with system, network, security and storage teams to prepare and configure new servers for the environment
• Configured and set up DB2 LUW Purescale and provided maintenance.
• Configured and managed cluster file systems, GPFS file systems etc
• Provided 3rd tier internal support for end-users on a Linux platform.
• Performance tuning and SQL tuning of DEV, TEST and production environments.
• Checked status of backups and verified that statistics are up to date.
• Monitored performance statistics, system and database on production.
• Monitored system/database logs for errors and warnings.
• Supported Red Hat Enterprise Linux virtual machines on Windows Server 2012.
• Worked on IBM tickets APARS and worked towards problem resolution
• Performed regular and redirected restores of databases.
• Performed data management tasks such as loading, restoring, and purging data as required.
• Planned and implemented Migrations of SQLSERVER from R2 and 2012
• Installed Standard patches, upgrades and scripting for automating routine tasks.
• Involved in Database support, Physical Database design/database layout and storage optimization, installs, security, integrity, Backup & Recovery, Problem Diagnosis solutions, Documentation.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Optimized data access methods, data configuration, creation and maintenance of several environments tasks including database creation, backup/recovery, defining processes and standards, documentation, database tuning, adding space on tablespaces and other day to day DBA tasks.
• Created and Modified SAP Business Objects Crystal Reports, and LOGI reports
• Tuned Instance and database configuration parameters for optimal performance.
• Tuned SQL statements to boost the overall database performance.
• Performed database monitoring and tuning through snapshot and event monitors.
• Planned & implemented Fix Pack upgrades of DB2 LUW UDB
• Worked on ETL packages development using SSIS
• Worked with SQL Server Migration Assistant (SSMA) to support migration from DB2 LUW v10.1 to Microsoft SQL Server 2012
• SSIS packages developed to extract, transform and load data from various sources into SQLSERVER Data warehouses.
• Schedule and Maintain SSIS packages
• Participated in code reviews, application and system design.
• Worked with Azure SQL Databases, Microsoft Power BI tools and Microsoft Azure Portal.
• Implemented change management requests for unit testing and integration environments before cascading to production.

Environment: DB2 LUW V9.7, V10.1, V10.5, V11.1, Microsoft SQLSERVER 2005, Microsoft SQL Server 2008, 2008 R2, 2012, Windows Server 2003, Windows Server 2008 R2, Microsoft SQL Server Management Studio version 10.50, Microsoft .NET Framework, HRSA Ryan White CAREWare Version 4.1, 5.0, SAP Business Objects Crystal Reports version 14 and 11, Logi Info Studio v12.2, SQL Server Migration Assistant (SSMA), Microsoft SQL Server Management Studio version 10.50, Microsoft SQL Server Management Studio 17, Microsoft Visual Studio 2010, Microsoft Visual Studio 2015, Microsoft Power BI v2.45.4704, Microsoft Azure Portal, Red Hat Enterprise Linux 6

Confidential, Charlotte, NC

Sr. Database Admin

Responsibilities:

• Supported SQLSERVER and DB2 LUW UDB databases on Operating Systems Windows Server 2008 R2, AIX 5.3 and 6.1.
• Developed third normal form and dimensional models that adhered to data warehouse best practices. Worked on development of logical and physical data modeling
• Configured and set up DB2 LUW Purescale and provided maintenance.
• Worked with Microsoft Cloud Azure SQL Databases
• Worked with SQL Server Migration Assistant (SSMA) to support migration from DB2 LUW v9.8 to Microsoft SQL Server 2012
• Involved in shift work and part of on call rotations, supporting 24 x7.
• Deeply involved with, and performed migration of various DPF and non-DPF Production, QA, DEV, and TEST Databases to new improved POWER7 servers.
• Performed SAP installations using SAPINST,
• Experience using SAP DBACockpit, SAP Logon, and navigating SAP with various T-codes and Menus, and monitoring SAP applications
• Worked on SQLSERVER and DB2 LUW database warehouse environment, database and table partitioning.
• Supported DPF databases on 21 Logical Partitions spread across 11 physical Nodes.
• The database sizes are currently 20+ terabytes of data.
• Planned and implemented FixPak upgrades of DB2 LUW UDB from v9.7 fp2 to v9.7 fp5
• Implemented and worked on Data compression, Range partitioning etc
• Planned and migrated various DB2 LUW AIX databases on Linux environment
• Setup kernel parameters for linux environment for optimal database performance
• Tuned various DB2 LUW udb databases on Linux environments
• Performance tuning and SQL tuning of DEV, TEST and production environments.
• Checked status of backups and verified that statistics are up to date.
• Worked on database backups involving File Server Backup, Veritas Netbackup and Data Domain.
• Performed backups using native DB2 LUW backup command with Veritas Netbackup interface direct to Data Domain.
• Worked on EMC TimeFinder and performed Clones for the purpose of production database backups and Reverse Clones for the purpose of production database restores.
• Setup HADR on OLTP systems, performed POC for HADR failovers.
• Troubleshoot problems related to HADR automatic failover scenarios.
• Implemented fix paks on HADR databases.
• Worked on and implemented advanced Backup and Recovery, HADR, log shipping and HACMP cluster
• SSIS packages developed to extract, transform and load data from various sources into SQLSERVER Datawarehouses
• Schedule and Maintain SSIS packages
• Worked on SAP/IBM tickets and followed up with vendors
• Researched SAP notes and IBM APARS and worked towards problem resolution
• Performed redirected restores of databases.
• Performed data management tasks as required loading, restoring, and purging data at the request of clients.
• Installed Standard patches, upgrades and scripting for automating routine tasks.
• Involved in DB2 LUW UDB support, Physical Database design/database layout and storage optimization, installs, security, integrity, Backup & Recovery, Problem Diagnosis solutions, Documentation.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Optimized data access methods, data configuration, creation and maintenance of several environments tasks including database creation, backup/recovery, defining processes and standards, documentation, database tuning, adding space on DMS tablespaces and other day to day DB2 LUW DBA tasks.
• Tuned Instance and database configuration parameters for optimal performance.
• Tuned SQL statements to boost the overall database performance.
• Performed database monitoring and tuning through db2top, snapshot and event monitors.

Environment: Microsoft SQLSERVER 2005, 2008 R2, Microsoft Azure SQL Database, Azure Portal, Microsoft WINDOWS SERVER 2005, 2008 R2, SAP Netweaver 7.X, SAP DBACockpit, SAP Logon, DB2 LUW V9.7, 9.8, AIX 5.3, AIX 6.1, P575, Linux, EMC DMX 3, EMC DMX 4, EMC VMAX, 64 Bit UDB EE, 64 Bit UDB EEE, EMC Time Finder Clone, Veritas Netbackup and Data Domain.

Confidential, Foster City, CA

SR. DB2 LUW DBA

Responsibilities:

• Supported DB2 LUW UDB databases on multiple Operating Systems AIX 5.3 and 6.1, and Windows NT.
• Supported DPF databases on 66 Logical Partitions spread across 8 physical Nodes.
• The database sizes are to the tune of 200+ terabytes of data.
• Planned and implemented Migrations of DB2 LUW UDB from v9.1 and 9.5 to v9.7
• Implemented and worked on Data compression, Range partitioning etc.
• Performance tuning and SQL tuning of DEV, TEST and production environments.
• Checked status of backups and verified that statistics are up to date.
• Worked on database backups involving File Server Backup & SQL Back Track
• Monitored performance statistics, system and database on production.
• Monitored system/ database logs for errors and warnings.
• Performed redirected restores of databases.
• Performed Korn Shell Scripting.
• Performed data management tasks as required loading, restoring, and purging data at the request of clients.
• Installed Standard patches, upgrades and scripting for automating routine tasks.
• Involved in DB2 LUW UDB support, Physical Database design, installs, security, integrity, Backup & Recovery, Problem Diagnosis solutions, Documentation.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Optimized data access methods, data configuration, creation and maintenance of several environments tasks including database creation, backup/recovery, defining processes and standards, documentation, database tuning, adding space on DMS tablespaces and other day to day DB2 LUW DBA tasks.
• Tuned Instance and database configuration parameters for optimal performance.
• Tuned SQL statements to boost the overall database performance.
• Performed database monitoring and tuning through db2top, snapshot and event monitors.

Environment: DB2 LUW UDB V9.1. V9.5, V9.7, AIX 5.3, AIX 6.1, Win NT, ABInitio, Microstrategy, P575, EMC DMX 3, EMC DMX 4, 64 Bit UDB EE, 64 Bit UDB EEE, SQL BackTrack v6.8, v7.3.5

Confidential, Providence, RI

DB2 LUW DBA

Responsibilities:

• Supported DB2 LUW UDB databases on multiple Operating Systems AIX 5.3, Solaris 9, Windows NT and Linux.
• Supported three partitioned databases on 27 Logical Partitions spread across 5 physical Nodes each.
• The database size for each is 2+ terabytes of data.
• Planned and implemented Migration of DB2 LUW UDB from v8.2 to v9.1
• Implemented and worked on new features of DB2 LUW UDB v9 features like STMM, Data compression, Range partitioning etc
• Performance tuning and SQL tuning of DEV, TEST and production environments.
• Checked status of backups and verified that statistics are up to date.
• Worked on database backups involving Legato, File Server Backup & NAS (network-attached storage devices) Backup
• Worked on Oracle 11g/10g Data Guard and standby databases, Snapshot maintenance and creation
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Used BCV split/Data Guard technology to migrate Databases.
• Managed RAC environment for Day to Day Database administration.
• Involved with Architecture, planning, designing, and supporting RAC/ASM environment
• Troubleshoot performance issues for RAC instances
• Advanced Backup and Recovery using Oracle’s RMAN software
• Participated in upgrade of Oracle 10g R2 RAC to 11g R2 RAC
• Worked with Oracle Enterprise Manager (OEM)
• Monitored performance statistics, system and database on production.
• Monitored system/ database logs for errors and warnings.
• Performed redirected restores from production servers to non-production servers.
• Performed redirected restores from non-production servers to production servers.
• Performed data management tasks as required loading, restoring, and purging data at the request of clients.
• Performed Shell Scripting using Perl
• Installed Standard patches, upgrades and scripting for automating routine tasks.
• Involved in DB2 LUW UDB support, Physical Database design, installs, security, integrity, Backup & Recovery, Problem Diagnosis solutions, Documentation.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Optimized data access methods, data configuration, creation and maintenance of several environments tasks including database creation, backup/recovery, defining processes and standards, documentation, database tuning, adding space on tablespaces and other day to day DBA tasks.
• Tuned database manager and database configuration parameters for optimal performance.
• Tuned SQL statements to boost the over all database performance.
• Performed database monitoring and tuning through snapshot and event monitors.

Environment: DB2 LUW UDB V8.1/V8.2 V9.5, Oracle 10g, Oracle 11g, AIX 5.3, Sun-Fire-V240, Solaris 5.9, Web sphere, Win NT, GNU/Linux 2.6.9, SMP, P575, EMC DMX 3, 64 Bit UDB EE, 64 Bit UDB EEE, Perl, Legato, File Server Backup & NAS Backup

Confidential, Atlanta

DB2 LUW DBA

Responsibilities:

• DB2 LUW UDB DBA for Manhattan Associate’s Warehouse Management System (WMS).
• Upgraded from DB2 LUW v8 FP 12 to DB2 LUW Fix Pak 15 on all WMS life cycles including production with HACMP involving one active and three failover nodes.
• Performed redirected restores from product servers to lower life cycle servers and vice versa.
• Performed data management tasks as required loading, restoring, and removing data at the request of clients.
• Attended meetings with application team to suggest solutions for better application coding and performance optimization.
• Worked with Data Architects to implement physical design.
• Worked with the SAN administrators to design the physical storage.
• Installed Standard patches, upgrades and scripting for automating routine tasks.
• Implemented HACMP on various DB2 LUW UDB databases.
• Worked on Shell Scripting
• Involved in DB2 LUW UDB support, Physical Database design, installs, security, integrity, Backup & Recovery, Problem Diagnosis solutions, Documentation.
• Worked on database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance.
• Understanding of database access and ability to provide appropriate suggestions to developers in their implementation of SQL or other data access code.
• Optimized data access methods, data configuration, creation and maintenance of several environments tasks including database creation, backup/recovery, defining processes and standards, documentation, database tuning, adding space on DMS tablespaces and other day to day DB2 LUW DBA tasks.
• Configured the backup and recovery on TSM server.
• Tuned database manager and database configuration for optimal performance.
• Tuned SQL statements to boost the over all database performance.
• Database monitoring and tuning through snapshot and event monitors.

Environment: UDB DB2 LUW V8.1/V8.2, AIX 5.3.5, Web sphere, Win NT, SMP, P575, 32, EMC DMX 3, 64 Bit UDB EE, Maestro, Perl, TSM

Confidential, Manhattan, NY

DB2 LUW DBA

Responsibilities:

• Participated in code reviews, application and system design.
• Implemented day-to-day change management requests for dev, and test environments before cascading to production.
• Performance tuning and SQL tuning DEV, TEST and production.
• Checked status of backups and verified that statistics are up to date.
• Monitored performance statistics, system and database on production.
• Monitored system/ database logs for errors and warnings.
• Worked with UNIX and storage team to identify the IO bottlenecks and get optimum performance.
• Performed HACMP test and implemented it in production environment.
• Performed schedule outages on different systems.
• Was part of on-call rotations, supporting 24 x7.
• Implemented client installations and fix pack installations.
• Implemented new DB2 LUW UDB v9 features and proved its worth in development and QA
• Time tracking and change management was also part of job.
• Provided steady-state production database administration
• Responsibilities included providing support for the database structure including all objects (databases, tables, view, triggers, stored procedures, etc)
• Responsibilities included object management, backup, recovery, security, performance tuning, troubleshooting, and upgrades.
• Worked on new application deployments by preparing test environments and populating the databases.
• Provided support for initial data loads on new databases.

Environment: GNU/Linux 2. .ELsmp, AS/400, Z/OS, DB2 LUW UDB 9 ESE with DPF, DB2 LUW UDB 8.2 ESE, Oracle 9i, Oracle 10g, DBVisualizer v5.0, TOAD for DB2 v2.5, IBM Shark, Erwin Data Modeler v 4.1.4.3907

Confidential, Lansing, MI

DB2 LUW DBA

Responsibilities:

• Installation of DB2 LUW UDB ee and eee on aix and sun solaris.
• Led training for developers and operations staff on DB2 LUW issue resolution procedures to reduce DBA support calls.
• Planned and implemented Migration of DB2 LUW UDB from v7 to v8.
• Implementing fix paks whenever necessary.
• Implemented new features of DB2 LUW UDB v8.
• Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.
• Ensured that developers adhered to standards during program preparation and implementation by assessing program SQL, verifying efficient access path, giving security access, and providing support.
• Develop, evaluate and execute project plans regarding database development, modifications, upgrades and maintenance.
• Supported the Performance testing team and environment. Resolved several performance issues with suggesting efficient SQL to the developers.
• Participated with the business analyst in analyzing business requirements and designed databases to support the business requirements.
• The other POC involved the migration of SP2 Clustered environment onto the P690 boxes, with AIX oslevel at 5.3 servers for creating and migrating the current Production Data Mart. The Mart is fully functional with 8 Logical Partitions spread across 2 physical Nodes. The Database Size grows up to 5 Tera Bytes by the end of the year. All the Data resides on the SHARK Storage devices, with Flash Copy implementation of the Device Copies Successfully working in the Dev phase from the Warehouse to the Data mart, which the Users eventually access.

Environment: UDB DB2 LUW V7.1 EE/EEE, 8.2 ESE, Oracle 8i, Oracle 9i, Oracle 10g, Data Warehouse Manager, AIX 5.1,5.2,5.3, Windows 2000, CA7 Scheduler, DJRA 7.1, DB2 Control Center, Quest Central, Tivoli Storage Manager (TSM), p690, RS/6000 model R50, z/OS, DB2 LUW V7.1.

Confidential, Boulder, CO

DB2 LUW DBA

Responsibilities:

• Part of on call rotations, supporting 24 x7.
• Participate in code reviews, application and system design.
• Wrote scripts to optimize data refresh for DB2 LUW, the data was pulled from mainframes.
• Load data on daily basis in DB2 LUW, which is extracted from various sites using ETL.
• Wrote shell scripts using ksh whenever necessary.
• Done basic AS400, Z/OS administration.
• Ensured connectivity from various mainframe AS/400, Z/OS sites worldwide for extraction of data.
• Set up connectivity and extract data from AS/400, Z/OS Singapore and Canada sites using DB2 CONNECT on AIX box.
• Implement day-to-day change management requests for unit test and integration environments before cascading to production.
• Performance tuning & SQL tuning in unit/integration and production is a continuous task.
• Configure TSM for backup and recovery.
• Use TSM to retrieve logs and do a roll forward Point in Time recovery.
• Have written scripts to backup and restore database-using TSM.
• Check status of backups and verified that statistics are up to date.
• Monitor performance statistics, system and database on production.
• Monitor system/ database logs for errors and warnings.
• Perform schedule outages on different systems.
• Client installations and fix pak installations.
• See how to implement new DB2 LUW UDB v8 features and prove its worth in development and QA before implementing changes in production.
• Time tracking and change management is also part of job.
• Provided steady-state production database administration for those accounts supported by Database Services.
• Provided support for the database structure including all objects (databases, tables, view, triggers, stored procedures, etc) as well as the underlying code on the server.
• Responsibilities included object management, backup, recovery, security, performance tuning, troubleshooting, and upgrades.
• Worked on new application deployments by preparing IVT and Production environments and populating the databases.
• Provided support for initial data loads on new databases.
• Handled the administration of databases for IBM’s internal instant messaging system, SAMETIME.
• Worked on a Load utility tool called by the Tivoli Workload scheduler (TWS, both event driven and time driven). The entire functionality of the tool is done using Shell Scripting.
• Participated in code reviews, application and system design.
• Implemented day-to-day change management requests for unit test and integration environments before cascading to production.
• Created logical/physical design for the data warehouse.
• Formulate backup/recovery strategy.
• Work with system admins to make system available for production.
• Took formal training on SAP BW and DB2 LUW UDB architecture.
• Good understanding of data flow in SAP BW.
• Performed sizing of SAP BW on DB2 LUW UDB.
• Installed SAP Central instance and SAP database instance.
• Installed SAP Business Content Add-on.
• Performed SAP BW general settings.
• Setting up process to archive SAPBW data.
• Keeping DB2 LUW UDB statistics up to date with SAP BW.
• Performed data load into info cubes.
• Handled concurrency, locking issues.
• Optimize SAP BW query performance in UDB.
• Helped scale single and multi-user SAP BW queries.
• Control DB2 LUW log space consumption with SAP BW.
• Analyze Performance bottlenecks and proactive monitoring.
• Scaling database, partitioning databases, relocating DB containers.

Environment: IBM mainframe ES/9000, IBM 3090, OS/390, AS/400, Z/OS, AIX 5.2, P690, 630, SP2, 2 ESS - Sharks, AB Initio, SAP BW, Business Objects, java, WINDOWS NT, Tivoli Storage Manager, IBM RS/, REDHAT LINUX kernel 2. .7, DB2 LUW UDB 8.1, DB2 LUW v7.1.0.75