PostgreSQL Database Administrator

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

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

90% Desk work

10% Remote travel to client sites, conferences, or internal team meetings

#LI-GF1 #LI-Remote

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