Part Delivery Active Directory

Jarrod W. (“Wade”) Hudson

Salado, TX *****

254-***-**** (U.S.)

*********@*****.***

LinkedIn: https://www.linkedin.com/in/j-wade-hudson-b3771a35/ EDUCATION and CERTIFICATION

Master of Science, Information Systems – August 2006 Tarleton State University-Central Texas (Texas A&M System), Killeen, TX

Bachelor of Science, Industrial Technology, Minor in Mathematics – May 1997 Southern Illinois University-Carbondale, Carbondale, IL

U.S. Army Signal Officer FA 53A Information Systems Management

Certified Information Systems Security Professional (CISSP), 2018

Microsoft Certified Solutions Expert (MCSE) Data SQL Server Database engineerManagement and Analytics SQL Server 2012/2014/2016

Certified Dimensional Modeling: The Kimball Method – Taught by Margy Ross

(June 2019), Owner of DecisionWorks Consulting, President of Kimball Group

Microsoft Certified Azure Data Engineer Associate, 2021

Databricks Certified Associate Developer (Python/PySpark), 2021

Databricks Certified Data Engineer Professional, 2022 CAREER AND SKILLS SUMMARY

I am a Developer and Information Technology professional with over 10 years experience providing various C#.NET, SQL Server, Azure, Databricks and assorted testing services within the US Department of Defense and corporate organizations. As a certified and experienced professional for Databricks, SQL Server, and Azure Data Engineering, I am fully proficient in all aspects of the aforementioned technologies, to include security, infrastructure design, performance tuning/optimization (server level and database/code level), code reviews/change management, monitoring, high availability, and operations and maintenance. I am extremely proficient with PowerShell and T-SQL. Specific technologies that I am proficient with include: C#, Python (PySpark), Databricks (Batch and Streaming solutions), Azure DevOps Tools, Azure CLI, Azure Synapse Analytics (Azure Data Lake and Blob Storage, SQL Data Warehouse, Azure Data Factory), CosmosDB, Azure Key Vault, Azure Stream Analytics, Azure Event Hubs, Azure Web App, Azure Functions, PowerBI, Azure SQL, SQL Server (2008R2 and above), SQL Server Availability Groups, SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS), SQL Server Analysis Services (SSAS). I have a basic understanding of HTML, CSS, Javascript, Angular, and Bootstrap. I am a retired U.S. Army Logistics and Signal Officer, and my military career culminated at the rank of Lieutenant Colonel while finishing in the Reserves. I am a problem-solver and a life-long learner.

EXPERIENCE

Home-based Proficiency Training Salado, TX 2/2020-present Databricks Professional Data Engineer and Azure Data Engineer Associate *********@*****.***

Stood up an end-to-end ELT (Extract Load Transform) batch and streaming solution for a fictitious gym chain that recorded and analyzed exercise and fitness data, using PySpark and some Scala.

Automated the standup of a Databricks Architecture which included simulated Kafka feeds and PowerBI reporting.

Am fully versed, as certified by Databricks, in query tuning/optimization and right-sizing clusters.

I understand some Machine Learning algorithms within the Databricks Workspace.

Integrated various solutions within GitHub and Azure DevOps tools.

Integrated Azure Stream Analytics with CosmosDB and partitioned for a multimaster, globally replicated solution.

Stood up and provisioned both Azure SQL and Azure Datawarehouse Dimensional Fund Advisors Austin, TX 9/2018-11/2021 SQL Server Applications DBA Developer

Performed code reviews for T-SQL code releases for various financial databases in stage and production environments. Oversaw and assisted with code development to ensure transactionally safe, durable, reliable and efficient code that would provide optimal database performance.

Evaluated execution plans, refactored poorly performing code, created relevant and effective indexes to optimize code, and assisted with the creation/refactoring of database objects (tables, views, stored procedures, functions, triggers and linked servers) to support optimizing database performance.

Performed incident-related causative research and repair for poorly performing database code, indexes and statistics using various tools to include dynamic management views, system stored procedures, third party tools.

Rectified locking and blocking issues and rectified performance bottlenecks.

Served as the database section’s Security Coordinator to assist with cybersecurity planning, audits and accreditation. Deployed T-SQL code for code releases to SQL Server 2008R2/2012/2014/2016.

Performed query, index, and performance tuning by analyzing execution plans and using such tools as dynamic management views (DMVs), System/Performance Monitor, Activity Monitor, SQL Profiler/Trace and Extended Events.

Assisted with T-SQL code upgrades in preparation for migrating legacy databases to SQL Server 2016.

Served on 24/7 on-call rotations. Fixed emergency incidents.

Performed table-level restores to recover developer errors.

Administered Active Directory, SQL Server and database permissions.

Created, administered, optimized and deployed SSRS (SQL Server Reporting Services) reports.

Created various conventional and advanced SSIS (SQL Server Integration Services) packages with conventional and C#.NET tasks and data flow components to move database data.

Built an ASP.NET WebAPI 2.0 REST web service to assist with automating database restores.

o Wrote the C# code to provide client-to-server functionality across http o Stood up the web server machines, engineered basic networks, administered IIS

(Internet Information Services)

o Refactored several stored procedures and SQL Agent jobs to allow the web service to function.

o Built and documented all the procedures to administer the web service.

Built various tools with PowerShell to automate various administrative functions. *********@*****.***

Created Python-based graphs to display statistics and analyze performance for various stored procedures.

Vectrus U.S. Army Camp Arifjan, Kuwait 1/2016-8/2018, and 12/2021-present

SQL Server Database Engineer

Managed, Created, and Stood up various SQL Server 2008R2/2012/2014/2016 standalone, Failover Cluster Instances, and Availability Groups. There were 50 servers and over 300 databases within several VMWare virtual machines that serviced over 20 different applications, and business performance Recovery Time Objectives and Recovery Point Objectives were met for each application.

Designed and troubleshot various LAN network ports, protocols, and services as part of managing and creating various SQL Server platforms.

Performance-tuned servers, databases and indexes; automated backups and restores; migrated databases and servers; automated the management, alerting, and migrations of server platforms with PowerShell, T-SQL and various other scripting technologies.

Supported a database migration to mitigate spillage and significantly reduced downtime via point-in-time restores.

Designed database capacity to support future usage.

Wrote custom queries to answer business questions to include providing XML-based reports.

Created and managed SQL Agent automated jobs and maintenance plans to keep the database platforms in optimum state.

Wrote the Vectrus SWACC SQL Engineer checklist to conduct hiring interviews.

Created numerous PowerShell and T-SQL scripts to assist in monitoring and managing the environment, for the database team as well as other teams within the organization.

Coordinated for the creation and application of appropriate Active Directory accounts, security groups, and Group Policy Objects.

Applied service packs and Information Assurance Vulnerability upgrades.

Hardened servers, database server instances, and databases using the correct Defense Information Systems Agency (DISA) Security Technical Information Guides (STIGs) that altered registry settings and implanted Auditing, Tracing, custom functions, and Triggers.

Took charge of the database team, trained three personnel, and performed the work of four team members with just two people.

o Managed work tasks.

o Provided input for routine personnel scheduling and special projects. o Documented substandard performance for one substandard employee. o Organized and quality controlled administrative and design documentation. Leidos Lackland AFB, TX 2/2015-12/2015

C#.NET/ASP.NET/SQL Server Developer

Created database tables, constraints, stored procedures, functions, and automated SQL jobs for the suite of applications.

Performance-tuned SQL queries, created and maintained indexes, partitioned databases, and administered SQL Server 2012 databases.

Created SQL Server Integration Services (SSIS) packages to Extract Transform and Load

(ETL) financial data.

Created custom databound ASP.NET pages, web forms and web parts for a suite of custom web applications that manage Non-Appropriated Funds for the U.S. Air Force. Made use of HTML5, CSS3, Bootstrap, Javascript, AJAX, jQuery and XML. *********@*****.***

Created C#.NET business and data access methods and classes for a suite of custom web applications that manage Non-Appropriated Funds for the U.S. Air Force.

Created custom security and auditing paradigms in accordance with requirements stipulated by DISA’s application security and other relevant STIGs. Maintained compliance using HP’s Fortify Static Code Analyzer.

Deployed the web applications to IIS 7.0 and administered the web applications for certificate logins.

Home-based Proficiency Training Killeen, TX 10/2014 – 01/2015 SQL Server Database Administrator and Business Intelligence Developer

Created SQL Server Integration Service (SSIS) packages to perform Extract, Transform, and Load (ETL) operations to migrate data from line-of-business OLTP databases to data warehouses.

Profiled and corrected data using Data Quality Services and Master Data Services.

Installed SQL Server Analysis Services (SSAS) and created OLAP data models

(Multidimensional cubes and Tabular BISM models) from a data warehouse. Created MDX queries and DAX expressions to query those data models.

Preaggregated data within OLAP data models using MOLAP, ROLAP, and HOLAP techniques.

Built standalone and Microsoft SharePoint/Active Directory integrated Self-Service Business Intelligence drill-down and drill-through reports using SQL Server Reporting Services (SSRS) and Microsoft Excel 2013 Power BI services: PowerQuery, PowerPivot, PowerView, PowerMap, and PerformancePoint services. Integrated business Key Performance Indicators (KPIs) into self-service reporting technologies. CSTF Contract, various contractors Fort Hood, TX 4/2007-10/2014 Senior Operations Research Systems Analyst (ORSA) and Test Engineer

Produced numerous reports based complex custom SQL aggregation queries to support man-hour accounting and testing and evaluation of numerous test events, using SQL Server 2008R2 and MicroStrategy.

Stood up a custom web application and SQL Server within a Microsoft Active Directory environment to support accurate man-hour estimates of numerous future test events.

Established a High Availability SQL Server cluster across a local area network.

Administered the SharePoint portal and the test incident database for the directorate.

Served as Chief Architect of the Test Architecture for numerous test events.

Architected numerous test events and the automated data collection infrastructure to support evaluation of those events.

Validated system architectures and instrumented data in support of test events.Supervised 60 Information Technology employees.

Created and ran various test plans for various DoD tactical systems.

Validated numerous logical Test Plans, Architectures and Reports of Army software systems tests. Made recommendations regarding their compliance with DoD requirements.Chaired numerous test incident adjudication boards. U.S. Army (TXARNG) Fort Gordon, GA 10/2010-5/2011

Information Systems Management Officer (Functional Area 53)

Designed and integrated diverse forms of enterprise WAN and LAN network and application services such as: email, file servers, network applied storage, active directory, databases, and Web conferencing and collaboration Knowledge Management portals in support of the Army warfighting operations, using the latest enterprise-level technologies such as: Cisco *********@*****.***

Routers and Switches, Microsoft Servers/Services (Active Directory, SharePoint, MS Exchange, SQL Server), VMWare and Adobe Connect while integrating Army accredited security concepts and technologies.

Trained more than 20 sub-administrators to administer and develop their subsites.

Assisted with the establishment of Active Directory integrated computer networks for three mobilization exercises and one deployment.

Supervised 11 Information Technology employees.

Sterling Trust Company Waco, TX 4/2007 -10/2007

C# Windows Application Developer

Developed Multi-tiered Windows-based financial applications using C#.NET, ADO.NET, Web Services, and T-SQL (SQL Server 2005), within a Service Oriented Architecture. SetFocus, LLC Parsippany, NJ 1/2007 -4/2007

C#.NET Applications Developer

Developed object-oriented and data driven solutions for diverse programming scenarios in C#.

Created, deployed and consumed XML Web Services. United States Army Various Locations 6/1997 - 8/2005 Various Logistics Officer Positions

Reduced National Training Center automation processing time by 75% with the implementation of an integrated database solution that I created. My efforts resulted in recoverable items being diminished by 50%, and saved Fort Irwin training money.

Reorganized local data processing cycles at Fort Irwin to match data processing cycles at the national level which reduced installation repair part delivery times by 1/6th .

Commanded a U.S. Army Maintenance Company with a $174,000 training budget, with responsibility of over $26 million of property and $15 million of repair parts. The company consisted of 210 personnel with 13 specific job specialties, of whom 20 personnel who directly reported to me.

Miscellaneous Certifications/Certificates/Awards

Certified Computer Technology Industry Association (CompTIA.org) o Security+ (2008)

o Network+ (2005)

o A+ (Operating Systems and Hardware, 2005)

Certified Host-Based Security System (HBSS) System Administrator, 2012

Earned U.S. Army Signal FA 53A training certificates: Windows Server 2003/Microsoft Active Directory; MS SharePoint 2003/2007/2010; MS Exchange; VMWare; Cisco Routers, Switches, and Firewalls; Network Attached Storage;

U.S. Army Signal FA 53A Project Management Professional (PMP) certificate

U.S. Army Bronze Star Medal

U.S. Army Commendation Medal

Contact this candidate