Database Administrator

Tata Consultancy Services; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Tata Consultancy Services is looking for an experienced database administrator proficient in PostgreSQL architecture. You will be responsible for managing large databases, troubleshooting performance issues, and supporting cloud deployments on platforms such as AWS and GCP.

The ideal candidate should demonstrate strong knowledge of backup procedures, database upgrades, and high-availability configurations while effectively collaborating across various teams.

Qualifications

• Strong knowledge of PostgreSQL architecture and maintenance.
• Experience with backups, restores, and upgrades in Postgres.
• Hands-on experience with multi-terabyte databases.

Skills

Postgres Architecture

Database performance troubleshooting

AWS or GCP

Kubernetes or container technologies

Communication skills

Job description

• Strong knowledge of Postgres Architecture.
• Experience with different types of backup and restores in Postgres.
• Experience with database upgrade on minor and major versions.
• Hands-on experience on Database replication and point-in-time-recovery.
• Day to Day operations and troubleshooting performance issues like load average, locks, blocking and long running sqls.
• Commonly used PostgreSQL configuration parameters and common system tables usage.
• Exposure to PostgreSQL maintenance tasks.
• Exposure to PostgreSQL deployments in cloud like AWS(RDS or EC2) or GCP.
• High-availability like Repmgr or pgpool or efm
• Exceptional experience administering multi-terabyte databases
• Aptitude to independently learn new technologies
• Strong communication skills and ability to work effectively across multiple business and technical teams
• Background in building large database infrastructure supporting a high volume of transactions in a mission-critical environment
• Hands on experience on Kubernetes or any containerization technologies.