SUMMARY:

IBM Certified DB2 Database Administrator with 10 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.

OVERALL SKILLS:

• Mainframe Skill Set
• COBOL, JCL, DB2, REXX, CICS, SAS,IMS
• Tools - Endevor, FileAid, Schedulers - CA-7, OPC
• DB2 versions and Tools
• IBM DB2 V8, DB2 V9 and DB2 V10, V11 for z/OS
• CA Platinum Tool Suite- RC Query, RC Migrator, Detector, Database Analyzer, Partition Expert, Log Analyzer, Insight for DB2, Plan Analyzer, Index expert, RI manager
• BMC Tools and Utilities
• IBM Data Studio and DB2 Connect
• IBM 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 for DB2 for z/OS

Responsibilities:

• ITS releases semi annually
• DSNACCOX RTS statistics
• Created REXX procedures to execute the DSNACCOX proc and generate the PARM cards based on the recommendations.
• Created REXX procedure which creates JCLS that can be scheduled without any manual intervention.
• 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.

Skills/Tools Used:

• DB2 V11, JCL,COBOL, REXX
• IBM Data Studio, DB2 Connect
• BMC tools and utilities, IBM DB2 Utilities

Confidential

DB2 Database Administrator for DB2 for z/OS

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.

Skills/Tools Used:

• DB2 V 10, V11, JCL,COBOL, REXX
• IBM Data Studio, DB2 Connect, Q Replication
• CA - Platinum tools R-14, R15, IBM DB2 Utilities,

Confidential, Los Angeles

DB2 Database Administrator for z/OS and IMS DBA

Responsibilities:

• 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 IBM 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 Database Administrator on z/OS

Responsibilities:

• 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.

SQL Server Database Administrator

Confidential

Responsibilities:

• 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

Skills/Tools Used:

• z/OS, DB2 V 9, V10, JCL,COBOL, REXX, SAS, Endevor
• UNIX, DB2 for LUW V 9.1
• IBM Data Studio, DB2 Connect, ER Studio
• CA - Platinum tools, IBM DB2 Utilities
• SQL Server 2005, SSIS, Attunity Studio, Attunity for SQL Server CDC.