We provide IT Staff Augmentation Services!

Dba Resume

5.00/5 (Submit Your Rating)

Columbia Sc Dba Columbia, SC

SUMMARY

  • Resourceful and dedicated professional consistently recognized for excellent technical skills, listening, assessment, persuasiveness, and customer service.
  • Known as a self - directed, flexible worker wif a strong desire for success. Offering over 25 years in Information Technology wif experience in Database Design,
  • Technical Support and Database Administration. Also served as Project Management and Application Team leader over DB technical support center for 5 years.
  • Involved in installation of multiple vendor packages in a highly complex mainframe environment. Providing 24/7 support for DB2 systems.
  • Technical Support
  • Problem Solving / Troubleshooting
  • Customer Service / Support / Training
  • Software Development / Testing / Support

TECHNICAL SKILLS

Systems: Z/OS, Windows, AIX

Databases: DB2 Z/OS (Data Sharing as well as non Data Sharing) and UDB

Languages: SQL, JCL, COBOL II, DL/I, DDL, DML, C, REXX, PACBASE

Utilities: IBM, BMC DB2, CA, Quest for DB2/UDB, IDAA, Omegamon,QREP

Applications: SPUFI, SDSF, Word, Excel, Outlook Express, Abendaid, Fileaid, ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

DBA

Responsibilities:

  • Worked on testing of DB2 from version V10 to V11.
  • Provided 24/7 support for DB2 Z/OS applications.
  • Developed multiple REXX applications/utilities to support DB2 reporting, status and problem resolution.
  • Worked on QREP Unidirectional Replication for multiple databases.
  • Worked on reducing high DB2 CPU programs utilizing indexes, virtual indexes, CA Detector, SYSVIEW and EXPLAIN.
  • Utilized BMC Recovery Utility to restore large tables to multiple subsystems.
  • Utilized SYSVIEW to monitor application system testing.
  • Utilized BMC CHANGE tools to propagate changes from QUAL to production.

Confidential, Montgomery, AL

DBA

Responsibilities:

  • Worked on the upgrade and testing of DB2 from version V9 to V10.
  • Performed DBA functions including developing, creating and maintaining DB2 objects.
  • Partitioned large tables to increase efficiency and performance on selected databases.
  • Worked on converting DB2 Tablespaces from segmented to Partition-by-Growth Tablespaces.
  • Set up a process to refresh DB2 test and user environment wif production data on a weekly basis.
  • Supported installation of Data Studio on Application users workstations.
  • Worked wif installing and supporting Shadow Client on user desktops which is a connectivity tool used to access DB2 Z/OS.
  • Worked wif programmers on system and SQL performance issues.
  • Supported Oracle databases in a secondary role on the Zlinux environment.

Confidential, Minneapolis, MN

Senior DBA

Responsibilities:

  • Performed DBA functions including developing, creating and maintaining DB2 objects.
  • Partitioned multiple tables to increase efficiency and performance in a complex database.
  • Performed backups recoveries and reorganizations of databases.
  • Utilized BMC and IBM utilities to develop strategy for recovery of DB2/VSAM systems. Overcame the problem of the system not being checkpoint restartable.
  • Assisted and implemented strategy for Minneapolis office to reduce the need for SYSADM in production for DBAs.
  • Provided 24/7 system support for DB2/IMS systems.
  • Assisted wif DBMS enhancements and testing of new releases.
  • Primary security representative for DBAs in unit-approved and investigated problems related to DB2 own objects and libraries. Reviewed changes to DBA security for ACF.
  • Maintained and updated DB2 Handbook for programmers at Ameriprise.
  • Led the DBA Support Group, which involved assigning a DBA as a point of contact for processing work or receiving calls from the application groups. Responsibilities included handling general questions and acting as a point of first call for problems/.
  • Assisted programmers wif resolving SQL performance bottlenecks in their programs.
  • Implemented multiple systems into production
  • Primary DBA wif responsibilities for companies life insurance products.
  • Acted as Lead for DB Strategy and Direction on Vantage, DB2 SME, and DB Security Administration.
  • Worked on UDB Projects using version 8 and 9.
  • Utilized Quest for DB2, DBArtisan and Quest Spotlight to develop, monitor and implement UDB Systems.

We'd love your feedback!