PostgreSQL Database Administrator

7 days ago

New Delhi, India Tata Consultancy Services Full time

PostgreSQL Database AdministratorExperience- 8 to 16 yearsLocation- KolkataResponsibilities- Database Architecture & Design: Design and maintain complex PostgreSQL database schemas. - Performance Tuning & Optimization: Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views. - Backup and Recovery: Implement and manage high-availability backup strategies. Test and document disaster recovery procedures. - Replication and High Availability: Set up and maintain replication (physical/logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II. - Security Management: Implement role-based access controls, SSL/TLS, and audit logging. Monitor for vulnerabilities and apply patches. - Monitoring & Maintenance: Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE). - Upgrades & Migrations: Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP).Required Skills- Extensive hands-on experience with PostgreSQL (v11 and above). - Database installation, configuration, and upgrades on Linux/Unix platforms. - High Availability (HA) setup using streaming replication, Patroni, repmgr, etc. - Backup and recovery strategies using tools like pgBackRest, Barman. - Performance tuning and query optimization. - Strong knowledge of PL/pgSQL scripting and automation. - Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana). - Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit). - Disaster Recovery planning and execution. - Capacity planning and data growth forecasting. - Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL). - Good communication skills with both technical and management teams.Preferred Skills- Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB). - Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy). - Knowledge of Infrastructure as Code (Terraform, Ansible). - Experience with CI/CD pipelines for database changes. - Experience with Databases (Oracle, DB2 & SQL server). - Exposure to PostgreSQL clustering and sharding. - Understanding of logical replication and change data capture (CDC). - Knowledge of network monitoring and tools. - Excellent stakeholder management and cross-functional collaboration. - Certifications (Optional but Preferred): AWS Certified Database – Specialty.

  • PostgreSQL Database Administrator

    1 week ago

    Delhi, Delhi, India Acesoft Labs Full time

    We have an immediate opportunity with one of our esteemed client Position - PostgreSQL DBA Exp - 5+ years Loc - Pan India NP - Immediate **Job Description**: **Must Have**: PostgreSQL BDR Sync replication Setup (must have) Backup and administration PostgreSQL Development (must have) Performance tuning (must have) **Nice to have**: User creation (nice...

  • PostgreSQL Database Administrator

    1 week ago

    New Delhi, India Jio Full time

    The Senior Postgre SQL DBA would need to have at least 4 years of experience with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing. PostgreSQL database cloning by using Pg_dump...

  • PostgreSQL Database Architect

    4 days ago

    New Delhi, India Adosis Full time

    experience supporting PostgreSQL and MySQL databases. This role will be primarily focused on production database administration for **PostgreSQL** & MySQL databases. **Responsibilities**: - Install, monitor, and maintain PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL...

  • Senior Database Administrator

    2 weeks ago

    New Delhi, India CirrusLabs Full time

    Experience - 8-10 yearsLocation - BengaluruJob SummaryAs a senior database administrator, you will be responsible for the administration, optimization, and reliability of Liongard's core platform database. You will work closely with development and DevOps teams to ensure database instances are performant, scalable, highly available, and cost-efficient.The...

  • AWS PostgreSQL Database Administrator

    2 weeks ago

    Delhi, India Springbord Full time

    !Springbord is hiring an experienced AWS PostgreSQL Database Administrator (DBA) with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud environment.Job Title...

  • AWS PostgreSQL Database Administrator

    2 weeks ago

    Delhi, India Springbord Full time

    !Springbordis hiring an experiencedAWS PostgreSQL Database Administrator (DBA)with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud environment.Job Title–...

  • PostgreSQL Database Administrator

    1 week ago

    Delhi, Delhi, India Jio Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    The Senior Postgre SQL DBA would need to have at least 4 years of experience with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.PostgreSQL database cloning by using Pg_dump and...

  • Database Administrator

    2 weeks ago

    New Delhi, India Secure Meters Limited Full time

    Role- Team Member - IT ServicesQualification– B.Tech(Computer Science) & MCA Location– Udaipur, Rajasthan Work experience– 2-3 Years Key Skills - Must have –PostgreSQL Database Administrator Good to have – Knowledge of Oracle and Linux-based Operating systems Key responsibilities- PostgreSQL Installation. PostgreSQL Database backups using...

  • AWS PostgreSQL Database Administrator

    2 weeks ago

    Delhi, India Springbord Full time

    ! Springbord is hiring an experienced AWS PostgreSQL Database Administrator (DBA) with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud environment. Job...

  • PostgreSQL Database Administrator

    1 week ago

    delhi, India Jio Full time

    The Senior Postgre SQL DBA would need to have at least 3 years of experience with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing.PostgreSQL database cloning by using Pg_dump and...