PostgreSQL DBA (Contract W2)

Siri InfoSolutions Inc; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

Siri InfoSolutions Inc. is seeking a PostgreSQL Database Administrator (Contract W2) in Irvine, CA to manage and optimize PostgreSQL databases in AWS.

You will drive migrations from on-prem SQL/Oracle, implement replication, backups, and high availability, and collaborate with engineering teams to meet performance and security requirements. Ideal candidates have hands-on PostgreSQL administration experience, AWS skills, and a track record of migrating databases to cloud environments, with a

Qualifications

• Experience migrating on-prem databases to AWS PostgreSQL.
• Code remediation from SQL/Oracle to PostgreSQL.
• Configure PostgreSQL across multiple versions.
• Design backup, recovery, and DR strategies.
• Implement and manage replication and high availability.

Responsibilities

• Lead migrations of on-prem databases to AWS PostgreSQL.
• Tune performance and ensure scalability.
• Implement disaster recovery with Multi-AZ.
• Monitor health with pgAdmin and CloudWatch.
• Collaborate with dev/infrastructure teams and document procedures.

Skills

PostgreSQL

AWS

Migration

Performance tuning

High availability

Backup & recovery

Replication

Security policy

Monitoring

SQL/Oracle migration

Tools

pgAdmin

AWS CloudWatch

DMS

S3

IAM

Replication tools

Job description

Role: PostgreSQL DBA (Contract W2)

Location: Irvine, CA

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.

• Lead and execute migration of on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL).
• Remediate code hands-on from SQL/Oracle to PostgreSQL including all schema components including stored procedures, triggers, functions. Experienced in finding and fixing naming conventions (Snake case vs Pascal case vs others). Code remediation not just to correct technically but able to engage with application teams to fix code functionally.
• 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