Expert Database Support Analyst page is loaded## Expert Database Support Analystlocations: British Columbia, Canada: Remote - Arizonatime type: Full timeposted on: Posted Todayjob requisition id: R0040460**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 SKILLED 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 CADHarris provides mission critical software solutions for the Public Sector, Healthcare, Utilities and Private Sector verticals throughout North America, Europe, Asia and Australia. Working for Harris is the perfect opportunity to fulfill your professional goals as well as achieve your personal dreams! Our employees enjoy a casual work environment that offers comfort while providing superior service to our customers. We offer a comprehensive benefit package as well as other additional “Perks”!* We empower our employees to make a difference* We have an award winning culture* We offer opportunity to learn* We are financially strong and we are owned by the largest software company in Canada (CSI)* We have fun!Follow us on social media to learn more about our company values, culture and initiatives!**Harris is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state or local law.***If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at (1)-(phone hidden) or at [email protected]**This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.*#J-18808-Ljbffr

📌 Expert Database Support Analyst - $65,000 - $73,000 A Year - Remote (Kelowna)
🏢 Harris
📍 Kelowna