We provide IT Staff Augmentation Services!

Senior Database Analyst And Administrator Resume Profile

Summary

A Senior Database professional with extensive experience in large and complex database environments. Excels in all areas for DB2 for z/OS, DB2 LUW, Microsoft SQL Server, and IMS DB/TM DBMS environments. Superior abilities in performance tuning, problem identification, and problem resolution.Exceptional analysis and problem solving skills. Expertise identifying and writing requirements andspecifications. Proficient in logical/physical database design.

Over twenty 25 years of experience in the insurance industry Life, Health, Annuity, and Property and Casualty P C .

In the most recent seven years performed as a Sr. Database Administrator working DB2 z/OS, DB2 LUW and IMS environments. Systems and Applications Database Administrator activities involved:

  • Performance tuning. Troubleshooting, and resolving space issues.
  • Performing logical and physical database design/modeling.
  • Conducting infrastructure, performance and capacity planning.
  • Creating and performing backup, restore, and disaster recovery procedures.
  • Assisting Developers in database related tasks.
  • DBMS Installation and Configuration

Prior to Transamerica, performed as a Sr. Systems Programmer, Sr. Database Administrator, Database Developer, and Systems Specialist.

Three examples of accomplishments include:

  • At Transamerica - Initiated the redesign and implementation of a Management Information System database interface resulting in over 600,000 in bottom line savings.
  • At Tricom - Received a spot award for resolving a serious space issue with an IMS database.
  • For Blue Cross and Blue Shield - created a DB2 Provider Database for HMO, PPO, and Point of Service Products. This database consisted of over a hundred logical and physical tables. Project activities included data modeling, logical design, physical design, and system integration.

Computer Languages

  • Cobol
  • z/OS Assembler
  • C and C
  • JavaScript
  • Java
  • PowerShell
  • REXX
  • Perl

Computer Software

  • IBM z/OS
  • AIX
  • Solaris
  • Microsoft Windows
  • IBM Utilities for IMS, DB2, VSAM, MQ
  • BMC Utilities for IMS, DB2, MQ
  • Platinum Utilities
  • T-SQL
  • PL/SQL
  • QMF
  • SPUFI
  • DB2 for z/OS
  • DB2 LUW
  • Microsoft SQL Server
  • Microsoft Access
  • PowerDesigner
  • Sybase
  • CA-Datacom
  • IDMS
  • IMS/DB and TM
  • Oracle
  • VSAM
  • VTAM
  • Control-M
  • Endeavor
  • CICS
  • Erwin
  • Microsoft Office
  • MS Project
  • Visio
  • DB2 Information Integrator
  • WebSphere Transformation Server

Experience

Confidential

Senior Database Analyst and Administrator

  • Performed DB2 for z/OS, DB2 LUW, Microsoft SQL Server, Sybase, IMS, and CA-Datacom data base administration for a large life insurance organization,
  • Conducted performance measurement and capacity planning activities.
  • Created and maintained backup, recovery, and maintenance procedures.
  • Evaluated DBMS-related application changes and recommended improvements in SQL calls and web-based service requests.
  • Installed, configured, and converted databases and software to new releases.
  • Information integration in Windows and AIX Server environments.
  • Provided 24 by 7 on-call support for the Database Administration area.

Systems Software Consultant

Serving the AFP Division of AEGON Americas, Kansas City MO

  • Performed IMS and DB2 data base administration for a large life insurance organization,
  • Conducted performance measurement and capacity planning activities.
  • Created and maintained backup, recovery, and maintenance procedures.
  • Evaluated DBMS-related application changes and recommended improvements in SQL calls and web-based service requests.
  • Supported WebSphere MQ, WebSphere Message Broker, DB2 LUW, and DB2 for z/OS.
  • Information Integrator in a Windows Server environment.
  • Provided 24 by 7 on-call support for the Database Administration area.

Systems Software Consultant

  • Provided IMS data base administration services to a large corporation providing stock and security processing services.
  • Performed system generation, definition, and implementation activities for IMS/DB and IMS/TM, including support of High-Availability Large Data Bases HALDB .
  • Provided z/OS Assembler Language and COBOL programming support for in-house developed database system exits and utilities.

Systems Software Consultant

  • Provided design and programming for IBM mainframe and midrange applications including CICS, DB2, IMS, and COBOL for a large agency of the State of Missouri.
  • Provided database design and modeling assistance in constructing a new statewide application system.

Senior Data Base Systems Programmer

  • Provided design, programming and debugging support for IBM mainframe applications including CICS, DB2, and COBOL.
  • Installed, maintained, and supported all mainframe DBMS software including IBM DB2 for z/OS, DB2 LUW, CA-Datacom, and CA-IDMS.
  • Installed, maintained, and supported all mainframe messaging and ETL software including IBM Websphere MQ and DataMirror Transformation Server.
  • Installed, maintained, and supported all mainframe DBMS-related utility and monitoring software including BMC Utilities for DB2, BMC Mainview for Websphere MQ, BMC Patrol for Websphere MQ, CA-Insight, Erwin, PowerDesigner, and Compuware File-Aid for DB2.
  • Provided z/OS Assembler Language programming support for in-house developed DB2 Call Attach Facility, DBMS Utilities, and system exits.

Systems Software Consultant

  • Provided design and programming for IBM mainframe applications including CICS, DB2, IMS, COBOL, Websphere MQ, VTAM, TCP/IP and Assembler.
  • Provided programming, DBA, and DA services as required by life, property/casualty, and health insurance brokers.
  • Provided design, development, and support to insurance brokers and health care providers as an independent contractor.
  • Provided customized programing solutions for mainframe and micro-based systems in business office environments.

Data Base Analyst

  • Designed, programmed, and implemented data access facilities for CICS and IMS programs needing data from IMS data bases and DB2 tables. These programs, consisting of over 100 modules, are used by most major application systems in the Local Telephone Division for Customer Billing, Accounts Receivable, Telephone Equipment, and Telephone Facilities applications.
  • Documented user requirements and wrote program specifications in support of batch and on-line programming assignments.

Senior Software Engineer

  • Provided consulting services to Sprint designing and programming a middleware data layer to isolate CICS and IMS application programs from direct access to IMS data bases. Components of the system included batch COBOL, CICS, IMS/DB2, and Assembler programs as well as micro-based maintenance components written in C .
  • Designed and programmed cross-systems interfaces for CICS and IMS applications using DB2 and Websphere MQ facilities.
  • Documented user requirements and wrote program specifications in support of batch and on-line programming assignments.

Vice President

  • Led programming teams to design, develop, and maintain commercial property/casualty and group life systems in a multi-platform environment including both mainframe and micro-based systems. Mainframe on-line programming for property/casualty and group life systems utilized COBOL, CICS, and VSAM.
  • Led design and programming efforts for the development of CICS on-line surety systems for the largest provider of surety services in the United States.

Informatica Technology Consultant

  • Designed, programmed, and implemented health insurance software using COBOL, CICS, and IMS/DB for a large Eastern U.S. Blue Cross and Blue Shield company.
  • Met with client personnel and documented user requirements as functional and technical specifications.

Director, Technical Support and Application Systems

  • Oversaw the acquisition and implementation of a new Information Technology department serving multiple hospitals and clinics.
  • Wrote and implemented design and programming standards.
  • Supported CICS/TM and IMS/DB in a 24 by 7 real time environment.

DataCenter Manager

  • Managed fifty data center personnel in a 24 by 7 environment.
  • Supported Information Services processing for all U.S. and overseas subsidiaries of Baxter Travenol.

Senior Systems Programmer

  • Installed and maintained infrastructure software products such as MVS, IMS, and CICS.
  • Worked with IMS DBA's to configure and install real-time application data base environments.
  • Initiated changes that allowed the Data Center to exceed all response time and availability service level goals.

Hire Now