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.
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.