SQL Database Developer

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

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

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