Inventory all databases being used by the enterprise.

• 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.

A DoJ project with public interaction was losing track of some applications.

Used MS SQL Server 2008 R2, Access and Excel to present/analyze data.

A DoJ project with public interaction was losing track of some applications.
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.
See #12 at https://www.mrexcel.com/forum/excel-questions/190025-pivot-table-drilldown-possibly-one-vba-gurus-2.html.
Used SQL Server 2014 for development.
Clearance: Position of Public Trust (DoJ).

NCI (National Cancer Institute) database development and administration,

• NCI (National Cancer Institute) database development and administration as required.
• NIDDK (National Institute of Diabetes and Digestive and Kidney Diseases) database development and administration as required.
• 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.
• For HIPAA, wrote logout monitoring together with login to give date-time per session.
• Used SSMA and migrated several servers to SQL Server 2014.
o Wrote Full/Differential/Log shipper.
• Simplified password change procedures.
• Added logging to SSIS packages.
• Added check connections to SSIS packages.
• 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.
• Support of SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017.
o Used Docker on home iMac to run Linux SQL Server 2017.

Created linked servers to Oracle and MySQL servers.
Created IIS website to document DBA practices.
o Wrote .aspx/C # page to show database issues.
Created email alerts for important issues (e.g. 823, 824, login failed).
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.
Simplified SSIS package modifications.
Added logging to SSIS jobs/packages.
Parameterized SSIS packages and jobs.
Decoded SSIS packages by writing an XML shredder.
Converted DTS packages to SSIS.
Oracle DBA and developer for test and production 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.)
Consulted on Always-On Availability Groups implementation.
Used both SSMS and VS with TFS.
Used extended properties to document databases, tables, views and stored procedures.
Attended daily/scrum/agile meetings.

NIDDK (National Institute of Diabetes and Digestive and Kidney Diseases) database development and administration.