Senior SQL Developer - ETL, SSIS & Data Performance

Med-Metrix; Tennessee; Remote; USD 90.000 - 140.000; Vollzeit

Zusammenfassung

Med-Metrix in the United States seeks a Senior SQL Developer to design, develop, and maintain database systems, including SSIS projects and reports, collaborating with the data team in a fast-paced environment.

You will optimize SQL performance, build stored procedures, and deliver operational reports for internal teams and clients, while ensuring HIPAA-compliant handling of PHI and adherence to security policies.

Qualifikationen

• Bachelor's degree in Computer Science/Information Technology
• 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 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
• Ability to work independently with minimal supervision

Aufgaben

• Develop SSIS projects to handle ETL, transmission, encryption, and archiving files
• 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 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

Ausbildung

Bachelor's degree in Computer Science/Information Technology

Tools

SSRS

SSIS

T-SQL

C#

VB.NET

MS SQL Server 2012+

Jobbeschreibung

Med-Metrix in the United States seeks a Senior SQL Developer to design, develop, and maintain database systems, including SSIS projects and reports, collaborating with the data team in a fast-paced environment.

You will optimize SQL performance, build stored procedures, and deliver operational reports for internal teams and clients, while ensuring HIPAA-compliant handling of PHI and adherence to security policies.