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. This role blends hands-on SQL development and developer support (approximately 80%) with core DBA 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. The role also includes DBA 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.

Responsibilities 

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.
• Experience with database security, backup and restore processes, and high availability/disaster recovery (HA/DR) methodologies.
• Proven ability to collaborate across Engineering, IT, and Product teams.