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.

JOB SUMMARY

Provide maintenance, calibration, and technical support to the manufacturing process and facility equipment.  Coordinate and perform testing and calibration on electrical, mechanical, and analytical equipment for conformance to established standards. Request purchase order requisitions for 3^rd party maintenance requirements.

ESSENTIAL JOB FUNCTIONS

• Assist in creating/establishing a Maintenance and Calibration Program including recommendation of Maintenance and Calibration activities and frequencies based upon system/equipment assessments
• Plan, schedule, and perform planned and unplanned maintenance and calibration on process and facility equipment/utilities including but not limited to HVAC, freezers, cold rooms, bioreactors, filling systems, analytical testing instruments, and building management control systems
• Coordinate and support external calibration service providers
• Build relationships with customers, colleagues, and service partners to provide a collaborative approach to the operational management of lab spaces.
• Track and report on calibration status of all equipment/instruments in the facility
• Ensure timely completion of calibrations/preventive maintenance and compliant record keeping.
• Obtain required documentation and approval prior to creation of purchase order requisition for service requests to be completed by 3^rd party vendors.
• After purchase order has been issued, ensure service delivery dates are correct and revise as necessary, per follow-up with suppliers and customers.
• Source, qualify, negotiate, and procure service contracts in support of lab operations.
• Ensure purchase requisitions are requisitions closed within 180 days and confirm that associated purchase orders are closed as well.
• Enter and maintain records in the Computerized Maintenance Management System (CMMS)
• Meet regularly with key stakeholders (lab staff, service partners, management) to identify, review and resolve issues in a timely manner and/or escalate as necessary.
• Adaptability required as work schedule may change based on business needs
• Criminal background check required
• Other duties as assigned

KNOWLEDGE, SKILLS AND EXPERIENCE

• Associates Degree
• Bachelor's degree 
• EET
• 3-5 years related Calibration/Metrology work experience
• Ability to understand user manuals/specifications, wiring diagrams, equipment Piping & Instrumentation Diagrams (P&ID), and Standard Operating Procedures (SOP)
• Mechanically inclined/knowledge of hand tools
• Proficient with advanced computer systems including the use of a CMMS
• Excellent interpersonal skills and communication skills with ability to act as a change agent

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work Environment

• Frequently required to work in a BSL 2 environment with personal protective equipment/aseptic gowning
• Regularly required to work around large machinery and typical utilities seen in pharmaceutical facilities
• Occasionally exposed to moving mechanical parts; high, precarious places; toxic or caustic chemicals; hazardous waste; and risk of electrical shock
• Occasionally exposed to extremely loud noise levels
• Spending time on the floor during activity execution (maintenance, construction, commissioning and qualification) is required

Movement

• Frequently required to stand; sit; use hands to finger, handle, or feel; reach with hands and arms
• Occasionally required to walk; climb or balance; and stoop, kneel, crouch, or crawl

Lifting

• Frequently lift and/or move up to 10 pounds
• Occasionally lift and/or move up to 25 pounds

Vision

• Frequently utilize close vision and the ability to adjust focus

Communication 

• Frequently required to communicate by talking, hearing, using telephone and e-mail

Join Horace Mann: Empower Educators, Achieve Financial Success

Ready to Make a Difference?

Join Horace Mann today and take the first step toward achieving your career and financial goals while making a meaningful impact on the educators you serve. Together, we can help educators secure their future while empowering you to achieve your own.

As an Insurance Producer at Horace Mann, you’ll receive mentorship from an experienced agent while gaining hands-on experience in the industry. Our insurance products are tailored to meet the unique needs of educators, and we provide outstanding training, competitive rates, and flexible work options. With an unparalleled compensation structure, exciting incentives, and bonus opportunities, top performers have the chance to earn all-expenses-paid trips to amazing destinations.

Why Join Us?

• Performance-Based Compensation [1099] with a 36-month incentive plan and enhanced commissions
• Monthly incentives based on sales volume for the first 36 months
• Quarterly production bonuses for the first 36 months
• No external office requirement—work from anywhere
• Leverage established books of business while building your own practice
• Access to a niche market that increases your potential for success
• Value-added services to connect you with ideal clients
• Simple, streamlined products and sales processes for quick success
• Networking, community, and industry events to expand your connections
• A comprehensive, multi-line product portfolio in a ‘One-Stop Shop’ model

What You Will Do:

• Solve financial challenges faced by educators through tailored solutions
• Present with confidence—one-on-one or in large groups—to educate potential clients on products
• Engage in community and networking events, expanding your professional connections
• Stay current with industry trends and apply new knowledge to help clients
• Cultivate strong market relationships and build a solid client base
• Invest time and resources in ensuring the success and growth of your business

What We’re Looking For:

• A commitment to helping educators achieve financial prosperity
• Strong interpersonal and presentation skills
• Self-motivation and the ability to manage your own business
• The ability to obtain or currently hold state licenses in Life & Health and Property & Casualty

Compensation and Benefits:

• Sign-On Bonus
• Uncapped Earnings/Commission
• Structured Incentive & Bonus Pay to reward your hard work
• Work Environment—work in-person, in the field, and/or from an office setting

Support and Accountability:

As an Insurance Producer, you'll be guided by a mentor agent who will support you every step of the way to ensure your success.

We make a difference!

At Horace Mann, we are driven by our mission to support the educators who shape the future of our children. We believe that educators deserve someone who looks after their financial well-being just as they do for their students. Our passion lies in providing tailored solutions that protect what educators have today and help them achieve long-term financial security and happiness.

#LI-SJ1

#VIZI#