Senior Software Developer - Databases at Intelerad

Job description

Role Overview When radiologists receive the right study at the right time, patients get answers faster, and behind every worklist, search, and assignment is a database that has to respond quickly and correctly. As a Senior Software Developer focused on the data layer of our InteleOrchestrator team, you’ll modernize the SQL Server-backed platform that streamlines radiology workflows for healthcare providers around the world. You’ll write the code that changes the database: refactoring schemas and queries, untangling legacy data-access code, and moving it to type-safe, well-tested patterns while the system stays live for clinicians. This is a hands-on software development role, not a database administration role; your time will be spent in code, query plans, and pull requests rather than in backups, patching, or server operations. Success in this role means faster, safer, and more maintainable data access that reduces clinical burden and gives time back to the clinicians who depend on it. Key Responsibilities • Lead complex database refactoring across a large, mature SQL Server schema, including restructuring tables, keys, and indexes, retiring legacy structures, and backfilling and normalizing data, delivered as safe, incremental, version-controlled migrations (e.g., Liquibase) with no disruption to clinical users. • Diagnose and resolve performance problems at the source by reading execution plans, rewriting queries to be sargable and set-based, replacing row-by-row processing with batched writes and properly indexed temp tables, and designing covering and filtered indexes based on real workload evidence. • Modernize the data-access layer by migrating legacy and inline SQL in PHP and C# code into type-safe Kotlin and jOOQ repositories, preserving behavior through characterization, regression, and scale testing. • Harden data access for security and reliability by eliminating SQL injection through parameterization and automated checks, establishing consistent locking, isolation, and query-timeout conventions, and building query attribution and diagnostics that trace database load back to the code responsible for it. • Build the tooling that makes database change routine, including migration and upgrade pipelines in Gradle and CI/CD, containerized SQL Server test environments, and automated checks that catch regressions before release. • Shape technical direction by defining SQL and data-access standards, documenting conventions, and contributing to architecture decisions and the InteleOrchestrator technical roadmap. • Partner with and mentor fellow developers through code reviews, knowledge sharing, and technical guidance, helping application teams write efficient, safe database code and fostering a culture of continuous learning. Qualifications & Experience • Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience. • 7+ years of professional software development experience, including 4+ years in which writing and refactoring database code (SQL, schemas, and data-access layers) for production systems was a core part of the role. • Expert-level T-SQL on Microsoft SQL Server, including query optimization, execution plan analysis, indexing strategy, temp tables, CTEs, window functions, stored procedures, and set-based design; PostgreSQL experience is also valued. • Proven track record of incrementally refactoring a large, legacy relational schema and the application code that depends on it while in production, not only greenfield database design. • Proficiency in Kotlin or Java, or an equivalent language, building backend services with Spring Boot or an equivalent framework. • Hands-on experience with database migration and version-control tools such as Liquibase or Flyway, treating schema as code within Git-based CI/CD pipelines. • Strong understanding of concurrency, locking, isolation levels, and transactional integrity, and how they affect application behavior under load. • Solid grounding in secure data-access practices, including SQL injection prevention and safe handling of sensitive patient data. • Experience delivering in agile teams using Gradle, Git, and modern DevOps practices across Windows and Linux environments. Preferred Qualifications & Special Requirements • Experience with jOOQ or similar type-safe SQL libraries and code generation from database schemas. • Experience reading, maintaining, and porting legacy application code in PHP and/or C# (.NET). • Experience with database testing approaches such as Testcontainers or Docker-based SQL Server environments, golden-master or characterization tests, and load or scale testing of queries. • Familiarity with SQL Server diagnostic tooling (Query Store, DMVs, Extended Events) and observability platforms such as Datadog or New Relic. • Experience with AWS data services such as Amazon RDS for SQL Server. • Experience working with healthcare data standards such as HL7 and DICOM, or building software in other regulated industries (e.g., FDA- or FAA-regulated environments). • Location: This role is open to candidates based in the United States or Canada. This job description is not a comprehensive list of tasks or requirements and Intelerad reserves the right to change it at any time. All your information will be kept confidential according to EEO guidelines. Applicants may be required to complete an online technical and/or personality assessment as part of your application. #LI-REMOTE The base pay for this position ranges from $100,000 to $140,000/yr USD within any geographic market in Canada. Pay may vary depending on job-related knowledge, skills, and experience. Intelerad is a total compensation company. Pay is dependent on the position offered. Bonus and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, retirement, PTO, and/or other benefits. Intelerad is committed to the principles of equal employment. We are committed to complying with all federal, state and local laws providing equal employment opportunities and all other employment laws and regulations. Applicants, employees and former employees are protected from employment discrimination based on race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age , disability and genetic information (including family medical history). Intelerad is dedicated to the fulfillment of this policy regarding all aspects of employment, including but not limited to recruiting, hiring, placement, transfer, training, promotion, rates of pay, and other compensation, termination, and all other terms, conditions, and privileges of employment.   Intelerad is committed to ensuring equal employment opportunity for qualified individuals with disabilities. Intelerad uses the Americans with Disabilities Act (“ADA”)as a standard for global recruiting and hiring purposes. This prohibits discrimination against qualified individuals with disabilities. The ADA defines “disability” as a physical or mental impairment that substantially limits one or more of the major life activities of an individual, a record of such impairment, or being regarded as having such an impairment

Requirements

Must-haves

Modernize the data-access layer by migrating legacy and inline SQL in PHP and C# code into type-safe Kotlin and jOOQ repositories, preserving behavior through characterization, regression, and scale testing.
Build the tooling that makes database change routine, including migration and upgrade pipelines in Gradle and CI/CD, containerized SQL Server test environments, and automated checks that catch regressions before release.
Shape technical direction by defining SQL and data-access standards, documenting conventions, and contributing to architecture decisions and the InteleOrchestrator technical roadmap.
Partner with and mentor fellow developers through code reviews, knowledge sharing, and technical guidance, helping application teams write efficient, safe database code and fostering a culture of continuous learning.
Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.
7+ years of professional software development experience, including 4+ years in which writing and refactoring database code (SQL, schemas, and data-access layers) for production systems was a core part of the role.
Proven track record of incrementally refactoring a large, legacy relational schema and the application code that depends on it while in production, not only greenfield database design.
Proficiency in Kotlin or Java, or an equivalent language, building backend services with Spring Boot or an equivalent framework.
Hands-on experience with database migration and version-control tools such as Liquibase or Flyway, treating schema as code within Git-based CI/CD pipelines.
Strong understanding of concurrency, locking, isolation levels, and transactional integrity, and how they affect application behavior under load.
Solid grounding in secure data-access practices, including SQL injection prevention and safe handling of sensitive patient data.
Experience delivering in agile teams using Gradle, Git, and modern DevOps practices across Windows and Linux environments.
Experience with jOOQ or similar type-safe SQL libraries and code generation from database schemas.
Experience reading, maintaining, and porting legacy application code in PHP and/or C# (.NET).
Experience with database testing approaches such as Testcontainers or Docker-based SQL Server environments, golden-master or characterization tests, and load or scale testing of queries.
Familiarity with SQL Server diagnostic tooling (Query Store, DMVs, Extended Events) and observability platforms such as Datadog or New Relic.
Experience with AWS data services such as Amazon RDS for SQL Server.
Experience working with healthcare data standards such as HL7 and DICOM, or building software in other regulated industries (e.g., FDA- or FAA-regulated environments).
Location: This role is open to candidates based in the United States or Canada.
This job description is not a comprehensive list of tasks or requirements and Intelerad reserves the right to change it at any time.
All your information will be kept confidential according to EEO guidelines.
Applicants may be required to complete an online technical and/or personality assessment as part of your application.

Nice-to-haves

Preferred Qualifications & Special Requirements

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlkotlinci/cdjavaagiledockeraws

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

Pto