Database Administrator (DBA)

Position: Database Administrator (DBA)

6+ Months Contract-to-Hire (C2H)

Work Location: 100% Remote

1. Job Overview

We are looking for an experienced Database Administrator (DBA) with strong hands-on expertise in PostgreSQL, Amazon RDS, and Amazon Aurora PostgreSQL.

The ideal candidate will be responsible for managing, maintaining, securing, and optimizing production and non-production database environments across cloud and on-premises infrastructure.

Candidates must have strong PostgreSQL administration and performance-tuning experience, particularly with AWS Aurora PostgreSQL.

2. Mandatory Technical Skills

Skill        Requirement

PostgreSQL          Mandatory – Strong hands-on DBA experience

Amazon Aurora PostgreSQL          Must Have – Critical Requirement

Amazon RDS       Hands-on administration experience

SQL        Strong SQL development and troubleshooting

PostgreSQL Performance Tuning Query optimization, indexing, VACUUM, ANALYZE

AWS DMS            Database migration experience

AWS Glue            Data integration and ETL experience

AWS Lake Formation       Data lake deployment and administration

Amazon Redshift               Architecture, RBAC, user/group management and permissions

3. Key Responsibilities

- Manage production, non-production, and redundant database environments.

- Install, configure, upgrade, patch, and maintain PostgreSQL databases.

- Administer Amazon RDS and Amazon Aurora PostgreSQL environments.

- Perform PostgreSQL performance tuning, query optimization, and indexing.

- Manage VACUUM and ANALYZE operations and database parameters.

- Monitor database performance, availability, resource utilization, and health.

- Develop and test database backup and recovery strategies.

- Maintain database security, access controls, and data integrity.

- Support database migration using AWS Database Migration Service (DMS).

- Work with AWS Glue for data integration and ETL activities.

- Support AWS Lake Formation and data lake administration.

- Collaborate with architecture, engineering, and security teams.

4. Required Qualifications

- Bachelor's degree in Computer Science, IT, or a related field, or equivalent experience.

- Minimum 5+ years of relevant database administration experience.

- Strong hands-on PostgreSQL DBA experience.

- Proven experience with Amazon Aurora PostgreSQL and Amazon RDS.

- Strong SQL development and database troubleshooting skills.

- Experience with AWS DMS, AWS Glue, and AWS Lake Formation.

- Understanding of Amazon Redshift architecture and security.

- Strong communication and problem-solving skills.

- PostgreSQL or Oracle certification preferred.

5. Ideal Candidate Profile

- 5+ years of experience as a Database Administrator.

- Strong PostgreSQL production DBA background.

- Real-world hands-on experience with Amazon Aurora PostgreSQL.

- Experience managing cloud-based database environments on AWS.

- Strong expertise in database performance optimization and troubleshooting.

- Experience handling database migrations, backup, recovery, and security.

6. Candidate Screening – Must Verify Before Submission

1. How many years of hands-on PostgreSQL DBA experience?

2. Have they worked extensively with Amazon Aurora PostgreSQL?

3. Have they administered Amazon RDS PostgreSQL?

4. Can they explain PostgreSQL performance tuning with real project examples?

5. Have they worked on AWS DMS migrations?

6. Do they have practical experience with AWS Glue and Lake Formation?

7. Have they worked with Amazon Redshift?

8. Can they explain their production database responsibilities and project architecture?

7. Submission Guidelines

The client specifically expects quality over quantity.

Every submission must include:

- Updated resume.

- LinkedIn profile URL.

- Brief candidate summary explaining technical alignment.

- Verified employment history and technical experience.

- Confirmation of hands-on PostgreSQL and Amazon Aurora PostgreSQL experience.

Top Priority

Amazon Aurora PostgreSQL + PostgreSQL DBA experience are the two most important screening criteria.

Recruiter Recommendation: Do not submit candidates who only have general SQL, MySQL, Oracle, or basic PostgreSQL experience without demonstrable Amazon Aurora PostgreSQL administration experience.