Database Administrator Sql Server
Resume:
Scott Summerour
ILLINOIS 60448
***********@*****.***
https://www.linkedin.com/in/sgsummerour
Summary
My primary expertise for the past 24+ years has been as a SQL Server Database Administrator. Highly skilled at designing, upgrading, tuning, and automating database infrastructures. I have extensive experience in administrating large number of SQL Servers and databases including installation, configuration, optimization, performance tuning, backup/restoration, log shipping, replication, clustering, partitioning, security administration, database mirroring as well as Always on Replication and encryption of sensitive information.
EXPERIENCE
Database Administrator 4 / Sr. Database Administrator June 2015 – December 2024
Kemper Insurance / American Access, Downers Grove, Illinois
Lead DBA for America Access until the Kemper buyout when I transitioned to the DBA team. My primary responsibilities were to keep the production, QA, staging and development environments of more than 600+ SQL Servers ranging from SQL 2008R2 to SQL 2022 servers with over 5000+ databases ranging in size from 15TB to 100MB, in high transactional environments at peak performance. Installed and configured SQL servers with or without clustering. Tested and migrated on premises databases and servers to Azure using both online and offline methods. Depending on the environment, size of the database and collected performance data resulted in which type of Azure to use, Azure SQL Managed Instance, SQL Server on Azure Virtual Machine or Azure SQL Database. Due to vendor requirements a couple Azure SQL Databases had to be moved to a Azure SQL Managed Instance. After the buyout by Kemper, all Azure databases had to then moved to AWS cloud servers in an EC2 instance. Migrated on premises servers to AWS cloud servers in an EC2 instance. Used various AWS tools to track and maintain a healthy AWS environment. Performed server type changes and drive space increases to AWS EC2 instances when needed. Implemented SQL 2019 Always on Availability Groups to handle main mission critical databases to provide 24x7 up time environments. Planned and executed routine maintenance plans to keep indexes and statistics at optimum levels. Implemented custom scripts to check server health and activity. Setup Always on Replication between production and reporting servers to keep traffic at a minimum for web facing production databases and perform database maintenance task on a read only node. Developed a replication process using Change data capture to reduce overnight processes. Worked with off shore personal to maintain a 24x7 support for all SQL Servers. Used third party tools and built in SQL DMV and extended events to diagnose issues within SQL. Used SolarWinds Orion and DPA to help monitor and alerting of potential issues. I provided support to all departments within Kemper/American Access by responding to all request in a timely manner. Worked in an on call rotation to deal with incidents and issues that arose. Met our SLA for core business needs by using Service Now to handle user change request and incident management. Provided solutions for security settings and setup database roles to limit access to sensitive data to authorized personal. Worked off hours support for projects or updates to various applications across Kemper to limit downtime during key business hours. Became proficient in various application in Redgate tool belt. We also used Idera Compliance manager to send alerts when highly sensitive data was accessed. Setup different levels of encryption to insure the data couldn't be readily accessible. Transparent data encryption (TDE) was used for on premises database servers to insure database files couldn't be copied and accessed without the proper keys and passwords. Cyberark was used to store all service account and SQL ID's passwords. Collaborated with data analysts and business users to define data needs and translate into actionable insights. Implemented data warehousing solutions to facilitate centralized data storage and analysis. Created and maintained user views and stored procedures to streamline data access and reporting processes. Participated in system design discussions, contributing expertise to ensure database solutions meet user needs. Implemented robust security measures to protect sensitive data from unauthorized access and cyber threats. Monitored system resources, including memory usage, CPU utilization, and disk space, and took corrective action when needed to maintain optimal performance levels. Implemented security measures to protect sensitive data stored in the databases from unauthorized access or manipulation of information.
Senior Database Administrator, DBA Team Lead December 2011 – June 2015
Rewards Network, Chicago, Illinois
DBA team lead with primary responsibilities for the production, QA, staging and development environments of more than 83 SQL 2000/2005/2008R2/2012 servers with over 600 databases ranging in size from 4TB to 100MB, in a high transactional environment. The average database size is approximately 400GB. Installed and configured SQL servers with or without clustering. Implemented SQL 2012 Always on Availability Groups to handle main mission critical databases to provide 24x7 up time environments. Also configured SQL cluster for internal application databases. Planned and executed routine maintenance plans to keep indexes and statistics at optimum levels. Developed scripts using Dynamic Management Views (DMV’s) to check server health and activity. Developed SSIS packages and stored procedures to handle new data feeds from vender sources. Maintained and upgraded stored procedures, DTS and SSIS packages for new projects. Implemented Common Table Expressions (CTE) in current stored procedures to run more efficiently. Setup replication between production and reporting databases to keep traffic at a minimum for web facing production databases. Configured replication and SSIS packages for data warehousing. Upgraded production, QA, staging and development servers from SQL 2000/2005 to SQL 2012. Provided 24x7 on-call support. Used third party software from Quest for monitoring of SQL servers.
Senior Database Administrator March 2007 – December 2011
MF Global Inc., Chicago, Illinois
Primary responsibilities as the sole production DBA in a high transactional environment which contains 100+ SQL servers with over 900 databases ranging in size from 9TB to 100MB.The average database size is approximately 200GB. Installed and configured SQL servers with or without clustering. Configured SQL cluster for mission critical application to provide 24x7 up time environment. Updated all SQL servers to the latest service packs and hot fixes. Planned and executed routine maintenance, including backup and recovery in SQL server. Created and maintained jobs and maintenance plans for databases backups, re-indexing and updating statistics. Responsible for database tuning, creation and design. Migration from SQL server 2000 to 2005 and 2000/2005 to 2008/2008 R2 by using in-place/side-by-side upgrades process, and documented the upgrade process. Setup Database log shipping and database mirroring for mission critical databases to our disaster recovery locations. Administer SQL server security using SQL and Windows authentication and setup proxy accounts to grant certain permission. Configured Linked server for the ability to run ad hoc queries and migrate data. Involved in day to day monitoring of SQL Server jobs failures, error logs, space usage, and security. Created the documentation for database policies and procedures. Provided after hours and 24/7/365 database support. Implemented a change control process for migrating changes from development to test to production. Configured SQL servers to comply with Sarbanes–Oxley Act. Used third party software, Lite Speed, Idera suite and Red Gate, for SOX compliance, backup compression and monitoring. Worked with server team to configure and design SAN for databases storage.
Senior Database Administrator April 2001 – February 2007
Fidelity National Information Services / Harris Bank, Chicago, Illinois
Performed duties as sole production DBA at Harris Bank Mortgage division. Monitored production, development and test SQL servers. Installed and configured SQL server 7.0/2000/2005. Updated all SQL servers to the latest service packs. Performed routine maintenance, including backup and recovery in SQL server. Created and maintained jobs and maintenance plans. Setup data warehousing using Microsoft SQL OLAP services. Responsible for Database tuning, creation and design. Migrated or updated servers to newer version of SQL. Setup Database log shipping and database mirroring for mission critical databases to our disaster recovery locations. Administer SQL server security using SQL and windows. Involved in day to day monitoring of SQL Server jobs failures, error logs, space usage, and security. Created the documentation for database policies and procedures. Provided after hours and 24/7 database support.
Lead Database Administrator June 2000 – March 2001
Computer Sciences Corporation, Chicago, Illinois
Setup, administer and maintain Microsoft Windows SQL Server 6.5 and 7.0. Responsible for maintaining 32 SQL servers. Responsible for migrating databases from a lab and development environment to production environment. Performed backups and restores of databases. Created both clustered and non-clustered indexes to boost performance. Created triggers to insure data integrity. Troubleshoot problems with stored procedures and VBS scripts. Migrated data using Microsoft Data Transfer Service. Setup data warehousing using Microsoft SQL OLAP services. Setup users’ permissions on databases. Setup database maintenance plans. Setup alerts to automatically dump the transaction logs when they reached 50%. Designed and developed logic for relational database. Applied service packs as needed.
Solutions Developer & Database Administrator July 1999 – July 2000
Segall, Bryant & Hamill Investment Counsel, Chicago, Illinois
Responsible for the development and deployment of custom in house software to manipulate investment related data. Developed application using Visual Basic as the front-end user interface and Microsoft SQL Server or Microsoft Access as the back-end relational databases for data storage. Maintaining and updating Equity Trade Order Routing and Management System utilizing SQL Server and Visual Basic. Maintaining and updating Electronic Portfolio Reconciliation System utilizing Microsoft Access and Visual Basic. Maintaining and updating Client Billing/Account Receivable Tracking System utilizing Microsoft Access, SQL Server and Visual Basic. Maintaining and updating Client Trade Confirmation/Monthly Statement Reporting System utilizing Microsoft Access. Developed custom in house applications using Visual C++ 6.0. Trouble shooting problems with Microsoft products.
Systems Engineer, I/T Specialist October 1998 – July 1999
Silicon Plains Technologies, Des Moines, Iowa
Responsible for the development, setup and rollout of different types of Windows NT 4.0 server based networks including the following: System Management Server 2.0, Terminal Server with Citrix Meta frame, Exchange 5.5, Internet Information Server 4.0, SQL Server 6.5 and Proxy 2.0. Performed duties as team leader in development, setup and rollout of projects. Performed duties as system administrator. Responsible for interfacing with clients, updating them on project status. Responsible for backing up the companies’ servers using Backup Exec. Assisted in the company’s intranet development and deployment. Setup networks in both routed and switched network environments. Setup and deployed a thousand-node network.
Systems Resource Manager November 1996 – October 1998
Swanson Companies, Jacksonville, Florida
Systems administrator for 23 different computer networks throughout Florida and Georgia. Responsible for maintaining and upgrading company software and dBase III files and data. Responsible for upgrading and repairing workstations and servers. Responsible for training personnel in use of company software and operating systems. Extensive knowledge of installation and upgrade for the following operating systems including DOS, Windows 3.1, Windows 3.11, Windows 95 and Windows NT 4.0. Interacting with clients in complex situations resolving technical problems in a timely and efficient manner.
Explosive Ordnance Disposal Specialist March 1992 – March 1996
United States Army, Fort McCoy, Wisconsin
Assistant Team Leader. Responsible for over ten million dollars’ worth of equipment. Supervised other soldiers in explosive cleanup operations. Coordinated explosive operations with local, state and federal agencies. Held a Top Secret Clearance with a sensitive background investigation. Assisted in the set up and upgrade of a computer system. Set up unit training on new computer systems for modernizing unit training and reporting procedures.
EDUCATION
Electronic Engineering March 2013 – July 2015
DeVry University, Chicago, Illinois
Computer Science January 2000 – December 2003
DePaul University, Chicago, Illinois
Physics January 1989 – December 1992
Illinois State University, Normal, Illinois
Skills
SQL 6.5 - 2022
SQL profiler
Query Analyzer
Index Analyzer
SQL Server Management Studio
MS Office Suite
Shell scripting
Visual Basic
Windows Server 2000/XP/2003/2008/
2016/2022
Backup & Recovery
Database Security
Database Designing and Query Optimization
Data Transformation Services
Manipulating Schemas, Tables, Indexes, Views and Triggers
Log Shipping
Data Extraction Using DTS and SSIS
T-SQL Programming
Using CTE’s
SSRS, SSAS and SSIS
Creating Packages, Jobs and sending Alerts using SQL Mail
Production Support for Database and Applications
Tuning SQL Queries
Data Warehouse Analysis, Design and Implementation.
Database Migration and Upgrade
Change Data Capture
Core Database Administration.
Installation, Upgrade and configuration
Implementing Snapshot, Merge and Transactional Replication
Redgate software suite
Idera Database Tools
Contact this candidate