Our intelligence analysis software tools help analysts and investigators transform data in real-time, enabling customers to detect, disrupt, and defeat sophisticated threats. We serve global customers carrying out critical missions in public safety, defense, fraud, and financial crimes. Supporting your application Our recruitment process will comprise of interviews and, at times, a written exercise, an assessment day and/or a presentation. As an equal opportunities’ employer, we want to make sure we do all we can to make this a positive experience for you. When applying, please make us aware on your application of any adjustments or additional support we can provide you with before or on the day of an interview. Salary range The hiring range for this role is $55,000 to $80,000 USD per year. Final compensation will be based on experience, skills, market conditions, and internal equity.
Expert Database Support Analyst
Location
United States + 1 moreAll locations: United States, Canada
Posted
4 days ago
Salary
$65K - $73K / year
Seniority
Mid Level
No structured requirement data.
Job Description
Job Title: Expert Database Support Analyst (Healthcare Software – Interoperability Focus)
Location: Remote – US or Canada (PST / MST time zone)
JOB SUMMARY
The Expert Database Support Analyst provides advanced technical support for Altera Solutions by remotely accessing client environments and delivering expert-level troubleshooting for both SQL Server databases and healthcare interoperability workflows. This role focuses on database performance, system stability, and complex interoperability workflows involving HL7, FHIR, APIs, and third‑party vendor systems. The analyst independently diagnoses and resolves complex technical issues using advanced problem‑solving skills, deep SQL Server expertise, and healthcare interoperability knowledge.
ESSENTIAL FUNCTIONS / MAJOR RESPONSIBILITIES
EXPERT SQL SERVER SUPPORT
- 7+ years of hands-on SQL Server DBA experience, including performance tuning, query optimization, indexing strategies, Always On, SQL Server Agent jobs, replication, deadlock analysis, and root cause diagnostics.
- Troubleshoots advanced SQL Server issues, including CPU/memory bottlenecks, blocking, missing indexes, poorly performing stored procedures, and T-SQL inefficiencies.
- Writes, debugs, and optimizes complex T-SQL scripts, stored procedures, and queries.
- Connects to client systems to diagnose database-related performance, stability, and functionality issues.
- Performs proactive database health checks, server performance monitoring, capacity analysis, and reliability reviews.
- Works directly with client DBAs and internal development teams on the most complex database challenges.
HEALTHCARE INTEROPERABILITY SUPPORT (Primary Functional Area)
- Troubleshoots and resolves high-complexity interoperability issues involving HL7 v2.x (ADT, ORU, SIU, ORM), FHIR resources, JSON/XML APIs, SFTP batch files, and custom data interfaces.
- Performs advanced root cause analysis on message failures, data mismatches, routing logic issues, HL7 segment problems, schema validation errors, and system connectivity failures.
- Reviews interoperability logs, traces, message queues, and endpoint configurations to identify system-level issues.
- Validates data mappings, message formats, and workflow correctness across multi-system interactions (EHRs, PM systems, third-party vendors).
- Supports interoperability engines such as Sunrise eLink / ISS (or other systems experience such as Rhapsody or Cloverleaf).
- Assists customers with interoperability onboarding, endpoint setup, credential/configuration validation, QA testing, and go-live coordination.
CROSS-TEAM COMMUNICATION & CLIENT SUPPORT
- Interacts daily with hospital IT staff and third-party vendors via phone, email, and remote access to diagnose and resolve complex database and interoperability issues.
- Communicates progress clearly, documents all actions in case records, and ensures high-quality client engagement.
- Assists field technicians during implementation, troubleshooting, and upgrade cycles.
- Serves as the escalation point for complex or high-severity database and interoperability issues.
- Reports defects and design concerns to development, providing clear reproduction steps and technical analysis.
TECHNICAL EXPERTISE & SYSTEMS KNOWLEDGE
- Strong technical knowledge of SQL Server, Windows Server, IIS/web services, Windows event logs, and system-level debugging.
- Preferred: Knowledge of Active Directory, networking fundamentals, SSL/TLS certificates, and VPN/SFTP secure transport.
- Maintains current knowledge of product updates, architecture changes, interoperability capabilities, and emerging healthcare data standards.
KNOWLEDGE MANAGEMENT, LEADERSHIP & CONTINUOUS IMPROVEMENT
- Authors and reviews knowledge base articles, troubleshooting guides, and interoperability documentation.
- Performs recurring root cause analysis to eliminate long-term issues and reduce repeat support incidents.
- Mentors and coaches junior team members in SQL, interoperability analysis, and troubleshooting methodologies.
- Acts as the single point of contact for escalated client situations, providing leadership in the absence of management.
- Performs proactive client environment reviews to improve system reliability and prevent future service disruptions.
ACADEMIC AND PROFESSIONAL QUALIFICATIONS
- BA or BS degree preferred, or equivalent experience/training.
- Microsoft SQL Server and/or Windows Server certifications preferred.
EXPERIENCE
- 7+ years of SQL Server database support, administration, or engineering experience.
- Prior experience in healthcare IT, software support, or interoperability environments strongly preferred.
- Deep familiarity with HL7, FHIR, and healthcare interoperability standards.
TRAVEL REQUIREMENTS
- May require minimal local travel or occasional travel based on business needs.
WORKING ARRANGEMENTS
- May require after-hours, on-call, or weekend support for critical issues or customer needs.
Salary Range
$65,000 – $73,000 USD
$95,926 to $100,000 CAD
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Discovery Database Administrator
Contact Government ServicesContact Review prides itself on finding high-quality, high-accountability, barred attorneys specifically tailored to the needs of our project. Assists with document review, privilege review, expert testimony, legal research, and foreign language translation Fosters a culture where every team member sees themselves as an extension of the project's team Looks for ways to improve efficiency and streamline workflows
CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Discovery Database Administrator, you will play a key role in supporting various aspects of the company's portfolio. Skills and attribute...
Harmonia Holdings is seeking a skilled Database Developer to support a federal government client. This role is responsible for the design, implementation, maintenance, and enhancement of complex database systems across all phases of the system development life cycle. The Database...
The Database Engineer Specialist designs, implements, optimizes, and maintains complex database systems supporting financial services platforms, focusing on high performance, availability, and security. This role involves designing scalable solutions, monitoring production databases, enforcing data security to meet regulatory standards, and optimizing query performance.
Mainframe Systems Programmer, DB2 DBA
EnsonoEnsono delivers complete Hybrid IT solutions, from mainframe to cloud, tailored to each client’s journey.
This role involves creating Low-Level Design documentation, providing technical expertise to sales and architecture teams, and leading client onboarding and migration efforts, including end-to-end server builds. Responsibilities also include supporting DB2 for z/OS upgrades, applying maintenance, and actively supporting the transition of client environments to Company’s managed services model.
