SUMMARY:

A results - oriented self-starter with more that 15+ years of DBMS experience and the necessary soft-skills to foster key relationships. Expertise includes; Database management, engineering, architecture and design, high-availability, performance tuning, writing complex stored procedures/functions/views/triggers, providing project management for task analysis and cost estimates and producing invaluable documentation. This expertise has occurred in large, high-pressure, Windows/Unix/Linux environments. My technical qualifications, ability to organize and prioritize and effectively communicate to technical and non-technical professionals make me a valuable asset in support of your mission.I look forward to discussing my abilities and your needs at your earliest convenience.

PROFESSIONAL EXPERIENCE:

Confidential (Washington, DC)

INDEPENDENT CONTRACTOR - SQL Server SME

Responsibilities as SQL Server Database Engineer includes; reviewing and documenting existing database environment, making recommendations for improvements; working with development team to advocate migrating/upgrading to SQL 2008 R2 and eventually to a SQL 2012 enterprise environment; using business acumen skills to champion a test environment as well as consolidating multiple SQL instances; converting a manual checklist process into an automated process via SCOM; confirming/creating/documenting a solid backup and restore process; meeting with client to discuss database and application architecture design and redesign, performing project management duties to set and monitor deadlines and future deliverables, reviewing STIGs to comply with DISA security requirements, developing performance maintenance plans and monitoring database activity and error logs to proactively address performance/application issues. This environment consists of VMWware, Windows 2003/2008 R2/2012, SQL Server 2000/2005/2008 R 2/2012/2014/2016, Microsoft Failover Clustering (FCI), SQL 2012/2014 Always On Availability Groups and NetApp SnapManager Backup and Recovery.

Confidential - (DC)

INDEPENDENT CONTRACTOR - Sr. SQL Server SME

Responsibilities as Senior SQL Server DBA includes; managing and monitoring 1000+ SharePoint databases, managing and monitoring several terabytes of data to include data, log and backup files, developing and modifying backup\maintenance strategies and TSQL code to support a VLDB environment; providing performance tuning recommendations and generating SQL environment reports as needed. This is a fast-paced environment and consists of SQL Server 2008 R2, IIS, Sharepoint 2010, Microsoft Failover Clustering (FCI), SQL 2012/2014 Always On Availability Groups and SQL Server log shipping.

Confidential (Ft. Belvoir, VA)

CONTRACTOR - SQL Server Developer/DB E

Responsibilities as SQL Server Developer/Database Engineer includes; writing T-SQL, ASP.NET, C# and JavaScript code to support a high-profile web application. Additional tasks include; reviewing and modifying the existing database and front-end architecture, meeting with client to discuss database and application architecture design and redesign, performing project management duties to set and monitor deadlines and future application deliverables, developing a backup/recovery plan, reviewing STIGs, developing performance maintenance plans and monitoring database activity and error logs to proactively address performance/application issues. This fast-paced, high-pressure environment consists of VMWware, Windows 2003/2008, SQL Server 2005/2008R2/2012, Sharepoint 2010, IIS, Veritas Clustering and Veritas Backup and Recovery.

Confidential (Springfield, VA)

CONTRACTOR - Senior SQL Server Database Administrator

Responsibilities as Senior DBA included; preparing weekly status reports for senior management; preparing Power Point presentations for Senior management to illustrate various SQL DBA achievements; producing Microsoft Visio architecture diagrams to illustrate network/database architectures for specific applications; performing daily reviews of system resources (SQL/OS/Storage); installing SQL 2K5, 2K8, 2K8 R2 clustered (active/passive or active/active) / standalone instances in physical WIN2K3/WIN2K8 or Virtual (VM) environments; participating in disaster recovery exercises, applying DHS SQL security best practices; reviewing and applying STIGs; performing peer-reviews of all SQL installations in production; developing T-SQL/VBScript/Windows scripts to perform tasks to load and or parse data or data files; performing performance tuning by reviewing various SQL code and re-writing the code if necessary; de-normalizing entities, modifying indexing techniques, or suggesting other avenues to obtain results. Projects completed; upgraded all SQL 2008 (clustered / standalone / clustered mirror) instance to SQL Server 2008 SP2 (Service Pack 2), tested and implemented NetBackup 6.5.6 across the enterprise for backup and recovery, lead the effort to re-design the NOC Access Control application using existing Microsoft Access 2007 development tools and moved the backend from Access to SQL Server 2008, developed an application using Windows Scripting and T-SQL to load all Blackberry server logs into SQL Server for ad-hoc reporting and setting up a SSRS (SQL Server Reporting Services) environment to produce on-demand, weekly/ monthly reports for both applications.

Responsibilities as Lead DBA for this fast-paced/high pressure FORTUNE 500 industry leader included; preparing weekly status reports, management and prioritization of day-to-day DBA operations; management and installation of all Open Systems Database environments to include; SQL Server, Netezza, DB2/UDB, Oracle and Informix; developing operational best practices and procedures; designing and developing processes to automate DBA management tasks; routinely meeting with clients for process improvements and to discuss DBA support; routinely testing disaster recover processes; management of Marriott’ s on-line reservations and member rewards DBMS project management and prioritization of all DBMS activities. Developed the process and lead the deployment of all Open System Databases to second data center at Iron Mountain. This effort included; documenting all Server names, Server Operating Systems, IP addresses, DNS and Router information required for server connectivity from main data center to second data center, capturing database and server performance metrics and confirming similar numbers at second data center, documenting EMC SAN design at main data center and confirming the design is duplicated at second data center, performing tests of EMC SAN carvings for all SQL Server, Oracle and DB2/UDB enterprise data and log files, documenting all clustered environments for high-availability, assisting with the rebuild of the backup and recovery environment and confirming all Windows, confirming HP-UX and AIX environments are labeled according and producing MS Visio documents to visually illustrate all Open System architecture.

Environment: Windows 2000/2003, HP-UX/AIX, NDS, SQL Server 6.5/7.0/ 2000/2005/2008, SQL Clustering (Active/active and Active/passive), Replication, OLAP, Log Shipping, DTS/SSIS, Netezza, Oracle 9/10G, DB2, IMS, IBM DB2/UDB, IBM Websphere SYBASE, INFORMIX, ERWIN Data Modeler, LDAP, Embarcadero, HTML/VBasic/VBsScript/ASP, AWK, KORNE-SHELL, Java, Vignette 7, SharePoint, MOM, BIGFIX.

Confidential (Alexandria, VA)

Senior Lead Database Administrator

Responsibilities as Lead DBA for this fast-paced/high pressure Internet Security Firm included management and installation of the world’ s largest SQL distributed database farm; performance monitoring; performance tuning and optimization of complex stored procedures, queries, and indexes; writing and documenting code for performance trending; mentoring four (4) Jr./Sr. level DBAs; relational database design/analysis; data space management; evaluating and making recommendations of code releases for development team; project management and prioritization of all DBMS activities; development using T-SQL/Visual Basic; QA process development; and producing weekly status reports for Executive staff. Other management duties;

Management of 600+ (Five Hundred Plus) security Production Databases.

Management of VLDBs. Sizes ranged from 4.5 gig to Terabyte+ of data.

Management of 50 to 80 maintenance job per server.

Management of 60+ security Production Database Servers.

Implemented/Managed Change Control Environment for 20+ Developers.

Management of Transactional Replication environment.

Management of ERDs using Case Tools.

Designing/implementing plans to resolve scalability issues. (Logical/Physical Distribution of DB objects ie. Indexes/Tables)

Recommend/Promote Best Business Practices.

Environment: Windows 2000, NDS, SQL Server 6.5/7/2000, Oracle 8i, Embacadero, Replication, Log Shipping, NT4/2000, Perl Scripting, IIS,Visual Basic, HTML/ASP, VBScript, XML, Cisco VOIP, PKI, All firewall types (ie. Checkpoint, Netscreen, Pix etc…)

Confidential (Arlington, VA)

Senior Database Engineer

Responsibilities as Senior DBA for this high pressure prestigious investment bank included; management of all database environments; performance monitoring; performance tuning and optimization of complex financial stored procedures, queries, and indexes; project management and prioritization of all DBMS activities; documenting database performance statistics for trending; relational database design/analysis; data space management; development in T-SQL/Visual Basic; evaluating and making recommendations of code releases for development team; management of the bank’ s website for online investors; firewall and load balancing management; web development using Vignette CMS; and producing weekly reports for Executive staff. Environment: SQL Server 6.5/ 7, Replication, Oracle8, NT4, Novell, IIS, LAN Configuration; Crystal Reports, Visual Basic, HTML/ASP/Front Page, Perl Scripting, TCL, Exchange/MS Outlook, MS Office Suite.

Confidential (Chevy Chase, MD)

Senior Database Administrator

Responsibilities as Senior DBA included management and installation of production databases; performance monitoring, tuning and optimization of stored procedures, queries, and indexes; relational database design/analysis; data space management; documenting database performance statistics for trending; and management of the Document Management System (DMS) / DOCS Open. Management of all outside developers for code review and quality control of new application releases. Environment: SQL Server 6.5/7, SYBASE 10, Thomson Financial, Oracle8, NT 4, HP-UX 9.04, IIS, Visual Basic, HTML/ASP, Exchange/MS Outlook, MS Office Suite.