SUMMARY

• One - stop shopping for Microsoft SQL server - what I don’t know, I’ll find out.
• US citizen with a current secret clearance (DoD).
• Over 30 years of Information Technology experience, and over 18 years as a SQL Server DBA and Developer.
• Managed large databases within production, COOP, UAT, QA, stage and development environments.
• Experienced with Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012 and 2014 performing: data acquisition, analysis and design, DBMS optimization, recovery strategy and load strategy design, and implementation.
• Performed standard DBA tasks with SQL Server including: installation and configuration, security management, space management, performance monitoring and tuning, backup and restore, maintaining indexes, design and development of databases, policy based management, EPM, MDW, and UCP.
• Created multiple logical and physical database designs using rules of normalization and sound design practices.
• Used Query Analyzer, SQL Server Management Studio and Visual Studio to create/edit Transact SQL to create stored procedures, triggers, optimize code, and create maintenance scripts, including batch (.cmd files) and PowerShell scripts.
• Transferred data using multiple ETL tools, including DTS, SSIS, BCP, and bulk load procedures from multiple environments (SQL Server, XML and flat data files).
• Experienced in developing scripts to manage and report on server availability, space utilization, database consistency, update statistics, security audits, scan server logs and SQL Server logs.
• Experienced with performance measuring and tuning methods using Windows performance monitor (PerfMon), SQL Activity Monitor, SQL Profiler and Extended Events.
• Supported/used Crystal Reports, reporting services (SSRS), replication and clustering (WSFC).
• Delivered large-scale systems with high quality and within prescribed timelines.
• Performed standard network management tasks on Windows 7 and Windows Server 2008, and 2012.
• Answered questions in Microsoft.public.sqlserver.* Usenet groups and SQLServerCentral.com.
• Active user, developer and administrator of DB2, Hadoop, MongoDB, MySQL, Oracle, PostgreSQL, SQL Server, Sybase and Teradata databases.
• Fast learner.
• Extensive Confidential mainframe experience.

TECHNICAL SKILLS

Loss of msdb database: email logs, backup history, restore (verify) history, CMS.

Loss of master database: logical backup, physical backup, re-buildable by script.

On server restart: email and DBCC CheckDb.

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

Senior SQL Server DBA and Developer

Responsibilities:

• Reviewed database backup schedules and procedures and implemented changes.
• Developed PowerShell scripts for routine monitoring and ETL.
• Scripted verification that full/differential/log backups were taken correctly and emailed violations.
• Created IIS website to document DBA practices.
• Wrote .aspx/C # page to show database issues.
• Created email alerts for important issues (e.g. 823, 824, login failed).
• For HIPAA, wrote logout monitoring together with login to give datetime per session.
• Wrote SQLCLR C# code to report reason for Windows server restart and include with SQL Server restart email.
• Wrote SQLCLR C# code for extensions to DbMail.
• Migrated several servers to SQL Server 2014.
• Wrote Full/Differential/Log shipper.
• Simplified password change procedures.
• Simplified SSIS package modifications.
• Parameterized SSIS packages and jobs.
• Decoded SSIS packages by writing an XML shredder.
• Converted DTS packages to SSIS.
• Used SSIS for ETL from Oracle and MySQL databases.
• Added logging to SSIS packages. Added check connections to SSIS packages.
• Created linked servers to Oracle and MySQL servers.
• Oracle DBA for test systems.
• Created .cmd scripts to ping/tnsping MS SQL Server/Oracle/MySQL servers/databases.
• Wrote generic ETL from DocManager databases. (DocManager, like PeopleSoft, is a database within a database.)
• Proposed and implemented Enterprise Policy Management (EPM) Policy Based Management (PBM) of SQL Servers.
• Full SQL Server support including SSAS, SSIS and SSRS, including report creation.
• Consulted on Always-On Availability Groups implementation.
• Support of SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017.
• Used both SSMS and VS with TFS.
• Used extended properties to document databases, tables, views and stored procedures.

Confidential, Hanover, MD

Senior DBA

Responsibilities:

• Developed inventory system and database using T-SQL.
• Reviewed databases backup schedules and recommended changes.
• Pointed out backup to be taken to another server should be copy only.
• Recommended changes in security environment.
• Proposed and implemented Enterprise Policy Management (EPM) Policy Based Management (PBM) of SQL Servers.
• Full SQL Server support including SSAS, SSIS and SSRS.
• Created reports.
• Support of SQL Server 2005, 2008, 2008 R2 and 2012.
• Used SQL Server 2014 for development.

Confidential, Washington, DC

Director of Data Engineering and Analysis

Responsibilities:

• Audited the database to show problems/bottlenecks/mislaid items:
• Used SQL Server 2008 R2, Access and Excel to present/analyze data.
• Wrote Excel VBA to neatly present Show Details from pivot tables.
• Wrote Access VBA to check backups/restores on SQL Server.
• Wrote Access VBA to drive SQL Server, Excel, PowerPoint, Word and Outlook for weekly reports for management.
• Wrote Access VBA to generate VBA code in Excel workbooks using the VBE object model.
• Used SQL Server 2014 for development.
• Clearance: Position of Public Trust.

Confidential, Herndon, VA

Senior Principal SQL SERVER DBA

Responsibilities:

• HAIMS DoD project Database Administrator and Database Developer.
• Supported and implemented both transactional replication and merge replication.
• Proposed and implemented SQL Server performance monitoring and alerting code:
• Replication, disk space, blocking and deadlock alerts recorded and emailed.
• Defined Fail-Safe operator.
• Nagios interface.
• Proposed and implemented Enterprise Policy Management (EPM) Policy Based Management (PBM) of SQL Servers.
• Reduced number of blocks and deadlocks:
• Wrote T-SQL to retime runs of replication agents to reduce conflicts (deadlocks).
• Wrote T-SQL to define replication email alerts with sensible values to get a grip on replication performance.
• Rewrote user application SQL code.
• Created jobs via T-SQL to test blocking and deadlock reporting.
• Wrote test harness for stored procedures:
• Free cache.
• Execute before/old code and save results of inserts/updates/deletes and timing.
• Rollback.
• Free cache.
• Execute after/new code and save results of inserts/updates/deletes and timing.
• Rollback.
• Before/after results and timing compared.
• STIG-ed several servers. Wrote T-SQL to automate most of STIG process.
• Full SQL Server support including SSAS, SSIS and SSRS.
• Created reports.
• Supported SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
• Used vSphere to administer VMware servers.
• Wrote Internet Explorer VBA to smoke test access to all 9 websites.
• PowerShell scripting and Unix scripting (BASH).
• Created websites using HTML and CSS.
• ASP.NET programming with MVC.

Confidential, Silver Spring, MD

Senior SQL SERVER DBA/SQL Developer

Responsibilities:

• SaaS (Software as a Service), PaaS (Platform as a Service) and IaaS (Infrastructure as a Service).
• Created virtual machines from template.
• Created standardized SQL server installation script to ensure correct installation every time:
• Usually used on VMware virtual machines.
• Active Directory accounts created, securely, by my DOS .cmd script.
• Wrote an IIS test webpage to check out basic connectivity to SQL Server database.
• Installed copy of IIS test webpage for every project.
• Active Directory (AD) domain administrator.
• Domain Name System (DNS) administrator:
• Made DNS entries as required and scripted process using DOS .cmd file.
• Internet Information Services (IIS) administrator.
• VMware administrator.
• Wrote ADSI stored procedures to report on Active directory and to create a project reference with database names, DNS server aliases, connection strings, AD project groups and members with last login date and password expiry.
• Automated daily checklists into a SQL Server job called Daily Checks.
• Agreed a smoke test procedure with developers for each project/database:
• IIS webpage, smoke test and Daily Checks used at end of each database maintenance period.
• Internet Information Services (IIS) installation and administration.
• Championed useful web response during maintenance/server/database unavailable.
• Full SQL Server support including SSAS, SSIS and SSRS.
• Wrote reports.
• SQL Development as required.
• Supported SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
• Led conversions from 2000->2005, 2005->2008, 2008->2008 R2, and 2008 R2->2012.
• Decided on Mirroring vs. Log Shipping for several projects.
• Advised on Microsoft Cluster Server (MSCS) and Windows Server Failover Clustering (WSFC).
• Wrote SOPs as required.
• Used EPM and policy based management (PBM) with CMS and PowerShell to centralize policy management thereby checking/enforcing Microsoft Best Practices across the enterprise.
• Installed, administered and used Oracle 11g, Sybase 15.7, MySQL 5.5 and DB2 9.7 under Windows on my laptop along with SAS 9.2 and Crystal Reports 11:
• These environments were for migration between database systems.
• Maintained a mirror copy of a small database in each environment.
• Automatic backup for each environment.
• Created VirtualBoxes on iMac for DB2, Hadoop, MongoDB, MySQL, Oracle, PostgreSQL, SQL Server, Sybase and Teradata for additional arenas for testing installation and maintenance scripts.
• Installed both
• LAMP (Linux, Apache, MySQL and PHP) and
• LAPP (Linux; Apache; PostgreSQL; and PHP, Python and Perl) stacks.
• Wrote stored procedures to email an arbitrary table with highlights.
• Emails from servers have sender address by function to simplify Outlook and iPhone rules.
• Each SQL server checked from an admin server to ensure running OK.
• Therefore, only a few servers need to be manually checked.
• Admin servers check each other.
• Admin servers in Check MK/Nagios too.
• Database Restore Plan
• Not just Backup plan.
• Exercised by database promotion/demotion to a different tier and weekly test.
• Every database has Page Verify set to checksum.
• Every backup
• Is restore verified.
• Has backup checksums.
• Wrote code to determine full backup, differential backup and transaction log backup sequence needed for recovery.
• Loss of msdb database: email logs, backup history, restore (verify) history.
• Restore into parallel/history database.
• In other words, loss of msdb is a minor irritation not a calamity.
• Loss of master database: logical backup, physical backup, re-buildable by script.
• Full dumps once a week or once per month with weekly differential.
• Transaction log backup every hour to allow Point In Time Recovery.
• DBCC CheckDb for all databases once per week.
• On server restart: email and DBCC CheckDb.
• Assisted in COOP design.
• Security Audit
• Wrote T-SQL stored procedures for Service Broker and triggers to report invalid login attempts.
• Email to DBA
• Wrote T-SQL stored procedures for Extended Events to detect logout.
• Database Performance
• Provided interface to Check MK/Icinga/Nagios/Prowl.
• Monitor job execution on each SQL server. Report if execution time > 2 sigma.
• Wrote stored procedures using Service Broker and extended events to report deadlocks and blocking. Shredded the resulting XML into a readable summary.
• Used PerfMon and Activity Monitor.
• Check MK, reports, dashboards, MDW and UCP to monitor trends and performance.
• Programmer/Developer support:
• Installed and modified two reporting dashboards. Application/developer orientated and DBA orientated.
• Provided generalized XML shredder stored procedure to developers:
• Shows XPath for each field for XPath, XSLT and XQuery.
• Namespaces handled.
• Wrote error handling stored procedure to report error details and give a window centred on the failing line of code.
• Debugged application developers’ stored procedures.
• Wrote C# filestream test programs to a different domain.
• Project orientated CMS automatically derived from Admin orientated CMS.
• PowerShell scripting and Unix scripting (BASH).
• Remote support using a cable modem.

Confidential, Falls Church, VA

SQL SERVER DBA/Programmer/Analyst/Consultant

Responsibilities:

• Initially on contract to Confidential Inc. who contracted to Nortel who contracted to Confidential .
• Later directly employed by division of Nortel. Nortel division then sold to Confidential .
• Database Administration and Database consultancy and Database development as required.
• Full SQL Server 2000, 2005 and 2008 support including transactional replication.
• Supported clustered (MSCS, WSFC) and non-clustered servers.
• Wrote and maintained automatic server and network monitoring code using SQLDMO, WMI and VBA.
• Used Port Ping to verify user workstation access to servers.
• Greatly simplified deployment procedures. (8 hour time-slot reduced to 5 minutes.)
• Designed and implemented changes to disaster recovery to dramatically reduce downtime.
• Received award. (3 hours reduced to < 5 minutes.)
• Proposed further changes including log shipping. Mirroring was considered but rejected.
• Wrote T-SQL code generators, dynamic SQL but used dynamic procedure calls when possible.
• For example: a T-SQL generator to verify customized replication procedures.
• Used ERwin; LiteSpeed; and Red Gate SQL Compare and SQL Data Compare.
• ColdFusion code analysis/debug to determine database change required.
• Developed and maintained a ColdFusion website for routine database modifications.
• Created .cmd file to script deployment using Visual SourceSafe (VSS) and Subversion (svn) source control systems.
• Daily monitoring of Informatica system.
• Wrote in T-SQL a stress test for replication and Informatica.
• Query optimization and performance tuning.
• Assisted application developers with database schema and procedure changes.
• Wrote documentation for each environment using Word Mail Merge and an Excel spreadsheet (to hold the configurations) to produce a distraction free document.
• MS Access DBA/VBA and MS Excel DBA/VBA support.
• Some Oracle support for HEAT which is Help Desk Software from FrontRange Solutions.
• Clearance: Position of Public Trust ( Confidential ).

Confidential, Herndon, VA

MS Access/MS Excel/SQL SERVER DBA/Programmer/Analyst/Consultant

Responsibilities:

• One week contract, extended to another three weeks, extended to another month, extended to another 5 months.
• Database administration, consultancy and development as required.
• Remote support using Nortel VPN with a cable modem.
• Somewhat appropriately, initiated use of ERwin (a Confidential product) when documenting the structure and usage of an existing database.
• Created data entry forms and coded data validation for MS Access and MS Excel.
• Added email capability beyond that provided by SendMail by using automation from Excel to control Outlook.
• As part of data analysis, wrote MS Access and Excel macros in VBA to condense and present financial data in a digestible form by creating PivotTables, PivotCharts, Charts and Graphs and emailing using automation/Outlook VBA as required.
• Also programmatically created PowerPoint presentations using VBA from Excel for management.
• Wrote two databases and supporting programs from scratch.
• Responsible for the creation and maintenance of entity relationship diagrams, meta data repository, optimizing the database functionality, performance monitoring, index turning, field naming conventions and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.
• Used ADO to fetch data into MS Excel and MS Access.

Confidential, Austin, TX

DBA/Programmer/Analyst/Consultant

Responsibilities:

• Monitored SQL Server performance using PerfMon and SQL Profiler.
• Troubleshot, tracked and resolved issues involving backups/restores for both the servers and clients.
• Created and maintained entity relationship diagrams and meta data repository.
• Responsible for optimizing database functionality, performance monitoring, index tuning, and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.
• J2EE development.
• Remote support using a cable modem.
• Used classic ADO to connect to SQL server.

Confidential, Crystal City, VA

DBA/Programmer/Analyst

Responsibilities:

• Subcontracted by Confidential .
• Provided MS SQL server support as developer and DBA.
• Provided Sybase SQL support as developer and DBA.
• Wrote stored procedures and used both static and dynamic SQL in Transact-SQL (commonly referred to as T-SQL or TSQL).
• Remote support using a cable modem.
• Used Sybase and PowerBuilder to access a database that was being converted to mainframe DMSII.
• Used DTS to transfer data from Sybase to MS SQL Server.
• Wrote a generator to parse Sybase DDL to:
• Create a BCP format file for each table for BCP to load data.
• Create a parameterized .cmd file to load a single table.
• Create a driver .cmd file to load all tables.
• Create a SQL server view for each table to expose table according to mainframe standards (datetime and money).
• Create an Instead Of trigger to update each table from the mainframe.
• Create a linked server on SQL Server to the Confidential mainframe.
• Verified data by using Java programs and ColdFusion.
• Same process used for development, QA and production.
• Used Excel and MS Access to download data from mainframe databases for reporting functions and verification that the database load from PowerBuilder/Sybase worked correctly each time.
• To summarize:
• Sybase database converted to Microsoft SQL Server.
• Existing java and ColdFusion programs accessed SQL Server.
• SQL Server database exposed as a mainframe DMSII database.
• Wrote stored procedures in T-SQL for Microsoft SQL Server to compare a table (either structure or structure and data) between two databases or all tables for the databases.
• Rewrote code for dynamic cursors.
• Used HTML and JavaScript.
• Clearance: Position of Public Trust ( Confidential ).

Confidential

DBA/Programmer/Analyst

Responsibilities:

• Performed many and varied tasks, including:
• First line customer support.
• Fly and fix support in Europe, Africa and New Zealand.
• All European countries except Italy.
• Support from the smallest desk computer system to the biggest mainframes.
• Designed and wrote application systems at the Application Development Centre in Feltham, Middlesex.
• Taught internal and external classes at the training school in Ruislip, Middlesex, Copenhagen, Denmark and Moscow, Russia.
• For large systems (ClearPath), medium systems, small systems, and all 3 CMS systems
• Customer support.
• Branch/district/division support.
• Engineering development for:
• Operating Systems.
• Database Management Systems.