PostgreSQL ( Database Administration )

Department Icon Data Science Analytics & Machine Learning
Posted: 18 hours ago
3-5 years
Bangalore
Data Science Analytics & Machine Learning
Work From Office
Full Time
Closes 5 Dec 2026
₹12,00,000 - ₹20,00,000

Posted: 18 hours ago
|
Applicants: 2
Let Jobaaj One apply for you

An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.

Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

PostgreSQL Database Administration

  • Perform day-to-day PostgreSQL database administration, monitoring, and maintenance activities.
  • Conduct regular database health checks and proactively identify potential issues.
  • Independently troubleshoot database errors, connection issues, performance bottlenecks, and operational incidents.
  • Manage database users, roles, permissions, schemas, and access privileges.
  • Monitor database capacity, resource utilization, connections, and storage growth.
  • Maintain PostgreSQL configuration parameters and recommend improvements based on workload requirements.

Backup, Restore, and Disaster Recovery

  • Manage and monitor incremental and full database backups.
  • Perform database restore operations and validate backup integrity.
  • Troubleshoot backup failures and ensure backup jobs complete successfully.
  • Participate in disaster recovery (DR) planning, recovery procedures, and DR testing.
  • Understand and manage Write-Ahead Logging (WAL), WAL retention, archiving, and cleanup.
  • Troubleshoot excessive WAL generation, replication slot retention, and associated disk-space issues.

Performance Tuning and Optimization

  • Analyze slow queries and troubleshoot database performance issues.
  • Perform query optimization using execution plans such as EXPLAIN and EXPLAIN ANALYZE.
  • Identify indexing opportunities and optimize existing indexes.
  • Monitor database statistics, locks, blocking sessions, long-running queries, and resource utilization.
  • Perform routine maintenance activities, including VACUUM, ANALYZE, and table/index maintenance.
  • Identify and resolve issues related to connection management, autovacuum, and table bloat.

Replication and High Availability

  • Configure, monitor, and troubleshoot PostgreSQL streaming replication.
  • Understand primary-replica architecture, replication lag, failover, and recovery procedures.
  • Manage PostgreSQL logical replication, including publications and subscriptions.
  • Troubleshoot logical replication errors, replication lag, and WAL retention issues.
  • Understand replication slots and their impact on WAL management and disk utilization.

CloudNativePG (CNPG) and Migration

  • Understand PostgreSQL deployment and administration in Kubernetes environments.
  • Assist with or perform PostgreSQL migration from traditional deployments to CloudNativePG (CNPG).
  • Understand CNPG cluster architecture, configuration, backup and recovery, and replica management.
  • Troubleshoot database availability, failover, replication, and operational issues in CNPG environments.
  • Work with DevOps and platform teams on database deployments, maintenance, and incident resolution.

MongoDB / NoSQL Knowledge

  • Possess a basic understanding of NoSQL database concepts, preferably MongoDB.
  • Understand MongoDB architecture, replica sets, and basic administration.
  • Perform basic MongoDB monitoring, health checks, and troubleshooting.
  • Understand indexing, query performance optimization, and database maintenance.
  • Have basic exposure to MongoDB upgrades and performance optimization.
Required Skills
  • 3–5 years of hands-on experience in PostgreSQL database administration.
  • Strong knowledge of PostgreSQL internals, administration, monitoring, and troubleshooting.
  • Practical experience with backup, restore, WAL management, and recovery procedures.
  • Good understanding of streaming replication, logical replication, publications, and subscriptions.
  • Experience with query tuning, indexing strategies, and database performance optimization.
  • Knowledge of database security, roles, privileges, and connection management.
  • Ability to independently analyze and troubleshoot database issues.
  • Basic knowledge of Linux commands, shell scripting, and database automation.
  • Basic knowledge of MongoDB or another NoSQL database; MongoDB is preferred.
  • Good analytical, problem-solving, and communication skills.
Preferred Skills
  • Experience with PostgreSQL on Kubernetes or CloudNativePG (CNPG).
  • Exposure to PostgreSQL version upgrades and database migration activities.
  • Knowledge of high availability, disaster recovery, and replication architecture.
  • Experience with database monitoring tools, alerting, and operational automation.
  • Familiarity with production database support and incident management.
Candidate Expectations
  • Strong hands-on PostgreSQL administration skills rather than theoretical knowledge alone.
  • Ability to independently investigate and resolve routine database issues.
  • Proactive approach to monitoring, preventive maintenance, and performance improvement.
  • Willingness to participate in production support, incident resolution, and planned maintenance activities.
Experience Requirements
  • 3+ years of work experience with SQL.
  • 1+ years of work experience with MongoDB.
  • 3+ years of work experience with PostgreSQL.

Skills

PostgreSQLMongoDBBackupRestore And WAL ManagementReplication (Streaming And Logical)Query Performance Tuning

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

Skan is an AI-powered process intelligence platform that helps enterprises understand, map, and optimize their business processes by capturing and analyzing digital work.

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Data Science Analytics & Machine Learning roles in Bangalore.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.