Summary

As a SQL DBA 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 \xe2\x80\x94 a community\xe2\x80\x99s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare\xe2\x80\x99s biggest challenges. Here are the details on this position.

Your role in our mission

• Monitors database activity and file usage, and ensures necessary resources are present. Determines data to collect and analyzes information as appropriate. Investigates and resolves technical database issues of significance.
• Oversees the analysis and determination of database performance characteristics, informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for more complex databases. Recommends and implements tuning opportunities to improve system response and run times.
• Defines logical attributes and data inter-relationships and designs complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance.
• Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. Limits database accessibility based upon information security level and ensures data spillage from more secure to less secure databases does not occur.
• Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security.
• Plans and installs upgrades of database management systems (DBMS) software as necessary to enhance database performance. Researches various hardware and software products; recommends solution and implements approved products.
• Functions as a technical project leader or provides work leadership for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
• Assists project managers in the development of project plans including detailed project estimates and tasks required for database activities. Utilizes standard corporate tools to record change and problem activities for tracking purposes.
• Integrates databases and commercial of the shelf software; resolves conflicts between databases and of the shelf software, operating systems, and open source applications.
• Designs and tests database installation, implementation, and recovery scenarios. Determines test to use and collects appropriate data according to established guidelines. Participates in analysis, development and implementation of unique database recovery plans in response to client-impacting outages.

What we\'re looking for

• 
  Responsible for designing, building, installing, configuring, and supporting database servers while following established guidelines.
• Creates and maintains documentation of data flow.
• Recommends solutions by defining databases\xe2\x80\x99 physical structure and functional capabilities, database security, back-up and recovery specifications; maintains corporate data standards; and manages access permissions and privileges for all databases.
• Collaborates with respective business application teams to resolve issues.
• Defines and recommends solutions to mitigate possible capacity issues.
• Conducts system or database performance monitoring and tuning.
• Analyzes technical problems with applications and their associated databases and implements effective solutions.
• Demonstrated skills in using a Windows development language, programming or scripting such as PowerShell, SQL performance tuning, preferably using SolarWinds DPA, SQL Query Store, or other industry standards.
• Experience working with multiple relational databases such as SQL Server, Postgres.

What you should expect in this role

• Fast-paced, challenging and rewarding work environment.
• Work life balance.