Demo

Lead SQL Server Developer

Gainwell Technologies
Ohio, OH Full Time
POSTED ON 2/14/2025
AVAILABLE BEFORE 5/11/2025

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

Discover career satisfaction by design in this challenging position, where you will :

  • Provide core technical expertise to support and manage Microsoft SQL Server in a highly challenging environment.
  • Provide expertise in writing complex queries, and perform SQL performance tuning
  • Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects using SQL / T-SQL
  • Analyze database and system response time and determine optimization and tuning recommendation to improve query performance.
  • Review long running SQL's in production database and recommend for tuning.
  • Work with application / development teams to assist in overall database design, helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures.
  • Analyze Microsoft SQL Server tables data volume and provide recommendation for indexes and triggers.
  • Maximize database stability, up time of databases including Production, Test, Development environments through system monitoring, performance tuning, and routine maintenance tasks such as index rebuilds, file compression, statistical updates, and database consistency checks.
  • Manage the storage environments for the databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.
  • Create and assign database roles and privileges.
  • Create and execute database backup and recovery policies and maintain integrity and reliability of access to information.
  • Import and export data to and from the database servers.
  • Perform routine backup and recovery testing, including testing and documenting recovery scenarios.
  • Conduct database performance monitoring and capacity planning.
  • Monitor and analyze disk I / O, queue lengths.
  • Conduct troubleshooting of issues associated with supported SQL databases.
  • Perform SQL performance tuning tasks.
  • Create and maintain detailed SOPs, configuration documentation, and maintenance plans for the database environment.
  • Assist internal client teams with management of production server systems such as network security teams, cloud teams, system security officers.
  • Serve as technical liaison between IT teams.

What we're looking for

9 years of lead SQL Server Development experience with SQL Server 2008 / 2012. Additional experience required includes :

  • Support and manage Microsoft SQL Server in a highly challenging environment
  • Write complex queries, and perform SQL performance tuning
  • Design and create tables, views, triggers, partitions, complex stored procedures, functions, indexes and other database objects using SQL / T-SQL
  • Analyze database and system response time and determine optimization and tuning recommendation to improve query performance
  • Review long running SQL's in production database and recommend for tuning
  • Work with application / development teams to assist in overall database design, helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures.
  • What you should expect in this role

  • Fully remote opportunity with the option to work anywhere within the United States
  • Opportunities to travel through your work (0-10%)
  • Willingness to work a flexible schedule to accommodate business needs and travel as required
  • Video cameras must be used during all interviews, as well as during the initial week of orientation
  • LI-SH1

    LI-REMOTE

    The deadline to submit applications for this posting is February 28, 2025

    The pay range for this position is $100,000 - $120,000 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.

    We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You'll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

    Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.

    Salary : $100,000 - $120,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Lead SQL Server Developer?

    Sign up to receive alerts about other jobs on the Lead SQL Server Developer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $130,034 - $179,473
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Gainwell Technologies

    Gainwell Technologies
    Hired Organization Address North Highlands, CA Full Time
    Great companies need great teams to propel their operations. Join the group that solves business challenges and enhances...
    Gainwell Technologies
    Hired Organization Address San Francisco, CA Full Time
    Great companies need great teams to propel their operations. Join the group that solves business challenges and enhances...
    Gainwell Technologies
    Hired Organization Address Warwick, RI Full Time
    Job Details Great companies need great teams to propel their operations. Join the group that solves business challenges ...
    Gainwell Technologies
    Hired Organization Address Albuquerque, NM Full Time
    Job Details Great companies need great teams to propel their operations. Join the group that solves business challenges ...

    Not the job you're looking for? Here are some other Lead SQL Server Developer jobs in the Ohio, OH area that may be a better fit.

    .Net Lead Developer (CONFIDENTIAL)

    ShiftCode Analytics, Ohio, OH

    Lead iOS developer

    Intone Networks, Ohio, OH

    AI Assistant is available now!

    Feel free to start your new journey!