PostgreSQL Database Administrator
Apply NowCompany: Tata Consultancy Services
Location: Cincinnati, OH 45238
Description:
Install, configure, and maintain PostgreSQL database instances (on-premises and cloud).
Monitor database performance, troubleshoot slow queries, and optimize indexes and queries.
Implement backup, restore, and disaster recovery strategies using tools.
Set up and manage replication (Streaming Replication, Logical Replication, BDR).
Manage database security, user roles, and permissions, ensuring compliance with standards.
Perform database migrations, upgrades, and patching while ensuring minimal downtime.
Automate database administration tasks with scripts (Bash, Python, SQL).
Monitor system resources, storage, and performance metrics to ensure availability and scalability.
Collaborate with development teams to improve database architecture and optimize queries.
Document database configurations, processes, and troubleshooting procedures.
Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.
Base Salary Range: $75,000 / Annum - $130,000 / Annum
#LI-SV2
Monitor database performance, troubleshoot slow queries, and optimize indexes and queries.
Implement backup, restore, and disaster recovery strategies using tools.
Set up and manage replication (Streaming Replication, Logical Replication, BDR).
Manage database security, user roles, and permissions, ensuring compliance with standards.
Perform database migrations, upgrades, and patching while ensuring minimal downtime.
Automate database administration tasks with scripts (Bash, Python, SQL).
Monitor system resources, storage, and performance metrics to ensure availability and scalability.
Collaborate with development teams to improve database architecture and optimize queries.
Document database configurations, processes, and troubleshooting procedures.
Physical Requirements - Ability to work in a standard office environment and May also need to provide support after regular hours, including on-call assistance.
Base Salary Range: $75,000 / Annum - $130,000 / Annum
#LI-SV2