Database Administrator

Prestige Staffing; Remote; USD 100,000 - 130,000; Full time

Job summary

A leading staffing firm is seeking an experienced PostgreSQL Database Administrator to optimize their cloud-based SaaS platform. The ideal candidate will excel in PostgreSQL administration, performance tuning, and database reliability within an AWS environment. Responsibilities include administering databases, optimizing queries, and collaborating in Agile development processes. Strong experience with AWS and code-based migrations is essential for success in this role.

Qualifications

• 5+ years of hands-on experience administering PostgreSQL databases.
• Strong expertise in PostgreSQL performance tuning and query optimization.
• Experience supporting cloud-based SaaS applications.

Responsibilities

• Administer, maintain, and support PostgreSQL databases in a cloud environment.
• Design and optimize database schemas and queries.
• Monitor performance and resolve bottlenecks.

Skills

PostgreSQL performance tuning

Query optimization

Agile development

Troubleshooting and problem-solving

Tools

AWS RDS/Aurora PostgreSQL

ORM frameworks

Job description

We are seeking an experienced PostgreSQL Database Administrator (DBA) to support and optimize our cloud-based SaaS platform. This role will focus on PostgreSQL administration, performance tuning, and database reliability within an AWS environment. The ideal candidate is comfortable working in an Agile development setting, collaborating closely with engineering teams, and managing database changes through code-based migrations and ORM frameworks.

Key Responsibilities

• Administer, maintain, and support PostgreSQL databases in a cloud-based SaaS environment
• Design, implement, and optimize database schemas, indexes, and queries to ensure high performance and scalability
• Monitor database performance and proactively identify and resolve bottlenecks
• Perform routine database maintenance, backups, recovery, and capacity planning
• Manage database changes using code-based migrations and collaborate with development teams on ORM-driven designs
• Ensure database security, availability, and compliance with best practices
• Support production and non-production environments, including troubleshooting and incident resolution
• Participate in Agile development processes, including sprint planning, stand-ups, and retrospectives
• Collaborate with DevOps and engineering teams to improve CI/CD pipelines related to database deployments

Required Qualifications

• 5+ years of hands‑on experience administering PostgreSQL databases
• Strong expertise in PostgreSQL performance tuning, query optimization, and index design
• Experience supporting cloud-based SaaS applications
• Practical experience with AWS technologies (e.g., RDS/Aurora PostgreSQL, EC2, S3, CloudWatch)
• Solid understanding of ORM concepts and database schema changes via code migrations
• Experience working in Agile or Scrum-based development environments
• Strong troubleshooting and problem‑solving skills