Sql Server Developer Jobs

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

• Aids in the definition and creation of solutions that meet user’s needs
• Effectively communicates project status and planning activities with team and customers
• Participates in off-hours support rotation
• Regular and predictable attendance
• Troubleshoots slow performing queries and database servers
• Designs and implements SSIS packages and other ETL processes
• Provides support for off-hour deployments and production issues
• Other duties as may be assigned
• 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
• Applies business and database analysis skills to gain deep understanding of user’¬s needs
• Consistently demonstrates compliance with HIPAA regulations, professional conduct, and ethical practice
• Develops custom database objects, stored procedures, functions, and T-SQL
• Collaborates to define projects, develops and interprets business rules, and debugs technical issues when they arise

Qualifications

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

Competencies

• Planning & Organizing - Displays ability to effectively plan, organize and implement applicable tasks or projects in relation to established goals and objectives
• Job Knowledge - Knowledge of products, policies and procedures; OR knowledge of techniques, skills, equipment, procedures, and materials
• Internal Controls - Knowledge of and ability to create, implement, evaluate and enhance internal control processes
• 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.
• 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
• 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.
• Ethics - Honest, accountable, maintains confidentiality
• Initiative - Takes action, seeks new opportunities, strives to see projects to completion
• Conflict Management - Good listener, committed to finding solution to problems, works well with difficult people

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.