Personify Health

Database Administrator II (MSSQL)

Job Locations US-Remote
Job ID
2024-3595
Category
Engineering
Posted Date
4 weeks ago(10/28/2024 9:32 AM)
Type
Regular Full-Time

Overview

Now is the time to join us! 

 

We’re Personify Health. We’re the first and only personalized health platform company to bring health, wellbeing, and navigation solutions together. Helping businesses optimize investments in their members while empowering people to meaningfully engage with their health. At Personify Health, we believe in offering total rewards, flexible opportunities, and a diverse inclusive community, where every voice matters. Together, we’re shaping a healthier, more engaged future.

Responsibilities

Who are you?

 

The Database Administrator II has advanced expertise in the administration and maintenance of Microsoft SQL Server data stores. The Database Administrator II will continuously monitor and improve performance and availability of database systems, as well as perform systems check, replication, backup, recovery, and load analysis. They will troubleshoot systems in collaboration with other engineers as required.

 

In this role you will wear many hats, but your knowledge will be essential in the following:  

  • Manage and maintain data management systems to encompass installation, deployment, replication, backup, restoration, security, and data exchange. Systems include ETL, transactional data stores, data warehouse, and reporting.
  • Maximize database performance by tuning file structures and managing indexes.
  • Analyze queries, indexes, execution plans, and stored procedures and tune for excellent performance.
  • Write simple to complex SQL queries, and help engineers write queries for best performance.
  • Manage data operations for data at rest, data exchange, batch processing, and data reporting.
  • Perform upgrades and install security patches of MSSQL Server.
  • Maintain documentation of data store systems, architectures, configurations, operations, and maintenance.

You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Qualifications

What you bring to the Personify Health team:

 

In order to represent the best of what we have to offer you come to us with a multitude of positive attributes including:

  • 3 years’ experience administering and maintaining Microsoft SQL Server
  • 2-3 years experience running MSSQL data stores in AWS on EC2 and RDS/Aurora
  • Advanced knowledge (1 year) of performance and availability monitoring, backup/restore, performance tuning, query optimization
  • Microsoft SQL Server certification is preferred.

You also take pride in offering the following Core Skills, Competencies, and Characteristics:

  • Thorough understanding of relational database technology and concepts, SQL scripting, database normalization best practices
  • Configuration of database servers for high availability and operation of HA environments via Always On availability groups
  • Expertise in T-SQL, stored procedures, data batch processing, and data as a service
  • Excellent communication and documentation skills
  • Ability to react well to changes in priority, work with teams, and self-manage time and effort to meet commitments.
  • Previous experience in healthcare or other highly regulated industries preferred.

No candidate will meet every single desired qualification. If your experience looks a little different from what we’ve identified and you think you can bring value to the role, we’d love to learn more about you!

 

Personify Health is an equal opportunity organization and is committed to diversity, inclusion, equity, and social justice.

 

In compliance with all states and cities that require transparency of pay, the base compensation for this position ranges from $75,000 to $100,000. Note that salary may vary based on location, skills, and experience. This position is eligible for 10% target bonus/variable compensation as well as health, dental, vision, mental health and other benefits.

 

We strive to cultivate a work environment where differences are celebrated, and employees of all backgrounds are empowered to thrive. Personify Health is committed to driving Diversity, Equity, Inclusion and Belonging (DEIB) for all stakeholders: employees (at each organization level), members, clients and the communities in which we operate. Diversity is core to who we are and critical to our work in health and wellbeing.

 

#WeAreHiring #PersonifyHealth

 

Beware of Hiring Scams: Personify Health will never ask for payment or sensitive personal information such as social security numbers during the hiring process. All official communication will come from a verified company email address. If you receive suspicious requests or communications, please report them to talent@personifyhealth.com. All of our legitimate openings can be found on the Personify Health Career Site.

 

Application Deadline: Open until position is filled.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed