SQL Server Database Administrator (DBA)

**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. 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 tun…