• 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
• 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
  
  

• 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.
• 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
• Gracious and welcoming personality for customer service interaction
  
  

• 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.
  
  

Please refer to job description.