Sr. Database Administrator Resume Addison, TX - Hire IT People

SUMMARY:

Self - motivated database administrator proficient in developing stored procedures, trouble-shooting performance issues and documentation standards. Strong background in backup and disaster recovery processes and database documentation. Highly competent in the installation and configuration of SQL Server 2008, 2012, and 2014 virtual and clustered servers.
Standardized data extraction processes to improve SSIS package efficiency and portability.
Designed a dynamic documentation solution to gather application/interface information from 900+ databases, utilized by the entire I.T. department.
Initiated and implemented monitoring standards for production, model and test database environments via SolarWinds.
Built interfaces from various applications into SQL Server
Created SSIS package to collect high level SQL Server information for inventory and trend analysis.
Coordinated database application migrations involving leveraged and dedicated servers.

PROFESSIONAL EXPERIENCE:

Confidential,Addison, TX

Sr. Database Administrator

Responsibilities:

Implemented standard database backup and maintenance plans, which included monitoring and documentation
Redesigned disjointed data extraction process to be highly efficient and portable
Built and modified Kronos interfaces to/from SQL Server
Designed and implemented an automated solution to gather application and interface documentation polling 150+ SQL Servers and 900+ databases.
Diagnosed query performance issues leveraging various scripts to analyze I/O bottlenecks, re-compilation frequency and missing indexes
Created documentation templates to be used for database and ETL processes
Implemented low level monitoring of application services using PowerShell

Confidential,Plano, TX

Sr. Database Administrator

Responsibilities:

Provide database support for over 50 database servers, including production, model, test and development environments.
Assisted in the development of custom maintenance scripts including tracking database growth trends and collecting database server statistics for performance trend analysis.
Develop and maintain ETL processes (using SSIS) to import and export patient and financial data, including logging and archiving processes.
Provide troubleshooting documentation for non-standard and complex database processes.
Initiated and developed Change Request process for production and test environments.
Implemented and maintained security standards and permissions for developers and application user ids.
Work with external vendor and internal Server, Storage and/or Network teams to resolve database server issues.
Assisted vendors with database change processes and script deployment.

Confidential, Plano, TX

Database Administrator

Responsibilities:

Provide database support for over 20+ critical database servers, including production and test environments.
Assisted in the development of custom maintenance scripts including smart reindexing and database backups.
Created standard backup and maintenance plans for Medical Records program.
Provide assistance in performance tuning of queries and stored procedures.

Confidential,Plano, TX

Jr. Database Administrator

Responsibilities:

Developed and maintained HR related database application used by CIO’s at 60+ hospitals.
Managed SQL code and schema change promotion for HR and Payroll database applications.
Responsible for weekly payroll processing which involved manipulating replication processes.