Frederick Coleman

Database Administrator

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

Kennesaw, GA 30152`

Mobile 470-***-****

E-mail: ad3ac7@r.postjobfree.com

I am a Sr. SQL Server DBA with over 13 years’ experience with managing the performance of corporate databases.

Experience using the following SQL Server tools:

Data Center Relocation

Management Studio

Data Migration

Configuration Manager

Reporting Services

Performance Tuning

Integration Services

Backup and Recovery

Availability Groups

PowerShell

Failover Cluster

Database Upgrades and patches

AlwaysON

Business Intelligence Development Studio

Log Shipping

Idera Compliance Manager

Red Gate

Idera Diagnostic Manager

Robo3T

Solarwinds

SQL Database security

Change Management Process and Ticketing System

Idera Diagnostic Manager

Monitoring database HA Clusters

Idera Compliance Manager

Skills Summary:

●Migrate Datacenters

●Extensive knowledge in planning, analysis, design & implementation of databases

●Maintenance and tuning of small and very large databases.

●Troubleshooting and problem-solving SQL server database issues.

●Writing Documentation for the environment setup and application interaction with SQL Server

●Ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designating backup/recovery strategies.

●Maintain failover clustering /Availability Groups.

●Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.

●Disaster Recovery

●Administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.

●Configure automated deployment via TeamCity and Octopus

●Experience in creating jobs to automate repetitive tasks using SQL agent jobs

●On-premises to Cloud DB migrations

Technical skills:

●Operating Systems: Windows Server 2008/2008R2/2012, 2016,2019,2020,2022

●Database: Mongodb, Sybase, SQL Server 2005, 2008 & 2008R2, 2012, 2014, 2016, 2019,2020 +, Clustering Availability Groups.

●Tools: Redgate Bundle, Idera Compliance Manager, Idera Diagnostic Manager, SolarWinds Outlook, ServiceNow Remedy, WhiteSands, DBArtsian,SSMA

●Cloud computing: Steel Cloud – Internal Cloud Service

Technical skills can be expanded as necessary.

EXPERIENCE:

JobCorps May 2021 – Current

SQL Server Database Administrator

Creating and maintaining various databases on Production, QA and Development environments using SQL Server 2012/2014 / 2016 /2019-2022

Maintain Availability Groups and create Availability Groups

Work with development teams closely

Database Migration of SYBASE to SQL Server

Ensure data connections from Sybase to SQL Server are consistent and deliver secure data to the client.

Data Migration from 2008r2 SQL Server versions to current versions 2012, 2014, 2016, 2017 & 2019

Managed failover cluster environment

Performance monitoring and tuning by implementing efficient schemas, Tuning indexes and Database Consistency Checks using DBCC Utilities.

Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of SQL Server in a VLDB environment and resolving database issues.

Design and implement database modules such as full text search. Setup and configure SQL Server file stream (Data Load Jobs)

Create System maintenance schedules and jobs for QA/ QC/ DEV/PROD

Develop, manage and test backup and recovery plans

Manage security of databases in production and Dev, QA, QC environments SQL Server 2012,2014,2016,2017 & 2019.

Scheduled and performed system and database backups using numerous backup software.

Maintained different backup polices (Full backup, differential backup and transaction log).

Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.

Handled database server tuning, application tuning, maintenance documentation, and database security.

Involved in Installation, Configuration, Development, Deployment.

24 X 7 Production Database on Call Support

Comcast October 2014 – May 2021

SQL Server Database Administrator

Supported 35,000 Employees and various teams

Creating and maintaining various databases on Production, QA and Development environments using SQL Server 2012/2014 / 2016/ 2019

Create Manage and maintain Availability Groups

Managed 100+ SQL Servers VLDBS

Data Migration from older SQL Server versions to current versions

Managed failover cluster environment

Design and configure AlwaysON environment

Performance monitoring and tuning by implementing efficient schemas, Tuning indexes and Database Consistency Checks native SQL Server Utilities.

Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of SQL Server in a VLDB environment and resolving database issues.

Tuned various SQL Server databases for better performance.

Supported Very Large databases (VLDB) and troubleshooting

Design and implement database modules such as full text search. Setup and configure SQL Server filestream..

Create and maintained backup schedules and jobs.

Develop, manage and test backup and recovery plans Manage security of databases in production and test environments.

Scheduled and performed system and database backups using numerous backup software.

Maintained different backup polices (Full backup, differential backup and transaction log).

Provided monitoring and on-call support for development, test, and production environments

Designed and implemented Logical and physical database design upon requirement, also the patching the critical servers\instances.

Handled database server tuning, application tuning, maintenance documentation, and database security.

Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments

24 X 7 on Call Support

National Christian Foundation (NCF) February 2013 – November 2014

SQL Server DBA Alpharetta, GA

Designed and maintained project databases using SQL Server 2005 & 2008; ensured accuracy of information and automated numerous functions.

Monitor High Priority ETL and new app and code deployment

Wrote, evaluated and optimized complex SQL codes, stored procedures and scripts for maintenance and reporting purposes

Design and implement database modules such as full text search, large volume database updates, offline report generation, and send email alerts to application administrators and end users.

Perform SQL Server Database upgrades

Configuring, administering and maintaining Replication

Performance monitoring and tuning by implementing efficient schemas, optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.

Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server.

Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Experience in database backups/restoration and recovery of NT server/SQL Servers

Worked on migration from SQL Server 2005 to SQL Server 2008

Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.

Communicate problems and issues to business owners and management.

Generated the weekly, monthly, and quarterly report by using SQL Reporting Services

Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Work with end users to define, implement, and maintain their reporting requirements.

Develop and maintain SSIS packages.

Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision

Disaster Recovery, stored procedures and triggers.

Modify, maintain and develop the SQL codes to develop new enhancements.

Designed the backups and recovery strategies for SQL Server databases to meet our customer requirements.

Good Cents Inc. Nov 2011 – Dec 2013 Database Administrator/SSRS/SSAS/SSIS Developer Dunwoody, GA

SQL Server Report Development /

Transact SQL code review

Creating SSIS Packages to clean and load data to data warehouse

Execute SQL Task and Data Flow Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Import/Export Data to new databases or existing tables

knowledge of Transact-SQL (DDL, DML).

Processed cube to perform incremental updates

Created reports by dragging data from cube and wrote mdx scripts.

Created reports by extracting data from cube.

Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.

Proficient in implementing all transformations available on the SSIS toolbox.

Generating reports using MS Reporting Services 2005/2008

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created and tuned stored procedures and tables.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Created indexes for better performance

Deployed reports on Microsoft Report Manager

Deminer Inc. March 2008 – November 2011

SQL Server DBA Marietta, GA

Designed and maintained project databases using SQL Server 2005 & 2008; ensured accuracy of information and automated numerous functions.

Wrote, evaluated and optimized complex SQL codes, stored procedures and scripts for maintenance and reporting purposes

Managed 20+ SQL Servers, from 100GB servers to a 1 terabyte.

Design and implement database modules such as full text search, large volume database updates, offline report generation, and send email alerts to application administrators and end users.

Perform SQL Server Database upgrades.

Configuring, administering and maintaining Replication

Performance monitoring and tuning by implementing efficient schemas, Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Utilities.

Setup, Reconfigured, and Monitored log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server.

Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Experience in database backups/restoration and recovery of NT server/SQL Servers

Worked on migration from SQL Server 2005 to SQL Server 2008

Communicate problems and issues to business owners and management.

Generated the weekly, monthly, and quarterly report by using SQL Reporting Services

Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Work with end users to define, implement, and maintain their reporting requirements.

Develop and maintain SSIS packages.

Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision

Disaster Recovery, stored procedures and triggers.

Modify, maintain and develop the SQL codes to develop new enhancements.

Designed the backups and recovery strategies for SQL Server databases to meet our customer requirements.

Education & Training

UNIVERSITY OF PHOENIX, Atlanta, GA

(Computer Information System/Programming)

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Security Engineer Associate

References available upon request.

10 /2010-2012

Contact this candidate