Principal Data Engineer - Procare Solutions

About Procare

Our mission is to simplify childcare operations and create meaningful connections by providing technology, expertise, and unparalleled service.

Procare Solutions is the #1 name in childcare software – used by more than 35,000 childcare businesses across the country. For over 30 years, childcare professionals have looked to Procare to provide real-time information for making critical decisions, maintaining compliance with local and state regulations, and adhering to business best practices.

We make childcare management run smoothly, so that our customers can spend more time focusing on the kiddos, not back office administrative duties.

A little about the role…

As a Principal Database Engineer for the Procare Platform team, you will be pivotal in building, scaling, securing, and optimizing our industry-leading SaaS solutions. With a focus on our production AWS Aurora Postgres instances, you will work alongside Platform, Security, and Application engineers to maintain and enhance our database systems. Your expertise will be crucial in breaking down complex problems and leading the execution of solutions that ensure scalability and reliability of our database architecture.

What You’ll Do

• Manage, scale, and secure AWS Aurora Postgres instances to ensure high performance and availability for our SaaS platform
• Develop strategies for database scaling that are in line with business requirements, focusing on optimizing read/write performance and efficient data access patterns
• Implement monitoring frameworks to capture and analyze database performance metrics that inform continuous improvement cycles
• Work closely with Application Engineers, especially within Ruby on Rails environments, to optimize interactions and scaling of ActiveRecord with Postgres
• Partner with teams across the organizations to drive performance, security, scalability, availability, reliability, observability for relational databases
• Design frameworks and maintain the general ecosystem around relational databases, including schema management, monitoring, permissions, service discovery integration, and more
• Design, automate, and document database operations
• Diagnose and effectively communicate the root cause of database issues
• Apply inspection/debugging techniques to metrics/telemetry, logs, events, and other information sources to diagnose operational issues
• Participate in incident response activities
• Document and present incident postmortems
• Serve on an on-call rotation to address high-priority issues as they arise

Requirements

Our Ideal Candidate Will Have…

• BA/BS degree in Computer Science or a related field
• Minimum of 5 years' experience in data engineering, with substantial experience as a DBA for large-scale user-facing applications backed by Postgres.
• In-depth knowledge of managing and scaling AWS Aurora Postgres instances
• Experience with Ruby/Rails, specifically in optimizing and scaling ActiveRecord and Postgres interactions
• Experience with Cloud-native data stores: DynamoDB, Redis, etc.
• Experience with Data streaming and event-driven models like Kafka
• Excellent problem-solving skills and ability to work as part of a dynamic engineering team
• Strong communication skills and experience in agile project environments
• AWS Certified Database Associate or Higher

Benefits

Why Procare?

• Excellent comprehensive benefits packages including: medical, dental, & vision plans- choose the plan best for you
• HSA option with employer contributions of $50/month
• Vacation time, holidays, sick days, volunteer & personal days
• 401K Plan with employer match and immediate vesting
• Medical, Dependent Care, and Transportation FSA Plans
• Paid Parental Leave
• Company paid Short and Long-Term disability and Life Insurance
• RTD EcoPass for all Denver employees
• Tuition Reimbursement up to $2,000/year and continued Professional Development
• Free access to our Employee Assistance Program with 24/7 live support
• Casual workplace environment
• Some meals provided
• Voluntary Pet Insurance
• Prime downtown location close to restaurants and entertainment
• Promote from within- excellent career paths

Salary

$160,000 to $185,000/year DOE

Location

We are currently in a hybrid in-office/remote working model based on business needs. While our preference is a candidate located in Denver, CO, this role is open to remote candidates in the following states: AL, AZ, CA, CO, CT, FL, GA, ID, IL, IN, IA, KY, ME, MD, MA, MI, MN, MO, NV, NJ, NY, NC, OH, OR, PA, TN, TX, VA, WA, WI.