SUMMARY OF QUALIFICATIONS

• Versatile and highly motivated IT professional with approximately FOUR years of experience in IBM DB2 on ZOS, LUW and Microsoft SQL Server Platforms as DBA with a large financial client.
• Proficient in using Database Management tools like CA's Platinum Database Management Suite for ZOS, Omegamon for DB2/CICS, IBM Data Studio, DB2 Connect, SQL Server Management Studio, Perfmon.
• Experienced in devising Disaster recovery, BCP strategies and implementing Capacity planning. Enacted as Recovery Manager for BCP Exercises. Functioned as Internal Auditor for various projects within Insurance Vertical.
• Acquired a strong sense of Software Development Methodologies Agile and Waterfall .
• Proficient in practicing ITIL methodologies resulting in efficient Change and Problem management.
• Excellent knowledge on tuning Application programs, implementing Storage optimization techniques and handling Database Version Upgrades, troubleshooting Production Issues.
• .

TECHNICAL SKILLS

Languages: COBOL, JCL, SQL, C .

Databases: DB2 V9, 10 for Z/OS, DB2 V9.7, 10.1 LUW HP-UX , MongoDB, SQL Server 2012.

Operating Systems: Z/OS, HP-UX, Windows 7, Windows Server 2008/2012, RHEL 6, Suse Linux 11.

Technologies: DB2 V9, V10 , CICS V4.1 , IBM Utilities, VSAM, SQL Server 2012, Microsoft Azure.

Tools: SQL Server Management Studio, Profiler, Perfmon, Activity Monitor, System Monitor, SSIS, FILEAID, CHANGEMAN, JOBTRAC, OMEGAMON for CICS/DB2, TSO, ISPF, AVRS, CA Database Management Suite for Z/OS, CA OPS/MVS, IPCP, IBM Data Studio, SPUFI, QMF, BMC Remedy, DB2 Connect, Visual Studio, SQL Server Management Studio.

Miscellaneous: MS-Office, Lotus notes.

Confidential

Lead Database Administrator, Server Administrator

Client is one of the largest and most diversified financial services institutions in the world. Team, the Development DBA Group for the Individual Life Insurance is responsible for Developing and Administering the Database Infrastructure and for maintaining Data in all Non-Production Environment.

Responsibilities:

Lead Database Administrator:

• Installed and configured DB2/SQL Server instances. Migrated certain workloads from DB2 to MongoDB, Executed database utilities on a daily basis. Ensured DDL consistency across different environments. Refined SQLs for programs yielding CPU cost/time savings.
• Oversaw promotion and testing of code as it moves from QA, UAT, E2E and finally to PROD. Resolved Database Production issues by doing Root-Cause Analysis and providing permanent fixes. Implemented Disaster Recovery/High Availability solutions.
• Orchestrated upgrade of databases and various tools used on newer releases. Facilitated learning sessions across teams for Improving Competency on Database technologies. Chaired team meetings between Application team, Data Modelling team and System DBA's for improving processes.
• Proposed and documented Process Improvement techniques and shared it across organization.

Server Administrator:

• Provided system administration support, user account setup and Group policy setup for offshore. Served as first point of contact for any Network/Server issues in offshore ODC. Facilitated patch upgrades and software upgrades. Audited all PC's for software compliance.

Achievements:

• Devised DASD space reduction for Database Objects by implementing Tablespace Compression and automatic resizing of datasets resulting in more than 15,000 savings per year. Replaced Traditional Image copies by Incremental Flash copies saving 10,000 per year.
• Fine tuning and rewriting SQLs of application programs to optimize performance resulting in less CPU Consumption saving more than 20,000 per year.

Environment: DB2 on HP UNIX, DB2 on Mainframe, SQL Server 2012, MongoDB, Windows Server 2012.

Confidential

DB2 Production Database Administrator

Confidential is one of the critical groups for production management services for major global financial sector companies. We provided uninterrupted availability of applications for use by Business partners and clients.

Responsibilities:

DB2 Application Database Administrator:

• Maintained Production Databases and related objects. Performed yearly Archival and Migration activities for different applications. Planned and Formalized Disaster Recovery Tests. Developed periodic reports for Historical Tracking and Performance Improvement.
• Resolved Production Database Issues during office hours and during On-call support. Chaired change control meetings and coordinated change implementation. Proficient in practicing ITIL methodologies resulting in efficient change and problem management.

CICS Application Administrator:

• Designed CICS Regions and defined resource definitions for applications online need. Performed CICS regions and vendor tools upgrade Omegamon, IPCP, Xpeditor and Hiperstation . Established ISC/MRO and MQ connections between regions.
• Controlled file allocation and de-allocation through batch and online. Controlling CICS regions through schedules created by using SSM System Schedule Manager and monitoring the Performance of CICS regions using Omegamon.
• Troubleshooting CICS region issues and On-call support during off-hours.

Environment: DB2 on Mainframe, CICS.