PostgreSQL Database Administrator

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 Postgre

SQL Database Administrator to join our System Operations team. This role will be crucial in managing our Postgre

SQL 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.

• 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 Dev Ops, development, and infrastructure teams to deliver integrated solutions
• A continuous learner who stays current with Postgre
  
  SQL best practices, AWS innovations, and database optimization techniques

• Manage day-to-day operations of Postgre
  
  SQL 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

• Conduct performance tuning and optimization of Postgre
  
  SQL databases and queries
• Analyze and resolve database performance bottlenecks using AWS Cloud Watch, App Dynamics, 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
• Leverage AWS Aurora Postgre
  
  SQL 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, Cloud Watch, Systems Manager, Lambda, and S3 for database operations
• Implement AWS best practices for security, monitoring, and cost optimization

• 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
• Provide technical support and troubleshooting for database-related issues
• Collaborate with Dev Ops, Net Ops, 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

• 4-7 years of hands-on experience as a Postgre
  
  SQL Database Administrator
• Strong experience with AWS Aurora Postgre
  
  SQL and RDS
• Proficiency in Postgre
  
  SQL performance…