| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Brewster, NYTechnical Skill Set:On-premise SQL server installation, upgrade & support Street Address + years (1998 present)SQL Server Street Address , 2019, and earlierT-SQL queries, triggers, stored procs, functions Street Address + years (1998 present)Azure environment and SQL Database administration (Databricks) 4 yearsAzure Data Factory (ADF) 3 yearsETL via SSIS 16 years (2007 2023)Data Warehousing, Backup & Recovery processes, data archiving 10+ yearsHigh Availability / Disaster Recovery 5 years (2019 2023)Replication 2 years (2017-2019)JavaScript 3 years (2020-2023)C# coding and MCSD Certification - 3 yearsVisual Basic (Visual Studio & VB.Net) coding and MCSD Certification - 15 yearsSQL Performance Tuning 5+ yearsSSRS 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 yearsDevelop and maintain maintenance plans and disaster recovery plansMS 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+ yearsDebugging and improving query performance -15+ yearsDeployed code packages using Git check-in - 2+ yearsCreated respective jobs in SQL Agent - 15+ yearsWorked with real-time, multi-tiered data processing systems - 15 yearsWorked with Transact-SQL and stored procedures - 20+ yearsEvery 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 yearsConduct comprehensive system Risk Analyses and Threat Assessments 4 yearsOptimizing database performance (in both On-premise and Azure environments)Certifications:IAT Level II - CompTIA Security+Microsoft Certified Azure Data Engineer AssociateMicrosoft Certified DBA: Microsoft SQL Server 2000+ MCDBAMicrosoft Certified Solution Developer MCSDMicrosoft Certified Trainer (Currently Inactive)Microsoft Certified Systems Admin/Engineer MCSA/MCSE (Currently Inactive)Certainly willing to earn others as neededEducation:Education: HS DiplomaSome college, did not graduateNon-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, ActiveUS CitizenInvestigation Type: T3Eligibility Date: 2019-09-23Investigation Closed: 2019-08-27CE Date: 2020-02-02Employment History:US Army (ATIS) / JANUS Research Group, LLCSenior SQL Database Administrator 05/23 05/24Remotely 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 serversUsed 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 / ElectrosoftLead Developer / SQL DBA 05/19 05/23Managed 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 CorporationSQL Server DBA/Developer 07/07 03/19Managed 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 ConsultingMicrosoft Certified Trainer 12/03 05/10Taught classes on SSIS, SSAS, SSRS, .NET Framework, Visual Basic .NET, Microsoft Office products.Ten-year U.S. Air Force Veteran |
