Role / Job Summary: Postgres DBA (Consultant Technical Lead)
Location: Bangalore/Chennai
Years of Experience: 9 – 15 years
Key Responsibilities
Providing round-the-clock database support, including handling incidents, requests, and changes.
Automating regular patch deployments, installations, and other routine tasks.
Designing and developing scalable database architectures to meet business requirements, along with recommending hardware and network solutions.
Optimizing data storage, retrieval, and indexing for improved performance efficiency.
Ensuring data integrity, security, and compliance with industry standards.
Collaboration with application developers, system administrators and other teams to enhance database operations and support.
Use of Performance Monitor, optimizing queries, and tracing long-running queries, blockages, and deadlocks.
Contribution towards automation of recurrent tasks.
Ticket reduction through problem management.
Hands-on experience of using tools/extensions
Account management tasks include creating, deleting, and modifying profiles,



as well as managing security and audit control parameters.
Knowledgeable in index defragmentation, re-indexing, updating index statistics and query tuning.
Proficient to manage DR and Resiliency strategies and underlying infrastructure architecture knowledge.
Proficient in troubleshooting & solving complex performance problems.
Proficient in managing Patching, Upgrades & Migrations.
Proficient in monitoring & performance analysis through open source tools
Working closely with application developers to optimize database interactions.
Strong background to conduct proof of concepts (POCs) for current features and enhancements to reduce costs.
Research and recommend new database technologies through POCs.
Proficient in documenting database structures, policies, and procedures.
Awareness to any of 2 public cloud platforms and responsible to integration designs from Tradi environments
Responsible for design implementati

📌 Postgres DBA (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru