[Remote] PostgreSQL Database Administrator

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.ResponsibilitiesManage day-to-day operations of PostgreSQL databases in AWS Aurora environments across multiple accountsPerform database setup, configuration, and deployment following best practicesImplement and maintain backup and recovery strategies, ensuring data integrity and disaster recovery readinessMonitor database health, performance metrics, and capacity planningExecute database upgrades, patches, and migrations with minimal downtimeConduct performance tuning and optimization of PostgreSQL databases and queriesAnalyze and resolve database performance bottlenecks using AWS CloudWatch, AppDynamics, Grafana and other monitoring toolsOptimize database parameters, indexes, and query execution plansWork with development teams to review and optimize SQL queries and database designsLeverage AWS Aurora PostgreSQL features including read replicas, automated backups, and high availability configurationsImplement and manage Aurora clusters, parameter groups, and security configurationsUtilize AWS services such as RDS, CloudWatch, Systems Manager, Lambda, and S3 for database operationsImplement AWS best practices for security, monitoring, and cost optimizationDevelop automation scripts using Python or other programming languages for routine database tasksCreate tools for database provisioning, monitoring, alerting, and reportingBuild and maintain CI/CD pipelines for database deploymentsAutomate backup verification, database refresh processes, and compliance reportingProvide technical support and troubleshooting for database-related issuesCollaborate with DevOps, NetOps, and development teams on infrastructure and application initiativesParticipate in on-call rotation for production supportDocument database procedures, configurations, and troubleshooting guidesContribute to database standards and best practicesSkills4-7 years of hands-on experience as a PostgreSQL Database AdministratorStrong experience with AWS Aurora PostgreSQL and RDSProficiency in PostgreSQL performance tuning, query optimization, and troubleshootingSolid understanding of database backup and recovery strategiesExperience with database security, user management, and access controlsProgramming skills in Python, Shell scripting, or similar languages for automationKnowledge of AWS services (CloudWatch, Lambda, S3, Systems Manager, IAM)Experience with database monitoring and alerting toolsStrong understanding of SQL and relational database conceptsExcellent problem-solving and analytical skillsAbility to work independently and collaboratively in a team environmentStrong written and verbal communication skillsExperience with PostgreSQL logical replication and streaming replicationFamiliarity 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 industriesAWS certifications (Solutions Architect, Database Specialty)PostgreSQL certificationsFamiliarity with data warehousing and ETL processesBenefitsEligible for Company Performance-based Bonus Program, based on individual and company performanceMedical, dental, and vision insurance401K 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 scheduleHSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year100% company paid short and long-term disability, AD&D, and group life insuranceAccrued annual paid time off (PTO) of 18 days for the first 3 years of service, increasing thereafter and 7 paid holiday daysEmployee Assistance ProgramContinuing Education funds up to $1500 annually for eligible programs after 1 year of serviceVoluntary benefits including FSA, Hospital indemnity, Accident and Critical Illness insurancesDrFirst 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 OverviewDrFirst 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 SponsorshipDrFirst, 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.