Senior Professional Programmer Analyst

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.

 

Summary

 

As a Senior SQL Server Developer at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.​

Your role in our mission

Develop your career as you support Gainwell’s focus on creating innovative, purpose-built technologies and solutions to deliver better health and human services outcomes.

 

• Experience in SQL Server 2008\2012 is mandatory. Should be able to write complex stored procedures and functions.
• Optimize long running queries using tuning advisor and Execution plan. Experience with SQL Server Analysis Services, Performance Tuning etc.,
• Use DDL (Data Definition Language) and DML (Data Manipulation Language) to build and deploy Database objects, including tables, views, user defined functions, and stored procedures.
• Utilizes database security regulations, policies, and guidelines.
• Build reporting deliverables, to include DDL/DML SQL Scripts.
• Participates in analysis and development of tasks related to business report requirements.
• Utilizes best practices, checklists and defined processes.
• Participates in data analysis for required database objects.
• Should possess strong architectural and design skills, implemented various design patterns and frameworks.
• Should possess Strong Debugging skills and able to identify and fix the issues/bugs identified in the Stored Procedure.
• Should know about Error Handling.
• Work experience in agile projects.

What we're looking for

6+ years of SQL Server Development experience with SQL Server 2008/2012.  Additional experience required includes: 

• Previous experience with Healthcare systems.   
• Ability to write complex stored procedures and functions.
• Optimize long running queries using tuning advisor and Execution plan
• SQL Server Analysis Services, Performance Tuning etc.,
• Use DDL (Data Definition Language) and DML (Data Manipulation Language) to build and deploy Database objects, including tables, views, user defined functions, and stored procedures.
• Utilizes database security regulations, policies, and guidelines.
• Build reporting deliverables, to include DDL/DML SQL Scripts..
• Knowledge of technology architecture, the product development life cycle, cloud technologies, software as a service, and product and platform configurations.
• Strong skills using and manipulating relational databases, event subscription-based communication and software development skills between modules.
• Willingness to lead and take ownership over assigned work and to mentor more junior colleagues in-role.

What you should expect in this role

• This position is part of a rotating on-call team.
• Fully remote opportunity with the option to work anywhere within the United States
• Video cameras must be used during all interviews, as well as during the initial week of orientation
• Fast paced, challenging and rewarding work environment.
• Work life balance.    
• Will require late evening work to overlap US work hours.

 

The per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.