Job Purpose

The SQL Server Developer plays a primary role in all aspects of the Information Technology Department including database analysis, query writing, creation of stored procedures, SSIS packages, SQL jobs, and data movement.

Duties and Responsibilities

• Collaborates to define projects, develops and interprets business rules, and debugs technical issues when they arise
• Applies business and database analysis skills to gain deep understanding of user’¬s needs
• Aids in the definition and creation of solutions that meet user’s needs
• Develops custom database objects, stored procedures, functions, and T-SQL
• Designs and implements SSIS packages and other ETL processes
• Effectively communicates project status and planning activities with team and customers
• Troubleshoots slow performing queries and database servers
• Provides support for off-hour deployments and production issues
• Participates in off-hours support rotation
• Regular and predictable attendance
• Consistently demonstrates compliance with HIPAA regulations, professional conduct, and ethical practice
• Maintains work area in a clean and orderly condition and ensures safe operating conditions within area of responsibility
• Works to encourage and promote Company culture throughout the organization
• Other duties as may be assigned

Qualifications

• Bachelor’s degree in Computer Science/Information Technology or equivalent
• 3 years minimum experience with SQL Server 2008 or higher, T-SQL development
• 3 years minimum experience with SSIS development and deployment
• 3 years minimum experience with Data Warehouse Development/ Dimensional Modeling
• Database Administrator roles (backup, restore, security) experience preferred
• Healthcare information experience preferred
• SSAS experience preferred

Competencies

• Ethics - Honest, accountable, maintains confidentiality
• Reliability - The extent to which the employee can be depended upon to be available for work, do it properly, and complete it on time. The degree to which the employee is reliable, trustworthy, and persistent.
• Sense of Urgency - Meets deadlines, establishes appropriate priority, gets the job done in a timely manner
• Communication Skills - Possesses effective communication skills: oral, written, listening
• Conflict Management - Good listener, committed to finding solution to problems, works well with difficult people
• Initiative - Takes action, seeks new opportunities, strives to see projects to completion
• Internal Controls - Knowledge of and ability to create, implement, evaluate and enhance internal control processes
• Job Knowledge - Knowledge of products, policies and procedures; OR knowledge of techniques, skills, equipment, procedures, and materials
• Planning & Organizing - Displays ability to effectively plan, organize and implement applicable tasks or projects in relation to established goals and objectives
• Problem Solving & Decision Making - Displays ability to define a problem, develops workable and realistic alternatives, and selects appropriate alternative to resolve problem. Decisions made are generally correct, and the time taken to make such decisions is reasonable.

Physical, Mental, Environmental & Working Conditions

Moderate amount of walking and writing. Moderate to significant amount of stress in meeting deadlines and dealing with day-to-day events in the execution of job duties. Needs flexibility and adaptability to change. Candidate must be self-disciplined and a self-starter and able to work independently with a flexible work schedule.