17 Nov
|
Tata Consultancy Services
|
Chennai
17 Nov
Tata Consultancy Services
Chennai
Open Position- PostgreSQL DBA
Exp- 10+ years
Location- Chennai
Job Requirements*
- Deep knowledge of PostgreSQL architecture, internals, configuration parameters, and common system tables
- Expertise in identifying and troubleshooting performance issues, including query optimization, indexing strategies, analyzing execution plans, and managingautovacuumsettings and concurrency
- Hands-on experience with high-availability solutions (e.g., streaming replication,repmgr,pgpool,efm), backup strategies, and Point-In-Time Recovery (PITR) with tools likepg_dump,pg_restore, andpgBackRest
- Proficiency in day-to-day operations, including installation, configuration, minor and major version upgrades, patching, and routine maintenance tasks likeVACUUMandANALYZE
- Experience deploying and managing PostgreSQL databases in cloud environments such as GCP
- Solid scripting skills (e.g., Unix shell, Python,
PL/pgSQL) for automating maintenance, deployment, and monitoring tasks, with a preference for infrastructure-as-code tools like Ansible or Terraform
Key Responsibilities*
- Administering multi-terabyte, mission-critical databases in high-volume, 24x7 environments
- Leading complex database migration projects, often from other systems like Oracle to PostgreSQL
- Collaborating with development teams on schema design, query optimization, and implementing database security best practices
- Planning for capacity, forecasting future needs, and implementing scaling measures
- Participating in on-call support rotations and leading incident management and troubleshooting efforts
📌 Postgresql Database Administrator (Chennai)
🏢 Tata Consultancy Services
📍 Chennai