Database Administrator

Novarad Corporation • Provo, UT

63d

About The Position

As a PostgreSQL Database Administrator at Novarad you are a member of a highly effective team of software and QA engineers that create excellent products for the business. Your key area of responsibility will be database/application performance monitoring and tuning in both a development and production-support capacity. You have deep expertise in database performance tuning, high availability, replication, and troubleshooting. You are a lifelong learner willing to take on new challenges. You can work autonomously with minimal direction. You have become proficient with Postgres in enterprise-scale environments, with the ability to diagnose and resolve complex database issues.

Requirements

• 3+ years of experience as a Database Administrator, Database Engineer, or in a similar technical role
• Strong hands-on experience with PostgreSQL administration, including query tuning and index optimization
• Proficiency in writing and troubleshooting SQL queries, functions, and stored procedures
• Familiarity with pgAdmin and other PostgreSQL performance monitoring tools
• Working knowledge of database backup, recovery, and replication techniques
• Strong analytical and problem-solving skills with attention to detail
• Ability to work effectively with both software and support engineering teams
• Excellent communication and documentation skills

Nice To Haves

• Experience in .NET based application environments
• Understanding of application performance impacts related to database design
• Familiarity with database monitoring, automation, or scripting tools (e.g., pg_stat_statements, Bash, Python)
• Experience in the medical software industry (PACS/RIS/HL7/HER)

Responsibilities

• Proactively monitor and tune database performance, addressing high CPU usage, memory bottlenecks, and I/O contention
• Analyze query execution plans, identify performance anti-patterns, and optimize queries and indexes
• Perform comprehensive database tuning, including PostgreSQL parameter optimization and infrastructure improvements
• Partner with software engineers during the development lifecycle to design efficient schemas and write optimized SQL queries, functions, and stored procedures
• Act as a consultant to the development team on database best practices for indexing, schema design, and resource utilization
• Establish and document database standards and best practices for the engineering teams
• Work closely with the development manager to meet assigned goals
• Employ effective communication across the organization
• Participate in company and technical trainings
• Serve as the escalation point for the Technical Support team on complex database-related issues at customer sites
• Investigate production performance issues, diagnose root causes, and implement lasting solutions
• Assist with the planning and execution of database backups, recovery strategies, and security configurations
• Develop and automate maintenance tasks to ensure the smooth operation of internal and customer-hosted databases
• Document processes, performance tuning findings, and recommendations for future releases
• Support PostgreSQL version upgrades

Benefits

• Competitive salary with generous PTO
• Health, dental, vision, life, and disability insurances
• HSA option with dollar-for-dollar match
• 401k with dollar-for-dollar match
• Wellness program
• Sundance corporate passes

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level