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