SQL Database Developer

Company Overview

Founded in 2010, Med-Metrix offers the healthcare industry web-based performance management solutions, coupled with workflow driven outsourced services and expert advisory capabilities honed by many years of direct operational experience. Our mission is simple: To help our clients improve their margins and efficiency.  We provide a full spectrum of Revenue Cycle Software, Consulting, and outsourced services from Patient Access to Case Management through final claim resolution in the business office. 

We are driven by hard-working and creative individuals that are passionate about what they do. Part of being a growing company is that change is constant — which keeps life exciting in our organization.  As a team, we are continually striving to evolve, embracing change to achieve bigger and better things and we’re looking for someone to assist in that growth.

Duties and Responsibilities

Assist with the development, maintenance and optimization of several SQL Server databases that support highly available enterprise software applications

Modify existing software to add enhancements, improve performance, and continuously improve our user experience

Work on multiple databases to troubleshoot databases and related apps

Experience executing SQL changes safely on live databases - following best practices to minimize disruption, with clear rollback and recovery procedures.

Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks

Commit quality code, reliably and on time to help the team achieve roadmap goals and customer commitment.

Follow Agile practices in your daily and weekly work and be a reliable team member.

Provide timely feedback on designs and code changesets and share technical insights, learnings, and best practices with the team

Accurately estimate work and proactively provide updates on your status. Proactively communicate adjustments to estimates as new information arises to ensure appropriate expectations

Embrace and consistently apply best practices, coding standards, and patterns for development and deployment of your code.

Investigate alerts or support requests related to possible errors or issues within our proprietary platform and address in a timely manner in accordance with technology platform SLAs.

Provide analytical support and technical advice during the conceptualization, development, and implementation phases.

Identify and resolve problems uncovered by testing or customer feedback

Work within a fast-paced environment

Evaluate code to ensure validity, HIPAA compliance, secure coding practices, and compatibility

Review of requirements with internal customers for software system design and maintenance

Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards.  Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties. Report any security or HIPAA violations or concerns to the HIPAA Officers in a timely fashion

Prepare technical design document & data dictionary as needed

Qualifications

Bachelor’s degree or equivalent in Computer or Information Science, Management Information Systems, Engineering, Mathematics or similar

6+ years of Database and software development experience  

Expertise in writing complex SQL Queries, stored procedures, functions, triggers, views, and indexes

Highly analytical and detail-oriented with extensive familiarity with database management principles

A solid background in writing secure, understandable, testable, and efficient code

Extensive experience in tuning queries for optimal performance

Familiarity with relevant tools and technologies, with a drive to stay up to date with ongoing changes and advancements

Clear communication around technical concepts and ideas and the ability to collaborate with engineering and other parts of the organization

Solid understanding of T-SQL Programming

Proficient in MS SQL Server 2012 or later

Experience with C# is plus

Knowledgeable with Change Management Processes, Secure Coding Methodologies, and Test Plans (Unit, Regression, Load)

Ability to multi-task with several complex and demanding projects

Healthcare experience preferred

Working Conditions

Ability to work Fully Remote

Ability to work a flexible schedule and off-hours as needed

Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.