SQL Server Database Administrator Resume

SUMMARY:

Data Management Analyst/Database Administrator with over twenty years technical and managerial experience maintaining computer systems and Microsoft SQL Server databases.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

Installation, configuration, upgrading and migration of SQL Server software and databases
Managing and administering over twenty five SQL Server production and development servers
Maintaining database security and permissions
Documenting the current configuration of all database servers
Disk storage and capacity management and planning
Performing database maintenance and installing service packs and updates
Responding to all database problems and outages
Executing database backup and recovery processes
Responding to all database help desk ticket requests
Participating/advising in the planning for a new Offender Management System

Confidential

SQL Server Database Administrator

Responsibilities:

Supported several critical Department of Defense SQL Server database system workloads
Led an effort to update several database servers from SQL Server R2 while migrating user databases to new hardware
Provided daily maintenance support to all assigned database system workloads
Worked closely with system administrators to troubleshoot Windows system problems on database servers
Installed database management system service packs and upgrades
Performed security manager functions for all assigned database system workloads
Ensured all databases met stringent DOD security requirements by performing security hardening procedures on each database
Participated in weekly teleconferences with customers to discuss and plan upgrades to their workloads
Monitored storage space utilization and made recommendations for improvements
Provided after hours on - call support and responded to all help desk calls

Confidential

Database Administrator

Responsibilities:

Worked with health care, dental, and vision vendors, along with state agencies, in the exchange of their data files with EBC
Coordinated data file format changes with external agencies and vendors
Imported/exported data files between EBC and all external users
Encrypted and decrypted data files to ensure the successful exchange of all files between EBC and their external users
Maintained SQL Server databases for the web-based benefits administration system (BAS)
Installed application software upgrades
Tested application software and SQL Server database upgrades
Modified the BAS database tables with new parameters for each new option period
Wrote ad-hoc database queries to provide data requested by users
Responded to all database problems
Performed database security manager functions
Worked with the software vendor to troubleshoot/resolve application problems
Responsible for database backup and recovery procedures
Responsible for moving current production data to/from development and test environments

Confidential

Data Management Analyst

Responsibilities:

Performed backup/restore functions and file maintenance on the database
Installed software updates on client PCs that accessed the accounting system server
Worked with the software vendor to troubleshoot software problems on client PCs
Responded to database problems and provided technical advice to users
Worked with SQL Server versions 6.5 and 7.0
Developed and maintained applications with MS Access
Developed reports for users utilizing Crystal Reports report writer

Confidential

Data Management Analyst

Responsibilities:

Responsible for supervising and managing the operation of Sybase SQL Server databases
Developed policies and procedures for performing database maintenance
Converted Sybase SQL Server databases to Microsoft SQL Server
Developed queries to retrieve Toll Collection data
Installed database upgrades
Backed up and restored databases
Responded to database problems