SUMMARY

• A seasoned DBA with over 22 years of IT experience with 12 years of proven experience as DB2 Application Programmer/ DB2 Database Administrator which includes DB2 UDB on Windows.
• DB2 & DBA experience expertise in leveraging DB2 database platform on AS - 400 (iSeries), Mainframe (z/OS and MVS), AIX and Windows.
• Administered DB2 on AS-400 (iSeries), Mainframe, AIX and Windows environments.
• Expert in Data Integration, Performance Tuning and troubleshooting problems.
• Extensively worked with DB2 Explain and Snapshot.
• Expert skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, Setting up Backup and recovery strategies, Scheduling jobs.
• Extensive experience in using Third party tools like Platinum for Database operations like Tuning, monitoring, backups & recovery and other Database operations, HADR utility for disaster recovery, Change Data Capture (previously Data Mirror Transformation) and ERWIN Data Modelling tool.
• Hands on experience on Creating and using Federated Database, implementation of DRDA (Distributed Relational Database Architecture)
• Expert knowledge of DDL and DML (SQLs)
• Have working knowledge of DDS.
• Expert Knowledge of DB2 Connect, QMF for Windows, iSeries Navigator and other DB2 utility.
• Expert in Complete Software Development and Maintenance Life Cycle.
• Expert knowledge of MS SQL Server and related products as SSRS, SSIS and SSAS. (4 Year experience).
• Expert Knowledge of SAP BO (Crystal Reports, Dashboard, Universe etc.) and SAP Data Services
• Expert Knowledge of using SQL Server Management Studio
• Have Experience in (24 x 7) Production Support
• Expert knowledge of ALDON (Version Control for iSeries Objects), HP ServiceCenter and Scheduler Control-M.
• Worked in domain like Insurance, Manufacturing, Retails and Banking.
• Adaptable to any technology.

TECHNICAL SKILLS

Hardware: Confidential AS-400, Confidential -390, PC

OS: OS/400, MVS, z/OS, Windows, DOS, AIX

Databases: DB2, DB2 UDB, MS SQL Server 2005, 2008R2 and 2012, MS Access

Db2 Tools: B2 Connect, iSeries Navigator, DB2 utility, QMF, BMC utilities, OMEGAMON, SOFTECH Utility, DB2 File Aid, Data Stage, HADR, Data Mirror Transformation

Languages: SQL, COBOL, JCL, CICS, CL

Version Control Tools: Endevor, ISPF, ALDON

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Database Administrator

Responsibilities:

• Identified database requirements by interviewing customers
• Analyzed department applications, programming, and operations
• Evaluated existing system and designed proposed systems
• Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Installed revised or new systems by proposing specifications and flowcharts
• Recommended optimum access techniques
• Coordinated installation requirements
• Maintained database performance by calculating optimum values for database parameters
• Implemented new releases and completed maintenance requirements
• Prepared users by conducting training; provided information to resolve problems
• Supported database functions by designing and coding utilities
• Maintained quality service by establishing and enforcing organization standards

Confidential, RTP, NC

DB2 Database Administrator

Responsibilities:

• Monitoring the jobs running on Data Collection through JAZZ ETL
• Tracking of Database servers
• Fine tuning database servers to make job run faster.
• Supporting Confidential Rational Team Concert and ClearQuest environments
• Supporting DB2 servers on AIX and Windows servers.
• Migrating DBs from AIX to Red Hat Linux and windows servers
• Migrated more than 200 databases (DB2, MS SQL and Oracle) from Old servers to New Servers (From DB2 9.5 to DB2 10.5, MS SQL 2005 to MS SQL 2012 and Oracle 10g Release 2 to Oracle 12c)

Confidential, Durham, NC

Production Support DBA

Responsibilities:

• Monitoring the health of DB2 Region on Mainframe and iSeries
• Tracking of DB2 jobs and trouble shooting
• Evaluated existing system and recommend solutions
• Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Installed revised or new systems by proposing specifications and flowcharts
• Recommended optimum access techniques
• Coordinated installation requirements
• Maintained database performance by calculating optimum values for database parameters
• Implemented new releases and completed maintenance requirements
• Supported database functions by designing and coding utilities
• Maintained quality service by establishing and enforcing organization standards
• Migrated reports from MS SQL Server 2005 to MS SQL Server 2008R2 using SSRS and also migrated integration packages from R2.

Confidential, Cary, NC

Database Administrator

Responsibilities:

• Identified database requirements by interviewing customers
• Analyzed department applications, programming, and operations
• Evaluated existing system and designed proposed systems
• Established solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Installed revised or new systems by proposing specifications and flowcharts
• Recommended optimum access techniques
• Coordinated installation requirements
• Maintained database performance by calculating optimum values for database parameters
• Implemented new releases and completed maintenance requirements
• Prepared users by conducting training; provided information to resolve problems
• Supported database functions by designing and coding utilities
• Maintained quality service by establishing and enforcing organization standards

Confidential, Washington, DC

DB2 DBA

Responsibilities:

• Additional responsibility of MS SQL Server DBA
• 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
• Created Physical and logical file using QMF and Command line CL command
• Created tables, indexes and views using DDL
• Used TOAD for DB2 to monitor Database health.
• Created and reviewed triggers and stored procedures.
• Data Modelling and implementation of Database design using ERWIN
• Imparted training to the Application Development Team
• Development and maintenance of Stored procedures
• Reviewed Stored Procedures and user defined functions before moving to production.
• Used IFS for many of the admin work on DB2 and AS-400
• Used CL command for monitoring jobs and working with objects.
• Co-ordinating with network and operational personals for maintaining performance of Database for users. Giving support 24X7 to the users of the AS-400 DB2 Environment.
• Performed MS SQL Server installation and configuration
• Performed MS SQL Server Reporting System and configuration
• Performed database migrations
• Provided ongoing database support including performance enhancement maintenance and end-user education
• Managed and resolved design issues during development stage and worked closely with developers
• Moved database Schema changes to stage or production.
• Performed database tuning using Quest monitoring tool, Explain Plan.
• Created databases and database objects
• Modified and enhanced existing databases
• Performed backups recoveries and reorganizations of databases
• Replicated database updates using Replication Centre
• Created database reports using SSRS
• Imported data from difference data resources using SSIS.

Confidential, Raleigh, NC

AS400 - DB2 DBA

Responsibilities:

• Interacted with end Users
• Designed Intermediate Database
• DB2 Support for System X and SEATS (Single Element Arrangement Transaction System)
• Developed application using CL programs
• Created tables, indexes and views.
• Created triggers and stored procedures.
• Co-ordinated between application development team and Confidential DB2 support team
• Kept track of change request and implementation of the same
• Kept defect register and took corrective action to remove defect and planned for preventive action to make sure subsequent deliverable should go error free.
• Maintained System X
• Maintained database model using ERWIN

Confidential, Chicago, IL

Technical Lead

Responsibilities:

• Preparing Impact Analysis for any change requested by business user
• Estimating efforts of the module assigned to him.
• Participation in the project Status meetings.
• Initial problem diagnosis (on-line functionality, output, batch jobs, interfaces, etc.)
• Identifying/proposing fixes and recovery steps using COBOL, DB2, SQL, MQ Series and JCL
• Testing the changes using JCL & DB2 Stored Procedures in COBOL Environment (development, user acceptance, integration, and regression testing)
• Made Extensive enhancements in called programs, which are stored procedure objects, fine-tuned various embedded SQL queries for faster response.
• Coding, self-reviewing and doing unit testing using COBOL, IMS DB, DB2 and Scripts.
• Writing and modifying JCLs
• Used SMARTEST for debugging the code.
• Writing Test plans and test cases for unit testing and user acceptance testing
• Supporting Production runs.
• Resolving Production ABENDs
• Interaction with business user to get clarification on the work to be done.
• Interaction with Operations people to make production run smooth.
• Working with other team members including SME to run jobs as requested by authorized users & monitoring the production on on-call basis
• ENDEVOR is used for version control management of all the objects being developed after extensive testing
• Responsible to move all the modules from Test environment to Quality control & from there into Production
• Migration of DB2 Stored procedures, COBOL, Link cards, JCLs etc. were made with the help of ENDEVOR.
• Sign-in & Sign out procedures were also assigned to him using Endeavour to support the entire team requirements.
• Performance Tuning the DB2 queries for the faster response.
• Preparing and presenting the status report for status meetings.
• Preparing and upgrading system documents and design documents.
• Providing various report to business users based on their request.
• Test data population in Unit, System Integration and regression testing environment.
• Loading Data from Mainframe to ORACLE Database
• Maintained Database design using ERWIN

Confidential, Louisville, KY

Technical Lead

Responsibilities:

• Analysed and Designed the HIDCMS.
• Interacted with business for Requirements
• Understanding business functionality.
• Imparted knowledge among the team members.
• Prepared and presented the status report for status meetings.
• Prepared and upgraded system documents and design documents.
• Interaction with business user to get clarification on the work to be done.
• Interaction with Operations people to make production run smooth.
• Coding, reviewing, testing using COBOL, DB2.
• Wrote and modified JCLs.
• Stored Procedure building using COBOL, DB2.
• Worked with other team members including SME to run jobs as requested by authorized users & monitoring the production on on-call basis
• PANVALET is used for version control management of all the objects being developed after extensive testing
• Estimated efforts of the system.
• Participation in the project Status meetings.
• Used SMARTEST for debugging the code.
• Monitored team members
• Logged defects
• Analysed defect pattern and take corrective actions to prevent occurrences of defects.
• Test data population in Unit, System Integration and regression testing environment.
• Responsible to move all the modules from Test environment to Quality control & from there into Production.

Confidential, Salt Lake City UT

Tech Lead

Responsibilities:

• Interaction with Business User
• Prepared Business process flows using MS-VISIO
• Reviewed Business process flow, Requirement Documents (K245s) and Business System Analysis Review (BSARs) Document.
• Prepared and presented the status report for status meetings.
• Prepared and upgraded system documents and design documents.
• Interaction with business user to get clarification on the requirements.
• Interaction with Operations people to gather more business requirement and data interpretation.
• Participation is project status meetings