PostgreSQL DBA

Wise Skulls; Irvine (CA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Wise Skulls is seeking an experienced PostgreSQL Database Administrator (DBA) with strong AWS expertise to manage PostgreSQL databases and lead migration and optimization in the AWS cloud. The role emphasizes migration responsibilities, performance tuning, high availability, and security policy management.

The candidate will work in Irvine, CA (Hybrid) with collaboration across development and infrastructure teams and will document configurations and procedures to ensure reliable database

Qualifications

• Experience administering PostgreSQL databases in AWS.
• Migration and optimization of database infrastructure to AWS.
• Strong in performance tuning, high availability, and backup/recovery.
• Ability to design security policies, roles, and privileges.
• Familiarity with monitoring tools and disaster recovery planning.

Responsibilities

• Lead migration of on-premise databases to AWS (PostgreSQL).
• Remediate code from SQL/Oracle to PostgreSQL.
• Install, configure, and manage PostgreSQL across versions.
• Optimize performance and ensure HA and scalability.
• Design and implement backup/recovery strategies using native tools and AWS.
• Manage PostgreSQL replication and HA setups.
• Configure PostgreSQL on AWS and utilize AWS services (S3, IAM, CloudWatch, DMS).
• Document environments, configurations, and procedures.

Skills

PostgreSQL

AWS

Database administration

High availability

Performance tuning

Backup & recovery

Replication

Security policies

Monitoring

Migration

Tools

pgAdmin

AWS CloudWatch

DMS

Job description

We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) with strong expertise in AWS. The candidate will be responsible for the day-to-day management of PostgreSQL databases and will lead efforts to migrate and optimize our database infrastructure in the AWS cloud. This role requires deep knowledge of PostgreSQL database administration and AWS services, particularly related to database migration, performance tuning, and high availability.

Important

Visa: USC and GC only

Location: Irvine CA (Hybrid)

JD

Key Responsibilities

• Lead and execute migration of on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL).
• Remediate code from SQL/Oracle to PostgreSQL.
• Install, configure, and manage PostgreSQL databases across various versions.
• Optimize database performance and ensure high availability and scalability.
• Design and implement backup and recovery strategies using native database tools and AWS services.
• Manage PostgreSQL replication (streaming replication, logical replication) and high availability setups.
• Implement and maintain PostgreSQL security policies, roles, and privileges.
• Monitor database health and performance using tools like pgAdmin, AWS CloudWatch, and other monitoring solutions.
• Perform regular database maintenance tasks including vacuuming, indexing, and query optimization.
• Configure and manage PostgreSQL on AWS
• Utilize AWS services such as S3, IAM, CloudWatch, and DMS for database operations and migration.
• Design and implement disaster recovery strategies, including Multi-AZ deployments and failover configurations.
• Collaborate with development and infrastructure teams to support application requirements.
• Document database environments, configurations, and procedures.

Certifications (Preferred but not mandatory)

• PostgreSQL Certified Professional (or equivalent)
• AWS Certified Solutions Architect – Associate/Professional