DB2 Data Base Administrator Resume Richmond VA - Hire IT People

SUMMARY:

8+ years of experience in Information Technology industry focused on Banking and Financial Service domain as well as Insurance industry having worked on multiple roles such as Developer, Module Lead, Tech lead, DB2 DBA.
Currently working as a ZOS DB2 DBA (DB2 Version V10) for past 2+ years.
Strong Experience on below database skills
Table design
SQL tuning
Performance monitoring
Database backup
High performance Unload (HPU)
Load
Runstat
Re - org
Recovery
Rebuild Index
IBM Mainframe Utilities
Strong exposure to IT consulting, software project management, team leadership, design, development, implementation, maintenance/support and Integration of Enterprise Software Applications.
IBM DB2 V8.1 Certified (700,703,702.Completed V10 DBA (000 - 612). Primary technical skills in DB2 Database administration, Mainframe Technologies (COBOL, JCL, and DB2) and Knowledge on ETL technologies Ab-initio. Experience in Relational Database DB2. Currently working on Latest version of DB2 v10.0. Excellent experience working for large Banking and Card Industry such as Confidential and Major Insurance industry. 3+ years of Onsite experience as Tech Lead (Client Module Lead). Strong experience in Cards, Bank, Mortgage, Digital LOBs. Strong experience on projects involving mobile applications on Digital and Card Processing. Experience in working on projects with Agile Methodology which includes Story writing, Sprint
Planning, providing updates thru Stand-ups, participating in Sprint retro with feature team. Experience using VERSIONONE to manage agile projects. Strong experience on both Development and Maintenance/Support projects. Good team player with excellent communication skills to work in a team and individual environment.

TECHNICAL SKILLS:

ETL Related Technologies: AB-INITIO

Languages: COBOL, JCL

Databases: DB2 V10.0

Operating Systems: Windows XP, Windows 2000, MS-DOS, ZOS

Database Tools: OMEGAMONSPUFI,: DB2ADMQMF,: File Manager DB2Datastudio,: ERWIN

Scheduling Tools: CA-7, Control-M

File Management Tools: File Manager, CAFM

Version Control: ENDEVOR, ChangeMan, Web EME

PROFESSIONAL EXPERIENCE:

Confidential

DB2 Data Base Administrator

Responsibilities:

Understand System requirement, High level Design, Data Model and transform into Database design.
Coordinate with project team to ensure optimized Table Design approach to be followed.
Arrange High level Design Review, PDM Review with Platform team.
Design the DB2 Objects across Dev and QA regions.
Reviewing Queries in Batch or Online programs (Stored Procedures) to ensure optimal performance.
Reviewing Load, Unload and other utility jobs.
Prepare and review Pre Prod Documents.
Preparing Production scripts and working with Production DBA to perform the changes in production environment.
Working with Production DBA to schedule Imagecopy jobs, RUNSTATs and REORG jobs as required.
Support QS testing
Support Performance testing and Production Implementations.
Monitoring the query performance using OMEGAMON.

Confidential, Richmond VA

Tech Lead

Responsibilities:

Reviewing complex business requirements and System requirements.
Analyzing the requirements and Coordinating with multiple stake holders to design/propose an optimal solution.
Reviewing Detail Design, Implementation plan with Clients and external Project team.
Reviewing system test cases, Supporting Integration testing, System testing,
Driving Project Implementation.

Confidential

Module Lead

Responsibilities:

Leading offshore team.
Preparing project statistics, estimation, Analysis,
Design, Design review, coding, code review,
Unit testing for the Online and Batch applications.
System testing support, Performing Implementation tasks, Validations during project deployment.

Confidential

Production Support Analyst/Developer

Responsibilities:

Collecting data from various upstream sources,
Formatting of the collected data.
Storing it in the database.
Extraction of data from database to various downstream sources on a monthly and quarterly basis.
Coding and Unit testing Scheduling and monitoring of various batch jobs.
Preparing Scheduling Calendar yearly basis. Monitoring of the scheduled and On Demand jobs. Fixing any production abend, preparing the emergency jobs/procs and raising request to restart the same.
Handling adhoc request from clients which involves some analysis of any existing process, providing data requested by client or any other external institutions which requests some particular data.
Handling enhancements of some existing processes. Enhancement involves gathering requirements, preparing test cases and then coding, unit testing, supporting system testing and production deployment.

We provide IT Staff Augmentation Services!

Db2 Data Base Administrator Resume

Richmond, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship