PostgreSQL Database Administrator

Job title -PostgreSQL Database Administrator

Work location - - Irvine, CA or San Antonio, TX - Onsite

Contract duration - 12 Months

Interview mode - In person/Virtual - Virtual

Minimum years of experience needed in the required skills- 10 yrs of experience

Minimum over all work experience required -10 yrs of experience

Any certification required - Good to have. PostgreSQL Certified Professional (or equivalent), AWS Certified Solutions Architect - Associate/Professional

Mandatory skills required -PostgreSQL Database, on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL). AWS services, Terraform

Complete job description - PostgreSQL DBA 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 Eligible to workimize 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).
• Administration of Postgres DB on AWS.
• Remediate code from SQL/Oracle to PostgreSQL.
• Install, configure, and manage PostgreSQL databases across various versions.
• Eligible to workimize 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 Eligible to workimization.
• 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

Disclaimer: Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may unsubscribe at any time.

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.