SUMMARY:

• Over 10 years of experience as a Production SQL DBA (SQL Server 2008R2, 2012, 2014, and 2016), installing instances, features and service packs, as well as testing new versions.
• Maintaining databases, indexes and statistics.
• Monitor server performance across servers for DBA database, later analyzing this data later for alerts, reports, and actions.
• Administrative experience also extends into usage of third party tools for performance monitoring and tuning such as Idera Diagnostic Manager, Spotlight on SQL, Red Gate Toolbelt, Brent Ozar s First Responder kit and other vendor tools as needed.
• Work in SQL server environments in healthcare, and areas supporting food industries.
• Work with the server team to recommend the best server set up/configuration for SQL Server.
• Work large environments as a DBA in charge of monitoring and maintaining production SQL Servers. Also assisted in the determination of the requirements for new SQL Servers.
• Take on projects involving research software solutions to problems.

WORK EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

• First DBA for over 30 applications
• Troubleshoot problems with jobs, backups, linked server, other objects
• Migrate databases from SQL Server 2008r2 to 2012 or 2016
• Migration of databases to new datacenters
• Work with database mirroring and AlwaysOn for HA and DR.
• Deploy code and SSIS packages during business hours and during outages
• Monitor performance of databases and SQL Server
• Maintaining documentation of request fulfillment processes, and other repeatable processes.

Confidential

SQL Server Database Administrator

Responsibilities:

• Work the SQL Server queue to pick up database hosting tasks.
• Run PowerShell scripts to create databases/jobs/operators on hosting servers.
• Join databases to AlwaysOn group.
• Work with Application DBA’s to troubleshoot issues with hosting and to clarify requests and/or to inform about new upgrade paths.
• Maintaining documentation of request fulfillment processes, and other repeatable processes.

SQL Server Database Administrator

Confidential, Charlotte, NC

Responsibilities:

• Create new instances of SQL Server on new servers. Add instances to servers. Install service packs. Add features to existing instances. Test out new service packs and SQL versions on DBA machine. Migration of SQL Server 2008R2 to 2014.
• Database, index, and statistic maintenance.
• Monitor servers using third party tools such as Idera Diagnostic Manager, Idera SQL Doctor, Precise, Spotlight on SQL Server, Apex SQL Monitor.
• I have also used the Central Management Server feature to query all servers in a group to obtain information on databases without recent backups, databases with the wrong backup mode, number of connections to a database, database growth, among other. These results were then turned into email reports.
• Respond to user requests for backups, moving and restoring databases on new servers, including logins, users, permissions - including securables.
• Run developer scripts as requested.
• Create script for gathering data to monitor server and databases configurations and performance.

SQL Server Database Administrator

Confidential, Blue Bell, PA

Responsibilities:

• Monitor 8 servers (SQL 2008R2) by gathering data on server performance, disk space, I/O pressure, memory pressure.
• Monitor database growth, database memory usage, track wait stats, track I/O pressure, failed jobs, and any other measurements that came up.
• Responding to JIRA tickets to move databases, stand up new databases, or solve issues concerns existing databases, code and disk space.
• Use of scripts to create reports for clients and put them up on SFTP sites for client retrieval.
• Use of T - Sql to create jobs and e-mail alerts.
• Testing out and using new software was also a part of my duties. We used various Apex products such as Diff and DataDiff. I also used the Idera toolset of free software, which are extremely useful. Whenever possible I use Idera's Diagnostic Manager for Server Monitoring, for its ability to maintain historical data.
• I set up my own Monitoring database so that I could gather data over time, and compare results from different time periods.
• Tested out software for Change Auditing, Scripting across Multiple Servers, Server Monitoring, and other software I thought could be useful when it comes to making our servers more stable and our ability to be proactive about issues easier.

Vice President/Data

Confidential, Destin, FL

Responsibilities:

• Property searches, pricing out rehab costs vs expected returns
• Draw up proposals for potential investors
• Create project brochures
• Create the database and front - end for the company contact information

SQL Server Database Administrator

Confidential, Chattanooga, TN

Responsibilities:

• Develop jobs to monitor Production databases (SQL 2008) to develop a baseline for the different servers and databases.
• Find trouble spots and work on them from a proactive perspective, such as setting up maintenance jobs to handle fragmentation automatically.
• Document databases in Development, Staging and Production, assuring scripts were run on correct database and level, deploying script as requested.
• . Reviewed relevant database software to see if it would be of value. I reviewed software such as Idera Diagnostic Manager, Idera SQL Doctor, Spotlight for SQL Server, and Combine.

SQL Server Database Administrator

Confidential, Clearwater, FL

Responsibilities:

• Production database administrator in charge of monitoring and troubleshooting QA, UAT and Production SQL Server boxes. SQL Servers were a mix of 2005 and 2008 R2.
• Used a variety of tools both built into SQL, T - SQL, Profiler, and third party such as Spotlight, Idera Diagnostic Manager, Idera SQL Doctor, and Configio s Ignite.
• Troubleshoot and solve server issues, the problems covering such issues as configurations, indexes, code, and recompile.
• Document the SQL Servers assuring they all had the same configurations, noting differences to be addressed.
• Document databases and run comparisons of schemas.
• Deploy scripts as requested to proper level.
• Use SharePoint 2010 to uploaded documents related to projects or general files, and team knowledgebase.
• Use ticketing system to track and resolve user application (frontend, CRM, etc.) problems and database issues and requests.

SQL Server Database Administrator

Confidential, Blacksburg, VA

Responsibilities:

• Improve performance of SQL 2005 databases, ranging from 5 - 57 GB in size, spread across several clustered servers.
• Used T-SQL to gather statistics/metrics on current performance of databases and queries.
• Worked on indexes with a view toward creation, dropping and modifications to improve query performance
• Reviewed the server, database and code configurations to make sure each was optimized for the current load/usage type.
• Revised tables that were not normalized so that additional tables were created and all the resulting tables were normalized optimally.

SQL Server Database Administrator

Confidential, Deland, FL

Responsibilities:

• Monitoring and deploying code/scripts to over 1900 field (branch) using SQL Server 2005 on Windows 2003 servers, with databases that ranged in size from 3 to 50 GB at each location.
• Code was deployed across servers simultaneously using SQL Farms Combine. Combine saved change history to a repository for review and allowed for the dynamic creations of server containers dependent upon the requirements of the deployment.
• Duties included: daily monitoring via scripts against a repository to check on the server jobs (failed and long running), check for synchronization of tables across all servers, check unused indexes and review any DBCC CheckDB issues. Creation of scripts and jobs, using T - SQL to be run at the field servers to populate a central repository of server information about SQL configurations, IO data, query and cache information, unused indexes and other areas of interest. Created simple SSIS packages.
• Worked with storage/hardware personnel to work on server builds/configurations and the placement of disk space and in placement of files in a SAN environment.
• I also taught/mentored field server operations personnel how to manage standard SQL DBA functions such as restores, queries and script distributions, how to tell minor SQL issues from major ones.
• Responsibility to research, evaluate/test and do direct comparisons of SQL encryption solutions. Do final testing for the POC and evaluation testing for the preferred/recommended solution to meet HIPAA and HITECH requirements. The solution I suggested was the solution chosen and implemented.
• Use of repository information for the extraction of data concerning the impact of changes due to code/script deployments or actual changes to the SQL Server configuration such as memory.
• The company was required to follow HIPAA regulation and I had training in HIPAA compliance.
• On-call rotation for off hours and weekend work.