Harris Computer Systems logo
Harris Computer Systems

Based in Ottawa, Ontario, Canada, Harris Computer Systems provides mission-critical software solutions for organizations across the United States and Canada, including healthcare c

Expert Database Support Analyst

Location

United States + 1 moreAll locations: United States | Canada

Posted

82 days ago

Salary

$65K - $73K / year

Seniority

Mid Level

No structured requirement data.

Job Description

Expert Database Support Analyst

Harris Computer Systems

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 Categories

Related Job Pages

More Database Administrator Jobs

Contact Government Services logo

Discovery Database Administrator

Contact Government Services

Contact 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

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description 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 attributes for success: - The Contractor shall provide database administration support to include, but not limited to the following activities: - Assist in managing Microsoft SQL Server 2019 and 2022 to include: - Setting up security - Creating tables, indexes, stored procedures - Designing SQL reports - Creating maintenance jobs - Assist in creating and maintaining databases in a Clustered Server environment. - Apply expert knowledge of the design, development, and maintenance of various data models and their components. - Apply working knowledge of: - Data lakes - Data warehouse and data mart architectures - Metadata and data modeling - Data flow - Entity relationship diagram - Schema architectures - Query languages - Mirror database servers, log shipping, and apply latest techniques for database redundancy and high availability. - Facilitate the migration of systems into cloud infrastructure. - Upgrade SQL Servers from lower versions to the latest version (version 2019 and up) and create reports using Microsoft SQL Server Reporting Services (SSRS). - Setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design. Qualifications - Experience with Microsoft SQL Server 2019 and 2022. - Expert knowledge in database administration and management. - Experience with cloud infrastructure migration. - Strong understanding of data modeling and architecture. Requirements - Ability to apply best practices for optimizing databases. - Working knowledge of data lakes, data warehouses, and data marts. - Experience with database redundancy and high availability techniques. - Proficiency in creating and maintaining SQL reports. Benefits - Health, Dental, and Vision insurance - Life Insurance - 401k - Flexible Spending Account (Health, Dependent Care, and Commuter) - Paid Time Off and Observance of State/Federal Holidays Company Description Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client’s specific needs. For the past seven years, we’ve been growing our government-contracting portfolio, and along the way, we’ve created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

United States
$142.1K - $192.9K / year
Harmonia Holdings Group, LLC logo

Database Developer

Harmonia Holdings Group, LLC

Harmonia Holdings Group, LLC is an award-winning, rapidly growing federal government contractor committed to providing innovative, high-performing solutions to our government clients and focused on fostering a workplace that encourages growth, initiative, creativity, and employee satisfaction. Here at Harmonia we are pleased to have been repeatedly recognized for our outstanding work culture, the innovative work we do, and the employees on our team who make a difference each day. Some of these recognitions include: Recognized as a Top 20 "Best Place to Work in Virginia" Recipient of Department of Labor's HireVets Gold Medallion Great Place to Work Certification for five years running A Virginia Chamber of Commerce Fantastic 50 company A Northern Virginia Technology Council Tech 100 company Inc. 5000 list of fastest growing companies for eleven years Two-time SBA SBIR Tibbett's Award winner Virginia Values Veterans (V3) Certification

OtherRemoteTeam 201-500

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description 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 Programmer will develop and maintain database objects, support data integration efforts, and ensure adherence to database standards and government change control processes. - Responsible for the design, implementation, and maintenance of complex databases while providing technical solutions to projects which may be in different stages of the development life cycle. - Includes maintenance of database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design. - Requires knowledge and experience with multiple Oracle or SQL Server DBMS Languages. - Ability to deliver O&M and system enhancement support by executing all phases of application programming activities. - Competent to work at the highest level of all phases of database management. Qualifications - US citizenship is required with the ability to obtain and maintain a Public Trust clearance. - Bachelor's degree in Computer Science or related field. - 5+ years of experience as a Database Developer. - Hands-on experience in developing complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. - Writing generic PL/SQL code modules (PL/SQL libraries) for reports to handle data manipulations. - Experience in Data loading, DDL Scripts, and Control Files for extracting data from simple flat text files and Excel files. - Writing scripts to create tables, indexes, views, synonyms, grants, roles, and privileges. - Knowledge of Toad for Oracle IDE. - Business requirements analysis. - Relational data modeling. - Technical writing/documentation. - Oracle replication (materialized views, data marts). - Government change control processes. - Excel. - GitHub. - Ability to work as a team player. - Detailed documentation skills. - Excellent oral and written communications. - Strong customer service/client-facing skills. Requirements - Current DHS/ICE Public Trust Suitability. Benefits - Traditional and HSA-eligible medical insurance plans. - 100% employer-paid dental and vision insurance options. - 100% employer-sponsored STD, LTD, and life insurance. - 5% 401(k) company matching. - Flexible schedules and teleworking options. - Paid holidays and PTO Accrual Plans. - Paid Parental Leave. - Professional development and career growth opportunities. - Team and company-wide events, recognition, and appreciation. - And so much more!

United States + 1 moreAll locations: United States | United Arab Emirates
Job Closed
OtherRemoteTeam 501-1,000H1B Sponsor

Truliant’s mission is to improve lives by putting our members first, providing great service and straightforward financial solutions. Our core values of Member Focus, Service, Guidance, Relationships, and Community define how we interact with members to fulfill our mission of improving lives and providing a foundation on which we conduct ourselves. Our Promise to Our Teammates: Truliant strives to provide all teammates with an enjoyable place to work where they feel valued, empowered and rewarded for all that they do. Remote: This position is remote within our NC footprint. Although this position is primarily remote, there are occasional events and meetings that may require you to work on-site at one of our Truliant locations. Purpose of the Job The Database Engineer Specialist designs, implements, optimizes, and maintains complex database systems that support our financial services platforms. The Specialist will have deep expertise in relational and non-relational databases, data security, and performance tuning, with a strong understanding of financial industry compliance and high-availability requirements. Essential Functions and Responsibilities - Designs and implements scalable and secure database solutions to support financial transactions, risk analytics, and reporting platforms. - Maintains, monitors, and troubleshoots production databases to ensure high performance, availability, and disaster recovery preparedness. - Collaborates with data engineers and developers to design efficient data pipelines for ingestion, transformation, and distribution of financial data. - Implements and enforces data security, encryption, access controls, and auditing mechanisms to meet regulatory standards (e.g., SOX, GDPR, PCI-DSS). - Analyzes query performance, fine-tunes indexes, and optimizes stored procedures to meet SLAs for financial applications. - Develops scripts for database deployment, migration, backups, and monitoring using tools like PowerShell, Python, or Bash. - Works closely with software developers, data scientists, and business analysts to support application development and data analytics. Other Duties and Responsibilities - Assists with other tasks and projects as assigned. Knowledge, Skills, and Abilities - Must have strong expertise in SQL Server, PostgreSQL, Oracle, or similar RDBMS. - Must have strong expertise in Oracle RAC and MS SQL AO clustering and patching. - Must be proficient in data modeling, query optimization, indexing, and replication. - Must have familiarity with cloud database services (e.g., AWS RDS, Azure SQL, Google Cloud Spanner). - Must have a solid understanding of data governance, regulatory compliance, and cybersecurity best practices in financial services. - Must have excellent communication skills in English, both verbal and written. - Must be adept at reading, writing, and interpreting technical documentation and procedure manuals. - Must have proven analytical and problem-solving abilities. - Must have the ability to make decisions and work independently. - Must be able to evaluate systems and procedures, implementing efficiency enhancements. - Must be detail-oriented and well-organized. - Must have strong problem-solving and communication skills. - Must be able to work in a general office environment. - Must be flexible and able to shift resources and priorities as required. - Must have a valid driver’s license. - Must be able to complete all assignments with minimal supervision. - Should possess a strong commitment to providing excellent service to Truliant’s members. Physical Requirements - Occasional standing, walking, bending, and stooping required. - Must be able to sit at a desk for long periods of time and use a computer. - Must be able to moderately lift or move up to 10 pounds and occasionally lift or move up to 30 pounds. - Must be able to travel between Truliant locations as needed. Education and Background - Bachelor’s degree in Computer Science, Information Systems, or related field required (Master’s preferred). - 5+ years of experience as a database engineer, administrator, or similar role in the financial services sector. required - Experience with CI/CD pipelines and Infrastructure as Code (IaC) tools like Terraform is advantageous preferred. - Experience with NoSQL databases such as MongoDB, Redis, or Cassandra is a plus. Preferred Skills: - Experience with data warehousing and OLAP tools (e.g., Snowflake, Redshift). - Knowledge of financial systems such as core banking, trading platforms, or payment processing. - Familiarity with data lake architectures and real-time data processing frameworks (Kafka, Spark). If you have a passion for member service and would like to invest in a meaningful career with opportunity for growth, we encourage you to apply to Truliant! As a member of the Truliant family, you will enjoy the following full time benefits: - No-cost employee Medical, dental, vision coverage - Prescription benefits (including mail order) - Paid holidays and Paid Time Off (PTO) - 401(k) plan with contribution matching - Paid community involvement volunteers hours - Paid group life Insurance - Teammate loan discounts - Tuition reimbursement - Short and long-term disability - Health & Wellness program - Teledoc (physician video conferencing) - Onsite fitness facilities or health club reimbursement - Employee Assistance Program (EAP) - Medical flexible spending account - Dependent care flexible spending account

United States
Job Closed
Ensono logo

Mainframe Systems Programmer, DB2 DBA

Ensono

Ensono is an information technology and services company on a mission to help technology leaders transform their businesses by becoming a “catalyst for change

At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things! We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation. We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. These five traits are the key to achieving our purpose: Honesty, Reliability, Curiosity, Collaboration, and Passion. About the role and what you'll be doing: in this role you are responsible for creating Low-Level Design (LLD) documentation and providing technical expertise to support Sales and Solution Architecture teams. You also work directly with prospective and new clients to identify components in scope for client onboarding and migration activities. In this role, you lead client onboarding and migration efforts and complete end-to-end server builds. You are responsible for DB2 for z/OS upgrades and associated ISV products and actively support the transition of client environments from in-house IT teams to Ensono’s managed services model. This role may support multiple migrations or projects concurrently. - Support DB2 environments for one or more clients, including applying maintenance and performing upgrades as needed. - Upgrade, install, and support DB2-related ISV software. - Test and monitor existing DB2 workloads following OS or CPU upgrades. - Collaborate with clients to diagnose, troubleshoot, and resolve DB2 system, software, and database-related issues. - Participate in onboarding new clients by supporting knowledge transfer activities and shadowing client environments. - Work collaboratively with a team of mainframe professionals to transition new clients into Ensono’s support model. - Apply a strong working knowledge of DB2 utilities, TSO, and FTP to daily support and project work. - Leverage a solid understanding of SMP/E and its role in the DB2 installation and maintenance process. - Demonstrate working knowledge of the WLM environment as it relates to DB2 performance and workload management. - Perform project-based work; this role does not require 24×7 on-call support. We want all new Associates to succeed in their roles at Ensono. That's why we've outlined the job requirements below. To be considered for this role, it's important that you meet all Required Qualifications. If you do not meet all of the Preferred Qualifications, we still encourage you to apply. - Minimum of 10 years of experience working in a z/OS mainframe environment. - Broad expertise across core mainframe domains, including the z/OS operating system, storage, databases, CICS, and disaster recovery concepts. - Proven experience implementing, supporting, and upgrading DB2 for z/OS in enterprise production environments. - Experience supporting DB2 for z/OS from a systems or DBA perspective. - Strong technical capability with DB2-related ISV software on the z/OS platform. - Proficiency with SMP/E, including base installations and ongoing maintenance for DB2 and associated ISV software. - Demonstrated experience working with ISV vendors to perform problem determination and drive issue resolution. - Working knowledge of common DB2 tooling, including CA database tools, IBM database tools, Sysview, OMEGAMON, and MainView. - Solid understanding of DB2 Connect, security exits, DB2 data sharing in a Sysplex environment, DB2 log analysis, and DB2 system recovery. - Ability to act as the primary technical database point of contact for clients during transitions and ongoing support. - Strong communication and organizational skills, with the ability to manage multiple initiatives in a client-facing environment. - Experience leading and participating in client meetings, workshops, and conference calls. - Proficiency in Microsoft Word and Excel to produce clear, client-ready documentation. Preferred Qualifications - Experience with CICS or advanced knowledge of the z/OS operating system. - Experience with IBM DB2 Analytics Accelerator (IDAA). - Experience with IMS and IMS upgrades. Why Ensono? Ensono is a place to make better happen – for our clients and for your career. You can do great things through innovation or collaboration, by learning or volunteering, or to promote diversity and inclusion. You can do great things for your own health or for a healthier planet. Whatever it means to you to do great things we want Ensono to be the place you can do it. We are a client-facing business, but we do encourage clients to allow us to work remotely most of the time so if you are not required to be on a client site, you can choose to work from home or in our Ensono offices. Some of our benefits include: - Unlimited Paid Days Off - Three health plan options through Blue Cross Blue Shield - 401k with company match - Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts - Paid Maternity Leave, Paternity Leave, and Sabbatical Leave - Education Reimbursement, Student Loan Assistance or 529 College Funding - Enhanced fertility coverage - Wellness program - Depending on location, ability to take advantage of fitness centers - Flexible work schedule As of the date of this posting, a good faith estimate of the current pay scale for this role is $80,000 $150,000 annually based on a full-time schedule. Please note that placement in the range may vary based on numerous factors including but not limited to skills, experience, internal equity, and business needs. In addition to base salary, other compensation programs, depending on eligibility, include an annual bonus plan based on company and individual performance, and an equity grant under our Associate Equity Appreciation Program. Ensono is an Equal Opportunity/Affirmative Action employer. We are committed to providing equal employment to our Associates and building a diverse and inclusive workforce. All qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or other legally protected basis, in accordance with applicable law. Pay transparency nondiscrimination statement/posting OFCCP’s pay transparency policy can be found on OFCCP’s website. If you need accommodation at any point during the application or interview process, please let your recruiter know or email USTalentAcquisition@ensono.com.

United States
$80K - $150K / year