Senior Database Administrator (MSSQL)

Overview:

Now is the time to join us! 

Who are you?

The Senior Database Administrator is an expert in the administration, maintenance, and optimization of Microsoft SQL Server data stores. The Senior Database Administrator will continuously monitor and improve performance and availability of database systems and processes, as well as perform systems check, replication, backup, recovery, and load analysis. They will advise software developers on data management best practices and enforce their implementation, and will troubleshoot systems 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 design, installation, deployment, replication, backup, restoration, optimization, security, and data exchange. Systems include ETL, transactional data stores, data warehouse, and reporting.
• Maximize database performance by tuning file structures and managing indexes.
• Advise and guide software architects and engineers on data access methods and decisions on optimal data structures.
• Safeguard data integrity and maintain security controls in all existing databases and data exchange technology through process, training, quality control, and monitoring.
• Write simple to complex SQL queries, troubleshoot queries, and tune queries for best performance.
• Design and implement processes to automate transactional information functions to optimize operational efficiency throughout the organization.
• Manage data operations for data at rest, data exchange, batch processing, and data reporting.
• Support development and production activities.
• Generate and maintain documentation of data store systems, architectures, configurations, operations, and maintenance.
• Provide guidance and coaching to junior and mid-level engineers.

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.

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:

• 5 years’ experience administering, maintaining, and optimizing Microsoft SQL Server at scale
• 3-5 years of experience running large MSSQL data stores in AWS on EC2 and RDS/Aurora
• Expert knowledge (2-3 years of experience) 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
• Advanced expertise in SQL, stored procedures, data batch processing, and data as a service
• Practical experience in managing internal and external database security
• Excellent communication and documentation skills
• Ability to triage issues, react well to changes in priority, work with teams, and self-manage time and effort across multiple projects
• 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 $103,000 to $130,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.