Who We Are

Clinical Architecture is at the forefront of healthcare IT innovation. Our team is an ambitious group of diverse leaders who balance creativity and expertise to solve tough problems that make a difference. Our environment is positive, casual, and comprised of people dedicated to delivering world-class solutions and exceptional customer service.

Come join our team for happier workdays. SQL Server Database Administrator (DBA) Clinical Architecture is seeking an experienced SQL Server Database Administrator (DBA) to join our team in the Indianapolis, IN area.

Responsibilities (Approximately 20%)

The SQL Server Database Administrator (DBA) will play a critical role in delivering high-quality, reliable healthcare data solutions by partnering closely with Application Developers, Cloud Engineers, Implementation Architecture, and DevOps teams. The ideal candidate is an experienced SQL Server professional who thrives in a collaborative development environment. This individual will write, review, and optimize SQL, assist with schema design, improve query performance, and promote best-practice coding standards across multiple systems.

Responsibilities

such as managing on-premises SQL Server environments and cloud-based SQL platforms (including Amazon RDS, Azure Managed SQL Instances, and Google Cloud SQL), with a focus on availability, security, and overall platform reliability. Experience must be rooted in 3-tier application development with real-time, high-volume transactional (OLTP) workloads, not ETL pipelines or data warehouse environments. This role is required to be on site at our Carmel, IN Headquarters.

Clinical Architecture offers ample flexibility to accommodate a healthy work-life balance. Providing false information on application questions may result in automatic dismissal of your application. Please answer questions truthfully and to the best of your ability.

Database Administration: Install, configure, and maintain on-prem SQL Server instances (SQL Server 2016 and newer). Administer Cloud Service Provider SQL Server instances, including monitoring, snapshots, and instance configuration. Manage SQL Server Agent jobs, linked servers, Database Mail, and other database platform components.

Implement, monitor, and continuously improve backup and disaster recovery strategies. Performance and Reliability: Troubleshoot performance issues using execution plans, Query Store, and dynamic management views (DMVs). Identify and resolve blocking, deadlocks, and query performance bottlenecks.

Design and maintain effective indexing and statistics strategies. SQL Development: Write, review, and optimize stored procedures, functions, views, and inline SQL used by application teams. Collaborate with developers to improve schema design, query patterns, and performance optimization.

Promote and enforce SQL coding standards and best practices. Security and Compliance: Apply least‑privilege security models and manage database access and permissions. Support compliance initiatives such as HIPAA, SOC 2, and HITRUST, as required.

Ensure encryption, auditing, and secure connectivity are consistently implemented. Monitoring and Automation: Configure monitoring and alerting for both on-prem SQL Server and Amazon RDS instances. Automate routine tasks using T‑SQL or PowerShell.

Assist with capacity planning and system lifecycle management.

Qualifications

and Experience 5+ years of experience as a SQL Server DBA in a production environment. Strong experience with SQL Server installation, configuration, and ongoing maintenance. Hands‑on experience with Amazon RDS for SQL Server.

Advanced T‑SQL skills, including writing and optimizing complex queries. In-depth knowledge of indexing strategies, execution plans, and performance tuning.