EXPERIENCE SUMMARY

• Over 15 years of experience in Installation, Design, Deployment, Production Support & upgrade of database.
• Expertise in Software Development Life Cycle (SDLC waterfall) and Agile processes in a large enterprise environment and proficient in analyzing existing systems and designing technical specifications for teh proposed business requirements.
• Domain expertise in US Finance (Banking, Credit Card, Stock exchange, Options), US Healthcare system. Best kept noledge of Health insurance, pharmacy and Pharma business intelligence business.
• Proven ability to research technology options and recommend solutions for various business processes.
• PMP Certified professional with Project Management methodology expertise and worked for clients such as Options Clearing Corporation, Confidential Finance, Confidential Healthcare Insurance, CVS Pharmacy, Accenture Services, GE Consumer Finance. Trained in Agile methodology.
• Strong leadership skills and Project Management skills. Excellent communication skills and strong team player.
• Diverse skill sets ranging from DB2 (13 years), SQL Server (4 years) to PostgreSQL (2 years) in various capacity as Database design, installation, Performance tuning & monitoring, and support.
• AWS Cloud based database support including EC2 and RDS platforms. Real time replications and DR support. High availability with AWS public cloud technology. Building and deploying Instances on demand and deleting teh stack with coordination with DevOps teams.

TECHNICAL SKILLS

Version control: Changeman, SCLM, Endeavor, Panvalet

Scheduling: UC4, CA - 7, CONTROL-M

Soft Skills: Empathy, Patience, Self-Motivated, Goal Oriented, Flexible, Accommodating, Team player, Mentoring attitude, Critical thinking

Tools & Applications: Vi, Speedgain (Monitoring), Data Studio, DB2 Optim tools, Visual explain, SQL Explain (Explain tables, Plan table)

HP Quality Center: DB2 administration related tools and commandsLoad, Runstats, Reorg, Recover, Import, Export, HADR, BACKUPdb2look, db2mtrk, db2pd, snapshot, db2support, db2trc etc..

IBM zOS: DB2-ADMIN tool, Omegamon DB2/IBM Performance monitoring, DB2 HPU, Runstats, Reorg, Recover, (IMAGE) COPY, Check, Load, Unload, Rebuild Index

BMC: Change Manager, Log Master, Mainview, AppTune, Recovery+, Unload+

PROFESSIONAL EXPERIENCE

Confidential

Senior DB2 database administrator

Responsibilities

• Performance Monitoring & troubleshooting using IBM Performance Monitor, Omegamon & DB2-Admin tools.
• Performance tuning using various methods, including access path validation by Explain/Visual Explain. Access path validation by seeing teh bufferpool & Miniplan in Omegamon. Performance index requesting for access path optimization. Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering. Develop DB2 SQL Stored procedures. Load/Unload data. Reorg, Runstats, monitoring using various tools provided by DB2.
• Participate in regression testing of z10 to z11 upgrade. Work on various tasks for DB2 V11 upgrade preparedness.
• DB2 LUW 9.5 installation, support, database creation, backup, performance tuning.
• AWS EC2 - SQL Server 2005 and 2012 installation. SQL SERVER DBA tasks including scripting to automate backup and clean up, index rebuild, space management and other tasks using SQL Agent. PostgreSQL installation and DBA tasks.
• AWS RDS - Instance creation, upgrades, rehydration, Multi-AZ, DR Failovers, cloud formation scripting. AWS Cloud Watch monitoring and various AWS Operations management tasks.

Environment Database - DB2 LUW 9.5, DB2 zOS, PostgreSQL 9.4, SQL Server (2012 and 2014)

Confidential

Senior DB2 database administrator

Responsibilities

• Migrate from DB2 9.7 to 10.5.
• POC with new features of DB2 10.5 like BLU and out of box CPU savings.
• HADR setup using Symantec Veritas for failover. Q replication (IIDR).
• Support total of 50+ database environments (including development, QA and Prod).
• Physical design (PDM) and deploy from Logical models. Create db2 instance, database, tables. Decide on partitioning strategy and indexes for performance. Create backup and disaster recovery strategies.
• Create and maintain Very large multi partition tables. And tune queries going against these hugh tables. And design bufferpools and configure DB CFG parameters for teh same.
• Create triggers and stored procedures.
• Data Replication, Migration & refresh from Production to Test environment. Support restore of Production data & unloads into development and QA environments using various methods. Redirected restores from backups.
• Monitor teh system performance, bufferpool performance, space management using SPEEDGAIN. And for troubleshooting and identifying teh problem SQLs.
• Recover tables from log / backups using IBM Recover.
• Maintain DB2 governor, restrict run away SQLs while allowing desirable work load to go through.
• Performance tuning using various methods, including access path validation by Explain/Visual Explain.
• Access path validation by seeing teh bufferpool & Miniplan in Omegamon (IBM Performance monitoring). Performance index requesting for access path optimization.
• Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering. Best example is reduced CPU of a SQL from 50 minutes to under a second.
• Create automation script to Install DB2 V9.7 in Red Hat Linux environment. Setup HADR. Create perl scripts to Reorg, Runstats and other maintenance tasks. Schedule using Cron.
• Install and maintain DB2 gateways. Register / deregister databases.
• POC on BLU columnar compression. Index jumps. Adaptive compression.
• Perform Database Maintenance tasks in Dev & QA environment like running Reorgs, Runstats, Backup & data compression. Requesting teh same for supported application tables in Production.
• Performance Monitoring & troubleshooting using BMC Mainview and BMC AppTune for zOS.
• Load/Unload data using DSNTIAUL for zOS and LOAD/IMPORT/EXPORT for DB2 UDB.
• Develop, enhance & support in house REXX tool for database task automation, saving 100s of DBA hours.
• DML/DCL/DDL/DB2 Security/Grants/RACF security/ACS2 groups/WLM Start-Stop

Environment Database - DB2 LUW 9.5, DB2 zOS V10, SQL Server

Confidential

Senior DB2 database administrator

Responsibilities

• Implement index compression and reclaim lot of space.
• Data Replication, Migration & refresh from Production to Test environment.
• Perform Database Maintenance tasks in Dev & QA environment like running Reorgs, Runstats, Backup/Copy & data compression. Requesting teh same for supported application tables in Production.
• Performance Monitoring & troubleshooting using IBM Performance Monitor, Omegamon & DB2-Admin tools.
• Performance tuning using various methods, including access path validation by Explain/Visual Explain. Access path validation by seeing teh bufferpool & Miniplan in Omegamon. Performance index requesting for access path optimization. Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering.
• Develop DB2 SQL Stored procedures.
• Develop python programs for task automation and analytical operational reports.
• Load/Unload data. Reorg, Runstats, monitoring using various tools provided by DB2.
• Participate in regression testing of z9 to z10 upgrade.
• Application support for AbInitio Co-op processing, troubleshoot production abends, review teh access patterns and validate teh SQLs for API & Load cards for Utility modes.
• DB2 Connect server support, Remote package binding, performance monitoring, script development for automation
• HADR setup using Tivoli system automation for failover.
• DB2 LUW 9.5 installation, support, database creation, backup, performance tuning.

Environment Database - DB2 LUW 9.5, Teradata, DB2 zOS

Confidential

Database consultant & Analyst

Responsibilities

• Worked with Business analysts & Architects to create ERD, logical data model in Erwin for new application.
• Data model analysis - Work with DBAs & Data Modelers to design teh new data models. Normalizing teh database. Implement referential integrity and triggers for audit tracking.
• Data Analysis - Analyze Hospital and Clinical Claim data as well as Rx prescription data. Load teh files in to Tables and perform complex data analysis tasks, joining multiple tables with ample conditions. Query teh tables to analyze teh data.
• Interact with Stakeholders to gather teh business requirement and convert them into functional requirement specification document and into value stream mapping.
• Convert functional specification into detail design documents and work as SME for development team.
• Provide Application Support with respect to Access path validation on queries, package binds/rebinds, data unload/backups.

Environment Database - Oracle, DB2, Netezza

Confidential

Application Specialist

Responsibilities

• Analysis of existing applications in Mainframe (Cobol, JCLs, easytrieves, CA-7) and .Net/C# to fix teh issues/bugs and find teh opportunities for performance improvement.
• Performance tuning of JCLs, COBOL and DB2 programs for CPU and IO optimization using tools such as PLATINUM DETECTOR and STROBE/iSTROBE. Use scheduling techniques like parallel processing, multi-threading to reduce teh application down window.
• Query Optimization of OLTP programs to improve response time. (Stored Procedures, Cobol/DB2 Programs)
• Improve Knowledge Repository by documenting, domain and technical expertise, best practices and lessons learnt.
• Installation and promotion of teh elements to Panvalet.

Confidential

DB2 Database Administrator

Responsibilities

• Installation and configuration of DB2 UDB V8 for LUW on multiple server and clients.
• Data modeling responsibilities. Designing database schemas and structure. Normalizing teh tables in teh database. Implement referential integrity and triggers for audit tracking.
• Performance monitoring and control of databases and instances. Index creation based on performance stats and frequency of queries. Schedule and perform Reorgs and Runstats to improve response time and accuracy of data.
• Security control and administration.
• DB2 SQL performance optimization by modifying teh queries to use best possible path. Used visual explain to optimize teh queries. Joints were optimized; sub-queries were eliminated or replaced with optimized ones. Temporary tables created for frequently used sub-queries.
• Automatic DB2 backups scheduled and mock run for disaster recoveries performed.

EnvironmentDB2 UDB V8, SQL, eSQL, XML, Java, HTML, Windows XP Server.