Application Database Administrator (SQL Server DBA)

Clinical Architecture is seeking an experienced Application Database Administrator (SQL Server 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. 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. 
• Applicants must be authorized to work in the U.S. without sponsorship. 
• 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.

Title: Treatment Coordinator
Practice: Bloomington Oral Surgery
Location: Bloomington, IN
Office Hours:  

• Monday: 7:30am - 5pm
• Tuesday: 7:30am - 5pm
• Wednesday: 7:30am - 5pm
• Thursday: 7:30am - 5pm
• Friday: 7:30am - 5pm
• Saturday: Closed
• Sunday: Closed

Position Purpose:

The Treatment Coordinator plays a vital role in managing patient care treatment plans and ensuring that patients understand and proceed with their recommended treatment. This position involves patient interaction, detailed communication, and administrative support to facilitate smooth and effective patient care from diagnosis through treatment completion.

Essential Functions

Patient Consultation and Education:

• Meet with patients to discuss their treatment plans as outlined by the surgeon.
• Explain treatment procedures, potential outcomes, and financial obligations.
• Answer patient questions and address concerns about their treatment options and plans.
• Provide educational materials and resources to help patients understand their treatment.
• Follow-up calls to patients that did not schedule and work to remove roadblocks to get treatment completed.

Treatment Plan Coordination:

• Coordinate the scheduling of treatments, surgeries, and follow-up appointments.
• Ensure that all necessary pre-treatment steps, such as lab work or imaging, are completed.
• Monitor patient progress and follow up to ensure adherence to treatment plans.
• Adjust treatment schedules as needed in response to patient needs or surgeon recommendations.

Financial Coordination:

• Discuss treatment costs with patients and provide detailed estimates.
• Review insurance coverage and assist patients with understanding their benefits.
• Coordinate with the billing department to manage insurance claims and payments.
• Develop and discuss payment plans for patients who require financial assistance.

Administrative Duties:

• Maintain accurate and up-to-date patient records in the electronic health record (EHR) system.
• Prepare and manage treatment-related documentation.
• Communicate effectively with clinical and front office team members to ensure seamless patient care.
• Handle patient communications, including appointment reminders and follow-up calls.
• Other duties as assigned by the practice administrator.

Compliance and Confidentiality:

• Ensure adherence to healthcare regulations and privacy laws, including HIPAA.
• Maintain patient confidentiality and secure handling of sensitive information.
• Follow clinic policies and procedures to maintain compliance with healthcare standards.

Qualifications

Education:

• High school diploma or equivalency, required.

Experience:

• Previous experience in a healthcare setting, particularly in treatment coordination or patient care roles, is highly desirable.
• Full understanding of surgical guide treatment from patient consultation to execution.
• Knowledge of relevant regulations and compliance requirements in healthcare.

Performance Requirements:

• Approachable, professional demeanor
• Strong communication and interpersonal skills.
• Detail-oriented and thorough in task execution.
• Excellent organizational and multitasking abilities.
• Proficiency in using electronic health record (EHR) systems and other office software.
• Knowledge of medical terminology and healthcare practices.
• Ability to work in a fast-paced environment and handle stressful situations with professionalism.
• Empathetic and patient-focused approach to care coordination.
• Independent decision-making skills and utilization of sound judgement.

• We offer Medical, Dental, and Vision Insurance plans to our full-time employees.
• Two out of the three medical plans offered include Health Savings Account (HSA) eligibility.
• Company-paid Life, AD&D and Long-Term Disability coverage.
• Additional Voluntary Life and AD&D Insurance for you and your family!
• Voluntary Short-Term Disability Insurance available to you as well
• Dependent Care Flexible Spending Account (FSA) offered.
• Immediately begin saving for retirement through our 401(k) starting with very first paycheck!
• Employer 401(k) contribution and Profit Sharing after six months of employment
• PTO and 8 Paid holidays for fulltime employees!

DISCLAIMER

The above statements are intended to describe the general nature and level of the work being performed by people assigned to this work.  This is not an exhaustive list of all duties and responsibilities.  OPS’s management reserves the right to amend and change responsibilities to meet business and organizational needs as necessary. 

About the Team  

The Virtual Preparatory Academy of Indiana @ Madison-Grant is a K–12 tuition-free online public school in the state of Indiana. We believe in empowering students by providing a flexible, innovative education at home, where state-certified teachers work closely with families to ensure each child reaches their full potential at their own pace.

We are seeking a highly qualified Virtual Special Education Teacher who is dedicated to providing a superior education for all students! ACCEL Schools uses a cutting-edge 21st-century curriculum, which can be accessed online and through a variety of traditional methods.   

The Virtual Special Education Teacher supports the educational and behavioral goals of all students with a focus on students with an Individualized Education Program. 

Please note – while this is an online school position and all instruction occurs virtually, travel and face to face attendance will be required several times per year to support in person state testing and student events. 

ELIGIBILITY: Open to residents of Indiana

About the Opportunity 

• Assist with the implementation of the Individualized Education Plan (IEP) for each student served 
• Write IEPs in a timely manner 
• Participate in the Multi-Tiered System of Supports (MTSS) 
• Maintain all student records and files according to federal, state and local mandates 
• Complete all necessary paperwork within timelines to be compliant 
• Complete progress reports as required 
• Complete all components of all paperwork 
• Work 1:1, in small groups or in whole class sessions with students 
• Administer Transition Assessments 
• Write lessons plans to accommodate goals in the student’s IEP 
• Teach all subjects following the school’s course of study or as assigned 
• Schedule and participate in IEP and other meetings for students with disabilities 
• Prepare and administer all standardized tests, benchmark assessments and evaluation assessments as directed 
• Work with the teaching staff to improve standardized and proficiency testing results 
• Maintain confidentiality concerning all student information and any professional matters 
• Keep accurate records on each student such as grade books and progress reports, lesson plans, attendance records, and behavior/discipline records 
• Collaborate with parents, teachers, psychologists, parents, Administrator, and professionals outside of school 
• Work with Related Services to keep evaluations current, updated every three years 
• Provide resources for classroom teachers for areas of disability 
• Attend professional developments as assigned  

About You 

• Masters’ Degree preferred 
• Current State certification/licensure in appropriate area 
• Three years of teaching experience, at least 2 of which are in special education preferred 
• Strong content knowledge in one or more content areas 
• Familiarity with state proficiency testing state teaching standards 
• Understanding of and/or willingness to learn the MTSS process 
• Prior experience working with a diverse student body 
• Excellent written and verbal communication skills that reflect professionalism and tact at all times 
• Genuine care for children and a passion for teaching 
• Proficiency in computer applications, including Google Docs, MS Office Suite, e-mail, and internet applications 
• Prior experience with software and databases used to maintain Individuals with Disabilities Education Act (IDEA) compliance including Power School Special Programs 
• Ability to learn new technologies and acquire new skills through independent study, professional training, and from more senior team members 
• Strong ability to gather, analyze, and interpret student data to make sound educational decisions 
• Ability to handle confidential information responsibly and exhibit sound judgment while maintaining that confidentiality 
• Ability to and willingness to work occasional evenings 
• Valid driver’s license and ability to perform occasional local and in-state travel 
• Ability to pass federal, state and local background checks 
• Knowledge of co-teaching models and the ability to co-teach 

About Us 

“We believe that every child should be able to be anything they want in life, regardless of their birthplace and circumstances.” – Ron Packard, CEO & Founder 

ACCEL Schools is a network of 80+ high-performing, public charter schools serving PK-12 students. We proudly advocate for school choice and work to address educational inequities throughout the United States. Our schools are inclusive and widely differ to reflect the unique values of the many urban, suburban, and rural communities we serve. Our brick-and-mortar, virtual, and hybrid schools specialize in closing educational gaps and offer innovative models such as career-technical education, sports training, bilingual programming, and more. We have been recognized and praised by legislators, authorizers, and researchers for providing exceptional education options to students in historically under-resourced communities. 

We offer the following benefits: 

Life benefits – time & peace of mind 

• Paid time off 
• Retirement contributions 
• Optional Basic Life and AD&D insurance 
• Voluntary life insurance (employee, spouse, child) 
• Discounted childcare at Early Learning Academies locations 

Health benefits – stay well & thrive 

• Medical, dental, and vision insurance 
• Employee Assistance Program 
• Voluntary short-term disability insurance 
• Voluntary long-term disability insurance 

Career benefits – keep growing 

• Career advancement opportunities throughout Pansophic Learning and our strong network of 4,000+ instructors and education professionals 

EQUAL EMPLOYMENT OPPORTUNITY 

It is our policy to abide by all federal, state and local laws prohibiting employment discrimination based solely on a person’s race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, physical disability, mental and/or intellectual disability, age, military status, veteran status (including protected veterans), marital status, registered domestic partner or civil union status, familial status, gender (including sex stereotyping and gender identity or expression), medical condition, genetic information, sexual orientation, or any other protected status except where a reasonable, bona fide occupational qualification exists. 

#LI-BL1

About the Team  

The Virtual Preparatory Academy of Indiana @ Madison-Grant is a K–12 tuition-free online public school in the state of Indiana. We believe in empowering students by providing a flexible, innovative education at home, where state-certified teachers work closely with families to ensure each child reaches their full potential at their own pace.

We are seeking a highly qualified Virtual Special Education Teacher who is dedicated to providing a superior education for all students! ACCEL Schools uses a cutting-edge 21st-century curriculum, which can be accessed online and through a variety of traditional methods.   

The Virtual Special Education Teacher supports the educational and behavioral goals of all students with a focus on students with an Individualized Education Program. 

Please note – while this is an online school position and all instruction occurs virtually, travel and face to face attendance will be required several times per year to support in person state testing and student events. 

ELIGIBILITY: Open to residents of Indiana

About the Opportunity 

• Assist with the implementation of the Individualized Education Plan (IEP) for each student served 
• Write IEPs in a timely manner 
• Participate in the Multi-Tiered System of Supports (MTSS) 
• Maintain all student records and files according to federal, state and local mandates 
• Complete all necessary paperwork within timelines to be compliant 
• Complete progress reports as required 
• Complete all components of all paperwork 
• Work 1:1, in small groups or in whole class sessions with students 
• Administer Transition Assessments 
• Write lessons plans to accommodate goals in the student’s IEP 
• Teach all subjects following the school’s course of study or as assigned 
• Schedule and participate in IEP and other meetings for students with disabilities 
• Prepare and administer all standardized tests, benchmark assessments and evaluation assessments as directed 
• Work with the teaching staff to improve standardized and proficiency testing results 
• Maintain confidentiality concerning all student information and any professional matters 
• Keep accurate records on each student such as grade books and progress reports, lesson plans, attendance records, and behavior/discipline records 
• Collaborate with parents, teachers, psychologists, parents, Administrator, and professionals outside of school 
• Work with Related Services to keep evaluations current, updated every three years 
• Provide resources for classroom teachers for areas of disability 
• Attend professional developments as assigned  

About You 

• Masters’ Degree preferred 
• Current State certification/licensure in appropriate area 
• Three years of teaching experience, at least 2 of which are in special education preferred 
• Strong content knowledge in one or more content areas 
• Familiarity with state proficiency testing state teaching standards 
• Understanding of and/or willingness to learn the MTSS process 
• Prior experience working with a diverse student body 
• Excellent written and verbal communication skills that reflect professionalism and tact at all times 
• Genuine care for children and a passion for teaching 
• Proficiency in computer applications, including Google Docs, MS Office Suite, e-mail, and internet applications 
• Prior experience with software and databases used to maintain Individuals with Disabilities Education Act (IDEA) compliance including Power School Special Programs 
• Ability to learn new technologies and acquire new skills through independent study, professional training, and from more senior team members 
• Strong ability to gather, analyze, and interpret student data to make sound educational decisions 
• Ability to handle confidential information responsibly and exhibit sound judgment while maintaining that confidentiality 
• Ability to and willingness to work occasional evenings 
• Valid driver’s license and ability to perform occasional local and in-state travel 
• Ability to pass federal, state and local background checks 
• Knowledge of co-teaching models and the ability to co-teach 

About Us 

“We believe that every child should be able to be anything they want in life, regardless of their birthplace and circumstances.” – Ron Packard, CEO & Founder 

ACCEL Schools is a network of 80+ high-performing, public charter schools serving PK-12 students. We proudly advocate for school choice and work to address educational inequities throughout the United States. Our schools are inclusive and widely differ to reflect the unique values of the many urban, suburban, and rural communities we serve. Our brick-and-mortar, virtual, and hybrid schools specialize in closing educational gaps and offer innovative models such as career-technical education, sports training, bilingual programming, and more. We have been recognized and praised by legislators, authorizers, and researchers for providing exceptional education options to students in historically under-resourced communities. 

We offer the following benefits: 

Life benefits – time & peace of mind 

• Paid time off 
• Retirement contributions 
• Optional Basic Life and AD&D insurance 
• Voluntary life insurance (employee, spouse, child) 
• Discounted childcare at Early Learning Academies locations 

Health benefits – stay well & thrive 

• Medical, dental, and vision insurance 
• Employee Assistance Program 
• Voluntary short-term disability insurance 
• Voluntary long-term disability insurance 

Career benefits – keep growing 

• Career advancement opportunities throughout Pansophic Learning and our strong network of 4,000+ instructors and education professionals 

EQUAL EMPLOYMENT OPPORTUNITY 

It is our policy to abide by all federal, state and local laws prohibiting employment discrimination based solely on a person’s race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, physical disability, mental and/or intellectual disability, age, military status, veteran status (including protected veterans), marital status, registered domestic partner or civil union status, familial status, gender (including sex stereotyping and gender identity or expression), medical condition, genetic information, sexual orientation, or any other protected status except where a reasonable, bona fide occupational qualification exists. 

#LI-BL1