PathGroup

Database and DevOps Engineer

PathGroup Nashville, Tennessee, United States

Hospitals and Health Care · 1,001-5,000 employees

6 d ago
devops Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The engineer is responsible for the performance, reliability, and health of Microsoft SQL Server databases supporting critical transactional applications. They will also contribute to application support by investigating defects, implementing code fixes, and optimizing database-application interactions.

What they look for

Microsoft SQL Server T-SQL Database Engineering DevOps C# .NET Query Optimization Performance Tuning Troubleshooting Data Integrity Stored Procedures Execution Plans Software Development SDLC Root Cause Analysis Indexing

Requirements

Candidates must possess advanced expertise in Microsoft SQL Server, T-SQL, and professional software development experience with C#/.NET. Strong problem-solving skills and the ability to troubleshoot complex issues across database and application layers are required.

Full description

The Database & DevOps Engineer is responsible for the performance, reliability, and overall health of Microsoft SQL Server databases supporting PathGroup's critical transactional applications. This is a hands-on, database-focused engineering role responsible for proactively monitoring, analyzing, troubleshooting, and optimizing Microsoft SQL Server databases supporting production transactional systems. The position requires advanced SQL Server and T-SQL expertise combined with professional software development experience and the ability to independently troubleshoot issues across database and application layers. In addition to database responsibilities, the engineer will actively contribute to application support and software development by investigating defects, implementing fixes, and making code changes to PathGroup applications. The engineer will balance database priorities with application defects, support issues, and other approved software changes as part of the Platform Engineering workload.

 

Accountable for the performance, reliability, and overall health of Microsoft SQL Server databases supporting critical transactional systems.

  • Perform approved data updates and corrections in production databases in response to authorized business

requests, using appropriate validation, change-control, and documentation processes to ensure data integrity and minimize operational risk.

  • Review and approve database schema, stored procedure, and other database-object changes for

PathGroup applications, evaluating impacts to 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 database health and performance, including

query performance, blocking, deadlocks, resource utilization, execution plans, indexing, and other indicators of database performance.

  • Identify, troubleshoot, and resolve database performance issues through 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 to identify 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 the database and application layers to

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 changes to application software and databases to correct problems,

improve performance, or enhance application 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.

  • Contribute to ongoing application support and software development by investigating defects,

troubleshooting production issues, and designing, developing, testing, and implementing approved application code changes following the PathGroup SDLC.

  • Develop and test database and application changes to ensure 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 all 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 abide by the Corporate Compliance Program and all Corporate

policies, including Privacy and Security policies.

Qualifications

Must be an excellent problem solver who is able to work independently.

  • Ability to prioritize duties and attentiveness to detail required.
  • 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 required.
  • Upbeat attitude, willingness to accept challenges, and ability to perform under pressure

required.

  • Advanced proficiency with Microsoft SQL Server and T-SQL is required.
  • 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 required; C++ experience preferred.

Experience with AardVrk preferred.

  • 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 that span application, database, infrastructure, and

integration layers.

  • Understanding of software development lifecycle, source control, testing, deployment, and

change-management practices.

Similar roles