← Back to jobs

Avance Consulting Logo
PostgreSQL DBA

Avance Consulting

 

Las Vegas,United States

Posted On: 1 day ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: PostgresSQL DBA
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

Own AWS database administration, including PostgreSQL and RDS management, performance tuning, and high-availability configuration for banking systems.

This role is on-site.

Responsibilities

  • Manage, install, configure, patch, migrate, and upgrade PostgreSQL and AWS RDS instances.
  • Implement database coding practices, partitioning, and indexing to ensure architectural stability.
  • Configure high availability and resiliency using Aurora Read Replicas and Global Database.
  • Execute capacity planning and performance assessments for AWS RDS environments.
  • Monitor database health using Performance Insights and manage RDS KPIs.

Required Skills

  • 10-12 years of experience managing PostgreSQL databases.
  • 5 years of experience with AWS RDS, including security policies, user authentication, and IAM.
  • Hands-on experience with AWS services including S3, EC2, and Lambda.
  • Expertise with PostgreSQL administration tools such as PgBouncer and PgPool.
  • Strong knowledge of database design, query optimization, index management, and isolation levels.
  • Proficiency with Linux OS and SSH connectivity using public/private keys.
  • Experience with automation and infrastructure tools: Ansible, Terraform, and GitHub.
  • Practical experience with CI/CD workflows using GitLab.
  • Technical proficiency in Python for database-related tasks.

Preferred Skills

  • Working knowledge of EDB, Oracle, and SQL Server.
  • Experience managing complex migrations and technical estimations.

Key Skills
Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs