PROFILE:

• A result oriented database professional with extensive experience in developing, designing and administration of DB/2 UDB V 5/7/8/9/9.7/10.1 /11.1 database applications and data warehousing
• Skilled in achieving results through and with other people in a team environment
• Experienced with SQL Server, Microsoft SQL Server Database Administration in both OLTP and Data warehouse (Business Intelligence), performance tuning, migration and disaster recovery.
• 23+ years administering and tuning expertise on large scale (>1TB) DB2 LUW UDB, DB2 MVS, (7.x,8.x,9.1, 9.5, 9.7 and 10.1/10.5) and SQL Server (V6.5 to SQL Server 2014) databases environments
• Over ten years of AIX,LINUX, Windows operating system experience including HACMP
• Relational database modeling and design (Logical and physical), SDLC and code walk - through
• SQL tuning in client/server networked environments Rich experience on trouble shooting, resolved based on type, severity, complexity and performance tuning of MS SQL Server databases/Query Plans/Query Optimization of T-SQL features like DMV,SQL Profiler, Resource Governor, PerfMon,SQL Sentry, SCOM. UNIX shell scripts, JCL, Windows ANT Oracle Real Application Cluster Server (3 nodes) Database Performance tuning, OEM, TOAD tools Oracle Replication, DB2 replication,Transport Tablespace, Materialized Viewsbitmap index, Partition table C, Java, JSP Programming DB/2 EXPORT, IMPORT, LOAD, RUNSTATS, REORGCHK, REORG, REBINDIBM MQ SERIES BACKUP, RESTORE, VISUAL EXPLAIN MS-ACCESS, MS-SQL SERVER 6.5/7/2000/2005/2008
• Knowledge and experience in bringing up Oracle, SQL Server and DB2 databases in a contingency environment when remote replication is done by SRDF or SRDF/A
• IBM MQ series install and setup (Windows) Brokerage Operations, Accounting, Inventory, fixed assets, MortgageOptions Trade Management, BSR Advance Software, Pega System Data Warehousing, Data Mart, Informatica Power Center (ETL)
• Relation connect, Data Joiner, Relational Connect, Buffer Pool Management, Isolate Queries
• Data Joiner, database connectivity, refreshes, Frameway SQL (issues & Tuning) debugging
• Cognos, Informatica, ASM, Oracle Cluster File System
• ER Studio, ER Win, Bachman data modeling tools, IBM IDA(Infosphere Data Architect)
• EMC SRDF and IBM shark storage
• Working knowledge of ETL tools IBM Info Sphere data stage, Informatica and Abinito
• DB2 performance monitoring, DB2 Data Studio, z/OS DB2 DBA admin tool, DB2 Health Monitor, Control
• IBM InfoSphere Data Architect( IDA), Clearcase, ER Studio, ER Win, Bachman data modeling tools
• TOAD, DB2 Data Studio, InfoSphere Optima, IBM Data Stage

TECHNICAL SKILLS:

Hardware: SUN, DG - 88, HP/9000, Alpha, Intel, IBM/390(VM/ESA), IBM-AIX, IBM Mainframe (MVS/zOS)

Operating System: HP-UX. Solaris, DG-UX, AIX, Alpha-Ultrix, VM/ESA (Main Frame), Linux, Z/OS (Main Frame)

DBMS: ORACLE 5/6/7/8/8i/9i/10G/11G, UNIFY 4, MS-SQL SERVER 6.5/7/2000/2005/2008 , DB2 UDB 5/7/8/9/9.7/10.1 , HP-IMAGE(Network database), INFORMIX 9/10/11

EXPERIENCE:

Confidential, Plano, TX

Database Administrator (DB2 and SQL Server)

Responsibilities:

• Install, configure, test, monitor, upgrade, and tune new and existing DB2 databases on Linux and AWS EC2
• DB2 10.1/11.1 Install on RedHat Linux,AIX
• Helping ETL team in coding package and implementing it
• AWS cloud base DB2,SQL Server database administration expertise using AWS S3 for database backup/restore using AWS VPC
• Peforming DB2 database HADR rolling patch/version upgrade with minimum downtime
• Using db2haicu, RSCT and TSA in DEV/UAT/PROD
• Designing data loading procedure, database recovery procedure
• Performed Production DBA tasks including performance tuning, transaction optimization, backup-recovery.
• Performed Transaction and Q-Replication in production and test environments.
• Experienced with Infosphere replication server.
• Powershell and Unix scripting for database monitoring
• DB2 WLM setup to monitor query and setup threshold
• Providing 24x7 on-call support for critical production systems
• Moving DB2 to AWS Cloud EC2
• Setting up Clouds backup using Storage S3.
• Performed capacity planning for PROD and built SQL Server environment based on new, expected capacity in a new datacenterfor projects.
• Planned, executed data center migration projects with minimal downtime, and their database sizes varies from 1- TB to 16 TB using Database Mirroring/Log Shipping technologies
• Build SQL servers by installing SQL Server 2012, configured Windows Clustering (Active/Active, Active/Passive), Always on and supported systems that have database of size 16 TB.
• Performed performance tuning using SQL Server native tools and provided Tier III support to 400+ SQL Servers, with 24/7 on call rotation, using incident management tool: TFS/VSTF.
• Using SSIS for Extract, transform and the Loads
• Supporting Oracle migration to DB2
• Always on SQL Server setup
• Managing DB2 Tablespaces SMS, DMS and automatic storage on Linus and AIX
• Written Power shell scripts to monitor database backups
• Doing DB2 monitoring using BMC,DSM, snapshot and event monitoring

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• Working on IBM Integrated Analytics System (IIAS) and doing DB2 setup, Sailfish
• Designed, created, and maintained DB2 LUW database objects.
• Performed Production support of SQL Server and DB2 databases.
• Managed database growth and performance with database reorgs
• Managing Database Cyber security using db2audit and on AWS using cloudalerts
• Supporting DB2 migration to AWS EC2 cloud
• Audited application SQL code with DB2 Explain prior to production implementation
• Assisted developers in database and application tuning for optimal performance
• Loaded and refreshed non-production databases for application testing.
• Performed production DBA tasks including performance tuning, transaction optimization, backup-recovery.
• Performed Transaction and Q-Replication in production and test environments.
• Used Infosphere replication sever.
• Designing data loading procedure, database recovery procedure
• Provided 24/7 on-call support for production databases on a rotation basis
• DB2 LUW connect setup between AIX and iSeries
• Moving SQL Server and DB2 to AWS Cloud EC2
• Setting up Clods backup using Storage S3
• Using DB2 10.5/11.1 BLU analytics, Column-organized tables
• Writing UNIX shell scripts on Linux/AIX
• Moving Row bases table to Column store tables
• SQL Server Always-on setup on DEV/UAT/Production
• SAP ECC software patching & Administration using ECC Life Cycle Management tools(HLM), SAP client, SAP studio
• SAP performance tuning
• Used SAP Transaction code DBCO, DBACOCKPIT, DB11, SAP ECC 6 data archiving using EMC InfoArchive
• Implemented step by step migration document for AWS EC2.
• Backup and Recovery of production DBAs and tuning them for better performance.

Confidential

DBA Consultant

Responsibilities:

• Supporting DB2 DPF/ISAS 50 TB, 34 partitions DB2 UDB Data Warehouse Enterprise Edition 10.5/11.1 project on AIX, Linux
• Installing DB2 LUW Linux, Unix and Windows instance and database creation.
• Data Modeling using ERWin for logical to physical data modeling
• Migrating DB2 databases from AIX platform to new RedHat Linux Servers
• Doing Linux/Unix shell scripting, shell command, crontab
• Doing database objects creation using Schema design and DDLs
• Doing DB2 partitioning, PureScale and Federation setup
• Using DB2 10.5/11.1 BLU analytics, Column-organized tables
• DB2 migration from 9.7 to DB2 11.1 from AIX to Linux
• Helping ETL team in coding SQL package and implementing it
• DB2 migration from 9.7 LUW to DB2 11.1 from AIX to Linux
• DB2 Q-Replication
• Database Schema changes implementation in DEV/UAT/PROD
• Installation and configuration of DB2 databases on PureScale
• Configuration and Administration of Active Data Guard environments
• Performance Tuning for SAS environments.
• Installed, Configured HADR
• Scripting of all installations for repeatability and consistency
• Comprehensive documentation of all activities
• Monitored and executed scheduled/requested jobs in AS/400 Robots, Control-M, SAP/R3, AIX Server and Autosys on both Mainframe and Midrange on a timely driven environment.
• Designing data loading procedure, database recovery procedure
• DB2 WLM setup to monitor query and setup threshold

Confidential

Database Consultant

Responsibilities:

• Optimize and tune performance of SQL queries using Visual Explan, db2advise
• DB2 LUW UDB development and production support on LINUX/AIX/SUN/Windows
• Supporting SAP BO FI/CO project on DB2 databases: FC,FIM, DS, familiar with SAP DBA Cockpit
• Expert understanding of troubleshooting (mongostat, mongotop, mongoperf, mongodb logs), methodologies of design and implementation, root cause analysis, systems optimization, disaster recovery, configuration and source code management, change control methods, SDLC, backup and recovery (mongodump, mongorestore)
• Expert understanding of MongoDB environments, architecture, functionality, administration, setup and maintenance
• Managing MDM project MDMDB DB2 database of size 1 TB
• Supporting Informatica team on DB2/DPF and doing performance tuning etc.
• DB2 Connect Enterprise Edition setup on AIX/Linus and cataloging to export data from Host Mainframe and AS/400
• Using DB2 deep compression and DB2 MQT for performance improvement
• DB2 Connect install to use host system
• Installation of DB2 databases and user security setup
• DB2 UDB re-organization, run stats jobs setup using shell scripts
• DB2 UDB migration from V9.2 to V10.1 (LINUX/AIX/Solars)
• Helped Project teams to understand and use DB2 SQL tuning and locking features as most developers were from Oracle development background
• Resolved customers critical care database related production issues
• Implementing star schema design using MDC, MQT
• Involved in design, development and implementation of application
• IBM InfoSphere Warehouse Cube and OLAP support
• DB2 UDB LUW 10.5 HADR setup
• Migrated Databases from SQL Server 2005, 2008, 2008r2 to SQL Server 2014 in Production and Test Environments.
• Consolidated Databases from previous version databases to 2014.
• Configured SQL Encryption on Production Servers.
• Monitored and resolving the issues on All SQL Servers by using SCOM.
• Worked extensively in Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business critical systems.
• Worked on high availability SQL Server solutions, including Log shipping, Transactional Replication and Mirroring.
• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Diagnosed and tuned the server Optimal Performance using SQL Server 2012’s Dynamic Management Views (DMV).
• Backup and Recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008/2012.
• Developing development and production implementation detailed plans for builds, preparing System build guide, maintenance jobs, and system performance testing and project implementations
• SQL Server 2005/2008/2014 schema changes and user management
• Migrating of SQL 2000 and 2005 Database to SQL 2012 and SQL 2014
• Migrating and consolidation of SQL Servers to Data Center

Confidential

DB2 Database Consultant

Responsibilities:

• DB2 LUW backup setup using TSM
• Planning and implementing database backup strategy for non DPF and DPF databases based on SLA
• DB2 schema changes implementation in DEV/QA/Production
• DB2 performance monitoring using monitor routines, Event monitoring, Snapshot monitoring and db2pd
• Using new feature of REDIRECT command to clone database from DEV to QA
• Implementing new ROLE based DB2 security feature
• Supporting DPF DB2 9.7 7 nodes and 48 partitions environment, size 60 TB
• DB2 HADR database setup
• DB2 Q-Replication setup
• DB2 UDB development and production support on LINUX/AIX/SUN/Windows
• DB2 database cloning using REDIRECT restore and db2relocatedb
• Production databases troubleshooting production issues
• Used DB2 Health Monitor and testing IBM Data studio for DB2 database monitoring
• Using IBM Infosphere Architect (IDA) for data model and generating DDL
• DB2 UDB V9.2 upgrade to DB2 V9.7, DB2 10.1 (Linux/AIX)
• Migrated Databases from SQL Server 2005, 2008, 2008r2 to SQL Server 2010 in Production and Test Environments.
• Consolidated Databases from previous version databases to 2014.
• Configured SQL Encryption on Production Servers.
• Monitored and resolving the issues on All SQL Servers by using SCOM.
• Worked extensively in Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business critical systems.
• Worked on high availability SQL Server solutions, including Log shipping, Transactional Replication and Mirroring.
• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Diagnosed and tuned the server Optimal Performance using SQL Server 2012’s Dynamic Management Views (DMV).
• Backup and Recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008/2012.
• SAP BO FI/CO project SQL DBA, designed backup/recovery plan, SQL Cluster install documentation and implementation, SSAS Cube generation support, Query performance etc.
• Developing development and production implementation detailed plans for builds, preparing System build guide, maintenance jobs, and system performance testing and project implementations
• SQL Server 2005/2008/2014 schema changes and user management
• Migrating of SQL 2000 and 2005 Database to SQL 2012 and SQL 2014
• Migrating and consolidation of SQL Servers to Data Center

Confidential

DB2 Consultant/Database Architect

Responsibilities:

• Developing logical and physical data model using IBM Infosphere Data Architect (IDA)
• Done DB2 LUW 10.1 install on AIX 6.1/LUW
• Writing corn shell script to monitor database and load data using LOAD and INGEST utility
• Using DB Artisan and DBA Studio tools for administration
• DB2 application tuning using SNAPSHOT, EVENT monitoring, Explain, monitoring routines
• Preparing schema generation DDL scripts including table, indexes etc for DEV/UAT/PROD
• DB2 Q-replication setup
• Optimize and tune performance of SQL queries using Visual Explan, db2advise
• DB2 UDB development and production support on LINUX/AIX/SUN/Windows
• Using snapshot monitoring and SYSIBMADM monitoring routines for performance tuning
• Supporting SAP BO FI/CO project on DB2 databases
• Experience on DB2 Pure data/Netezza and migrating Oracle RAC to Netezza
• Managing MDM project MDMDB DB2 database of size 1 TB
• DB2 Connect Enterprise Edition setup on AIX/Linus and cataloging to export data from Host Mainframe and AS/400
• Using DB2 deep compression and DB2 MQT for performance improvement
• Supporting 30 partitions DPF environment on DB2 9.7
• DB2 Connect install to use host system
• Installation of DB2 databases and user security setup
• DB2 UDB re-organization, run stats jobs setup using shell scripts
• DB2 UDB migration from V9.2 to V9.7 (LINUX/AIX/Solars)
• Setup of DB2 10.1 on development server, working on Temporal storage, RCAC etc
• Helped Project teams to understand and use DB2 SQL tuning and locking features as most developers were from Oracle development background
• Resolved customers critical care database related production issues
• SQL Server performance tuning using DTA and SQL Profiler, readtrace
• SQL Server upgrade from SQL 2000 to SQL 2008 and provided documentation
• SQL Server SSRS install
• SQL Server 2014 install on Cloud
• Using VSS/Serena and TFS for source code management and build
• Managing source code and change control management system
• Plan out for periodic test recover of the database to ensure a foolproof backup system.
• SQL server backup and recovery planning and DR testing
• SQL Server 2008 Cluster install on three nodes cluster using IBM SAN storage
• Writing TSQL store procedures, SSIS packages
• SQL Server 2012 Cluster install and failover testing on three nodes cluster
• Data modeling using IBM InfoSphere Architect (IDA) tool
• Involved in trend analysis and capacity planning
• Involved in setting up SCOM SQL Server monitoring alerts
• Providing production on-call DBA support including root cause analysis
• Involved in setup of SQL Server Database mirroring
• Supporting SAP BO FICO/FMS, BI warehouse of size over 1 TB
• Writing Windows shell script and Power shell programming
• Providing 7 by 24 pager support on rotation basis
• Maintaining database integrity and schema changes between Dev/QA/Prod environments
• Involved in DR testing planning
• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Setting up IBM TDP for SQL Server database backup and restore

Confidential

DBA Consultant

Responsibilities:

• Implementing star schema design using MDC, MQT
• Involved in design, development and implementation of application
• Implemented Shell script for DB2 full/online/delta/incremental backup on AIX/Linux
• IBM InfoSphere Warehouse Cube and OLAP support
• DB2 UDB 9.7 HADR setup
• SQL server 2005 to SQL server 2008 upgrade and implementing database backup compression
• SQL Server 2000 to SQL Server 2005 migration
• SQL Server performance tuning using readtrace, perfmon
• SQL Server 2008 Cluster Install on three nodes cluster

Confidential

DBA Consultant/contractor

Responsibilities:

• DB2 Connect setup and written Shell script to load data from AS/400
• DB2 LUW database backup/restore using TSM
• SQL server 2005 cluster install and database mirroring setup
• Informix production support
• SQL Server database backup and restore setup
• Resolving Scotia clients database connection issues

Confidential

Lead DB2 DBA

Responsibilities:

• Installation of DB2 databases and user security setup
• DB2 UDB re-organization, run stats jobs setup using shell scripts
• DB2 UDB migration from V9 to V9.2 (LINUX/AIX)
• DB2 table partition and row compression design and implementation
• Work Load Manager (WLM) setup to control and monitor query execution
• Helped Project teams to understand and use DB2 SQL tuning and locking features as most developers were from Oracle development background
• Resolved customers critical care database related production issues
• Using IBM InfoSphere Data Warehouse to build cube, OLAP metadata repository
• Modeling using IBM InforSphere Warehouse 9.5 Design Studio
• Implementing star schema design using MDC, MQT
• Involved in design, development and implementation of application
• SQL Server schema changes and user management
• SQL Server query tuning using SQL Profiler
• DB2 UDB 9.5/9.7 HADR setup, DB2 replication setup
• Install of Oracle 11g and SQL server 2008 to certify application
• Using DB2 LUW table range partition feature on Data warehouse of size 5 TB
• Created DB2 databases on zOS (mainframe), AIX and SUN (non DPF and DPF)
• Implemented DB2 9 table range partition for Data warehouse
• Implemented database schema changes (DB2 zOS, DB2AIX, Oracle SUN, SQL Server)
• Implemented Perl scripts to take database backup, reorg
• Used DB2 Performance Expert tool for DB2 performance monitoring
• Written JCL job DB2 Mainframe, Shell scripts for DB2 LUW and T-SQL/Wsh for SQL Server
• Implemented MDC, MQT and Federated database for DB2 Data Warehouse
• Creating data transformation jobs to prepare the data for OLAP analysis
• Monitoring the performance of the data transformation and data movement jobs as the database grows over time
• SQL Server transaction log shipping setup for standby database
• Using TSO/JCL to resolve tablespace check pending issue, run runstats etc.
• Writing shell scripts to take DB2 backup in DPF environment, run runstats, reorg etc

Confidential

DB2 Domain Lead/DBA Specialist

Responsibilities:

• Supported Pega systems team
• Developed code to do backup, restore, reorg of CIBC Mortgage database
• Using DB2 Data warehouse Edition OLAP function for Mortgage application
• DB2 LUW database cloning using REDIRECT restore and db2relocatedb
• DB2 UDB Federated database setup across SUN/AIX/zOS
• Installed of DB2 Connect and prepared document on the install on AIX
• DB2 Informatica performance tuning
• Used Tivoli storage Manager(TSM) to restore DB2 backup from tape
• Supported Informatica development team on DB2/Oracle mapping, performance tuning
• DB2 Connect setup for Informatica and Cognos Mainframe access
• DB2 UDB Federated database setup between AIX and z/OS
• Implemented/Supporting CIBC Mortgage DB2 data warehouse of size 6 TB
• Using ERWin for data modeling of DB2 database application
• Involved in Basel project supporting 10TB size DB2 databases
• DB2 performance tuning using Health Monitor, Visual Explain
• DB2 UDB migration from 7 to 8 (Windows)
• ER/WIN modeling tool to reverse engineer Oracle, DB2 databases
• DB2 DR test by restoring database on DR site using EMC SRDF
• On-call production Oracle/DB2 UDB/SQL Server DBA support
• Migrating DB2 application from AIX on DB2 V7 to SUN on DB2 V8
• DB2 archive log mode setup and backup and recovery implementation
• Korn Shell programming to implement DB2 and Oracle batch job i.e. data purge, backup
• Knowledge and experience in bringing up Oracle and DB2 databases in a contingency environment when remote replication is done by SRDF or SRDF/A, IBM PPRC
• Correcting/Modifying code of DB2 SQL/PL, Oracle PL/SQL and SQL Server T-SQL of Oracle/DB2/SQL development team
• SQL Server database restore from PROD to UAT, user management, DR test using EMC SRDF
• Implementing SQL Server schema changes
• Implemented DB2 and Oracle database audit as per bank audit requirements
• DB2Audit setup for database auditing
• Creating and managing DB2 database on DB2 Mainframe Z/OS
• Good exposure of JCL/TSO, JCL programming for DB2zOS database maintenance.

Confidential

Database Manager

Responsibilities:

• Re-engineer Legacy Credit verification HP-Image database to Linux/DB2
• Written bash/Perl scripts for data conversion
• Supported Oracle, SQL Server, DB2 and HP-Image databases
• Oracle and DB2 Performance tuning
• Coded DB2 backup scripts using TSM storage on EEE/DPF
• Created logical/physical Data Model using ER/Studio and maintained Data dictionary
• Worked on DB2 Warehouse edition to create schema, cube for OLAP analysis
• Oracle PL/SQL and DB2 SQL PL and PERL coding
• DB2 development project support: Create schema, store procedure, security setup and Oracle backup and restore setup using RMAN
• MS SQL server 2000/7 production support
• Writing SQL server T-SQL store procedures and providing SQL Server DBA support
• Plan out for periodic test recover of the Oracle/DB2/SQL Server database to ensure a foolproof backup system
• Scheduling for periodic SQL Server database maintenance tasks and monitoring their execution
• Oracle upgrade patch and DB2 fixpack install
• IBM MQ series setup, C coding to transfer file and read message from queue
• Tuned DB2 database and Database manager configuration for optimum performance
• Experimented with changing bufferpool and tablespace page size to improve time taken by ETL to build data marts
• Experimented with indexes, and employed Index Advisor and Visual Explain, to both improve user report performance and speed ETL run times
• Employed REORGCHK, REORG TABLE and RUNSTATS to further performance goals
• Perl programming to monitor DB2 database and performance tuning
• SQL PL database programming for DB2 UDB.