Talent.com
Postgres Database Administrator

Postgres Database Administrator

ConfidentialMumbai, India
16 hours ago
Job description

We are seeking a skilled PostgreSQL Database Administrator (DBA) with 3–6 years of experience to manage, maintain, and optimize our database systems. The ideal candidate will have hands-on expertise in PostgreSQL administration, database performance tuning, and backup strategies, along with working knowledge of AWS database services (such as RDS, EC2, S3, and CloudWatch). You will be responsible for ensuring database availability, security, and performance in both on-premise and cloud environments.

Key Responsibilities

Database Administration

  • Install, configure, and upgrade PostgreSQL database servers and related tools.
  • Manage database schemas, tables, indexes, constraints, and relationships.
  • Perform routine database maintenance, including vacuuming, reindexing, and statistics updates.
  • Manage database replication (streaming or logical), clustering, and failover setups.
  • Implement and manage database backup and recovery procedures using tools like pg_dump, pg_basebackup, and WAL archiving.
  • Monitor database health, query performance, and storage utilization.
  • Troubleshoot database errors, crashes, and performance bottlenecks.

Performance Tuning and Optimization

  • Analyze slow queries and optimize SQL statements and indexes.
  • Perform regular health checks, query plan analysis, and database tuning.
  • Configure PostgreSQL parameters (e.g., shared buffers, work_mem, autovacuum) for optimal performance.
  • Security and Compliance

  • Implement and maintain user access control and role-based permissions.
  • Ensure database security through encryption, SSL, and audit trails.
  • Perform regular database patching and version upgrades to maintain compliance.
  • AWS Cloud Database Operations
  • Deploy and manage PostgreSQL databases on AWS services such as Amazon RDS, Aurora PostgreSQL, or EC2.
  • Configure automated backups, snapshots, and monitoring via CloudWatch.
  • Manage parameter groups, security groups, and IAM roles for database access.
  • Support DR (Disaster Recovery) planning and cross-region replication.
  • Maintenance and Automation

  • Automate repetitive DBA tasks using scripts (Python, Bash, or SQL).
  • Schedule and monitor maintenance tasks such as backups, reindexing, and vacuuming.
  • Support CI / CD pipelines for database schema deployment.
  • Collaborate with development teams for schema design and data model optimization.
  • Monitoring and Reporting

  • Set up and maintain monitoring tools (e.g., pgAdmin, Prometheus + Grafana, AWS CloudWatch, or Datadog).
  • Generate performance reports and provide insights to improve database efficiency.
  • Required Skills And Qualifications

  • Bachelor's degree in computer science, Information Technology, or related field.
  • 3–4 years of experience as a PostgreSQL DBA in production environments.
  • Strong understanding of PostgreSQL internals, performance tuning, and SQL optimization.
  • Experience with AWS cloud services related to database hosting and management.
  • Proficiency with Linux / Unix environments and shell scripting.
  • Hands-on experience with backup and recovery strategies, replication, and clustering.
  • Familiarity with monitoring tools (e.g., CloudWatch, pg_stat_statements, or similar).
  • Strong troubleshooting and analytical skills.
  • Preferred Qualifications

  • Certification in AWS (e.g., AWS Certified Database – Specialty or AWS Solutions Architect Associate).
  • Experience with automation tools (Terraform, Ansible) for database provisioning.
  • Exposure to other database platforms (MySQL, MongoDB) is a plus.
  • Understanding of DevOps pipelines and CI / CD integration with databases.
  • Soft Skills

  • Excellent communication and documentation skills.
  • Strong problem-solving and analytical mindset.
  • Ability to work independently and collaborate in a cross-functional team environment.
  • Commitment to continuous learning and staying updated with PostgreSQL and AWS trends.
  • Skills Required

    Unix, Postgresql, Prometheus, Bash, AWS CloudWatch, Grafana, Datadog, Sql, Linux, Terraform, Ansible, pgadmin , Python

    Create a job alert for this search

    Database Administrator • Mumbai, India

    Related jobs
    • Promoted
    snowflake Cloud Database Administrator

    snowflake Cloud Database Administrator

    Leading automobile GCCmumbai, maharashtra, in
    Cloud Platform Expertise : Familiarity with leading cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, and Snowflake is essential. Understanding their database offerings, such as AWS...Show moreLast updated: 30+ days ago
    • Promoted
    Lead Database Administrator

    Lead Database Administrator

    LearningMateMumbai, Maharashtra, India
    Role : Senior Database(MSSQL Server) Developer.Experience administering Microsoft SQL Server.Proficiency in writing complex SQL queries. Strong experience in schema design and index optimization.Han...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle Integration Cloud (OIC) Administrator

    Oracle Integration Cloud (OIC) Administrator

    Vienna Consultancythane, maharashtra, in
    Title- Oracle Integration Cloud (OIC) Administrator.Contract Duration- 6 Months ,with the possibility of extension.We are seeking a skilled Oracle Integration Cloud (OIC) Administrator responsible ...Show moreLast updated: 3 days ago
    • Promoted
    Database Administrator

    Database Administrator

    Amicon Hub ServicesKalyan-Dombivli, IN
    Role : Databricks Administrator (Client : Patch).Strong hands-on experience in Databricks workspace setup & cluster management. User & group administration via Azure AD / IAM / SCIM.Cluster configurat...Show moreLast updated: 24 days ago
    • Promoted
    MONGO DB Administrator

    MONGO DB Administrator

    IGT SolutionsThane, IN
    MongoDB Administrator with Java Exposure.Immediate to 30 days preferred.MongoDB databases in a distributed environment.The ideal candidate should possess strong database administration expertise, s...Show moreLast updated: 25 days ago
    • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    SumCircle Technologies Private Limitedmumbai, maharashtra, in
    JD for Oracle Database Administrator : .Oracle Database architecture 12c, 19c.Backup & Recovery using RMAN and Data Pump. Instance parameter and configuration management.DB alerts, crons, jobs creatio...Show moreLast updated: 30+ days ago
    • Promoted
    Solution Architect - Database

    Solution Architect - Database

    Jio Platforms Limited (JPL)thane, maharashtra, in
    We are looking for Solution Architects for designing data management solutions, having strong knowledge of architecting and designing highly available and scalable database on cloud • He will deliv...Show moreLast updated: 4 days ago
    • Promoted
    PostreSQL DBA

    PostreSQL DBA

    PibyThreemumbai, maharashtra, in
    Job Role : We are seeking an experienced Database Administrator with strong PostgreSQL expertise and knowledge of containerized environments and distributed database systems.The ideal candidate will...Show moreLast updated: 4 days ago
    • Promoted
    Senior AWS Administrator

    Senior AWS Administrator

    CYAN360Kalyan-Dombivli, IN
    Job title : AWS Infrastructure Engineer.Work Timings : 2 : 30 PM to 11 : 30 PM IST.ETL / ELT processes using AWS services such as AWS Glue, AWS Lambda and AWS Step Functions. Ensure data quality, security, ...Show moreLast updated: 17 days ago
    • Promoted
    Database Developer

    Database Developer

    AVASO Technology SolutionsKalyan-Dombivli, IN
    AVASO Technology is a global leader in providing IT solutions and services, specializing in offering top-tier support and managed services. We are committed to delivering cutting-edge technology sol...Show moreLast updated: 1 day ago
    • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    ACL Digitaldombivli, maharashtra, in
    I have a interesting opportunity for Oracle DBA, looking for immediate joiner with below skillls : .Bengaluru / Hyderabad / Remote. DBA with strong experience in Oracle databases, and experience with ...Show moreLast updated: 13 days ago
    • Promoted
    AWS PostgreSQL Database Administrator (DBA)

    AWS PostgreSQL Database Administrator (DBA)

    SpringbordMumbai, IN
    AWS PostgreSQL Database Administrator (DBA).This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud env...Show moreLast updated: 3 days ago
    • Promoted
    Cloud Database Adminstrator

    Cloud Database Adminstrator

    ALIANDOThane, IN
    Job Title : Cloud Database Administrator.ALIANDO is an award-winning Azure Expert Managed Service solutions company focused on selling and deploying Microsoft technologies for U.For over 20 years, M...Show moreLast updated: 5 days ago
    • Promoted
    SQL Database Administrator

    SQL Database Administrator

    Penta ConsultingThane, IN
    We are currently looking for a SQL Server Database Administrator to work remotely in India with a global OEM.In this role you will support mission-critical infrastructure / DBs at an enterprise scale...Show moreLast updated: 5 days ago
    • Promoted
    Azure Database Administrator

    Azure Database Administrator

    LTIMindtreemumbai, maharashtra, in
    Azure SQL (DB & MI), MySQL, PostgreSQL, and Cosmos DB(API & vCore) : .Design and implement resilient architectures for Azure database services including Azure SQL( DB & MI), MySQL, PostgreSQL, and Co...Show moreLast updated: 4 days ago
    • Promoted
    SQL Database Administrator

    SQL Database Administrator

    Insight Globalmumbai, maharashtra, in
    IST – 11pm IST OR 5am IST to 2pm IST, OR Weekend 12 hour shifts.Hours workweek – they are flexible on schedule and will accommodate which what works best for candidate. Pay : 10-15Lakh based on exper...Show moreLast updated: 4 days ago
    • Promoted
    GCP Platform Administrator

    GCP Platform Administrator

    Sapphire Software Solutions IncThane, IN
    Position : GCP Platform Administrator.Interview Process : 1 round – hiring ASAP.Google Cloud Platform (GCP) administration experience. Solid knowledge of Google Cloud products / services – IaaS and PaaS...Show moreLast updated: 1 day ago
    • Promoted
    SAP Business One Administrator on Azure Infrastructure

    SAP Business One Administrator on Azure Infrastructure

    Eton TechnologiesThane, IN
    SAP Business One Administrator.The ideal candidate should also have solid Azure infrastructure and DevOps skills to support smooth operations and automation. VMs, storage, networking, security.Autom...Show moreLast updated: 26 days ago