18 Nov
|
Tata Consultancy Services
|
Chennai
18 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 likepgdump,pgrestore, 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 settings
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