SUMMARY:

• An Experienced Mainframe DBA that designs, develops and overseers the efficient of DB2, IMS, and DATACOM databases. As a Database Operations Mainframe DBA responsibilities includes creation and maintenance of database management, creation of database objects, logical and physical database design, ensuring client’s computer security, monitoring database and machine performance, troubleshoot performance problems, creating and backup and recovery procedures, disaster recovery procedure and testing process, ensuring compliance name standards, participated as a team member project that prevents outages and upgrades to database, capacity planning, coordinated resolution of DBMS problems that require vendor intervention, on call support 24/7 for two locations with complex data, monitoring and managing the operations of information.
• Data Definition Language, Data Manipulation, Standard Query Language
• DBMS utilities, Operating System Utilities, BMC Utilities
• Data Modeling, Database Design Concepts
• DB2 for z/OS v 9 Database Performance and Tuning,
• Supported developers and programmer using SPUFI

TECHNICAL SKILLS:

Hardware: OS/VS, OS/MVS, Z/OS, HASP, JES1&2 and CMS

Software: Panvelet, Librarian, BAL, Easytrieve, Endevor, ISPF, JCL, CA - 7DATACOM/DB, DB2, IMS, IMS Fast Path, SQL, SDSF, BMC, Mainview, CA DetectorEddie Lee Lemon SPUFI, CHANGEMAN, QMF, and Platinum. TSO, Roscoe, File-Aid for DB2, File-Aid for RDX, File Manager

MCITP: Database Administration SQL Server 2008

PROFESSIONAL EXPERIENCE:

Confidential

SR. Mainframe DB2 DBA

Responsibilities:

• Assisted with Migration of DB2 v9 z/OS to DB2 v10 z/OS on test and production sub-system.
• DB2 v10 Creation of database and database objects like tables, views, groups.etc.
• Logical and Physical Database Design
• Ensuring Clients Computer Security Policies are followed and report violations
• Monitoring database and machine performance and troubleshoot performance problems, using Mainview and BMC
• Design, Implemented and Perform Disaster Recovery test for DB2 v10
• Ensuring compliance with naming standards
• Coordinating the resolution of DBMS problems that require DBMS vendor intervention.
• 24/7 On-call support DB2 v10
• Installed DB2 Connect v10.5.0.5

Confidential

Mainframe DB2 DBA

Responsibilities:

• Performance and Tuning DB2 z/OS v9 on Atlanta, Ga. and San Antonio, Texas production sub-systems
• Installed, Migrated DB2 v7 z/OS to DB2 v8 z/OS on test and production sub-system using SMP/E
• DB2 v9 Creation of database and database objects like tables, views, groups.etc.
• Logical and Physical Database Design
• Ensuring Clients Computer Security Policies are followed and report violations
• Monitoring database and machine performance and troubleshoot performance problems, using COBOL, DB2,SQL DATACOM, SPUFI and QMF
• Design, Implemented and Perform Disaster Recovery test for DB2 v9 and DATACOM database
• Ensuring compliance with naming standards Eddie Lee Lemon
• Team member participation of projects that required outages and upgrades to database
• Capacity planning for DB2 v9, portioning/clustering and indexing
• Coordinating the resolution of DBMS problems that require DBMS vendor intervention.
• 24/7 On-call support IMS, DB2 v9 and DATACOM for Atlanta, GA and San Antonio, Texas
• Ability to build good relationship with colleagues and handle multiples task
• Ability to work under pressure and a great team member.
• IBM Administration tools - for z/OS that associated with managing a DB2 database
• Supported IMS z/OS v8 and IMS z/OS v9
• Performed DBD, PSB, ACB Gens
• Scheduled and supported Change Accumulation Utilities, BMC Utilities

Confidential

Mainframe Database Administrator

Responsibilities:

• Supported 11 applications (1 HR- PeopleSoft) across 22 MVS sites and 41 DB2 V7 Sub systems with implementation of physical database structures for existing systems in support of business requirements
• Developed appropriate jobs to support database creation, maintenance, and backup and recovery (BMC Software)
• Handle responsibilities of preparing system requirements, source analysis and process analysis and design throughout the database implementation
• Creation and maintenance of Database Management Systems.
• Created and maintained backup and recovery procedure
• Ensuring compliance with naming standards
• Supported developer and programmers using DB2 z/OS v10 SPUFI and BMC
• On-call support for 41 DB2 v7 production sub-system

Confidential

Lead Programmer/Mainframe DBA

Responsibilities:

• Installed, maintained and supported DB2 Material Management System, converted systems from VSAM to DB2. Code and tested for Y2K compliance. 24/7 mainframe support for batch and online production systems. Configuring and Installed Microsoft Access on PC’s for DB2 users. As a Lead Programmer performed maintenance and supported other production subsystems
• Creation of database and database objects like table, view, etc.
• Logical and Physical Database Design
• Monitoring database and machine performance and troubleshoot performance problems
• Responsible for creating and maintaining backup and recovery procedures and process
• Capacity planning
• Maintained and supported test and production for DB2 subsystems for test and production DB2 z/OS v8 sub-systems using COBOL,DB2, SPUFI and QMF
• On-call support for batch and on-line