Location: Any city
Company: Gainwell Technologies
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 SQL Developer / Support, 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. 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. Your role in our mission Essential Job Functions Provide core technical expertise to support and manage Microsoft SQL Server in a highly challenging environment.
Provide expertise in writing complex queries. 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. What we're looking for Experience with a health insurance company, TPA, or claim processor and a thorough understanding of the underlying structure of claims transactions.
Experience with Healthcare EDI standards such as 835s and job scheduling tools. Knowledge of SSIS and SSRS DBA/SQL Developer that has application performance experience. This is a must have. Expertise in Microsoft SQL Server database, as well as data modeling, both logical and physical. SQL knowledge (query performance tuning, index maintenance, etc. ) as well as an understanding of database structure. Experience with collecting business requirements from customers and transform the requirements into DB data processes and data schema.
What you should expect in this role This position is remote. This position is part of a rotating on-call team. #LI-DN1 #LI-Remote The pay range for this position is $58,200.00 - $83,200.00 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), interactionual 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.
IT jobs refer to positions focused on the creation, maintenance, and support of computer systems and networks in various industries. These roles can include software development, network architecture, system administration, cybersecurity, information systems management, and technical support. Characteristically, IT jobs require a blend of technical skills, problem-solving abilities, and a continuous learning mindset due to the fast-paced nature of technological advancements. They often involve working with complex systems and data, necessitating attention to detail and a methodical approach to work. Additionally, collaboration with other professionals and clear communication are key, as IT roles typically support businesses in achieving strategic goals through technological solutions.
IT jobs refer to positions in the field of Information Technology, a sector dedicated to computing technology, telecommunications, and data management. These jobs typically involve the design, development, implementation, support, and management of computer-based information systems. Key characteristics of IT jobs include a focus on problem-solving, continual learning due to rapidly evolving technologies, and a blend of technical proficiency with soft skills like teamwork and communication. Roles can range from software developers and system analysts to network engineers and cyber security specialists, all contributing to the technological backbone of modern businesses.
IT jobs refer to positions within the Information Technology sector, where professionals focus on computer-based systems. These roles can range from software development, network administration, and cybersecurity to data analysis and IT support. IT jobs often feature continuous learning due to the fast-paced nature of tech advancements. Additionally, they may offer flexibility with options for remote work and have a significant emphasis on problem-solving and innovation. As technology becomes increasingly integral to all industries, IT jobs are in high demand and often offer competitive salaries.
IT jobs refer to positions in the field of Information Technology, a sector dedicated to computing technology, telecommunications, and data management. These jobs typically involve the design, development, implementation, support, and management of computer-based information systems. Key characteristics of IT jobs include a focus on problem-solving, continual learning due to rapidly evolving technologies, and a blend of technical proficiency with soft skills like teamwork and communication. Roles can range from software developers and system analysts to network engineers and cyber security specialists, all contributing to the technological backbone of modern businesses.
