SQL Database Developer

Job Title

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.