Job Description

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 Use problem-solving skills to assist in resolution of business and technical problems Identify root causes for problems and propose solutions to prevent recurring

Qualifications

Requires a four-year degree in Computer Science/Information Technology Minimum 5+ years working as a Database engineer or a related role. Minimum of two years' experience with C# andor 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 Extensive knowledge with SSRSSSIST-SQL Experience with C# andor VB.NET. 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. Require ability to work independently with minimal supervision Ability to multi-task with several complex and demanding Projects

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.