Postgres SQL DB Admin with AWS

Tata Consultancy Services Limited
Chandler, United States of America
14 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 110K

Job location

Chandler, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Cloud Computing
PostgreSQL
Liquibase
Performance Tuning
PostGIS
SQL Databases
System Availability
Terraform

Job description

  • Database Operations (PostgreSQL)
  • Administer and optimize PostgreSQL across Amazon RDS/Aurora PostgreSQL and EC2/self-managed (where applicable).
  • Perform performance tuning: query plans, indexes, vacuum/analyze, autovacuum tuning, connection management (PgBouncer), partitioning, statistics, and parameter tuning.
  • Own backup/restore, PITR, logical/physical replication (streaming, logical decoding) and cross-region DR strategies.
  • Implement and maintain HA (Multi-AZ, Aurora clusters, Patroni or equivalent), DR runbooks, and failover testing.
  • Lifecycle management: upgrades, patching, extensions (e.g., PostGIS, pg_partman, pg_stat_statements), and schema change orchestration (e.g., with Liquibase/Flyway).
  • Capacity planning: storage, IOPS, throughput; prevent bloat and hot spots. Experience on open-shift containers

Requirements

  • Primary Skill: Postgres SQL DB Admin, AWS
  • Secondary: Terraform, Open Shift Containers
  • Experience: Minimum 7 Years

Roles & Responsibilities

  • We're seeking a hands-on engineer to own PostgreSQL database operations on AWS-covering provisioning, performance tuning, high availability, automation, monitoring, and cost optimization.
  • The ideal candidate blends deep Postgres administration with AWS platform expertise, uses Infrastructure as Code, and thrives in a production support environment with strong incident management and continuous improvement mindset.
  • 5+ years of AWS experience
  • 5+ years Cloud/AWS/Terraform and POstgreSQL expertise

Benefits & conditions

Discretionary Annual Incentive. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. Family Support: Maternal & Parental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. Salary Range: $100,000 - $110,000 a year

About the company

Review for Tata Consultancy Services Review for Tata Consultancy Services, Chandler, AZ Review for Postgres SQL DB Admin With AWS at Tata Consultancy Services Review for Postgres SQL DB Admin With AWS at Tata Consultancy Services, Chandler, AZ

Apply for this position