DrFirst, Inc.

PostgreSQL Database Administrator

DrFirst, Inc.  •  $130k - $150k/yr  •  United States (Remote)  •  4 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

About DrFirst

For 25 years, DrFirst has empowered providers and patients to achieve better health through intelligent medication management. We improve healthcare workflows and help patients start and stay on therapy with end-to-end solutions that enhance prescription access, affordability, and adherence. Our solutions help 100 million patients a year and are used by more than 420,000 prescribers, 71,000 pharmacies, 270 EHRs and health information systems, and over 2,000 hospitals in the U.S. This is a great opportunity to be a part of a successful Healthcare IT company experiencing significant growth. Here you'll get to work with some of the smartest and most interesting people around, solving unique and complex challenges in healthcare on a scale matched by few companies. If you get excited about stretching yourself in new ways, developing yourself to your fullest potential, and care about working with smart colleagues, we want to talk to you!

We are seeking a talented mid-level PostgreSQL Database Administrator to join our System Operations team. This role will be crucial in managing our PostgreSQL infrastructure, primarily running on AWS Aurora, supporting mission-critical healthcare applications. You'll work in a collaborative environment focused on automation, performance optimization, and operational excellence.

Who will love this job

  • A problem-solver who enjoys diagnosing complex database performance issues and implementing elegant solutions that improve system reliability
  • An automation enthusiast who sees repetitive tasks as opportunities to build scripts and tools that scale operations efficiently
  • A detail-oriented professional who takes pride in maintaining robust backup strategies, ensuring data integrity, and planning for disaster recovery scenarios
  • A collaborative team player who works effectively with DevOps, development, and infrastructure teams to deliver integrated solutions
  • A continuous learner who stays current with PostgreSQL best practices, AWS innovations, and database optimization techniques

What you will work on

Database Management & Operations

  • Manage day-to-day operations of PostgreSQL databases in AWS Aurora environments across multiple accounts
  • Perform database setup, configuration, and deployment following best practices
  • Implement and maintain backup and recovery strategies, ensuring data integrity and disaster recovery readiness
  • Monitor database health, performance metrics, and capacity planning
  • Execute database upgrades, patches, and migrations with minimal downtime

Performance Optimization

  • Conduct performance tuning and optimization of PostgreSQL databases and queries
  • Analyze and resolve database performance bottlenecks using AWS CloudWatch, AppDynamics, Grafana and other monitoring tools
  • Optimize database parameters, indexes, and query execution plans
  • Work with development teams to review and optimize SQL queries and database designs

AWS Cloud Infrastructure

  • Leverage AWS Aurora PostgreSQL features including read replicas, automated backups, and high availability configurations
  • Implement and manage Aurora clusters, parameter groups, and security configurations
  • Utilize AWS services such as RDS, CloudWatch, Systems Manager, Lambda, and S3 for database operations
  • Implement AWS best practices for security, monitoring, and cost optimization

Automation & Scripting

  • Develop automation scripts using Python or other programming languages for routine database tasks
  • Create tools for database provisioning, monitoring, alerting, and reporting
  • Build and maintain CI/CD pipelines for database deployments
  • Automate backup verification, database refresh processes, and compliance reporting

Collaboration & Support

  • Provide technical support and troubleshooting for database-related issues
  • Collaborate with DevOps, NetOps, and development teams on infrastructure and application initiatives
  • Participate in on-call rotation for production support
  • Document database procedures, configurations, and troubleshooting guides
  • Contribute to database standards and best practices

Qualifications

Required:

  • 4-7 years of hands-on experience as a PostgreSQL Database Administrator
  • Strong experience with AWS Aurora PostgreSQL and RDS
  • Proficiency in PostgreSQL performance tuning, query optimization, and troubleshooting
  • Solid understanding of database backup and recovery strategies
  • Experience with database security, user management, and access controls
  • Programming skills in Python, Shell scripting, or similar languages for automation
  • Knowledge of AWS services (CloudWatch, Lambda, S3, Systems Manager, IAM)
  • Experience with database monitoring and alerting tools
  • Strong understanding of SQL and relational database concepts
  • Excellent problem-solving and analytical skills
  • Ability to work independently and collaboratively in a team environment
  • Strong written and verbal communication skills

Preferred:

  • Experience with PostgreSQL logical replication and streaming replication
  • Familiarity with infrastructure as code (Terraform, CloudFormation)
  • Experience with CI/CD tools (Jenkins, GitLab CI, AWS CodePipeline)
  • Knowledge of other database platforms (Oracle, MySQL, Redshift)
  • Experience in healthcare technology or regulated industries
  • AWS certifications (Solutions Architect, Database Specialty)
  • PostgreSQL certifications
  • Familiarity with data warehousing and ETL processes

Physical Requirements

  • 90% Desk work
  • 10% Remote travel to client sites, conferences, or internal team meetings

#LI-GF1 #LI-Remote

Benefits

  • Competitive compensation, with a base salary of $130,000 - $150,000 (Exact compensation may vary based on skills and experience)
  • Eligible for Company Performance-based Bonus Program, based on individual and company performance
  • Medical, dental, and vision insurance
  • 401K eligible after 3 months of employment, with 50% company match up to first 5% of salary contributed to the plan with a 3-year vesting schedule
  • HSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year
  • 100% company paid short and long-term disability, AD&D, and group life insurance
  • Accrued annual paid time off (PTO) of 18 days for the first 3 years of service, increasing thereafter and 7 paid holiday days
  • Employee Assistance Program
  • Continuing Education funds up to $1500 annually for eligible programs after 1 year of service
  • Voluntary benefits including FSA, Hospital indemnity, Accident and Critical Illness insurances

DrFirst is committed to being a Remote-First company, creating a dynamic and flexible workplace where everyone can thrive, no matter where they log in from. Check out our approach to remote work: https://drfirst.com/company/about-us/careers/.

Our recruitment process at DrFirst is straightforward and secure. You will only be contacted by our recruitment team through an official @drfirst.com email address. We will never ask you for payment or sensitive personal information, such as your social security number or banking details, at any stage of the hiring process. Additionally, we will not request that you purchase equipment or accept e-checks or checks for deposit. If you encounter any communications claiming to be from DrFirst that seem suspicious, please contact our recruitment team directly at recruiter@drfirst.com to verify the message's authenticity. Your security is important to us!

Learn more about our benefits and professional development opportunities: https://drfirst.com/company/about-us/careers/the-perks/.

DrFirst, Inc.

About DrFirst, Inc.

DrFirst has been transforming medication management for 25 years, helping providers and patients navigate a complex and often fragmented healthcare system.

After all, “first” isn’t just in our name—it’s a fundamental part of who we are as a company.

We were first to bring real-time price transparency into prescribing workflows and first to enable e-prescribing for controlled substances—solutions that are now standard across the industry.

DrFirst has won over 25 awards for excellence and innovation, including winning Gold in the prestigious Edison Awards in 2023, recognizing our game-changing use of clinical-grade AI to streamline time-consuming healthcare workflows and prevent medication errors.

Why It Matters: Medication management is full of roadblocks such as friction-filled workflows, outdated systems, regulatory complexity, and disconnected stakeholders. The result? Delays in care, high medication abandonment rates, and poor adherence that negatively impact patient outcomes.

DrFirst tackles these challenges with end-to-end solutions that support:

Prescribing: Adaptable workflows that deliver the right information at the right time to boost efficiency and improve outcomes.

Adherence: Innovative solutions that inform patients and providers to increase medication access and affordability.

Optimization: Clinical-grade AI that aggregates fragmented data from multiple sources and fills-in gaps to deliver clean, complete, and consumable information at the point of care.

Industry
Healthcare & Social Services
Company Size
201-500 employees
Headquarters
Rockville, MD
Year Founded
2000
Social Media