Sql Server Database Administrator
Resume:
Frederick Coleman
Database Administrator
Kennesaw, GA 30152`
Mobile 470-***-****
E-mail: *******************@*****.***
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