SQL Database Developer - Remote

Job Purpose
The SQL Database Developer is responsible for analyzing, developing SSIS projects, custom reports and work closely with the team on any SQL issues.

Duties & Responsibilities

Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated
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
Develop time estimates for assigned tasks
Use problem-solving skills to assist in resolution of business and technical problems
Identify root causes for problems and propose solutions to prevent recurring
Stay abreast of new and emerging security threats and mitigation approaches for your respective area and perform periodic security reviews of your assigned areas
Work to ensure regulatory compliance (HIPAA, etc.) in all aspects of data utilization and information access
Ensure all proposed changes follow the Change Management policy and procedure for production changes
Other duties as assigned
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

BSCS with 3+ years MS SQL experience
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 2005/2008/2012/2014
Knowledge of SSIS/SSRS is a plus
Experience with C# or VB.NET
Technical knowledge of MS SQL Server internals with emphasis on query performance.
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

Must possess a smart-phone or electronic device capable of downloading applications, for multifactor authentication and security purposes
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.