Working as a member of a remote team to improve individual health outcomes through data-driven interventions.- Build ETL processes in Python or SSIS to access and transform data from API or SFTP sources into internal data structures- Troubleshoot job failures and track issues to their source, contacting vendors and clients to keep them informed with status updates- Analyze options and formulate study designs for our data science team to use in the AI engine- Create, modify, and test SQL Server tables, views, and stored procedures- Perform code reviews on Python and SQL code for other contributors using GitHub- Advise coworkers and leadership on the use of Git and RedGate software as necessary- Design development workflow for a team of engineers to use best practices for SDLC- Attend client meetings to communicate solutions and stay aligned with goals and timelines

Remotely working to scale and optimize SQL Server so that existing systems and processes continue to work as more clients are brought on.- Supervise a team focused on automating and optimizing existing processes- Write code in Transact-SQL for SQL Server queries, stored procedures, tables, views, etc.- Build tools in PowerShell or C# to automate work where possible, including schema comparisons- Implement tools to scale database change deployments, reducing deployment time by over 90%- Train teammates on SQL and Git, and perform code reviews before merging changes- Create and optimize ETL procedures in SQL Server to load client files into our data warehouse- Refactor tables and stored procedures into structures that make more sense or are more efficient

Creating an environment where SQL Server can be relied on by the developers and users, and creating the tools and processes that help keep it that way.- Ensured all production databases were backed up, restorable, and not corrupt- Troubleshot data and query errors as reported by team members or automatic notifications- Optimized and troubleshot queries and indexes, both in SQL objects and in application code- Designed and Implemented database schema, interfacing with developers to produce solid database design choices and system integration- Developed views, stored procedures, functions, triggers, and SSRS reports- Generated test data and migrated databases through dev, test, and prod environments- Supported high availability databases using Always On Availability Groups and Azure SQL DB- Discussed and coordinated patching, upgrades, and alerts with systems administrators- Worked on specific high priority software development projects as a developer or project manager

Using SQL Server, C#, .NET, Azure, and Ignition to design automation systems that enable employees to do work that is more value-added. - Queried and altered data efficiently with stored procedures, SQL Agent jobs, and queries in SSMS or application code- Designed new database structures based on discussions with various stakeholders as well as data modeling standards such as relational integrity and normalization- Worked as part of a team to build business-critical systems in .NET, SQL Server, and Azure- Built and updated software used throughout the company with Jython in Inductive Automation’s Ignition platform- Integrated disparate software systems via stored procedures or direct database updates- Switched from project to project depending on priority, deadline, and estimated time to completion- Created documentation for new systems as they were developed for support and other developers- Managed the budget, timeline, and prioritization for third-party updates to our ordering system - Developed a system to track all SQL Agent Job history from twelve linked servers in one database- Established an automated system to restore database backups from various high-priority instances and check their integrity on a rotating schedule

Working to keep things running for our users and to communicate effectively through our ticketing system.- Responded promptly to employee requests by phone and e-mail- Resolved hardware and software issues quickly in order to maintain production schedules- Developed scripts to automatically implement procedures and streamline the laptop rollout process- Learned the users’ needs in order to better create workarounds for unresolvable technical issues- Documented steps taken to resolve issues in a wiki so they can be resolved more quickly in the future