Postgresql database administrator

2 weeks ago

chennai, India CBTS Full time

Job Title: Experienced PostgreSQL Database Administrator (DBA)

‌

Location: 100% On-site – Chennai Office

Responsibilities:

  • Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.
  • Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting.
  • Deploy and maintain database infrastructure on both on-premises servers and AWS cloud platforms, utilizing best practices for scalability, reliability, and cost-efficiency.
  • Collaborate with cross-functional teams to design, implement, and optimize database architectures to meet business requirements and performance goals.
  • Implement and maintain disaster recovery solutions, including backup strategies, replication, and failover procedures, for both on-premises and AWS deployments.
  • Automate routine DBA tasks and workflows using scripting languages.
  • Ensure compliance with security policies, regulatory requirements, and industry best practices for database operations and data protection.
  • Monitor and response to DB alerts from monitoring tools and command center team.
  • Monitor database performance and capacity utilization, proactively identifying and resolving issues to maintain optimal performance and scalability.
  • Provide trend analysis to executive management to help them taking informed decisions regarding resource management.
  • Lead, monitor and provide guidance to junior DBA.
  • Collaborate with cross-functional teams to ensure smooth integration of databases with other systems and applications.
  • Perform database capacity planning and trend analysis.
  • Apply changes to the database following strict procedures of Change management policies and protocol.

Must Have:

  • Experience with PostgreSQL database, Enterprise Failover Manager (EFM), Postgres Enterprise Manager (PEM) and PGBACKREST on Linux servers.
  • Proficiency in end-to-end architecture of PostgreSQL database, including database design, development, administrate of large-scale database, OLTP and analytical data structures (logical and physical design)
  • Experience managing PostgreSQL databases in AWS RDS and/or EC2 environments.
  • Proficiency in PostgreSQL troubleshooting, performance tuning, SQL Tuning, access management and security setup, health monitoring and maintenance, PL/PGSQL (triggers, functions, ….)
  • Experience in designing, implementing, and monitoring disaster recovery (DR) solutions for PostgreSQL databases including Backup and restore, Point-in-Time-Recovery (PITR), on-site/offsite replication.
  • Experience managing Amazon RDS implementation of PostgreSQL.
  • Experience in database and data migration from on-premises to cloud.
  • Experience in creating Linux shell scripts.

‌

Nice To Have:

  • Experience with Connection Management using options such as LDAP, Kerberos in PostgreSQL.
  • Familiarity with managing version control and deployment processes, specifically within Amazon RDS and on-premises server environments.
  • Experience with database automation and orchestration tools such as Jenkins and Ansible.
  • Solid understanding of database security best practices and compliance standards.
  • Provision, manage, deploy, monitor and benchmarking statistics in OpenShift environment.
  • Experience with latest PG community contribution modules/projects.
  • Experience with other database technologies (e.g., MySQL, Oracle, MongoDB).
  • Familiarity with containerization technologies such as Docker and Kubernetes.
  • Knowledge of DevOps practices and principles.

‌

Preferred Qualification:

  • Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
  • Proven experience as a PostgreSQL Database Administrator, with at least 5-7 years of hands-on experience.
  • Ability to work effectively in a fast-paced environment and manage multiple priorities.
  • Excellent communication and collaboration skills, with a strong customer service orientation.
  • PostgreSQL certification (e.g., Certified PostgreSQL Associate/Professional) is a plus.

If you're a skilled PostgreSQL DBA looking for an exciting opportunity to work with cutting-edge technologies and contribute to the success of a dynamic team, we'd love to hear from you. Apply now and join us on our journey to innovate and transform the world of technology.

  • Postgresql database administrator

    2 weeks ago

    Chennai, India CBTS Full time

    Job Title: Experienced PostgreSQL Database Administrator (DBA)‌Location: 100% On-site – Chennai OfficeResponsibilities:Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.Perform regular database administration tasks such as installation, configuration, monitoring,...

  • Postgresql database administrator

    4 days ago

    Chennai, India CBTS Full time

    Job Title: Experienced PostgreSQL Database Administrator (DBA)‌Location: 100% On-site – Chennai OfficeResponsibilities:Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.Perform regular database administration tasks such as installation, configuration, monitoring,...

  • Database Administrator

    5 days ago

    Chennai, Tamil Nadu, India Ensono Full time

    **About Us**: **Role and responsibility**: - **Lead the end-to-end migration process from Oracle to PostgreSQL.**: - **Collaborate with stakeholders to define migration requirements and design efficient database structures.**: - **Execute data migration tasks with precision and mínimal downtime.**: - **Manage day-to-day operations of both Oracle and...

  • Database Administrator

    4 days ago

    Chennai, India Risk Resources LLP Full time

    Job Description :1. Should know the PostgreSQL database and working experience as well.2. Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.3. In Performance tuning - Constraints creations, Indexes creation & analysis, VACUUM, AUTOVCUUM parameter setup & enabling,...

  • Aws PostgreSQL Database Administrator

    6 days ago

    Tharamani, Chennai, Tamil Nadu, India mds hr consultancy Full time

    Designation - AWS PostgreSQL Database Administrator (DBA) No of Positions opening for : 1 Experience must be between 3-4 Years CTC upto - 13,00,000 **Position Overview**: As an AWS PostgreSQL Database Administrator (DBA), you will play a critical role in managing and maintaining the performance, integrity, and security of PostgreSQL databases hosted on...

  • Database Administrator

    2 days ago

    Hyderabad/Bangalore/Pune/Chennai/Bhubaneshwar, IN Risk Resources LLP Full time

    Job Description :1. Should know the PostgreSQL database and working experience as well.2. Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.3. In Performance tuning - Constraints creations, Indexes creation & analysis, VACUUM, AUTOVCUUM parameter setup & enabling,...

  • Database Administrator

    2 days ago

    Hyderabad/Bangalore/Pune/Chennai/Bhubaneshwar, India Risk Resources LLP Full time

    Job Description : 1. Should know the PostgreSQL database and working experience as well.2. Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.3. In Performance tuning - Constraints creations, Indexes creation & analysis, VACUUM, AUTOVCUUM parameter setup & enabling,...

  • Database Administrator

    4 days ago

    Chennai, India CBTS Full time

    Job DescriptionJob Purpose:Responsibilities:Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security.Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting.Deploy and...

  • Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India CBTS India Full time

    Job Purpose:Responsibilities: Manage and maintain PostgreSQL databases across onpremises and AWS environments, ensuring high availability, performance, and security. Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting. Deploy and maintain database...

  • Database Administrator

    2 weeks ago

    Chennai, India Wipro Full time

    Experience: Database Administrators with scripting/automation knowledge having 5+ Years of Relevant Experience in below Streaming, Replication, Backup and Restore, Monitoring Tools for PostgreSQL, Minor and Major Version upgradation. Scripting Languages: Unix Shell (Mandatory); Ansible, PowerShell & Python, Perl, Java is a plus Database: Strong database...

  • Database Administrator

    2 weeks ago

    Chennai, India Wipro Full time

    Experience: Database Administrators with scripting/automation knowledge having 5+ Years of Relevant Experience in belowStreaming, Replication, Backup and Restore, Monitoring Tools for PostgreSQL, Minor and Major Version upgradation.Scripting Languages: Unix Shell (Mandatory); Ansible, PowerShell & Python, Perl, Java is a plusDatabase: Strong database...

  • PostgreSQL

    3 weeks ago

    Chennai, India VARITE INDIA PRIVATE LIMITED Full time

    Description: - Location Chennai/Pune/Hyderabad. Total Experience 8 + Years Must gave have relevant experience and in-depth knowledge in any PostgreSQL administration task A database administrator's responsibilities can include the following tasks: - Perform installations and upgrades of PostgreSQL (Preferably PPAS 9.4+) - Plan and perform DB Patching. -...

  • Database Administrator

    2 weeks ago

    Chennai, India CBTS Full time

    Job Description Job Purpose: Responsibilities: Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security. Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting. ...

  • Database Administrator

    5 days ago

    chennai, India CBTS Full time

    Job Description Job Purpose: Responsibilities: Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security. Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and...

  • Database Administrator

    2 weeks ago

    Chennai, India HEPL - A Cavinkare Group Company Full time

    Our client is a leadingniche Software Services provider , dedicated to delivering best-in-class services to enterprises. Founded with the mission to blend unique domain expertise with cutting-edge technical skills, they stand out as a reliable partner for businesses seeking exceptional software solutions. Based in India, they leverage the timezone advantage...

  • Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India CBTS India Full time

    **Job Purpose**: **Responsibilities**: - Manage and maintain PostgreSQL databases across on-premises and AWS environments, ensuring high availability, performance, and security. - Perform regular database administration tasks such as installation, configuration, monitoring, tuning, patching, upgrading, backup, recovery, and troubleshooting. - Deploy and...

  • Database Administrator

    2 weeks ago

    Chennai, India HEPL - A Cavinkare Group Company Full time

    Our client is a leading niche Software Services provider, dedicated to delivering best-in-class services to enterprises. Founded with the mission to blend unique domain expertise with cutting-edge technical skills, they stand out as a reliable partner for businesses seeking exceptional software solutions. Based in India, they leverage the timezone advantage...

  • Database Administrator

    2 weeks ago

    chennai, India HEPL - A Cavinkare Group Company Full time

    Our client is a leading niche Software Services provider , dedicated to delivering best-in-class services to enterprises. Founded with the mission to blend unique domain expertise with cutting-edge technical skills, they stand out as a reliable partner for businesses seeking exceptional software solutions. Based in India, they leverage the timezone advantage...

  • Database Administrator

    2 weeks ago

    Chennai, India HEPL - A Cavinkare Group Company Full time

    Our client is a leading niche Software Services provider, dedicated to delivering best-in-class services to enterprises. Founded with the mission to blend unique domain expertise with cutting-edge technical skills, they stand out as a reliable partner for businesses seeking exceptional software solutions. Based in India, they leverage the timezone advantage...

  • PostgreSQL Db Administration

    2 weeks ago

    Chennai, Tamil Nadu, India Cognizant Full time

    PostgreSQL DB AdministrationMandatory Skills: Integral part of the DBS team at Chewy, responsible for handling both large engineering projects (keto), and smaller day to day requests. Trained in Chewy's architecture and processes required to navigate approval process for major production changes- production support during off hours (on-call support) Work as...