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.