CHARLES BAILEY

ALPHARETTA, GA

aczc6b@r.postjobfree.com

Cell: 470 – 219 – 9592

PROFILE SUMMARY

An accomplished Microsoft database administrator, with over 6 years’ experience in IT infrastructure database architecture, and SQL server management. With a track record of good management, and inter personal skills, in the development and optimization of services. Always seeking challenges in database management in order to increase organizational efficiency.

AREAS OF EXPERTISE

Performance Tuning

Consolidation Strategies

Index Maintenance

Windows Server Installation and Configurations

VM Ware Installation and Configurations

High Availability Solutions

SQL Installation and Configurations

Backup and Recovery

Database Upgrades & Patches

SKILLS SUMMARY:

Experience with development and production support in various MS SQL Server environments from SQL Server 2005 through SQL Server 2008R2 as well as SQL Server 2012 and SQL Server 2014 on Windows Server 2005, 2008, 2008R2, 2012 and 2012R2.

Strong knowledge of backups, restores, recovery models, DBCC commands, Clustering, Log Shipping, Mirroring, and Replication.

Experience in troubleshooting and resolving performance issues, blocking and deadlocking issues, database integrity issues, security issues, log shipping issues, replication issues, connectivity issues, etc.

Proficient in writing and optimizing T-SQL codes and stored procedures.

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

Installation, Upgrade, Maintenance and Tuning of SQL Server 2005, 2008, 2008R2, 2012.

Tables partitioning, file, and file-group management.

Knowledge of High Availability of database servers using SQL Server 2012 AlwaysOn.

Develop and modify stored procedures, queries, triggers, views, indexes, and functions.

Experienced with monitoring and troubleshooting in 24x7 operations.

Experience with network connection tuning using SQL Server 2008R2.

Have good understanding of Disk and Server configuration for SQL Server.

Proficient in performance of SQL Server software new installation and upgrades.

Proficient in Backup/Recovery strategies implementation.

Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.

Responsible for troubleshooting and problem solving of SQL database Servers.

Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.

Experienced in deploying SQL Server 2012 cluster solutions.

Experience managing multiple MS SQL 2005, 2008, 2008r2, 2012 RDBMS on web-based, transactions.

Experience with Windows environment, VM

Index Maintenance and tuning of the databases.

Provide SQL Server database physical model creation and implementation (data type, indexing, and table design).

Experience working with transactional and snapshot replication.

Management of multi-terabyte production clustered systems using both ACTIVE-PASSIVE and ACTIVE-ACTIVE Clustering.

Experience with SQL Server 2005, 2008, 2008R2 and 2012 on Windows NT, Server 2005, 2008, 2008R2, and 2012

Proficient in use of tools like SQL Server Profiler and Windows Performance Monitor.

Experienced with the design, implementation, and administration of SQL Server database solutions.

Development database support (T-SQL tuning, Application tuning etc.)

Proficient in SQL Server 2005, 2008 and 2008R2 database cloning.

Experience with SAN from the workgroup servers to the enterprise servers, providing the computer applications and database resources necessary to drive the data.

Experience with monitoring and performance tools (SQL Sentry, SolarWinds, sp_Blitz tool stack, sp_WhoIsActive, etc

Working knowledge of Red Gate SQL Backup Pro and SQL Monitor

Working knowledge of Idera SQL Safe and Diagnostic Manager

Extensive knowledge in Microsoft SQL Server databases, as well as SSIS, DTS packages, T-SQL, performance tuning, database design and data warehousing.

TECHNICAL SKILLS:

RDBMS: SQL 2005, 2008, 2008R2, 2012 Database Administration, Clustering, Data Modeling, Replication, Enterprise Environments, Tuning, SQL Profiler, SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services

Operating systems: Windows XP, Windows 7, Windows 8, Windows 10, Windows Server 2005, 2008, 2008R2, 2012, 2012R2

WORK EXPERIENCE:

The Tech-Edge Group June 2010 - Present

SQL Server Database Administrator

Part of a team of 7 DBAs supporting client and in-house SQL Server database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.

Interfacing with developers and clients to help them understand their needs based on budget and licensing cost.

Upgrading client RDBMS to SQL Server 2008R2 and SQL Server 2012.

Engaged in Strategic Planning, Implemented and supported high availability (HA) and disaster recovery (DR) solutions via log shipping and database mirroring along with proper backup strategies across multiple SQL Server instances.

Owning, tracking and resolving database and database cluster related incidents and requests.

Installation and configuration of SQL server infrastructure running on the latest VMWare technology.

Design, implement and administer High Availability solutions, (clustering, log shipping, mirroring, and replication).

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

Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.

Responsible for maintenance, Backup & Recovery, capacity planning, testing, alerts (job failures, database & server capacity, etc.), and database integrity checks.

Used scripts and SQL Agent jobs to automate database maintenance tasks.

Setting up and managing transactional replication, mirroring, and log shipping.

Set up HADR for SQL Server 2012 databases.

Configure and install Windows Server 2012 clusters and SQL Server 2012 clusters.

Configure and install Windows Server 2008R2 clusters and SQL Server 2008R2 clusters.

Serving as the technical expert in SQL Server technologies.

Serving as lead for the SQL Server Production team.

Participating in SQL Server database systems design and operations.

Participating in software upgrades, revisions, patches, and fixes mandated by the vendor.

Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T- SQL.

Assisting in the resolution of complex problems in support of production; including on call support.

Ensuring that the detailed physical design of database and data structures comply with data policies, standards, principles, and meets the established level of service agreements/goals for the system.

Using native and third party monitoring and troubleshooting tools.

Maintaining solid technical skills in RDBMS, products, utilities, protocols, and techniques.

Managing and monitoring SLAs for uptime and performance of SQL Server databases.

Demonstrating experience in working on root cause analysis for SQL Server database issues.

Flexible, adaptable, and able to manage multiple tasks in a dynamic environment.

Proactively monitoring the database systems to ensure secure services with minimum downtime.

Provide on call support on a rotating basis.

Ensured availability of instance and databases via clustering and mirroring.

Education

DEVRY UNIVERSITY, Alpharetta, Georgia

Bachelor of Science in Business Administration

Contact this candidate