Debaranjan Sahoo (DB* DBA for Z/OS on mainframes)

SUMMARY

9+ years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise wide solutions. Work experience includes DB2 Application Programmer/ DB2 Database Administrator.

Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.

Hands on experience as DB2 DBA for mainframes and AIX environments and Lead team of 7 DB2 DBA. Provided mentoring services in DB2 DBA, Data Modeling and Development.

Experienced as Application & Support DBA. Hands on experience in Data Integration, Performance Tuning and troubleshooting problems. Exposure to Complete Software Development and Maintenance Life Cycle.

Strengths include Data Architecture, database administration, production support, Performance Monitoring and Tuning.

Has extensive experience in using Third party tools like Platinum for Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.

Has knowledge of Power Designer for data modeling.

Exceptional skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, Setting up Backup and recovery strategies, Scheduling jobs, developing database procedures, functions and packages.

Worked closely with Project Architects/Technical Managers to assure adequate technical directions / standards are followed and issues are addressed.

Has mentored Users and IT Staff in Application development in Db2 Database Technologies.

Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities. Experienced in (24 x 7) Production Support

Knowledge of Disaster recovery, Buffer pool maintenance/tuning.

TECHNICAL SKILLS

Hardware : IBM Mainframe, NT, PC

OS : OS/400, Windows, DOS

Databases : DB2, SQL Server, MS Access, ORACLE

Data Modeling : Power Designer

Db2 Tools : Platinum, Db2 Admin, Visual Explain, TMON, QMF, BMC utilities,

OMEGAMON, Replication Center, SMPE

Languages : SQL, COBOL, JCL, CSP, VB, CICS, REXX

Other Skills : RACF admin, RMDS admin

Version Control Tools: Microsoft VSS, Clearcase, SCLM, Endevor, ISPW

Scheduling Tools : OPC, Control – M, CA - 7

EDUCATION & TRAINING AND CERTIFICATION:

Bachelors Degree in Instrumentation and Electronics engineering

IBM Certified DB2 Database Administration on Z/OS v 8.1

IBM Certified DB2 Database Associate on v 8.1

Brainbench DB2 (Z/OS) Database Administration

Advanced Brainbench certification in JCL

Brainbench Certification in COBOL

Brainbench Certification in MVS

DB2 V9 training

WORK EXPERIENCES :

FIDELITY INVESTMENTS Nov 2006 till Date

DB2 DATABASE ADMINISTRATOR New York, USA

As a DB2 DBA I am responsible for

• Production Support for all DB2 mission critical databases and applications on 24X7 basis on mainframe and federated environment

• Designed Implemented and supported databases as well as Custom developed

• Database Performance monitoring, tuning and capacity planning

• Data maintenance , Backup Planning and Recovery

• Object / Data Migration and authority profile from one DB2 subsystem to another

• Doing BIND/REBIND/SQL code REVIEW for new / existing applications

• Planning for VSAM to DB2 conversion

• Data Modeling and implementation of Database design

• Resync of Subsystems on two different machines

• Imparting training to the Application Development Team

• Development and maintenance of Stored procedures

• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments

• Testing zparms features and optimizing suggestions to DBMS group for implementation

• Exposure to SMP/E for migrating from DB2 V7 to V8 and installation.

• Using RTS to optimize PROD environments

MBNA/BANK OF AMERICA July 2006 till Nov 2006

DB2 DATABASE ADMINISTRATOR Dallas, USA

As a DB2 DBA I am responsible for

• Conversion of Credit card data from BAC system into MBNA legacy system

• Design the data normalization for the conversion of credit card data to be loaded from BAC system into MBNA system

• Support the application team with optimal design

• Performance Monitoring and tuning recommendations for the applications

• Support during the testing on MOCK environments

• Sizing of Database

• Updating the statistics of data into DB2 tables

• Analysis and recommendation for best access path for the application programs

• Support and Administer SQL replication for DB2 on Z/OS environment

• Running the LOG CAPTURE and APPLY jobs for the data updated during the conversion process

I was part of the CREDIT CARD conversion from MBNA to BAC data which is so far considered as the largest and successful conversion of its kind in the history of banking industry.

FIDELITY INVESTMENTS Dec 2004 till May 2006

Software Engineer/ DB2 Database Administrator BOSTON/BANGALORE

As a DB2 DBA I am responsible for

• Production Support for all DB2 mission critical databases and applications on 24X7 basis on mainframe and federated environment

• Designed Implemented and supported databases as well as Custom developed

• Database Performance monitoring, tuning and capacity planning

• Data maintenance , Backup Planning and Recovery

• Object / Data Migration and authority profile from one DB2 subsystem to another

• Doing BIND/REBIND/SQL code REVIEW for new / existing applications

• Planning for VSAM to DB2 conversion

• Data Modeling and implementation of Database design

• Resync of Subsystems on two different machines

• Imparting training to the Application Development Team

• Development and maintenance of Stored procedures for DBA maintenance purpose

• Testing zparms features and optimizing suggestions to DBMS group for implementation

During my tenure with Fidelity Investments, I designed a tool to identify the poorly performing queries and provide pointers for DBA to look for.

IBM Global Services Dec. 2003 to Dec 2004

Software Engineer/ DB2 DBA Bangalore/Netherlands/USA

IBM is the largest IT Corporation of the World is the leading Laptop/Desktop supplier. FMS project was designed for Performance / Remuneration calculation of Sales Reps of IBM

• Production Support of FMS application on 24X7 basis

• Object creation, alteration and granting access to Application users

• Doing BIND/REBIND for new existing programs

• Involved in Analysis, Design, and Development of implementation modules of DB2 , COBOL , PL-I , JCL

• Backup and Recovery Planning

• Disaster Recovery

• Provide/resolve DB related issues during the running of test cycle

• Running utilities for Data Maintenance

• Data Migration from One subsystem to another

• Designed an automated OPC application which when scheduled would replicate the production database with test databases and notify the application owner into his/her mail box incase there is any discrepancy or error while doing the replication

• Installation of new versions of application on Mainframes and AIX environments

Infosys Technologies Ltd. India - Southern California Edison July 2001 to October 2003

Software Engineer/ DB2 DBA Bhubaneswar, India/USA

Environment: DB2 Z/OS, JCL, COBOL, CICS, CSP, SPUFI, MS-OFFICE, VISUAL BASIC, PLATINUM, ENDEVOR, ISPW, TPU, CA - 7

During my tenure with INFOSYS, I won the first prize for the DB2 QUIZ held at INFOSYS, BHUBANESWAR during May, 2003.

SCE is the premier electricity/Gas/ Water distribution company in southern and central region of California.

• 24X7 production support

• Development of new COBOL/CICS-DB2 Application programs

• Enhancement of existing application(DB2-COBOL/CICS) programs

• Analysis / Design / Testing of Application programs

• Development of new CICS / CSP transaction

• Enhancement of existing CICS/ CSP coded application

• Design and coding of Conversion of VSAM to DB2 for various programs

• Creation of test databases/ Alteration of DB2 Objects

• Granting access to DB2 Objects

• Performance Tuning of Existing/new programs

• BIND/REBIND of batch/ONLINE packages

Contact this candidate