DUSTIN MARZOLF

Implemented system enhancements to propose, design and develop solutions to fulfill requests and address problem reports.

• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Established company automation methodology, frameworks and tools.
• Kept on track with deadlines for development cycle times.
• Utilized expertise in PowerShell to assist companies in migrating on premise SQL environments to Azure as well as other cloud providers using provider supplied PowerShell modules
• Developed REST APIs using PowerShell to create self-service solutions for developers.
• Assisted companies in creating IaC solutions for SQL Server in Microsoft Azure.
• Assisted companies in automating and securing on-premise and cloud environments using Desired State Configuration and Microsoft "Just Enough Administration" to allow for fine grained control over user access that cannot be attained via traditional active directory policies and permissions.
• Developed holistic enterprise SQL configuration management and administration using PowerShell and C# to assist company that had two DBAs manage well over 500 SQL Servers.

• Exhibited strong technical aptitude and application expertise resulting in optimized performance, continuous improvement recommendations and product innovation.
• Conducted Research to determine feasibility of requested process improvements, presented findings to stake holders, communicated technical development stages and developed requirements for targeted automation solutions.
• Developed custom test automation using Powershell to insure Terraform Modules were maintained to company specifications.
• Automated Azure Sentinel Deployment
• Started process of developing PowerShell based AWS Lamda Functions
• Developed PowerShell module to assist the company in codifying their requirements for Server Builds.

• Focused on developing IaC for Microsoft Azure deployment, configuration and validation using Powershell and azure automation.
• Helped team integrate powershell into Ansible and terraform.
• Worked on fully agile team
• Helped other team members increase efficiency and decrease execution time of automation through powershell multiple threading
• Improved maintainability and decreased complexity of IaC scripts for the end user using Powershell Classes.
• Automated Microfocus Quality Center ALM test execution and sign off using a Powershell class that leveraged the QC REST API.
• Developed automated Powershell configuration validation and remediation solution. To insure requirements were being met and drift was fixed without user intervention.
• Developed automated solution so application teams could take database backups by creating a completely powershell based web application that utilized a rest api written 100% in powershell.
• Helped create a powershell based configuration Management system where the IaC could pull needed configuration values from if they weren't passed in at runtime.
• Worked with technical architects and translated requirements into code.
• Worked with the security team to help them better understand how to apply proper policies around SQL server, and how to implement auditing that met FINRA and NIST requirements.
• Automated creation, configuration, and azure active directory authentication enablement on SQL MI.
• Established company automation methodology, frameworks and tools.
• Maintained, debugged and optimized automation programs.

• Automated Patch Checking Process reducing toil significantly from 24 hours over 3-4 evenings between two people to 15 minutes.
• Developed and Rolled out Agent-Based Backups solution to the database environment. Backups were not taking place consistently prior.
• Developed and rolled automated agent-based Database Maintenance solution for corruption check and re-indexing that were not taking place prior.
• Developed an on demand automated solution to move all Edward Jones employees home directories moving to Microsoft One Drive. Utilizing SharePoint as the web interface and powershell to preform the work. Saving potentially hundreds of hours of manual work.
• Developed and Implemented comprehensive performance monitoring and alerting solution
• Developed and implemented log shipping monitoring solution to ensure we were meeting required RPO/RTO requirements.
• Created and implemented database designs and data models.
• Tested programs and databases to identify issues and make necessary modifications.
• Planned and implemented security measures to safeguard vital business data.
• Modified existing databases to meet unique needs and goals determined during the initial evaluation and planning process.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Set up and controlled user-profiles and access levels for each database segment to protect important data.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Created scripts and processes for data integration and maintenance.

• Designed and implemented a central audit log solution to provide a record of data changes on critical tables for government compliance.
• Designed and Implemented a standard database maintenance solution, which included Corruption Checking, Intelligent Index Defragmentation, and Intelligent Statistics Updates.
• Designed and Implemented both an enterprise monitoring solution (PandoraFMS) for their entire environment and a SQL Specific monitoring solution to closely monitoring key performance metrics of their SQL Environment.
• Stood up company-wide git repository so all development could be tracked and stored somewhere safe.
• Implemented a company-wide Wiki (Dokuwiki) so that we had a central information repository.
• Designed PowerShell Script to crawl the entire environment and Active Directory Structures, and pull back information on all the Servers and Network devices and all-important AD objects, so that the company had comprehensive documentation on its servers.
• Created comprehensive and detailed run-books on all SQL Servers using PowerShell so that there was comprehensive documentation on the SQL servers that could be used to rebuild them if all was lost.
• Automated Several processes that were being done manually, including Excel, reports with pivot tables using PowerShell.
• Wrote several SSRS reports based on business needs.
• Designed and implemented a central audit log solution to record data changes on critical tables for government compliance.
• Was on-call for the entire 9 months
• Tuned the SQL servers at the instance level, Index, and query level to improve server performance to save them money on throwing more hardware at poorly written queries and incorrect indexing.
• Worked with Developers on troubleshooting query issues such as deadlocking and blocking that was causing business disruption.
• Developed and implemented an automated system to keep Virtual Log File numbers in check throughout the SQL environment due to it causing performance issues.

• Created easily follow-able documentation for other database administrators to reference for self-developed solutions Replaced several old and outdated SSIS packages with PowerShell based solutions or with Hybrid solutions utilizing both PowerShell and SSIS to create more resilient solutions that were easier for lower-level staff to troubleshoot and maintain Participated in on-call rotation once every 3 weeks Helped maintain and troubleshoot all HA and DR solutions including Fail-over Clusters, Log shipping, and Availability groups Performed in collaboration with other database administrators keep the lights on type of work.
• Revamped their SQL Server setup procedures using Desired State Configuration and a self-developed PowerShell module to speed up the setup process from a 3-day process to less than a day(~2 hours depending on the day's workload) by removing almost all manual steps.
• Managed the web development teams SQL Servers in Azure
• Helped design a concise, repeatable framework and PowerShell module that could be utilized by level one support staff to handle and troubleshoot SQL Server issues.
• Created easily follow-able documentation for other database administrators to reference for self-developed solutions Replaced several old and outdated SSIS packages with Powershell based solutions or with Hybrid solutions utilizing both Powershell and SSIS to create more resilient solutions that were easier for lower-level staff to troubleshoot and maintain Participated in on-call rotation once every 3 weeks Helped maintain and troubleshoot all HA and DR solutions including Fail-over Clusters, Log shipping, and Availability groups Performed in collaboration with other database administrators keep the lights on type of work.
• Ensure all backups and SQL Agent jobs were completing.
• Perform restores for accidental table deletions by the development teams.
• Investigate and database corruption and ensure all Re-indexing jobs were completed as expected.
• Worked in concert with the development teams to troubleshoot any application connectivity issues to the database server.
• As well as any poorly performing queries and stored procedures.

• Microsoft SQL Server DBA (App/Infrastructure).
• Served as Microsoft SQL Server DBA and Subject Matter Expert.
• Provided monitoring and assisted in troubleshooting various issues with the SQL Server environment; backups, index maintenance, database integrity checks, several 3rd party application as well proprietary applications developed in-house Assisted in performing monthly security audits Administration of database privileges Performance tuning (Index Tuning, Query Tuning, and General Performance Troubleshooting).
• Performed Analysis of current monitoring needs and determined the company was paying for a monitoring application and licenses that were not necessary.
• Potentially saving the company $1,000's a month.
• Implemented tools for Monitoring/Troubleshooting/Implementing HA/Failover Clusters/AGs/Mirroring/Log Shipping.
• Planned, evaluated, and deployed upgrades and patches.
• Developed and Implemented Centralized Management Database to automate and simplify daily tasks.
• Automated several manual tasks and helped developers update old SSIS packages to meet new business needs.
• Developed a stored procedure so developers could quickly restore a copy of the production database on their local instance for development purposes.

• Worked Remotely From My Home Office 95% of the time Acted as a managed services DBA for 20 clients ranging from small to medium-sized companies.
• Oversaw all aspects of their database environments both in Azure and some were at the customer's business.
• Worked with customers in tuning stored procedures and worked with third-party application vendors to optimize the SQL Server and Applicationperformance.
• Oversaw the maintenance and resolved any issues that arose regarding HA solutions( AGs and Fail-over clusters) Performed consultation duties to companies that needed an MSSQL Subject Matter Expert to perform specific tasks but did not want to pay for managed services.
• Performed proactive monitoring of customers' environment and reached out to them with various recommendations on how they could mitigate things from becoming a problem or informed them of potential issues down the road.
• Received, owned, responded, and resolved client issues through phone calls, e-mails, and tickets meeting all SLAs Performed all migrations of customers SQL servers if they wanted to migrate the instances.
• Initially worked with another DBA on-call sharing every 2 weeks.
• Three months into the job, the other DBA left the company.
• Performed all on-call duties for 2 months straight.
• Oversaw all customer environments.
• Proposed the use of work plans and better change management to more efficiently serve our clients.
• Resolved SSRS and SSIS issues such as reports randomly failing and SSIS packages not completing or not completing quickly enough.

• Managed Microsoft SQL Server database administration assignments for a diverse set of customers.
• Monitored/troubleshot client SQL Servers for backup failures, SQL Agent job failures, and critical performance metrics.
• Implemented, monitored, and troubleshot client HA solutions (Mirroring, Failover Clustering, Log Shipping, and Availability Groups).
• Received, owned, responded, and resolved customer issues through phone calls, e-mails, and escalation from the staff of support engineers.
• Worked with clients and Microsoft engineers to provide root cause analysis on any issues that caused a loss in production.
• Performed customer migrations, either for new customers migrating over servers from their past environment or when current clients want to upgrade to a newer SQL Server version.
• Designed several custom PowerShell scripts for backups, alerting, and automation of client migrations.
• Managed Customers environments in Azure
• Developed stored procedures to automate the restoration of databases so the support staff could perform them without having to escalate to the DBA team.
• Created a set of stored procedures and batch jobs that automate rolling out a server-side trace to a client's server.
• Served as the on-call escalation point 1 week every month, 24 hours a day.

• Worked with many different technologies and information systems.
• Responded to system-generated alarms and notifications from our internal infrastructure and client's environments.
• Quickly diagnosed issues and resolving as soon as possible to meet client SLAs.
• Worked with customers and their environments to address issues, expand for future growth, or assist in implementing the latest technologies to increase efficiency and the end-user experience.
• Hired as a Support Engineer
• DBA in less than one and one-half years.
• Worked with various Systems Engineers (Virtualization, DBA, and The Web) to troubleshoot client issues and develop strategic plans for resolution.
• Trained new support engineers I, II, II on best practices, troubleshooting, and other system administration tasks (Active Directory, Exchange, Juniper, Riverbed, F5).
• Created documentation around best practices and proper procedures to perform system administration duties.
• Cosentry bought out Xiolink in 2014.