Location: All cities,AK, USA
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 Programmer Analyst SQL at Gainwell, you will be a part of an innovative healthcare technology company with a mission to serve the healthcare needs of our communities. You will use your programming and analytical skills to drive the development of healthcare administration products used, and relied upon, by millions of patients. Most importantly, you ll have the chance to grow and develop as a professional through our exceptional developmental opportunities. Your role in our mission Take a close look at some of the details that contribute to Gainwell s industry-leading tools and technologies in this challenging position. 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. Experience with Healthcare EDI standards such as 835s. Knowledge of SSIS and SSRS Experience with job scheduling tools. Experience with a health insurance company, TPA, or claim processor and a thorough understanding on the underlying structure of claims transactions. Role is not a standard SQL Server DBA, but rather a DBA/SQL Developer that has application performance experience. This is a must have. What we're looking for 10+ years of progressively responsible experience in a directly related area, during which both professional and management capabilities have been clearly demonstrated. Extensive 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. Extensive knowledge in Data De-identification and Test data preparation. Extensive 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. The pay range for this position is $72,800.00 - $104,000.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), 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. #J-18808-Ljbffr