SUMMARY:

• Over 18 years of professional experience in IT
• Over 13 years of experience in the SQL Database Administration and the role of a SQL database manager, architect, and administrator.
• Experience in database architecture and design with SQL .
• Involved in the architecture, monitoring and maintaining a 10TB Data warehouse with hundreds of SSIS packages with Confidential . Migrated entire SQL production environment to AWS at Confidential .
• Expert skills in performance tuning, production support. Responsible for SQL code reviews, releases to production, SQL server performance tuning, and engaging and supporting the .Net development team with their SQL code.
• Good working knowledge on installation/upgrades datacenter/ SQL server Migrations maintenance and monitoring.
• Architect in SQL server environment with maximum stability, flexibility, availability, disaster recovery and ROI. Worked with clustering, availability groups, database mirroring, integration services (SSIS), and SAN replication
• Experienced in enterprise - wide project management, upgrades, troubleshooting, development, deployment, training, documentation, and budgeting.
• Excellent in fostering teamwork and identifying opportunities and actions to improve business results and processes. Excellent leadership, problem solving and communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. SQL DBA / Architect

• Sr. SQL DBA supporting dev, QA, and prod.
• Architect HA and DR using availability groups in VM environment. Involved in SQL server consolidation, 2 data center moves, and upgrading to SQL 2014.
• Performance tune ETL SSIS packages to run 30% faster.
• Write and implement SQL security standards and procedures.
• Take over support of AWS SQL server instances.

Confidential, Mooresville, NC

Sr. SQL DBA / Architect

• Lead SQL server DBA for ATG, Lowes.ca, and Lowe’s For Pros websites along with 100 internal websites.
• Manage and mentor a team of 3 SQL DBA’s.
• Responsible for SQL code reviews, releases to production, SQL server performance tuning, and engaging and supporting the .Net development team with their SQL code.
• Write and implement standards and procedures.
• Working on data center migrations and new SQL server consolidation effort.

Confidential, Charlotte, NC

Sr. Database Administrator and Architect

• Only SQL DBA managing and consulting on 300+ SQL servers that support $4 billion in annual revenue.
• Responsible for dividing SQL environment to support the spin-off of current company into two new publicly traded companies, Confidential Corporation and Confidential Flow.
• Support 5 TB SAP databases on SQL server.
• Architecting SQL Azure environment.
• Leading and implementing companywide SQL server consolidation and standards project.
• Oversaw all database environments, including SQL server, Oracle, and MySQL.

Confidential, Charlotte, NC

Database Manager and Developer

• Report directly to CIO. Manage SQL server development team. Architect, monitor, and maintain SQL servers at 3 data centers for web hosting and other applications.
• Responsible for maintaining 99.9999% uptime for production SQL environment using SQL 2012 clustering and availability groups for automatic failover and disaster recovery.
• Migrated most production SQL servers to AWS cloud.
• Troubleshoot and improve all SQL server performance. Set up and monitor alerts.
• Consolidated and upgraded SQL environment to SQL 2012 from SQL 2000, 2005, 2008, and 2008 R2.
• Responsible for all SQL server backup and recovery. Monitor disk space and baseline performance on all production servers.
• Architect, troubleshoot, monitor, and maintain 10 TB data warehouse SSIS packages.
• Improved data warehouse latency from 2 days to 10 minutes.
• Support and maintain development, QA, and staging environments, including automated data refreshes.
• Responsible for all SQL server security in all environments at all data centers.
• Implemented SQL server replication and SQL 2012 Read-Only availability group replica to move ETL reads and SQL reporting off transactional SQL servers.
• Review all SQL code before it’s released to each environment. Support SQL developers.

Confidential, Winston-Salem, NC

Director of Database Administration and Production DBA

• Manage DBA team. .
• Migrate about 75% of SQL servers to ESXi VMware environment.
• Implemented SQL server Transparent Data Encryption, encryption of database backups, and forced SSL encryption on all database connections.
• Architect SQL server environment for maximum stability, flexibility, availability, disaster recovery and ROI. Use of clustering, database mirroring, integration services (SSIS), and SAN replication.
• Responsible for SQL development and production deployment of mission critical projects including ETL process.
• Database design and modeling for enterprise web applications.
• Extensive experience in troubleshooting SQL code performance and server hardware.
• Authored SQL security hardening documentation and procedures for SQL server internal and external environments.
• Developed and deployed SQL 2008 Reporting Services (RS) enterprise solution.
• Create RS reports for management and company billing, saving hundreds of man-hours each month by automating manual processes. Trained several internal departments to write RS reports.
• Support QC team in testing of applications.
• Completed SQL Server consolidation project saving company money and improved performance.
• Responsible for SQL backups and recovery in development, test, UAT, and production.
• Implementation of SQL 2008 R2 in multi-node active-active production cluster.

Confidential, Charlotte, NC

Sr. Database Administrator

• Responsible for SQL servers supporting 12 mission critical applications within Wachovia’s Corporate and Investment Banking division.
• Install and configure SQL 2000 and SQL bit instances in multi-node clustered environments.
• Recommend SQL server hardware specifications and production SAN utilization.
• On call for all production SQL servers in the division.
• Code review SQL scripts before they are implemented in production.
• In-depth experience in performance tuning worst performing queries, resolving deadlocks, and aiding developers in best practices in creating tables, indexes, RI, triggers, views, and stored procedures.
• Expert in troubleshooting production performance issues.
• Install, configure, and monitor SQL 2000 and 2005 replication and log shipping.
• Automate nightly database refreshes from production backups to Dev and UAT environments to speed up development cycle.
• Responsible for backup and restoring of databases and DR testing.
• Upgrade SQL, including rewriting SQL code to meet SQL 2005 compatibility.
• Manage, monitor, and enforce database security.
• Mentor other SQL DBA’s.

Confidential, Charlotte, NC

Sr. Database Administrator

• Configure and monitor alerting for over a hundred enterprise SQL servers.
• Maintain and troubleshoot ETL process for SQL server data warehouses.
• On call for all production SQL servers and nightly ETL processes.
• Code review SQL scripts before they are pushed to Production.
• Troubleshoot SQL server performance for SQL 2000 and SQL 2005 in 24/7 environment.
• Install, configure, and monitor SQL 2000 and 2005 replication and log shipping.
• Install and rebuild SQL 2000 and SQL 2005 servers.
• Install, configure, and maintain archiving of production SQL data.
• Responsible for backup and restoring of databases.
• Upgrade SQL for dozens of instances, including production.
• Experience with third party tools; Diagnostic Manager, SQLSafe, SQLH2, Princeton’s Optim Archiving, SQL LiteSpeed, and Serena ChangeMan, Red Gate SQL and Data Compare, among others.

Confidential, Salisbury, NC

Sr. SQL Database Developer & Admin.

• Implemented enterprise wide database backup and recovery.
• Provided database tuning for production servers.
• Developed and implemented triggers and audit tables for all production SQL database tables.
• Wrote over 100 stored procedures to migrate data from old ASP application to new .Net application in SQL 2005.
• Work with .Net developers on table and database design.
• Installed and maintain SQL 2000 and SQL 2005 Report Server and IIS servers.
• Upgraded all SQL 2000 servers to SQL 2005 and migrated all databases to SQL 2005.
• Upgraded domain with Active Directory. Set up new DNS servers. Implemented and maintain a corporate VPN.
• Visual Source Safe administrator and daily release manager for SQL, .Net, and ASP applications.

Confidential, Mooresville, NC

President & Owner

• Installed and maintained company computers, network, and software.
• Over $5-million in sales in 2-years.
• Managed a team of 12 employees in sales, construction, and property management.
• Sold business in November 2005.

Confidential, Charlotte, NC

Sr. Database Engineer

• Designed, documented, implemented and managed enterprise wide SQL 7.0 to SQL 2000 upgrade for 75+ servers, 500+ databases, in multiple countries.
• Companywide go-to SQL Server technical lead to DBA’s and application teams.
• Developed stored procedures, triggers, batch files, and views.
• Implemented SQL server replication for many applications, including critical database information to and from power plants in the U.S. and Brazil. Trained Oracle and SQL DBA’s to use replication.
• Responsible for SQL server user security across the company. Created enterprise wide SQL server security protocol and guidelines. Trained new security team on SQL server user security.
• Developed DTS packages for DBA’s and software engineers to automate and enhance database functions and applications. Trained DBA’s on best use for DTS packages.
• SQL server performance tuning using performance monitor and SQL profiler.
• Monitored and advised on database capacity planning with weekly reports emailed to key managers.
• Designed, documented, and deployed companywide strategy for SQL database disaster recovery procedures.
• Responsible for SQL database backups and restores. Identified best backup and restore options according to business needs.
• Led projects to convert Oracle to SQL server migrations. Team lead in integrating data sharing between Oracle, SQL, DB2, UDB, and Sybase databases using replication, BCP, DTS packages, stored procedures, triggers, PERL, and SQL jobs.
• Established and documented SQL server test and QA environments for DBA’s and applications teams.
• Worked with NT server team in implementation of MS SQL cluster servers.
• Liaison between Confidential and Microsoft in SQL server troubleshooting, hot fixes, and new product design.

Confidential, Greenville, SC

Sr. Network Engineer & DBA

• Designed, budgeted, built, and maintained enterprise Windows servers and Ethernet networks for fast growing data center.
• Designed, budgeted, built, and maintained optical disc library for online imaging system of insurance documents.
• Implemented, tested, and documented off-site disaster recovery for all data.
• Senior database administrator for SQL 6.5 mission critical applications.