Database Administration

Experience:  2 Years

Database Administration Responsibilities

Maintained data dictionaries and maintenance plans for all databases. Performed report writing tasks with raw SQL, Crystal Reports, and application-specific report generation tools. Performed all OS and database service pack deployment and database / data structure upgrade procedures. Performed database restores and "roll-forwards" from backups and transaction logs. Performed traces and performance tuning for databases. Was member of all system upgrade teams where database had tasks associated with the upgrade. Worked with on-site consultants when major system upgrades occurred.

With few exceptions, the above-listed responsibilities apply to all of the following Databases/Applications:

Database System Application Associated with Database
Microsoft SQL Server 7.0
bulletMcKesson's Pathways Home Care
bulletMcKesson's Electronic Claims 2000
bulletESP - Employee Shift Scheduling
bulletHES - Employee Education Software
bulletIn-house Developed Abstract Archive
bulletDBA - Utility/Test Database
Microsoft SQL Server 6.5
bulletMcKesson's Pathways Materials Management
bulletMcKesson's Pathways Financial Management
Oracle 8 Enterprise
bulletADP - HR Perspective
bulletPC Payroll for Windows
Oracle 7 Enterprise
bulletMcKesson's Care Manager
Sybase 12 Adaptive Enterprise Server
bulletMcKesson's Pathways Contract Management
DG/UX Mumps Database
bulletMcKesson's Star System
MySQL on Linux
bulletIn-house Developed Help Desk
bulletIn-house Developed Employee Status
bulletIn-house Developed LAN/WAN Database
Microsoft Access 9x/2000
bulletTo many to mention

CLICK THE [Back] BUTTON ON THE BROWSER WINDOW TO RETURN