Database Administrator Sql Server
Resume:
ROBERT W. MILLIS
Etters, PA ***19
717-***-**** ***********@*******.***
PROFESSIONAL SUMMARY
SQL Server Database Administrator with over 24 years of experience in database management and administration. Certified Microsoft SQL Server DBA with a proven track record of delivering robust, customized solutions to complex technical challenges. Recognized for strong communication, analytical, troubleshooting, and interpersonal skills. A collaborative team player and effective leader, known for mentoring fellow DBAs and enhancing team capabilities in product knowledge and problem-solving.
PROFESSIONAL EXPERIENCE
Rite Aid Pharmacy, Etters, PA 2017 – 2025
Senior Database Administrator
Led the SQL Server DBA team by assigning tasks and projects, providing ongoing guidance, and serving as a key technical resource.
Mentored junior DBAs to enhance their product knowledge, troubleshooting capabilities, and overall professional development.
Designed and implemented customized business processes and database solutions to meet evolving organizational needs.
Proactively monitored database systems and processes to identify and resolve performance issues before they impacted operations.
Architected high availability SQL Server solutions using Always On Availability Groups and failover cluster instances.
Supported and facilitated the migration of SQL Server environments to cloud-based infrastructure.
US ROAD RUNNING, Manchester, PA 2015 – 2017
Partner/Owner
Brought in as a partner to a small business to takeover and run the technical side of the company.
Designed and created a new database to be the foundation of a new company eCommerce site.
Designed, implemented and wrote an eCommerce site with multiple API connections to other sites including printing mailing labels, processing credit cards through a clearing house, and social media networks.
Designed, created and wrote an app for US Road Running that can be used on the Android and iPhone platforms. The app integrates with our website and tracks our user’s virtual races using GPS functionality on the phone and then uploads the results back to the website.
Managed, directed and organized US Road Running live race events including the management of numerous employees, volunteers, and worked with local officials and police in obtaining all necessary permits.
Managed and directed employees for other clients that hired us to perform the timing functions for their running events.
MODIS, Mechanicsburg, PA 2014 – 2015
Senior SQL Database Administrator
Worked as a consultant for a contract position for the State of Pennsylvania, Department of Corrections for an integral part of a new software rollout.
Designed and implemented an upgrade process for migration to a newer version of SQL Server for the new software rollout.
Met with key business leaders and managers to instill confidence and buy in for the new software.
Worked with the state employed DBAs to help train and educate with the new SQL platform.
SOURCE INTERLINK, Harrisburg, PA 2012 – 2014
Senior SQL Database Administrator
Designed and configured high availability solutions between multiple data centers and sites.
Overseeing an offshore database consultant group to help maintain and optimize all SQL servers in the companies’ environment.
Periodically reviewed the database systems to verify that we are following the best practices and company procedures.
Implemented a new monitoring system that allowed the DBAs to monitor system growth, available drive space, basic server measurements (ex. CPU utilization, memory, disc IO…) and system availability.
Designed upgrade paths for older versions of SQL server and implemented service packs and hot fix when appropriate.
Created and developed PowerShell scripts to monitor and automate certain DBA functions and collect critical server information.
Backup DBA for Oracle systems.
LANCASTER GENERAL HOSPITAL, Lancaster, PA 2006 – 2012 Senior SQL Database Administrator
Ran, maintained, and customizes a large vendor designed ETL process to load data into our main reporting system at the hospital.
Created custom ETL processes using SQL tools like SSIS, SQL scripts, and PowerShell to move data around as needed.
Researched, analyzed and developed a partitioning strategy on a reporting database that had a table with over 2.5 billion rows; efforts improved query response times.
Helped develop a drug alerting check mechanism which validates data between two systems, alerting for inconsistencies that might result in patient harm: decreasing medication administration errors.
Designed and implemented new software packages to help enhance the business units.
Worked with vendors and users to overcome performance issues that caused a decrease in productivity to the business unit.
Contributed to the EPIC system conversion project and gained proficiency in the Clarity reporting module to support healthcare data analysis and reporting.
Worked with LAN to design and implement a total server recovery for disaster recovery with all corresponding documentation.
Coordinated, scheduled and implanted with project leaders for maintenance and software upgrades that occurred after hours.
NEIGHBORCARE, Baltimore, MD 2005 – 2006
Senior SQL Database Administrator
Created and implemented all backup and recovery strategies for databases on each SQL Servers.
Worked with application support to identify, correct, and improve query response times and application slow down.
Responsible for a new installations and software updates on all SQL Servers.
Responsible for monitoring SQL Servers and performing the necessary maintenance tasks to keep a SQL Server optimized.
Moved servers and applications from our old data center to the new one. Was responsible for interfacing and scheduling the move of all servers where the application depended on SQL Server.
POMEROY, Harrisburg, PA 2001 – 2005
Database \ Systems Administrator
As a consultant worked as a Microsoft SQL Programmer, Database Designer and Administrator.
Worked with department heads in gathering knowledge and procedures to run conversion programs for data migration.
Wrote stored procedures, triggers and conversion programs for data migration.
Worked with DTS with the conversion programs to import and populate database tables.
Worked with IT department and analysts to improve performance and response times with database queries.
Worked with department heads and analysts in designing new database structures and new specialized reports.
Designed and developed web based applications in Microsoft .NET using C#.
Created custom internal .NET application.
Helped fellow programmers integrate web base .NET applications to use the full power of Microsoft SQL server.
Designed and developed Data Warehousing solutions using SQL Server analytic OLAP services.
CERIDIAN. Exton, PA 2001 – 2001
Systems Administrator
Designed SQL 2000 Databases.
Installed and configured SQL 7.0 and SQL 2000 Servers.
Wrote queries and helped Programmers.
Backed-up, restored and provided general maintenance of SQL Servers.
Imported and exported with DTS.
Assisted IS Department.
Contact this candidate