SQL Server Database Administrator

Charles Jefferson

*** *** ******* **, *************, GA 30045

H: 470-***-**** C: 678-***-****

**********@*****.***

PROFESSIONAL SUMMARY

Over 10+ years of IT SQL Server Administration experience,

Developed a strong, working understanding of both the physical and logical Architecture of Windows Server Platforms along with SQL Server Administration including Installation, Configuration and Maintenance of both Platforms

Responsible for SQL 2005/2008 logical and physical database design, implementation, and maintenance on Windows Server 2003/2008 platforms.

Configured Transactional Replication with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.

Followed the Enterprise Change Management process and executed Change Management scripts according to Change Management and Business-need schedules.

Identify, recommend, and implement all new database technologies and SQL license management.

Handled database server tuning, application tuning, maintaining documentation, capacity planning and application integration formats.

Microsoft MCSE Certified

SKILLS

Indexes

Excellent problem-solving abilities

Profile Tracing

Windows Server 2003/2008

Disaster Recovery and Failover Design

MS-SQL 2005/2008

Data Backup and Recovery Strategies

IIS

Query Tuning

SSIS

Ability to work within deadlines

WORK HISTORY

World Changers International 05/2014 to Present

SQL Database Administrator

Responsible for SQL 2008R2 logical and physical database implementation, and maintenance on Windows Server 2008 virtual platforms.

Configure, Install and update reports to the SSRS Servers

Handle Data Analysis for the CRM Microsoft Dynamics Application

Produce Server and database documentation using Reverse Engineering Tools and Visio

Deploy data scrubbing operations of databases using Fuzzy Logic techniques

Setup security rules and processes for the SQL server environment.

Delivered automation scripts for backups, indexing, and Database mail alerting system

Setup Linked servers for SQL agent server functions

AIG Sunamerica Asset Mgmt – Jersey City NJ 05/2001 to 12/2013

Systems/Database Engineer

Responsible for SQL 2005/2008 logical and physical database design, implementation, and maintenance on Windows Server 2003/2008 platforms.

Created new databases and users: set up backups, export, and other monitoring scripts.

Implemented database index and data scrubbing for improved reliability and 24/7 up times of client data.

Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.

Performed installations of SQL Server Standard and Enterprise Edition (32 and 64bit versions).

Failover testing and resolution on servers as well as monitoring and backup with Storage team.

Configured Transactional Replication with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.

Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Performed periodic backups as part of the corporate business disaster recovery initiative using Symantec Backup Exec.

Executed Log Shipping and Mirroring procedures for corporate Disaster Recovery Initiatives

Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.

Installed and configured SQL Server 2000/2005/2008R2/2012.

Followed the Enterprise Change Management process and executed Change Management scripts according to Change Management and Business-need schedules.

Identify, recommend, and implement all new database technologies and SQL license management.

Handled database server tuning, application tuning, maintaining documentation, capacity planning and application integration formats.

EDUCATION

Information Systems, New York University - 70 Washington Square S, New York, NY 10012

Computer Science, Howard University

High School Diploma: Engineering, 1987 Brooklyn Technical High School - 29 Ft. Greene Pl Brooklyn NY 11201

Contact this candidate