SUMMARY:

• Confidential Certified DB2 Database Administrator with 8.5 years of expertise in various DBMS - DB2 on z/OS/Mainframe, DB2 UDB for LUW and MS SQL Server. Proven ability to quickly pick up new technical skills and work concurrently on multiple tasks. Excellent technical specifications and documentation skills.

TECHNICAL SKILLS:

SKILLS: Mainframe Skill Set COBOL, JCL, DB2, REXX, CICS, SAS,IMS Tools Endevor, FileAid, Schedulers - CA-7, OPC DB2 versions and Tools Confidential DB2 V8, DB2 V9 and DB2 V10, V11 for z/OS Confidential DB2 for LUW V9.1, 10.5 CA Platinum Tool Suite- RC Query, RC Migrator, Detector, Database Analyzer, Partition Expert, Log Analyzer, Insight for DB2, Plan Analyzer, Index expert, RI manager Confidential Data Studio and DB2 Connect Confidential Q Replication SQL Server MS SQL Server 2005, 2008, 2012 Data Warehousing and BI Middleware: Attunity Connect, Attunity Stream, Attunity Federate SSIS, ETL

PROFESSIONAL EXPERIENCE:

Confidential

DB2 Database Administrator

Responsibilities:

• Confidential has a strict schedule of releases wherein changes are done every quarter. Apart from the regular releases, off cycle releases also been handled.
• Co-ordinated the release activities in various environments
• Meticulously planned and implemented production releases where many changes were implemented in a narrow window of 2 to 3 hours.
• Automation and Scripting
• Modified the existing in-grown tool for Maintenance activities such as REORGs to encompass new DB2 features like Automatic creation of Mapping Tables.
• Created procedures to report latency in the Q Replication tool.
• Production support and developer Support
• 24x7 On call Production Support
• Troubleshoot any DB2 issues Prod and Non-production environments.
• Implemented data models, database designs, data access and table maintenance codes.
• Resolved database performance issues, database issues, replication and other data issues.
• Worked with other Information Architects and Database Designers to implement the physical data model.
• Developed the database performance monitoring process and analyzed data for optimization opportunities.

Confidential, Los Angeles

DB2 Database Administrator

Responsibilities:

• Release Activities:
• Farmers has a strict schedule of Releases in which code changes are completed.
• Coordinated the Release activities in 56 odd Non-Prod and Prod environments.
• Automation and Scripting
• Created REXX procedures generating the JCLs/Jobs to apply the schema changes to all the 56 test environments.
• Automated the DB2 Health Check reporting in Farmers which had previously taken nearly 4hrs every Monday. This was done using Confidential utilities, FTP scripting and MS Excel VB macros.
• Generated Migration Strategies for setting up new multi-database environments in TEST/UAT regions.
• Production support and developer support
• 24x7 Production Support
• Troubleshoot any DB2 or IMS issues Prod and Non production environments.
• SQL tuning
• Did extensive SQL tuning suggesting various ways to improve performance.
• Analyzed, reported and tuned long running queries.

Confidential

DB2 DBA on z/OS, DB2 for LUW and MS SQL Server

Responsibilities:

• DB2 Database Administrator on z/OS
• DB2 Objects Maintenance:
• Designed and developed RC Migrator strategies for the project control flow which can achieve the required changes of the tables from dispersed sources and can apply the same to several targets at the same time.
• Executed the database object change requests using a change request procedure across development, Model and Production environments.
• Automation and DB2 Health Check
• Developed and Automated DB2 Space monitoring jobs which are run weekly. The report is FTPed to desktop and pulled into Excel sheets using macros.
• Automated the Error and Exception report jobs using SAS.
• Developed a process to identify Obsolete packages in different subsystems to keep SPT01 and SKT01 clean
• Production support and Developer Support
• 24x7 Production Support
• Test/UAT Environment Maintenance and Data Refreshes.
• Troubleshoot Utility Job failures in Non production environments.
• Interacted with the application development team for problem resolution and suggested modifications to the long running SQL queries.
• Reviewed and approved DB2 programs changes and JCLs in Endevor.
• Documented the solutions and best practices to help new resources within the team.
• Maintenance Activities
• Developed Database Analyzer strategies for Re-organizing the DB2 tables which had very poor performance. Used Platinum for handling the Real Time Statistics of the databases.
• Performance Monitoring and Tuning
• Developed backup/recovery strategies using Recovery Analyzer for critical application tables.
• DB2 for LUW Administration
• Specified, designed and developed utility programs as required to support the DB2 UDB environment; consulted on their implementation and usage.
• Extensive experience in administering, maintaining, developing and implementing policies and procedures for ensuring the security and integrity of databases.
• Developed SQL scripts for administration and maintenance.
• Wrote shell scripts for monitoring and performing day to day and weekly tasks such as BACKUPS, REORGS, RUNSTATS, tablespace and bufferpool utilization.
• Used RUNSTATS, REORGCHK and REORG to enhance application performance.
• Transferred data using Import, Export and Load utilities.
• Experience in DPF environment.
• Experience setting up and managing HADR.
• Well experienced in using DB2 tools like db2top, db2pd etc., for continuous monitoring and trouble shooting.
• Created users and maintained them by granting appropriate privileges.
• Created EXPLAIN tables and running the visual explain utility on SQL statements.
• Applied knowledge of Data Mapping, Data Loading Concepts and Shell scripts.
• Wrote shell scripts to automate the runstats and backups’ and added them to the cron.
• Good exposure on installation of DB2 and applying fix packs.
• SQL Server Database Administrator
• Data copies (table to table) from Production to UAT/Dev
• Provided the access permissions in Development
• Created databases, dropping and Shrinking database files in Development
• Performed database restores in Development
• Tuned database applications (SQL queries)
• SSIS package performance tuning
• Monitored system resources while running production jobs
• Compressed large tables in Dev/UAT and Prod servers
• Updated statistics on the databases
• Created and rebuilt indexes
• Created the linked server configuration between servers
• Compared the two Servers configuration, Databases configuration from two different servers; Comparing SQL Objects structure/data using Embarcadero Change Manager

Confidential

Responsibilities:

• Involved supporting all the applications for EMEA countries.
• Worked on abends and met SLA’s. Ensured they were fixed permanently.
• Reviewed the work from the development team before deploying in the same in Production. ed with Appreciation by the BAM Business Area Manager for effectively installing the tape, ICFS Release 8.9

Confidential

Responsibilities:

• Worked on the tickets raised by the Customer which involved SPUFI requests, Flow changes, calendar loads till investigation of problems which had direct impact on Saturn’s Warehouses.
• Received appreciation from customers for timely delivery of critical Business Requests and other adhoc requests.
• Was a major contributor to Preventive Maintenance activities which helped reduce the number of tickets and abends as well as to automate activities which increased customer satisfaction and appreciation.
• Participated in a LEAN SIGMA initiative in the account level and implemented it in my project.