Senior SQL Developer - Remote

Job Purpose

The Senior SQL Developer will design, develop, and maintain database systems, including SSIS projects and custom reports, while collaborating with the data team to address SQL issues and ensure efficient data management within a fast-paced environment.

Duties & Responsibilities

Develop SSIS projects to handle ETL, transmission, encryption, and archiving files received and generated

SQL Database Tuning and Performance

Design, develop, and maintain database tables, stored procedures, and supporting objects

Build and support operational reports for company and clients

Work with data team to provide operational support, resolve recurring problems

Document database topology, architecture, processes and procedures

Develop SQL queries and support ad hoc requests for data

Assist with capacity planning and resource expansion through data aggregation and analysis

Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement

Identify inefficiencies in the database platform and provide solutions to the management

Use problem-solving skills to assist in resolution of business problems

Develop analytical skills to resolve technical problems

Identify root causes for problems and propose solutions to prevent recurring.

Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards

Understand and comply with Information Security and HIPAA policies and procedures at all times

Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties

Qualifications

Bachelor’s degree in Computer Science/Information Technology required

Minimum five years working as a Database engineer or a related role

Minimum of three years extensive SSRS\SSIS\T-SQL experience

Minimum of two years’ experience with C# and\or VB.NET

Thorough understanding of database structures, theories, principles, & practices

Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints

Extensive knowledge of MS SQL Server 2012 or later with emphasis on query performance

Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations

Require ability to work independently with minimal supervision

Ability to multi-task with several complex and demanding projects

Proficiency in Microsoft Office Suite

Strong interpersonal skills, ability to communicate well at all levels of the organization

Strong problem solving and creative skills and the ability to exercise sound judgment and make decisions based on accurate and timely analyses

High level of integrity and dependability with a strong sense of urgency and results oriented

Excellent written and verbal communication skills required

Working Conditions

Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.

Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.

Work Environment: The noise level in the work environment is usually minimal.

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.