{"schemaVersion":"jobsearcher.job.v1","id":"79a19ffae2a2b2ad4d551158","url":"https://jobsearcher.com/jobs/79a19ffae2a2b2ad4d551158","canonicalUrl":"https://jobsearcher.com/jobs/79a19ffae2a2b2ad4d551158","title":"PostgreSQL DBA","description":"Job Description PostgreSQL DBA – Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.\r\nKey Responsibilities Database Administration: Install, configure, and maintain PostgreSQL databases in production and non-production environments.\r\nPerform database refresh activities between environments as required.\r\nExecute patching and upgrade activities to ensure databases remain secure, stable, and up to date.\r\nArchitecture & Performance: Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.\r\nHandle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices.\r\nHigh Availability & Clustering: Implement and manage repmgr cluster technology for high availability and failover.\r\nTroubleshoot and resolve cluster node failure issues promptly to minimize downtime.\r\nMigration & Cloud Integration: Design and execute migration strategies from on-prem to cloud environments.\r\nKnowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.\r\nBackup & Recovery: Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.\r\nImplement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.\r\nReplication: Configure and manage logical replication for data synchronization across environments.\r\nRequired Skills & Qualifications Proven experience as a Postgres Database Administrator in enterprise environments.\r\nStrong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.\r\nHands-on experience with repmgr clustering, failover handling, and node recovery.\r\nExpertise in performance tuning, query optimization, and troubleshooting.\r\nExperience with migration strategies from on-premises to cloud platforms.\r\nFamiliarity with Oracle DBA, RMAN, Goldengate, Exadata.\r\nProficiency in backup, recovery, and disaster recovery planning.\r\nWorking knowledge of logical replication and streaming replication.\r\nExcellent problem-solving and communication skills.\r\nPreferred Qualifications Experience with automation tools (Ansible, Terraform) for database deployments.\r\nKnowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.\r\nScripting skills in Shell, Python, or similar for automation.\r\nSalary Range: $95,000-$100,000 a year\r\nJ-18808-Ljbffr","company":"Tata Consultancy Services","rawCompany":"tata consultancy services","city":"Laurel","state":"MT","isRemote":false,"isActive":false,"createdAt":"2026-06-26T02:19:22.850Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1244.00","title":"Network and Computer Systems Administrators","slug":"network-and-computer-systems-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PostgreSQL DBA","description":"Job Description PostgreSQL DBA – Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.\r\nKey Responsibilities Database Administration: Install, configure, and maintain PostgreSQL databases in production and non-production environments.\r\nPerform database refresh activities between environments as required.\r\nExecute patching and upgrade activities to ensure databases remain secure, stable, and up to date.\r\nArchitecture & Performance: Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.\r\nHandle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices.\r\nHigh Availability & Clustering: Implement and manage repmgr cluster technology for high availability and failover.\r\nTroubleshoot and resolve cluster node failure issues promptly to minimize downtime.\r\nMigration & Cloud Integration: Design and execute migration strategies from on-prem to cloud environments.\r\nKnowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.\r\nBackup & Recovery: Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.\r\nImplement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.\r\nReplication: Configure and manage logical replication for data synchronization across environments.\r\nRequired Skills & Qualifications Proven experience as a Postgres Database Administrator in enterprise environments.\r\nStrong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.\r\nHands-on experience with repmgr clustering, failover handling, and node recovery.\r\nExpertise in performance tuning, query optimization, and troubleshooting.\r\nExperience with migration strategies from on-premises to cloud platforms.\r\nFamiliarity with Oracle DBA, RMAN, Goldengate, Exadata.\r\nProficiency in backup, recovery, and disaster recovery planning.\r\nWorking knowledge of logical replication and streaming replication.\r\nExcellent problem-solving and communication skills.\r\nPreferred Qualifications Experience with automation tools (Ansible, Terraform) for database deployments.\r\nKnowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.\r\nScripting skills in Shell, Python, or similar for automation.\r\nSalary Range: $95,000-$100,000 a year\r\nJ-18808-Ljbffr","datePosted":"2026-06-26T02:19:22.850Z","dateModified":"2026-06-26T02:19:22.850Z","hiringOrganization":{"@type":"Organization","name":"Tata Consultancy Services","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Laurel","addressRegion":"MT","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"79a19ffae2a2b2ad4d551158"},"url":"https://jobsearcher.com/jobs/79a19ffae2a2b2ad4d551158"}}