Engineer

Tata Consultancy Services Limited

Costa Mesa (CA)

On-site

USD 110,000 - 125,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support: Parental Leaves
Auto & Home Insurance
Certification & Training Reimbursement
Vacation & Holidays
401K Plan & Bonus

Job summary

Tata Consultancy Services Limited in Costa Mesa, California is seeking an experienced Amazon Aurora PostgreSQL DBA to design, administer and optimize PostgreSQL databases in AWS. You will manage multi-AZ deployments, perform backups, patching and performance tuning while ensuring availability and DR readiness.

The role requires 5+ years of hands-on PostgreSQL experience in AWS, plus scripting and IaC skills.

Qualifications

  • Minimum 5+ years of hands-on database administration experience.
  • Strong experience administering PostgreSQL databases in AWS environments.
  • Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.

Responsibilities

  • Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
  • Perform database installation, upgrades, patching and lifecycle management.
  • Monitor database health, capacity and performance metrics.
  • Analyze and optimize SQL queries and database workloads.
  • Implement indexing strategies and query tuning best practices.
  • Manage connection pooling and resolve infrastructure bottlenecks.
  • Troubleshoot and resolve database performance issues.
  • Design and implement Multi-AZ deployments and cross-region replication.
  • Develop, test, and maintain backup and disaster recovery processes.
  • Lead or support database migration initiatives to Aurora PostgreSQL.
  • Utilize AWS DMS and SCT for migration projects.
  • Perform migration assessments, validations and post-migration optimization.
  • Develop automation scripts for routine database administration activities.
  • Manage infrastructure using Terraform, Ansible or AWS CloudFormation.
  • Support CI/CD pipeline integration for database deployments and schema changes.
  • Implement security controls, database encryption and access management.
  • Apply database patches and vulnerability remediation activities.
  • Ensure compliance with security standards.
  • Perform periodic security reviews and audit support activities.

Skills

PostgreSQL
Aurora PostgreSQL
AWS RDS
DMS
SCT
CloudWatch
IAM
KMS
Python
Bash
PowerShell
Terraform
Ansible
CloudFormation
CI/CD
DevOps
Performance tuning

Education

Bachelor's degree

Tools

Terraform
Ansible
CloudFormation
DMS
SCT

Job description

Amazon Aurora PostgreSQL Database Administrator (DBA)
Must Have Technical/Functional Skills
Technical Skills
  • *Strong expertise in PostgreSQL architecture, replication, backup and recovery.
  • *Deep knowledge of AWS database services, including:
  • oAmazon Aurora PostgreSQL
  • oAmazon RDS
  • oAWS DMS
  • oAWS SCT
  • oCloudWatch
  • oIAM
  • oKMS
  • *Experience with database performance tuning and troubleshooting.
  • *Proficiency in scripting languages such as Python, Bash, or PowerShell.
  • *Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
  • *Familiarity with CI/CD tools and DevOps practices.
Experience
  • *Minimum 5+ years of hands‑on database administration experience.
  • *Strong experience administering PostgreSQL databases in AWS environments.
  • *Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.
Roles & Responsibilities
Database Administration
  • *Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
  • *Perform database installation, upgrades, patching and lifecycle management.
  • *Monitor database health, capacity and performance metrics.
Performance Optimization
  • *Analyze and optimize SQL queries and database workloads.
  • *Implement indexing strategies and query tuning best practices.
  • *Manage connection pooling and resolve infrastructure bottlenecks.
  • *Troubleshoot and resolve database performance issues.
High Availability & Disaster Recovery
  • *Design and implement Multi‑AZ deployments and cross‑region replication.
  • *Develop, test, and maintain backup and disaster recovery processes.
  • *Ensure database availability and business continuity objectives are met.
Cloud Migration & Modernization
  • *Lead or support database migration initiatives to Aurora PostgreSQL.
  • *Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.
  • *Perform migration assessments, validations and post‑migration optimization.
Automation & Infrastructure as Code (IaC)
  • *Develop automation scripts for routine database administration activities.
  • *Manage infrastructure using Terraform, Ansible or AWS CloudFormation.
  • *Support CI/CD pipeline integration for database deployments and schema changes.
Security & Compliance
  • *Implement security controls, database encryption and access management.
  • *Apply database patches and vulnerability remediation activities.
  • *Ensure compliance with organizational and regulatory security standards.
  • *Perform periodic security reviews and audit support activities.
Education

Bachelor's degree

TCS Employee Benefits Summary
  • *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: $110000 - $125000 a year

#LI-JH1

Location

Costa Mesa, CA

Function

TECHNOLOGY

Role

Engineer

ID

439152

Skills

Postgresql DBA

Salary Range

$110,000 - $125,000

Desired Candidate Profile
Qualifications

BACHELOR OF COMPUTER SCIENCE

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PostgreSQL Database Administrator
PostgreSQL Database Administrator

Dataquest • Harrisburg

On-site
USD 100,000 - 130,000
Medical insurance
Vision insurance
401(k)
+1
Database Admin
Database Admin

Tata Consultancy Services Limited • Phoenix (AZ)

On-site
USD 90,000 - 120,000
Discretionary Incentive
Medical Coverage
Parental Leaves
+5
100% Remote-Amazon Aurora PostgreSQL Database Administrator (DBA)
100% Remote-Amazon Aurora PostgreSQL Database Administrator (DBA)

Ventures Unlimited Inc • Costa Mesa (CA)

On-site
USD 120,000 - 160,000
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Drillo.AI • St. Louis (MO)

On-site
USD 90,000 - 115,000
Aurora PostgreSQL Database Administrator (DBA)
Aurora PostgreSQL Database Administrator (DBA)

Talent Software Services, Inc. • Seven Hills (OH)

On-site
USD 120,000 - 170,000
Senior Postgres/db2 Dba
Senior Postgres/db2 Dba

Tata Consultancy Services Limited • San Antonio (TX)

On-site
USD 95,000 - 110,000
Senior Database Reliability Engineer (Dbre)
Senior Database Reliability Engineer (Dbre)

Tata Consultancy Services Limited • San Jose (CA)

On-site
USD 100,000 - 130,000
Medical Coverage
Dental & Vision
401K Plan
+4
PostgreSQL DBA
PostgreSQL DBA

Softcom Systems Inc • Irvine (CA)

On-site
USD 80,000 - 120,000
Senior PostgreSQL Database Engineer, RDS
Senior PostgreSQL Database Engineer, RDS

Amazon • Seattle (WA)

On-site
USD 131,400 - 227,000
Mentorship opportunities
Flexible work-life balance
Competitive health benefits
+2
PostgreSQL DBA - Onsite
PostgreSQL DBA - Onsite

The Dignify Solutions, LLC • Jersey City (NJ)

On-site
USD 90,000 - 120,000