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 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.

This role is based on-site at our Carmel IN Headquarters five days a week. While we are an in-office organization we do our best to offer flexibility when needed ensuring both work-life balance and uninterrupted business operations.

Applicants must be authorized to work in the U.S. without sponsorship.

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.

Why Clinical Architecture
We offer:

• Opportunities for learning development and growth.
• Experiences that connect you with colleagues.
• A laid-back work environment with thoughtful amenities.
• Paid Volunteer Time Paid Holidays & PTO including our own winter break week for full-time team members.
• Sabbatical opportunities for tenured team members.
• Comprehensive Medical Dental Vision and ancillary insurance options for eligible employees.
• Maternity and Parental leave benefits.
• Employer paid Short-term Disability & Long-term Disability.
• Health and Wellness incentives.
• 401k Matching.
• Better workdays.

Clinical Architecture is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race color religion sex national origin gender identity or expression sexual orientation age disability veteran status marital status or any other protected characteristic.