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 leastprivilege 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 TSQL 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.
- Handson experience with Amazon RDS for SQL Server.
- Advanced TSQL 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.