Job description
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 Sr. Microsoft SQL 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
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.
- Experience in writing complex queries.
- Working 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.
- Maximizing 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.
- Managing the storage environments for the databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.
- Creating and assigning database roles and privileges, backup and recovery policies and maintain integrity and reliability of access to information.
- Importing and exporting data to and from the database servers.
- Performing routine backup and recovery testing, including testing and documenting recovery scenarios.
- Monitor and analyze disk I/O, queue lengths.
- Conduct troubleshooting of issues associated with supported SQL databases.
- Performing SQL performance tuning tasks and SQL performance Queries. Also, responsible for database performance monitoring and capacity planning.
- Creating and maintaining detailed SOPs, configuration documentation, and maintenance plans for the database environment.
- Provide support of client site change control activities, supporting change control requests and review boards with respect to system implementation.
- Distinguish between necessary security settings that would protect the system while ensuring usability versus security settings to meet security compliance.
- Understand and translate business needs into data models supporting long-term solutions.
- Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
- Optimize and update logical and physical data models to support new and existing projects and maintain conceptual, logical and physical data models along with corresponding metadata.
- Evaluate data models and physical databases for variances and discrepancies.
What we're looking for
8 or more years of SQL Developer with application performance experience- 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
- Knowledge of SSIS and SSRS and experience with job scheduling tools
- 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
What you should expect in this role
Remote Opportunity
#LI-IP1
#LI-REMOTE
The pay range for this position is $90,900.00 - $129,900.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.
offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.