Job Type
Full-time
Description
Hi, We Are Novarad
Novarad's solutions help healthcare executives, clinicians and IT professionals deliver clinical, operational, and fiscal excellence. With a self-sustaining business model, more than three decades of technology leadership, and an intense focus on our customers' needs, Novarad brings people and technology together in ways no one else can. We're driven by innovation that truly transforms healthcare - for the provider and their patient.
As a PostgreSQL Database Administrator at Novarad you are a member of a highly effect 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.
Your Benefits (We know you're always scrolling to the bottom for these, so here you go!)
- 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
Requirements
As a member of the Software Engineering team, you will-
Performance & Tuning :
Proactively monitor and tune database performance, addressing high CPU usage, memory bottlenecks, and I / O contentionAnalyze query execution plans, identify performance anti-patterns, and optimize queries and indexesPerform comprehensive database tuning, including PostgreSQL parameter optimization and infrastructure improvementsDevelopment & Collaboration :
Partner with software engineers during the development lifecycle to design efficient schemas ans write optimized SQL queries, functions, and stored proceduresAct as a consultant to the development team on database best practices for indexing, schema design, and resource utilizationEstablish and document database standards and best practices for the engineering teamsWork closely with the development manager to meet assigned goalsEmploy effective communication across the organizationParticipate in company and technical trainingsSupport & Operations :
Serve as the excalation point for the Technical Support team on complex database-related issues at customer sitesInvestigate production performance issues, diagnose root causes, and implement lasting solutionsAssist with the planning and execution of database backups, recovery strategies, and security configurationsDevelop and automate maintenance tasks to ensure the smooth operation of internal and customer-hosted databasesDocument processes, performance tuning findings, and recommendations for future releases.Support PostgreSQL version upgradesWhat you will bring-
Knowledge and Experience
3+ years of experience as a Database Administrator, Database Engineer, or in a similar technical roleStrong hands-on experience with PostgreSQL administration, including query tuning and index optimizationProficiency 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.Beneficial Experience and Skills :
Experience in .NET based application environmentsUnderstanding of application performance impacts related to database designFamiliarity with database monitoring, automation, or scripting tools (e.g., pg_stat_statements, Bash, Python)Experience in the medical software industry (PACS / RIS / HL7 / HER)Our recruits come from all walks of life; our customers come from all walks of life; and so do we. Novarad celebrates an inclusive and diverse workforce. This makes our team stronger by sharing our differences and experiences in open and creative conversation. Come share your differences with us.
It is the policy of Novarad to provide equal employment opportunities without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, genetic information or any other protected characteristic under applicable law.