SUMMARY

Senior Database Administrator, with over 15+ years of experience in the IT industry and 15+ years of experience in Database Architecture. Specialist on IMS, DB2 UDB database technology ( v8.2, V9.x) and SQL Server 2008/2012. Solid expertise on administration, architecture and development. Proven ability in tuning and optimizing databases. Expert in Unix Scripts (Korn shell),Stored Procedure, Functions, MQT, MDC and Triggers. Experienced AIX and Z/OS, supported databases with capacity of over 7 terabytes in size.Have experience in project management and people leadership.

Databases

DB2 z/OS, DB2 UDB, IMS, SQL server 2008/2012 and Oracle 10g/12c

Data Modelling

Erwin

Data Warehousing

ETL, Datamart, Cogito, Query Patroller, Cognos 8, Crystal/SSRS/SSIS

Languages/Web

QMF, C, C++, SQL/PLUS, Java1.2, XML, UNIX Shell Scripting, Perl 5.0, Java, Microsoft .Net Visual Basic

Application Product

Epic 2012/2014, Meditech 6.0, HMS, Cogito Data Warehouse, Epic Clarity, ETL.

Tools

DB2 development Center, DB2 Replication Center, Command center, Tasks Center, Visual Explain, DB2 Performance Monitor, Snapshots, Event Monitor, db2batch, Embarcadero DBArtisan, SQL profile, TSO, JCL, VSAM, BMC, IBM utilites.

Erwin 4.1 Quest Central fro DB2, Oracle Sql Plus, TOAD, SQL Navigator, OEM, RMAN, Cognos 8.0,CICS, SPUFI, QMF, Platinum Tools, MVS Utilities, Endevor, File-Aid, JCL, SDF-II, CEDF, TSO/ISPF, XPEDITOR.

Environment

z/OS 1.7, IBM RS/6000 AIX v5.1/v6.1, SQL server 2008/2012, OS390, MVS, Linux UNIX, MS Windows.

EMPLOYMENT HISTORY

Medhost, Sr. Database Architect/DBA – Franklin, TN,

Jan, 2014 to May 2015

Responsibilities:

- Support iseries databases and performance tunning DBMON, Visual Explain over production systems.

- Design and create DB2 objects for HMS 10/11/12/14 products.

- Worked in RPG/CL/SQL/C programming for database development HMS utilities, SQLCAT, HMSDBMON, CTRFIL, and Aldon.

- Worked in MIMIX backup, Journaling, and BRMS for Medhost applications.

- Backups/restoring databases objects for new install/release versions HMS11/12/420

- Create all objects using Aldon change Management and Truth tables versions.

- Automate various scripts for daily and weekly jobs. Code perl scripts. Backup / restore

- Create and maintain Tables and Range Partition.

- Set, and Implement HADR in various servers.

- Set alerts for performance monitor: Locks, CPU utilization, Memory, storage and security

- Hardware/Software: IBM AIX 7.1, UDB DB2 V9.5, SQL server 2008, iSeries V5.1 and V7.1, IASP’s

HCA, DBA Consultant – Nashville, TN

Mar, 2012 to Dec, 2012

Responsibilities:

- Design and create DB2/SQL DR objects for Meditech 6.0 EHR/CDM Applications.

- Design and implement MQT (Materialized Query Tables), Views, SP’s.

- Support very complex Queries with multi terabyte storage in a SQL/DB2 databases.

- Analyze and recommend best practices for SQL code and Store Procedure.

- Design, maintain and Performance Tuning of DB2 and SQL servers databases.

- Assist user with Load process and also with SQL optimization. EXPLAIN analysis

- Set alerts for performance monitor: Locks, CPU utilization, Memory, storage and security

- Participate in a rotational 6 weekls on call DBA

- Perform regular DBA maintenance: Backup, Reorgs, Runstats and Loads

- Hardware/Software: IBM z/OS, Oracle 11g, Meditech 6.0, SQL server 2008 R2, BMC, Teradata, ETL.

State of Tennessee, DBA III – New Jersey

May, 2010 to Mar, 2012

Responsibilities:

- Support the PCP/COSMOS Load process on Oracle databases.

- Write SQL/PL Stored Procedure for DIDD application System

- Monitor and automate daily DBA scripts: Backus, restore, REORG

- Create and Update script to load batch files into the system

- Built a monitor Process to collect metrics and locking information from various datababaes.

- Perform regular DBA maintenance: Backup, Reorgs, Runstats and Loads

- Hardware/Software: IBM z/OS, Oracle 10g, SQL 2005, BMC, Crystal Reports, DB2/IMS.

Nissan North America (NNA), Senior DBA – Franklin, TN

Mar, 2005 to April, 2010

-Responsible for DB2 UDB Installation, Physical Database design, Implementation, Maintain, Monitor and perform Performance and Tuning.

- Supported DB2/IMS databases migration projects.

- UNIX Scripts and using Perl programs to automate DBA tasks and projects related.

- Assisted in performing data analysis and data modeling services for new data warehouse processes.

- Use toolset and experience to identify and resolve database bottlenecks. Use Governor and Event Monitor and query patroller.

- Implement MDC to improve performance and maintenance to the Client Reporting Data warehouse DB.

- Analyze and optimize the DDL out from Erwin.

- Improve the ETL process to reflect on-line availability and fast load. Usage of Abinito ETL tool.

- Implement Query Patroller and on hand made scripts for Performance Tuning in he ESE DPF UDB Environment

-Hardware/Software: IBM AIX 6.1, UDB DB2 V8.1, IMS 8, Erwin, UNIX, CA, BMC MAX 4.5, DBRC, IBM utilities, QMF, ISPF, OMEGAMON II, IMS DC, COBOL, JCL, VSAM, EDI, ENDEVOR, CMT, RACF, REXX, CLIST, QMF, MVS, z/OS 1.7, Telnet, FTP

Singapore Airlines, DBA – DB2/IMS, Singapore

Jun 2001 to Dec 2004

- Responsible for Install, Maintain, Monitor and Deploy large DB2 for Data warehouse Project

- Work in conjunction with Data Modelers to forward and reverse engineering. Use Erwin to update Models

- Enhance queries, out of the ETL Tool Datastage

- Responsible for the design and build of new EBF DB2 tables.

- Preparation of the Control Cards for REORG, RUNSTATS, IMAGE COPY

- Design/implement physical table spaces and database, Tables, Indexes

- IMS DBA, BMC Tool, DBRC commands, and to Gen DBDs, HDAM, HIDAM, DEDB, PSBs, ACBs, File system, BTS, RECON’s, Pointer check, IRLM, Backout, AR/CTL.

- Data Warehouse Concepts – for legacy systems data migration to SAP

Responsible for database backup and recovery, disaster recovery, DB2 performance and problem determination in a 24 x 7 environment- Extensive use of DB2 UDB tools like Control, Journal and Script Center.

-Hardware/Software: DB2 7.2, OS/390, z/OS, IMS, CA, AS/400, DB2/400, DBCTL, VSE, MVS, IBM utilities, File Aid, TSO, JCL, VSAM, COBOL, UNIX, SHELL script, PL/1, ISPF, CMT, Control M, MQ series, Erwin, SAP, EDI, MQ series.

EDUCATION

Master in Computer Application, Bharathidasn University, India, 1997

Bachelor of Science, Sri Venkateswara University, India, 1994

Contact this candidate