SUMMARY:

Senior level production Database Administrator (DBA) and Database Developer with 15 years experience managing SQL Server, Oracle and MySQL database technology. Extensive expertise with database design, architecture, administration, development, disaster recovery, replication and performance tuning.

SKILL MATRIX:

Development Languages:

• T - SQL
• ANSI SQL
• PL/SQL
• PowerShell
• VB6, VBA
• VB.Net, ASP.Net
• JavaScript
• HTML
• XML

Database Technology:

• Performance Tuning
• ETL
• Logical and Physical Database Design
• Procedures, functions, CTEs
• SQL Server - Failover Clustering (Active/Active, Active/Passive)
• SQL Server - DTS, SSIS, Bulk Import
• SQL Server - Replication, Log Shipping and Mirroring
• SQL Server - Reporting Services (SSRS)
• Oracle - Backup / Recovery (RMAN)
• Oracle - DataGuard
• MySQL
• Microsoft Access

Platforms and Systems:

• SQL Server - 7.0, 2000, 2005, 2008, 2008 R2, 2012, Azure
• Oracle - 9i, 10g, 11g
• MySQL – 5.0, 5.1, 5.5
• Windows – 2000, 2003, XP, Vista, 2008, 2008 R2, 7
• SharePoint / MOSS – 2003, 2007, 2010
• Smartphones - Windows Mobile, Android
• SUSE Linux – 9, 10
• RedHat Linux – 7, 8

Applications:

• Microsoft Office 97-2010 (Excel, PowerPoint, Publisher)
• Microsoft Project
• Microsoft Visio
• Microsoft Visual Studio
• VMware Workstation
• VMware vSphere
• Redgate Toolbelt
• Adobe Photoshop
• DB Artisan
• Embarcadero ER/Studio

QUALIFICATIONS:

Leadership:

• Able to use depth of real - world database administration experience to lead or contribute to the team.
• Productive, motivated self-starter who aggressively attacks tasks and follows through to completion.
• Ability to convey complex technical concepts to clients and non-technical team members.
• Well versed in preparing technical presentations, documentation, SOWs and budgets.
• Comfortable with clients, end users, senior management, technical and non-technical staff.
• Experienced project manager with attention to budgetary and labor constraints.
• Managed team of four senior and mid-level Production Database Administrators.
• Team leader for two mid-level Database Administrators and Database Developers.

Technical:

• Senior-level Database Administrator skilled in SQL Server, Oracle and MySQL database technology.
• Expert knowledge of T-SQL, stored procedures, user-defined functions, CTEs and partitioning.
• Extensive experience with disaster recovery (DR), high availability (HA) and scalability.
• Solid experience with failover clustering including active/active and active/passive configurations.
• Advanced knowledge of replication, log shipping and mirroring using SQL Server, Oracle and MySQL.
• Expertise with ETL using DTS, SSIS, bulk import, T-SQL, Oracle Data Pump and mysqldump.
• Extremely proficient configuring and developing SQL Server Reporting Services (SSRS) reports.
• Performance tuning experience using server-side traces, query plan analysis, perfmon and DMVs.
• Strong experience with maintaining very large databases (VLDBs) surpassing 1.5 terabytes.
• Advanced sysadmin and IT skills for root cause analysis and production administration and support.
• Expert in process automation using PowerShell, VBScript, batch files and bash scripting languages.

ACCOMPLISHMENTS:

• Migrated 1.2 terabyte SQL Server database to new server with ten minutes of downtime.
• Built and migrated SQL Server active/active clusters to new hardware with minimal downtime.
• Administered database environment consisting of 3.2 terabytes on one hundred twenty-five servers.
• Automated mirroring of new databases to disaster recovery (DR) site using T-SQL and sqlcmd.
• Created custom monitoring and performance dashboard using perfmon, DMVs and server traces.
• Designed and implemented custom index and statistics maintenance process to increase performance.
• Automated creation of new database and Reporting Services (SSRS) instances for SaaS customers.
• Created stored procedure in MySQL to simulate Oracle sequence numbering architecture.
• Created custom partitioning scheme to vastly improve query performance of 500 million record table.
• Migrated fifty SQL Server instances to virtual servers and tuned for I/O performance.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior Database Consultant

Responsibilities:

• Manage Database Engineering department consisting of two senior and two mid-level DBAs.
• Manage client environments totaling three hundred SQL Server, Oracle and MySQL instances.
• Create SOWs, technical presentations and requirements documents for client and prospects.
• Built twelve SQL Server 2008 R2 dual node clusters with two active/active instances per cluster.
• Performance tuned client OLTP environment to support thousands of transactions per second.
• Optimized 800 GB database, index and log files to significantly increase query performance.
• Created custom backup and retention job for client environment using T-SQL and data modeling.
• Created separate reporting server using replication to reduce load on production OLTP environment.

Confidential, Atlanta, GA

Senior Database Administrator

• Team leader for two mid-level Database Administrators and Database Developers.
• Project Manager for two-year-long records management system consolidation, totaling 1 TB of data.
• Designed and implemented automated process to upgrades to firm-wide financial system (Aderant).
• Optimized database schema, index and log files to reduce I/O and reduce month end processing time.
• Performed code reviews and mentoring for .Net and Database Developers using TFS and VSS.
• Created business continuity (DR) process leveraging mirroring to geographically disperse data centers.
• Automated monthly client billing process, reducing labor costs and processing time.

Confidential, Atlanta, GA

Senior Database Administrator

• Lead SQL Server Developer for data warehouse and dashboard project using ETL and T-SQL.
• Developed stored procedures and application code leveraging VSS, SSMS and Query Analyzer.
• Primary MySQL Database Administrator using replication and tuning to maintain SaaS servers.
• Migrated older SaaS environments from MySQL to highly available SQL Server clusters.

Confidential, Peachtree City, GA

Database Architect

• Architected, implemented and maintained entire database SQL Server, Oracle and MySQL environment.
• Leveraged replication and Oracle Data Guard to synchronize data with remote (DR) data center.
• Reengineered COM and file-based application to ASP and SQL Server, greatly increasing scalability.
• Migrated SaaS applications from Oracle 10g to MySQL 5.0 to substantially reduce licensing costs.

Confidential, Atlanta, GA

Production Database Programmer

• Created form mail scanning application using SQL Server and Visual Basic to reduce data entry.
• Developed ETL process to produce large scale mailing lists using T-SQL, sqlcmd and bulk import.
• Defined requirements and documentation for client extracts to conform to corporate ETL processes.
• Upsized Microsoft Access application to Visual Basic and SQL Server to increase scalability.