Database and DevOps Engineer

PathGroup•Nashville, TN

About The Position

The Database & DevOps Engineer is a hands-on, database-focused engineering role responsible for the performance, reliability, and overall health of Microsoft SQL Server databases supporting PathGroup’s critical transactional applications. The role proactively monitors, analyzes, troubleshoots, and optimizes production databases, combining advanced SQL Server and T-SQL expertise with professional software development experience and independent troubleshooting across database and application layers. The engineer also contributes to application support and software development by investigating defects, implementing fixes, and changing PathGroup applications. The role balances database priorities with application defects, support issues, and other approved software changes as part of the Platform Engineering workload. Work includes developing, testing, and implementing approved database and application changes in accordance with the PathGroup SDLC, maintaining data integrity and operational reliability, supporting production incidents, and following security practices and regulatory guidelines to protect sensitive company data and protected health information.

Requirements

  • Must be an excellent problem solver who can work independently.
  • Ability to prioritize duties and demonstrate attentiveness to detail.
  • Demonstrated ability to safely develop, validate, and execute T-SQL data updates in transactional database environments while maintaining data integrity.
  • Effective oral and written communication skills and excellent interpersonal skills.
  • Upbeat attitude, willingness to accept challenges, and ability to perform under pressure.
  • Advanced proficiency with Microsoft SQL Server and T-SQL.
  • Strong experience troubleshooting and optimizing SQL queries, stored procedures, indexes, and execution plans.
  • Strong understanding of database performance concepts, including indexing, statistics, locking, blocking, deadlocks, query optimization, transaction management, and resource utilization.
  • Experience monitoring and troubleshooting production SQL Server environments.
  • Strong understanding of relational database design, data integrity, and transactional database concepts.
  • Demonstrated ability to read, troubleshoot, modify, test, and support application code.
  • Experience with C#/.NET is required.
  • Ability to analyze existing application code and identify how application behavior affects database performance.
  • Ability to independently develop, modify, test, and troubleshoot application code to resolve defects, production issues, performance issues, and other approved software changes.
  • Experience diagnosing complex problems spanning application, database, infrastructure, and integration layers.
  • Understanding of software development lifecycle, source control, testing, deployment, and change-management practices.

Nice To Haves

  • C++ experience.
  • Experience with AardVrk.

Responsibilities

  • Be accountable for the performance, reliability, and overall health of Microsoft SQL Server databases supporting critical transactional systems.
  • Perform approved production database updates and corrections in response to authorized business requests, following validation, change-control, and documentation processes.
  • Review and approve database schema, stored procedure, and other database-object changes for PathGroup applications, assessing their effects on performance, reliability, and data integrity.
  • Identify and recommend improvements to data management practices, database standards, performance, reliability, and supportability.
  • Proactively monitor and analyze SQL Server health and performance, including query performance, blocking, deadlocks, resource utilization, execution plans, and indexing.
  • Troubleshoot and resolve database performance issues using query optimization, indexing, stored procedure changes, database configuration, or application changes as appropriate.
  • Analyze T-SQL queries, stored procedures, execution plans, indexes, statistics, and database objects for opportunities to improve performance, reliability, and scalability.
  • Analyze root causes of application and database failures and modify application code or database logic as necessary.
  • Troubleshoot complex production issues across database and application layers, identify root causes, and implement sustainable solutions.
  • Review application database interactions and identify inefficient data-access patterns, excessive database calls, or application behavior affecting database performance.
  • Implement approved application software and database changes to correct problems, improve performance, or enhance functionality.
  • Monitor and respond to production database and application health issues, participating in incident troubleshooting and resolution as needed.
  • Perform root-cause analysis for significant database and application incidents and recommend corrective and preventive actions.
  • Investigate defects, troubleshoot production issues, and design, develop, test, and implement approved application code changes following the PathGroup SDLC.
  • Develop and test database and application changes to verify performance, reliability, data integrity, and functionality before production implementation.
  • Monitor and validate database maintenance processes and partner with Infrastructure to support established recovery objectives, including RPO and RTO requirements.
  • Participate in the PathGroup Support Process.
  • Perform job responsibilities in alignment with industry security practices and regulatory guidelines to protect the confidentiality, integrity, and availability of protected health information and other sensitive company data.
  • Become familiar with and comply with the Corporate Compliance Program and Corporate policies, including Privacy and Security policies.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service