Med-Metrix
Overview
Join to apply for the
Senior Database Developer
role at
Med-Metrix . The Senior Database Developer will be 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; optimize SQL database tuning and performance Design, develop, and maintain database tables, stored procedures, and supporting objects Build and support operational reports for the company and clients Work with the data team to provide operational support and resolve recurring problems Document database topology, architecture, processes and procedures Develop SQL queries and support ad hoc data requests Assist with capacity planning and resource expansion through data aggregation and analysis Collaborate with project managers to ensure reports and metrics identify business needs and opportunities for process improvement Identify inefficiencies in the database platform and propose solutions to management Use problem-solving skills to assist in resolving 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’ PHI only in accordance with HIPAA standards Understand and comply with Information Security and HIPAA policies and procedures at all times Limit viewing of PHI to the minimum necessary to perform assigned duties Qualifications
Four-year degree in Computer Science/Information Technology required Minimum five years of experience as a Database Engineer or related role Minimum of three years SSIS experience Minimum of two years experience with C# and/or VB.NET Thorough understanding of database structures, theories, principles, and practices Ability to write and troubleshoot SQL code and design stored procedures, functions, tables, views, triggers, indexes, and constraints Extensive knowledge of MS SQL Server 2012 or later Extensive knowledge of SSRS/SSIS/T-SQL Technical knowledge of MS SQL Server internals with emphasis on query performance Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations Ability to work independently with minimal supervision Ability to multi-task with several complex and demanding projects Strong interpersonal skills and ability to communicate well at all levels Strong problem solving and creative skills and the ability to exercise sound judgment and make timely analyses High level of integrity and dependability with a strong sense of urgency and results orientation Excellent written and verbal communication skills Working Conditions
Physical Demands: The employee may move around the work area, sit, perform manual tasks, operate office equipment, extend arms, kneel, talk and hear. Mental Demands: Must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level 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, or any other characteristic protected by federal, state or local law.
#J-18808-Ljbffr
Join to apply for the
Senior Database Developer
role at
Med-Metrix . The Senior Database Developer will be 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; optimize SQL database tuning and performance Design, develop, and maintain database tables, stored procedures, and supporting objects Build and support operational reports for the company and clients Work with the data team to provide operational support and resolve recurring problems Document database topology, architecture, processes and procedures Develop SQL queries and support ad hoc data requests Assist with capacity planning and resource expansion through data aggregation and analysis Collaborate with project managers to ensure reports and metrics identify business needs and opportunities for process improvement Identify inefficiencies in the database platform and propose solutions to management Use problem-solving skills to assist in resolving 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’ PHI only in accordance with HIPAA standards Understand and comply with Information Security and HIPAA policies and procedures at all times Limit viewing of PHI to the minimum necessary to perform assigned duties Qualifications
Four-year degree in Computer Science/Information Technology required Minimum five years of experience as a Database Engineer or related role Minimum of three years SSIS experience Minimum of two years experience with C# and/or VB.NET Thorough understanding of database structures, theories, principles, and practices Ability to write and troubleshoot SQL code and design stored procedures, functions, tables, views, triggers, indexes, and constraints Extensive knowledge of MS SQL Server 2012 or later Extensive knowledge of SSRS/SSIS/T-SQL Technical knowledge of MS SQL Server internals with emphasis on query performance Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations Ability to work independently with minimal supervision Ability to multi-task with several complex and demanding projects Strong interpersonal skills and ability to communicate well at all levels Strong problem solving and creative skills and the ability to exercise sound judgment and make timely analyses High level of integrity and dependability with a strong sense of urgency and results orientation Excellent written and verbal communication skills Working Conditions
Physical Demands: The employee may move around the work area, sit, perform manual tasks, operate office equipment, extend arms, kneel, talk and hear. Mental Demands: Must be able to follow directions, collaborate with others, and handle stress. Work Environment: The noise level 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, or any other characteristic protected by federal, state or local law.
#J-18808-Ljbffr