PostgreSQL Database Administrator (DBA) AWS Aurora(Only W2 Resources)

Overview

Remote
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Database Administration
Data Structure
Specification Gathering
Stored Procedures
Authorization
Regulatory Compliance
Data Security
SQL Tuning
Scalability
Optimization
Disaster Recovery
Confluence
Database
Performance Tuning
Amazon Web Services
High Availability
DevOps
Continuous Integration
Continuous Delivery
PostgreSQL
Meta-data Management
IMG
SANS

Job Details

Hello Everyone,

Hope you are doing good

This is Raja from Tek Leaders. We have an urgent requirement below that is open with our client.

Position: PostgreSQL Database Administrator (DBA) - AWS Aurora(Only W2 Resources)

Location: Northern California (Remote).

Duration: 6+ Months.

Key Responsibilities

  • Create data structures such as tables, views, and schemas based on technical specifications.
  • Develop and maintain stored procedures, triggers, and functions to support application logic.
  • Implement authorization-level security using PostgreSQL roles and privileges.
  • Maintain compliance with organizational and regulatory data protection standards.
  • Implement physical performance optimizations through indexes, partitions, and materialized views.
  • Conduct logical performance tuning through SQL optimization and query analysis.
  • Configure and tune AWS Aurora performance and scalability features to ensure efficient database operation.
  • Identify and implement PostgreSQL and AWS cost optimization opportunities.
  • Design and implement high availability (HA) and disaster recovery (DR) architectures leveraging AWS Aurora features.
  • Conduct cross-environment data cloning and synchronization.
  • Work with DevOps teams to implement PostgreSQL CI/CD pipelines for automated deployment and versioning.
  • Develop code generators to automate recurring administration tasks using PostgreSQL metadata tables.
  • Define and enforce PostgreSQL best practices including deployment processes, performance baselines, and security standards.
  • Document architectures, procedures, and data models using Confluence and Lucidchart.

Mandatory Qualifications

  • 5+ years of experience administering PostgreSQL databases.
  • 2+ years of hands-on experience administering AWS Aurora PostgreSQL.
  • 4+ years performing physical and logical performance tuning for PostgreSQL.
  • Proven experience implementing AWS Aurora high availability features.
  • Demonstrated ability to work with DevOps teams to design and deploy PostgreSQL CI/CD pipelines.
  • Hands-on experience developing PostgreSQL code generators using metadata tables.

Raja

Email ID:

Aakash Raja :

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.