Database Administrator II (MSSQL)

$75,000 - $100,000/Yr

Personify Health - Remote, OR

Full-time - Mid Level

Remote, OR

About the position

The Database Administrator II at Personify Health is responsible for the administration and maintenance of Microsoft SQL Server data stores. This role focuses on optimizing database performance, ensuring availability, and managing data operations, including backup, recovery, and security. The position requires collaboration with other engineers to troubleshoot systems and improve overall database efficiency.

Responsibilities

• Manage and maintain data management systems including installation, deployment, replication, backup, restoration, security, and data exchange.
• Maximize database performance by tuning file structures and managing indexes.
• Analyze queries, indexes, execution plans, and stored procedures for performance tuning.
• Write simple to complex SQL queries and assist engineers in writing optimized queries.
• Manage data operations for data at rest, data exchange, batch processing, and data reporting.
• Perform upgrades and install security patches for MSSQL Server.
• Maintain documentation of data store systems, architectures, configurations, operations, and maintenance.

Requirements

• 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 of performance and availability monitoring, backup/restore, performance tuning, and query optimization.
• Microsoft SQL Server certification is preferred.
• Thorough understanding of relational database technology and concepts, SQL scripting, and 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 adapt to changes in priority and self-manage time and effort.

Nice-to-haves

• Previous experience in healthcare or other highly regulated industries.

Benefits

• Base compensation ranging from $75,000 to $100,000.
• 10% target bonus/variable compensation.
• Health insurance coverage.
• Dental insurance coverage.
• Vision insurance coverage.
• Mental health benefits.