Sql Server Administration, T-SQL SME

Steven Horth

Brewster, NY

Technical Skill Set:

On-premise SQL server installation, upgrade & support – 20+ years (1998 – present)

SQL Server 2016, 2019, and earlier

T-SQL queries, triggers, stored procs, functions – 20+ years (1998 – present)

Azure environment and SQL Database administration (Databricks) – 4 years

Azure Data Factory (ADF) – 3 years

ETL via SSIS – 16 years (2007 – 2023)

Data Warehousing, Backup & Recovery processes, data archiving – 10+ years

High Availability / Disaster Recovery – 5 years (2019 – 2023)

Replication – 2 years (2017-2019)

JavaScript – 3 years (2020-2023)

C# coding and MCSD Certification - 3 years

Visual Basic (Visual Studio & VB.Net) coding and MCSD Certification - 15 years

SQL Performance Tuning – 5+ years

SSRS – 5+ years (since 2005, on and off)

SSAS – 3 years (2000, 2005, 2023)

SSMS – 19 years (2005-present)

Azure maintenance tasks, including alerts, logging and performance tracking – 4 years

Develop and maintain maintenance plans and disaster recovery plans

MS Access - 12+ years (2007 - 2019)

VBA - 5+ years (since 2005, on and off)

Supporting .Net applications - 4 years (2019 – 2023)

Establishing ETL scripts and processes to various desktop database applications (Access, Filemaker pro, dBase, Foxpro, Boland Paradox, R:Base, Lotus Approach) – 5 years (2007-2012)

Designed, developed, and implemented ETL/ ELT solutions for data ingestion, cleansing, business rules execution and data distribution - 10+ years

Debugging and improving query performance -15+ years

Deployed code packages using Git check-in - 2+ years

Created respective jobs in SQL Agent - 15+ years

Worked with real-time, multi-tiered data processing systems - 15 years

Worked with Transact-SQL and stored procedures - 20+ years

Every phase of security-related STIG reconciliation and POA&M processing, to include necessary escalation of mitigation efforts requiring upper management attention and occasional waiver processing – 5 years

Conduct comprehensive system Risk Analyses and Threat Assessments – 4 years

Optimizing database performance (in both On-premise and Azure environments)

Certifications:

IAT Level II - CompTIA Security+

Microsoft Certified Azure Data Engineer Associate

Microsoft Certified DBA: Microsoft SQL Server 2000+ MCDBA

Microsoft Certified Solution Developer MCSD

Microsoft Certified Trainer (Currently Inactive)

Microsoft Certified Systems Admin/Engineer MCSA/MCSE (Currently Inactive)

Certainly willing to earn others as needed

Education:

Education: HS Diploma

Some college, did not graduate

Non-Technical Skills:

Communication skills, both written and verbal, are second to none.

Finely tuned attention to detail.

Has led a team of DBAs and developers to provide application solutions and feature upgrades.

Worked for the government since 2019, deeply involved with STIGs (the inventor of which should receive a Nobel Prize), security compliance management, POA&Ms, and varieties of Security documentation.

Ten-year USAF veteran.

Machine Linguistics: Possess good working knowledge of C, C#, VB, and Python languages; personal experience using Power BI, SSAS and SSRS.

Handle customer/user interactions, including application feature complaints/bug reporting, to track and coordinate with stakeholders to resolve complicated issues.

Security Clearance:

Level of Clearance: Secret, Active

US Citizen

Investigation Type: T3

Eligibility Date: 2019-09-23

Investigation Closed: 2019-08-27

CE Date: 2020-02-02

Employment History:

US Army (ATIS) / JANUS Research Group, LLC

Senior SQL Database Administrator 05/23 – 05/24

Remotely managed and maintained on-premise SQL databases.

Addressed STIG issues (for both database servers and databases), responses to ISSMs.

Migrated five SQL Databases from legacy servers

Used T-SQL language to create SQL queries, which were mainly used for managing a bullet-proof migration process and checking database health.

Analyzed T-SQL and stored procs to determine bottlenecks and overall efficiency.

Utilized SSMS and SQL Server's native tools to monitor performance and suggest improvements.

DMI / Electrosoft

Lead Developer / SQL DBA 05/19 – 05/23

Managed and modeled SQL databases - On-Premise and Azure SQL Managed Instance on Gov Cloud.

Created and troubleshot complex Views, Triggers, Stored Procs, Functions, Nested Stored Procs and Nested Views.

Addressed STIG issues (for both database servers and app servers), responses to ISSMs, SAs. Escalated open STIG items to necessary responsible parties, established audit-proof POA&Ms and responses.

Created Security Docs - Risk Analyses, Threat Models, Privacy Impact Assessments, Cyber Incident Handling Plans for both database servers and application servers.

Responsible for code reviews, troubleshooting, light systems administration, and code release management.

Used T-SQL language to write very complex nested SQL queries to generate record-sets for reports, and importing and exporting data.

Used Git as a software version control system.

Used stored procs to create and populate temporary tables for aggregating data for reports and data warehousing.

Handled many factors which were involved in improving query performance, including indexing, tracing, and trying many different methods of achieving the same (desired) result.

Supervisor of code developers and database administrators.

Kobrand Corporation

SQL Server DBA/Developer 07/07 – 03/19

Managed SQL Server databases from version 2000 through 2016, and all database responsibilities, including database and data modeling.

Migrated an especially primitive data platform (data “transferred” vocally over the telephone in various foreign languages!) to automated on-demand data connections to a worldwide collection of desktop databases (Access, Filemaker Pro, dBase, Foxpro, Boland Paradox, R:Base, Lotus Approach) that ran scripted processes and SSIS pipelines that would ETL data into SQL Server.

Created complex Views, Triggers, Stored Procs, Functions, nested views & procs.

Performed report writing from various data feeds, including SSRS, Tableau, Access, Jet.

Used T-SQL language to write very complex nested SQL queries to generate record-sets for reports, and importing and exporting data.

Created and deployed many SSRS reports to replace dozens of poorly designed Excel spreadsheets.

Used SSIS ETL to import data into SQL Server and MS Access.

Used multiple stored procs to monitor and maintain server health and to improve throughput.

Managed and moved many tables from MS Access (and Jet) to SQL Server, conducting much performance tuning.

Other Employment History:

Independent Consulting

Microsoft Certified Trainer 12/03 – 05/10

Taught classes on SSIS, SSAS, SSRS, .NET Framework, Visual Basic .NET, Microsoft Office products.

Ten-year U.S. Air Force Veteran

Contact this candidate