PROFESSIONAL SUMMARY:

• 15 + years of experience in Database administration, software analysis, design, implementation, testing, integration solutions and production support in various applications on IBM Mainframes, Unix, Windows platforms. Established a consistent record of providing successful systems and deliverable benefits through the innovative use of technology.
• Strong skills in developing applications using DB2 SQL. Experience in working on DB2 on multiple platforms - Mainframes, AS/400, LUW.
• Experience in improving application performance by tuning the SQL Queries. Strong knowledge in Db2 catalog tables and experience in performance improvement using tools and traditional methods.
• Managed enterprise applications and various teams to deliver scalable solutions across platforms. Successfully integrated Windows, UNIX and Mainframe systems.
• Experience on lead teams of various sizes. Performed the role of mentor. Ensured the team adheres to organizational guidelines and standards
• Orchestrated numerous components on heterogeneous platforms to deliver a service oriented solution along with high availability
• Skilled in troubleshooting, debugging a wide variety of languages, diagnosing application, and operating system issues.
• Experience in troubleshooting, fixing Production issues.
• Experience in DW replications, ETL development, DW Query tuning etc. & Qrep

AREAS OF EXPERTISE:

• Database administration on DB2 V10, V11 on Z/OS and V9 on LUW
• Database tuning & Performance improvement
• Database Development, Application development, Production Support, Release Activities
• Cobol Development/coding, Testing
• Systems Testing & Maintenance

EXPERIENCE AND SKILLS:

• DB2 Z/OS V10, V11
• Db2 LUW V8, V9
• COBOL, JCL
• Squirrel, Data Studio V4.1.2
• File AID, AQT, CHANGEMAN, RACF, Princeton Rational Rose tools, Main view, Omegamon, CA Plainum tools RC Query, RC Migrator, Detector, Sqlease, Plan Analyzer etc.
• SQL
• Linux, Shell Scripting
• TOAD, Db2 Control Center, command line processor, Command Window
• Doc1 Designer V6

CHRONOLOGY OF EXPERIENCE:

Confidential

DB2 Database Administrator (DBA)

Environment: Db2 V11 Z/OS,TSO/ISPF,SPUFI,QMF,OMEGAMON,BMC MainView, PLATINUM, Data Studio, AQT, IBM Info Sphere Q Replication, CA-7, ZEKE.

Responsibilities:

• Enforcing database standards, naming conventions for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Tuning Sql queries using Explain, Plan Analyzer and SQLEASE.
• Create Database objects such as table spaces, tables, indexes, View, Sequence, Stored procedures, Triggers.
• Alter Tablespaces, Tables. Rotating partitions for Tablespaces.
• Generating strategy thru CA-Migrator and create objects.
• Analyzing Db2 workloads for performance issues or errors using CA-Detector.
• Generating and Analyzing Log files using CA-Log Analyzer, Db2 Master Log.
• Performing Unloads, Load, Runstats, Reorgs, Image Copy, Modify, Recovery.
• Extensively used Catalog tables data in reporting and analyzing the data trend and capacity planning.
• Release coordination for Monthly DBA maintenance window.
• 24 x 7 production support on rotation basis.
• Supporting JETS (production mirror) performance testing.
• Working with application teams on purge strategy for historical data.
• Generating / analyzing the audit reports collected from catalog tables part database health.
• Generating ASNCLP scripts for create/ manage subscriptions, Publications and Q maps.
• Deployment of database objects with Q-Replications scripts.
• Generating Q-rep health reports such as E2E latency, Queue depths, status of started tasks and analyzing the data trend.
• Q-rep alerting thru ASNMON tables and IBM info sphere dashboard.

Specialty Applications Database Administrator

Confidential, Cleveland, OH & Columbus, OH

Responsibilities:

• Implemented database standards and naming convention for the database objects.
• Developing SQL scripts for maintaining administration tasks.
• Rate revision support - Scripts generation, Involved in Doc1 design forms support
• Cobol coding - Maintenance
• Supporting application dev team in tuning SP’s
• Maintain all the SQL documents, data conversion Procedures documents.
• Analyzing Log files using Db2diag tool, Deleting the log files for Test databases only,
• Data move utilities - Import, Export, Load
• Performing Backup, Restore, Runstats, Reorg.
• Extensively used Catalog tables data in reporting and analyzing the data trend
• Executing the release tasks - To run Stored procedures, And any DML/DDL statements provided by projects
• Establishing and configuring the database at client copies using Configuration Assistant tool

Confidential

Db2 administrator

Environment: Db2 LUW V 9.1 on UNIX, Informatica, Db2 Control Center

Tools: Embarcadero, DB Artisan for db2, Informatica for DW, web sphere

Responsibilities:

• Database Maintenance for Development and Synchronizing it with Production databases Automated tuning capability and cross server SQL
• Used Star - Schema as the base to eliminate as many “joins “as possible.
• Creating and Maintaining Databases, Table spaces, Tables, Indexes in DB2 environment for Application group
• Setting up full volume of Test region, Development Database using Backup and Restore utilities
• Working with a wide range of Utilities including Load, Unload, Runstats, Re org etc.
• Monitor and Tune database systems using various tools and reports for improved system performance and corrective actions.
• Run Unix scripts
• Run queries against the Oracle databases /DB2 databases
• Implemented split up the high volume tables to Current and Archive tables based on the table data in catalog tables. The application performance (Java Screens pointing to OLTP database) has drastically improved with my advice.
• Star schema is used to develop data warehouse; it provides exceptional speed for data retrieval.
• Designing database backup and recovery strategies and schedule the task
• Coordinate and Resolve day to day issues and concerns from various teams.
• Developed data (record) mapping between multiple platforms and ingredients, with manual promote, inherit/push
• Administer DB2 objects to create, security, recovery, repair and data migrations.

Confidential

Project Leader

Environment: Mainframes - COBOL, Db2, Jcl, Unix

Tools: File-Aid, Solve, Managenow

Responsibilities:

• Project planning, designing & implementation of minor enhancements/Defect Fixing.
• Working with various businesses groups while working for enhancements
• Monitoring batch cycle
• Created scripts for objects such as tables, views, indexes, procedures.
• Automate administrative tasks and diagnose and resolve problems. Code in - Stored Procedures, Triggers, Views and Cursors. Mail configuration and setup.
• Production Support activities

Confidential

Software Engineer

Environment: Mainframes - Cobol, Jcl, Db2, IMSDB

Responsibilities:

• Involved in coding, Unit testing
• Involved in small enhancements and production support activity