PROFESSIONAL EXPERIENCE:

• Over 8+ years of experience in the IT industry as DBA on DB2 UDB, ESE and EEE v8.2, v9.1, v9.5, v9.7, v10.1,v10.5 and v11.1 on Linux, Unix, Windows LUW and AIX v5.1, 6.2 . Knowledgeable in all aspects of database administration, maintenance, migration, upgrade and architecture. Proven ability in sizing, tuning and optimizing databases.
• Extensive with OLTP and Data Warehouse systems, Application development life cycle methodologies, Database and Application performance tuning and Advanced Replication in OLTP environment
• Done migrations from UDB DB2 V8.2 to V9.1 and V9.5 to V9.7. Upgraded multiple databases and Fix pack upgraded for UDB DB2 V8.2 to DB2 V9.1, V9.5, V9.7, V10.1, V10.5 and V11.1
• Participated in DB2 logical database design and been instrumental in doing DB2 on AIX physical design for large Data warehouse environments and also highly transactional customized OTLP databases.
• Worked on the 16 Partitioned Data Warehouse database, each partitioned DB is about 2 TB size.
• Implemented DB2 DWE to interact with AIX DB2 data warehouse environments.
• Done large implementations of OLAP environments using DB2 DWE, to facilitate report generation of DB2 queries for the Business Intelligence teams.
• Very good experience in WebSphere, WebLogic, JDBC, Tomcat and experience with Databases running under VMware, RedHat Linux, Virtual Storage Pools
• Database utility experience including reorg, runstats, rebind, export, import, load, auto - load, backup, restore and roll forward utilities.
• Documented test plan including the testing of data partitioning (DPF), table partitioning, multi-dimensional clustering (MDC), XML support, and data compression. Improved performance by 40% by converting tablespaces to multiple partitions with DPF.
• Collaborated with Technical Project Services Group to deliver comprehensive database solutions supporting business functions, OLTP systems, Information Integration, Data Marts and other enterprise data stores.
• Excellent work experience on ETL tools.
• Worked with third Party utilities and tools like QUEST tools, IBM data studio, BMC tools, Toad Optim tools etc.
• Scripting experience using both the shell programming and batch programming.
• Database recovery experience with backup, restore, roll-forward, and log archival, and the DB2 advanced database recovery tool (db2dart).
• High availability (HA) experience with HACMP and HADR and Manage maintenance of production application databases, disaster recovery testing,
• Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
• Extensive experience working on Work Load Manager WLM . I have setup the Workload manager for mul
• System, instance, and database security and auditing experience using table definitions, triggers, data replication, and the DB2 Audit Facility.
• Stored procedure, user defined function, and user defined table function experience with DB2 SQL/PL
• Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities, and database analysis reporting tool (DART).
• Database benchmarking experience using Quest Software Benchmark Factory and Mercury Interactive Load Runner benchmarking tools.
• To carry pager 24/7 On-call rotation team, performed On-Call duties taking care more than 60 UDB databases various client servers during the regular time and off hours. Resolved many on Non-production and production issues like, failed backups, archiving to TSM, Tablespaces &
• System maximum used file systems limit alert, and databases down, etc.
• Capturing the long running queries and executing Explain and db2advis to create indexes and examine the access plan.
• Addressing the DB issues submitted on PR Ticket with Sev 3 to Sev 1. And also reported the PMR Tickets for the various issues on db2
• Able to perform change/problem management activities using standard change/problem processes in support of application database related changes.

TECHNICAL SKILLS:

• DB2 UDB V10.5/10.1 9.7/9.1
• 9.1/8.2
• DB2 for Z/OS 11
• Oracle
• SQL Server
• AIX V 4.3.2 on RS/6000
• AIX v5.1 v6.1
• Snapshot and Flash clone technology
• DB2 EEE
• OLAP Integration Server
• Brio
• Web Sphere
• COBOL
• DPROPR
• Optim Performance Manager (OPM)
• Data Joiner
• Purescale
• REORGCHK
• RUNSTATS
• event monitors
• snap shots using shell scripts
• Quest Central
• Embarcadero
• DBArtisan
• SQL Guy
• HADR
• SQL Compare
• Q replication
• MS Office
• Putty
• TOAD
• SSMS
• Erwin
• DB2 Text Extender
• Db2 Explain
• DB2 Connect
• Data Propagator
• DB2 Replication Center (DB2RC).

PROFESSIONAL EXPERIENCE

Confidential,Dublin, OH

DB2 UDB Database Administrator

Responsibilities:

• Migration from 9.7 to 10.1, 10.5 & 11.1 Migration from AIX to LINUX, RHEL, UNIX and vice versa.
• Provided consultation to application development teams on DBMS product technical issues, techniques and SQL review.
• Experience with SQL tuning and analysis.
• Work with 'agile' teams to create DB2 tables and perform data load from DATACOM extracts and copybook formats.
• Coordinated with system engineers to configure servers for DBMS product installation and complex database creation
• Supported IBM IIDR/CDC heterogeneous data replication-implementation, upgrades, support between Oracle and DB2/Mainframe.
• Performed database related optimization, diagnose system bottlenecks and application related bottlenecks.
• Served as resource for database server consolidations project, collapsing multiple database servers to form large SMP environment.
• Configured IBM IIDR/CDC heterogeneous (DB2-Oracle) replication on Exadata
• Designed and coded the COBOL programs dat created the Report of Patients historical database (Flat files).
• Performed checks dat are run against specific databases to identify specific conditions or vulnerabilities using McAfee Vulnerability Manager. Served as the DB2 DBA SME for various applications like RBC, Order Express, Dot Com, GWSA, ADC, PMOD, and DAM.
• Responsible for DB2 physical database design, implementation and maintenance on Z/OS.
• Created and maintained UDB DDL for databases, table spaces, tables, views, triggers, and stored procedures. Resolved lock escalations, lock-waits and deadlocks.
• Expert experience in database performance tuning and troubleshooting.
• Experience with ETL tools (Informatica, Data Stage, etc) preferred Experience with DBI Monitoring and
• Performance tools Experience with WLM (Work Load Manager).
• Used Erwin data modeling tool for designing logical and physical data model.
• Use z/OS DB2 Native Mainframe daily to perform DB2 DBA functions (Display database).
• Experience with DB2 Federated databases Experience collecting database statistics for forecasting, key performance indicators and SLA statistics.
• Established, maintained, troubleshot SQL Replication. Worked with TSM and VERITAS net backups.
• Designed the disaster recovery strategies, which involved the backup and recovery procedures, setting up of HADR across UNIX clusters, HADR with TSA (Tivoli Software Automations) Implementations.
• Scheduled the self-written shell scripts to do periodic runstats, reorgchks and REORGS if required (during the maintenance window) and all other database maintenance activities, like tablespace, container space monitoring, and database sizing scripts for Servers running on UNIX Operating Systems.
• Worked extensively on db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Managed database storage and capacity planning on DPF and Non-DPF databases. I have expertise in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and
• I have designed, tested and debugged external and DB2 native stored procedures.
• Worked with remote stored procedure calls.
• Analyzed index requirements and designed appropriate indexes.
• Performed SQL tuning and bind plan/package creation for enhancements and developments
• Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.
• Provided 24x7 DB2 support for all production cycles. dis support included resolving DB2 application (COBOL) problems as well as DB2 utility and TCP/IP problems.
• Responsible for performance tuning, support, analysis and resolution of database problems dat occurs during the critical time processing.

Environment: DB2 Version 10.1/10.5, AIX, LINUX, IBM CDC Data replication DB2 Connect V 10.1, Service Now Ticketing tool, COBOL, Erwin, Shell Scripting, BPM, Web Sphere, McAfee Vulnerability Manager, DPF, Work Load Manager WLM .

Zulily, Seattle, WA

UBD DB2 Database Administration

Responsibilities:

• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance.
• Working on the migration plans for moving over to v9.7 from v8.18.
• Capturing the long running queries and executing Explain and db2advis to create indexes and examine the access plan.
• Designed, debugged and implemented stored procedures and triggers
• Identified problematic SQL and optimized SQL queries dat helped improve application performance.
• Worked on copybook and segment database updates.
• Restored the databases using offline and online backups. Redirected restores were also done.
• Create Tables/Database Schemas in z/OS Mainframe environment with DB2 using both SPUFI and BMC's Catalog Manager.
• Use MEET tool to evaluate compatibility of client database objects between Sybase and DB2.
• Install and configure DB2 SQL skin, IBMDMT and DB2 migration tool kit.
• Developed and maintained code written in COBOL, FORTRAN, CICS, DB2, and various utilities using state-of-the-art systems analysis and design techniques.
• Analyze data criticality to devise data migration strategies using DB2 backup/restore or DB2 export/load.
• Generated and implemented DDL for several projects from the logical model, using Erwin Data modeling.
• Worked with client DBA on space/memory allocation for DB2 instances/databases.
• Worked in SAP environments with database sizes up to 6 terabytes.
• Handled Db2 Database on SAP Environment, Implemented the SAP Notes on the Database.
• Project Planning - Preparing detailed plan, providing estimates for tasks, Scheduling tasks.
• Follow-up with software updates and fixes following bug resolution.
• Performance monitoring of the complete DB activities which include Lock/Deadlock situations, Log archiving, tablespace size issues.
• Updating the progress of the new projects at the daily meetings.
• UDB DB2 database tuning by dealing with Database & Registry variables to enable speedy transactions.
• Written shell scripts to automate the Offline and Online backups. Scripts backup the db to disk and to the TSM tapes.
• Upgraded Database and Applied database Fix Pack for current version.
• Established the 3-tier architecture using the IBM WebSphere Database model and done physical design of the DB2 database.
• Participated in weekly on-call production support.

Environment: DB2 V8.18 & DB2 V10.1/9.7/9.5/9.1.3/8.2, AIX 5.3, HADR with TSA v2.2 (Tivoli System Automation), Quest Central, TOAD, COBOL, Erwin Data modeling, DB2 UDB Database consisting of SAP R/3 4.6C, BW 3.1C, IBM Web Sphere Commerce Suite, DB2 migration tool kit.

Confidential, Detroit, MI

UDB DB2 LUW Database Administrator

Responsibilities:

• Supported and maintained IMS and DB2 Databases.
• Administration of database, table and table spaces.
• Moving the data by using EXPORT, IMPORT, LOAD, db2move utilities.
• Monitored Databases using snapshot monitoring and Event monitoring.
• Database backup & recovering the database as per business requests.
• Implemented DB2 Security, Locking and Concurrency Control.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to incorporate the new functionalities. Migrated from V8.2 to V9.1
• Initiated and executed maintenance schedules for production performance monitoring
• Seamlessly instituted new IMS Databases and DB2 Tables
• Proactively participated in DR exercises
• Create and modify databases and database objects as per application requests.
• Provided on-call support and well exposed to 24x7 environments.
• Daily and weekly database Maintenance activities such as backup, RUNSTATS, reorg and all related activities for databases.
• Worked on SQL Tuning using db2advisor and db2explain tools.
• Updated the DBM and DB configuration parameter.
• Generated SQL Statements using DB2LOOK Utility.
• Worked as part of a database administration team and provided support for critical and non-critical implementation and maintenance issues.

Environment: DB2 Version 9.7/9.5.x/9.1.x/10.1, DB2 for Z/OS 10.1/11, COBOL, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, BMC Patrol, HP Service manager, Control-M

Confidential

UDB DB2 LUW Database Administrator

Responsibilities:

• 24x7 production database support which includes handling pager calls, problem identification & resolution of DB2 systems.
• Project involves production, test, and development administration and support for client's existing DB2 UDB platform running DB2 UDB v9.1 and v8.2 on servers under various operating system platform (UNIX, Linux and Windows environment)
• Initial responsibilities include: stabilizing environment, monitoring, tuning, and problem management reporting (PMR).
• High availability, maintenance, monitoring, and problem management reporting.
• Additional tasks included documenting platform configuration, maintenance, security, standards, and high availability disaster recovery
• Migrating and maintaining data with LOAD, EXPORT, IMPORT and DB2MOVE utilities
• Performance tuning of the DBM and DB configurations.
• Monitoring of the activities in the databases with Snapshots and Event Monitors and recommending measures for optimizing the db performance
• Addressing the DB issues submitted on PR Ticket with Severity 3 to Severity 1. And also reported the PMR Tickets for the various issues on db2
• Alter the table spaces from 4K page size to 8K, 16k and 32 K page sizes.
• Refresh production database in to the PPD and other environments from the TSM.
• Update TSM NODENAME and TSM PASSWORD for Refresh QAT/PPD environment from production database
• Coordinated and supported various teams on the deployment from QAT/PPD and PROD databases built
• Installing and Maintaining DB2 environment including creating Databases, Buffer pools, logical and Physical design of database storages using DMS tablespaces
• Refreshment of Test, development with copy of production databases. Support at the time of moving from test, development to production systems.
• Migration from one environment to another at database, schema and table levels.
• Maintaining job scheduling utilities for all database maintenance scripts Online/ Offline backup strategies, archive Logs, db2 issues error alerts in db2diag log, REORGCHK, REORG, table spaces maximum used space alert, db sizes, and etc., via Unix and Window cron job scheduler.

Environment: AIX, Linux, Windows, ODBC, Data Propagator replication (DPROPR), Smitty, Enterprise Manager,DB2 UDB, ER Studio, BMC, UNIX Shell Scripting (Ksh, Bash).