Note: The job is a remote job and is open to candidates in USA. DrFirst, Inc. is a Healthcare IT company that has been empowering providers and patients for 25 years through intelligent medication management solutions. They are seeking a mid-level PostgreSQL Database Administrator to manage their PostgreSQL infrastructure on AWS Aurora, supporting critical healthcare applications while focusing on automation, performance optimization, and operational excellence.
Responsibilities
- 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
- 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
- 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
- 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 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
Skills
- 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
- 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
Benefits
- 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.
Company Overview
DrFirst has been transforming medication management for 25 years, helping providers and patients navigate a complex and often fragmented healthcare system. It was founded in 2000, and is headquartered in Rockville, Maryland, USA, with a workforce of 201-500 employees. Its website is http://drfirst.com.Company H1B Sponsorship
DrFirst, Inc. has a track record of offering H1B sponsorships, with 2 in 2026, 20 in 2025, 10 in 2024, 18 in 2023, 19 in 2022, 5 in 2021, 14 in 2020. Please note that this does not guarantee sponsorship for this specific role.