PostgreSQL DBA - Irvine, CA - 66775

Overview

On Site
$55
Contract - W2
Contract - 6 month(s)

Skills

CloudWatch
Postgre DBA

Job Details

PostgreSQL DBA - 66775

We have an immediate long-term opportunity with one of our prime clients for a position of PostgreSQL DBA to work in Irvine, CA on Hybrid basis.

Rate : $50- $55/hr

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.

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
  • Extensive experience in terraform
  • 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

For immediate consideration, please contact:

Narasimha
PRIMUS Global Services
Phone: ext. 267
Email:

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About PRIMUS Global Services Inc.