Sql Server Manager

Clifton Dunaway

** ****** **** *****

Simpsonville, SC 29681

864-***-**** (cell)

ac0ns4@r.postjobfree.com

SUMMARY

Summary Senior Database Administrator, and Project Manager in a wide variety of business applications. Particularly interested in client/server and relational database design using MS-SQL Server. Always interested in migration projects, as well as close interaction with the DB manufacturers. Creates custom reports using Microsoft SQL Server Reporting Services, including reports from SharePoint lists to run inside of SharePoint.

Technical Skills:

Databases: SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5, 6.0. SSIS, SSRS, SSAS, DTS, Oracle 10g, Oracle 11g

Operating Systems: Server 2016, Server 2012 R2, Server 2012, Server 2008 R2, Server 2008, Server 2003, Server 2000, Windows NT Server 4.0, Windows NT Workstation 4.0, Windows 10, Windows 7, Windows XP, DOS.

Applications: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 2011 – 4.0

Languages: Microsoft Visual Basic 2015, 2013, 2010, 2008, 2003, VB 1.0 – 6.0

PROFESSIONAL EXPERIENCE

The Gordian Group 02/2015 – 12/2016

Senior Production Database Administrator / Database Manager

I was hired to lead the DBA team, and to teach a junior DBA how to manage 22 SQL Servers properly.

I setup:

oFull, Differential, and Transaction Log backups

oDBCC checks

oVLF checks

oEmail alerts

I created several new clusters and 2012 Availability Groups

I worked with the developers to teach them how to use the listeners in the Availability Groups

I created a PowerShell script to setup SQL Servers when new ones are spun up from VMware

oWe now are at over 50 SQL Servers.

I perform monthly patching of the servers, as well as keep all the SQL instances patched with the latest service pack and CU (cumulative update).

I have taught our server admins about clustering and what that takes to keep them up and running reliably.

INFOR 08/2012 – 02/2015

Senior SQL Architect / Senior SQL DBA 05/2014 – 02/2015

I have been tasked with creating a new data center in the Amazon AWS site.

I created PowerShell scripts to install SQL Server 2012, Enterprise edition, and then customize the servers with this:

oCreate a Cluster,

oSet up Availability Groups

oSet up the Listener inside SQL Server.

Senior Systems Administrator / DBA Cloud Services 08/2012 – 05/2014

I was hired to be the Senior System Administrator and DBA in the SaaS (Software as a Service) group, to maintain twenty-three production SQL Servers with over three thousand databases.

My responsibilities include:

Ensuring all databases are up

Monitor server’s logs and resources

I setup transaction backups every ten minutes, and nightly full backups.

I monitor drive space, and increase the LUNS on the NetApp SAN as required to keep from running low on drive space.

.

Consulting / Contracting 01/2011 – 08/2012

Sage Automotive Interiors 07/2012 – 08/2012

Database Administrator

I was brought in to assist Sage with setting up their databases from a Data Center, to be controlled by a direct employee DBA. Since they did have a DBA, I was brought in to manage their databases and setup new policies for data security, performance tuning, and disaster recovery. Also, I was asked to setup a new set of 6 servers, to cluster two of them, and mirror data from the cluster to a third server. The other two servers are for SSRS Reporting

Greenville County School District 01/2012 – 07/2012

Database Administrator

I was contracted to manage the Oracle databases for the districts’ main application called Power School. I was responsible to monitoring, backing up, and replicating databases to other servers. I converted the database from Oracle 10g to 11g for upgrading their application to a new version. I also managed over 100 servers for the Power School application.

I converted SSIS packages that were running slow to a new 64-bit server. These then ran 80% faster. I created a new server with RAID 10 drives.

I created procedures on how to secure the databases and how developers should not have access to production servers.

I diagnosed a critical application that was running poorly, and was able to get it setup on a new server that I specified, and load SQL Server 2012 on it. I got it working excellently with a new SSIS package, and email notifications.

I maintain two clustered SQL Servers. I provide security policies, and disaster recovery. I have setup replication to a remote SQL Server for a production server.

Fluor, Greenville, SC 03/2011 – 12/2011

Senior SQL Server Developer

I was hired on a contract basis, to help the IT team to learn how to create the SSRS Reports to run in best practices.

I was the mentor for the reporting team

I did performance tuning for all major reports to improve execution performance

I was assigned sole responsibility for several major projects. I created a dozen custom reports that show information for projects that were being pursued. I also created many custom reports for personal Medical data in Afghanistan. I know how to setup security via Active Directory for only certain people and AD groups to see the reports.

I managed the SQL Server replications between production servers and development servers.

Worked with SSAS to develop Data Marts

I worked with clustered SQL Servers in order to maintain a 99.99 uptime system.

Avery Dennison, Clinton, SC 02/2011-02/2011

Contract Programmer

I was hired on a contract basis, to help the IT team catch up on updating Crystal Reports and updating VB.NET programs. I created a new application to send customers invoices.

Capsugel, Greenwood, SC 01/2011 – 01/2011

Contract SQL Programmer

Assigned to work at Capsugel on a short-term contract, to update 32 SSRS Reports. This was done under the time set for this, and under budget which made the management was very happy.

Acumen IT, Greenville, SC 02/10 – 01/11

Manager of Business Applications

Created many custom SSRS Reports for many clients against Microsoft Dynamics GP Databases using SQL Server 2005, 2008, and 2008 R2.

Customized many Microsoft Dynamics GP forms for clients.

Created SSIS packages for clients.

Setup SSRS Reports in SharePoint for clients. Setup SharePoint websites for clients.

Synesis International, Greenville, SC 01/06 – 02/10

Senior Systems Consultant/SQL Server DBA

Developed applications using Visual Basic.NET for use by many users in multi-site corporations.

Developed Web Parts for SharePoint.

Created SQL Server Integration Services packages to pull data from custom SQL Server tables, and push to multiple multi-line displays in several plants.

Performs SharePoint Administration and Customization.

Creates SQL Server Reporting Services Reports for use within SharePoint.

Implements a software package called ActivPlant in industries that is used to monitor production in real-time.

Contracted to be the DBA for Strategic Power Systems, in Charlotte, NC while they were searching for a new DBA.

Created SSIS Packages for Georgia Pacific saw mills in Mississippi and Texas to push data to displays throughout their facilities.

Extended Stay Hotels, Spartanburg, SC 03/05 – 01/06

SQL Server DBA

Was the sole SQL Server DBA for Extended Stay

Managed twenty production and ten development SQL Servers.

Responsibilities included creating a new security policy that would keep developers off the production servers, monitoring all SQL Servers to keep an eye on performance, connections, locks, etc., hourly transaction log and nightly full backups, management of a NAS to store the databases and backups, was the sole Visual Source Safe Administrator, mentored developers on best practices for writing code for SQL Server, performed index tuning, setup databases for mirroring and log shipping, managed databases over 1 TB in size, monitored real-time transactions from over 650 sites hitting the databases, monitored DTS jobs to ensure proper execution, Implemented and maintained database security, provided 24x7 support.

Provided the new Disaster Recovery procedures for Extended Stay.

Worked for 3 companies that were related: 02/01 – 03/05

Premier System Integrators (formerly Cernotec), Greenville, SC 09/03 – 03/05

Senior Systems Specialist

Responsible for implementing Antiplant solutions.

Managed the local VPN for the local users

Specified servers for SQL Server

Cernotec (division of Integrys), Greenville, SC 03/02 – 09/03

Senior Engineer

Chief Engineer to specify and build the server for a Visual Plant installation at Avery Dennison in Gainesville, GA.

Performed the integration for a large ERP system to extract needed data and place into a SQL Server database. Created DTS packages to move some data into two other databases.

Architected, designed, and built a very dynamic SQL Server database, that was used to create source code for an industrial control login application. Also created the Visual Basic front end to extract the data and create source files. Interviewed the client and designed the database using SQL Server 2000 Enterprise Edition.

Designed a front-end application using Visual Basic to store and retrieve parts in a warehouse. This application communicated to a SQL Server database and to a machine via the serial port.

Generated reports using Crystal Reports.

Monitored databases using SQL Profiler and the stored proc sp_who2.

Used the Tuning Wizard for heavily loaded databases with unknown queries and indexes.

Setup Maintenance Plans for backing up databases, and checking DBs.

Setup a SQL Server 2000 server to testing the Visual Plant software.

Integrys, Greenville, SC 02/01 – 02/02

SQL Server DBA/Developer

Designed and developed a database with over 130 tables and over 350 stored procedures using SQL Server 2000 Enterprise Edition.

Designed and implemented SQL Server databases for web site development

Created the database engine for www.DiscoverSouthCarolina.com

Designed DTS Packages to synchronize data between an Oracle database and SQL Server.

Architected the ‘Middle Tier’ for handling the business logic

Interests:

Technical Producer at First Baptist Church, Simpsonville, SC

Boy Scouts of America (Wood badge Leader Ship Trained )

EDUCATION & CERTIFICATIONS

1999 – Microsoft Certified Professional

1997 Learning Tree International, Vocational, Reston, VA

1997 New Horizons Learning Center, Greenville, SC

Certifications in VB and Windows Server

1980 Greenville Technical College, Greenville, SC

Associate Degree

Contact this candidate