Job Description
Must Have Technical/Functional Skills
- 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
Key Responsibilities
- 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
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: $100,000 - $110,000 a year
Qualifications:
BACHELOR OF COMPUTER SCIENCE
