Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Codvo

Compare

3.9

based on 46 Reviews

62 Codvo Jobs

PostgreSQL DBA

Codvo.ai

3.9

based on 46 Reviews

8-10 years

Pune

1 vacancy

PostgreSQL DBA

Codvo

posted 1d ago

Job Role Insights

Flexible timing

Key skills for the job

Python SQL Compliance Postgresql Troubleshooting Shell Scripting

+ 3 more

Job Description

Job Title: PostgreSQL Database Administrator

Company Overview:

At Codvo, software and people transformations go together. We are a global empathy-led technology services company with a core DNA of product innovation and mature software engineering. We uphold the values of Respect, Fairness, Growth, Agility, and Inclusiveness in everything we do.

We are looking for an experienced 8 to 10 years and detail-oriented PostgreSQL Database Administrator to join our dynamic team. The ideal candidate will be responsible for managing and optimizing PostgreSQL databases, ensuring high performance, and assisting in the design and implementation of database systems. You will also play a key role in database troubleshooting, backups, migrations, and scaling solutions to meet company needs.

Key Responsibilities:

Documentation Collaboration:

Ability to write structured documentation in Markdown, Confluence, or dedicated documentation tools.

Database Reverse Engineering:

Understanding schema visualization, entity-relationship (ER) modeling, and dependency tracing.

Database Design Management:

Design, implement, and manage PostgreSQL database systems.

Perform regular maintenance of PostgreSQL databases, including updates, backups, and restores.

Ensure database availability, reliability, and performance tuning.

Optimization Troubleshooting:

Monitor and optimize the performance of PostgreSQL databases.

Write efficient SQL queries, create stored procedures, and optimize queries for better performance.

Troubleshoot and resolve database issues, performance bottlenecks, and outages.

Backup Disaster Recovery:

Implement and maintain regular backup and disaster recovery processes for databases.

Perform database replication and clustering for high availability.

Security Compliance:

Enforce database security policies, including user access management and data encryption.

Ensure compliance with relevant data protection regulations and standards.

Collaboration Development:

Work with developers to optimize application queries and database design.

Assist in database migrations and upgrades to new versions of PostgreSQL.

Participate in code reviews, system design discussions, and database architecture planning.

Skills Qualifications:

Experience:

Proven experience as a PostgreSQL Database Administrator.

Strong knowledge of PostgreSQL database design, administration, and performance tuning.

Technical Skills:

Proficiency with SQL and PL/pgSQL
Experience with PostgreSQL clustering, replication, and sharding.
Familiarity with database backup tools (pg_dump, pg_basebackup) and high-availability techniques (replication, failover) tools like patroni, pgpool2 etc.
Understanding of PostgreSQL performance tuning, indexing, and query optimization.

Preferred Skills:

Should have experience in Azure-managed databases.
Ability to manage databases (specifically Percona Postgres Distribution) in Kubernetes environments.
Expertise in managing Postgres databases on cloud virtual machines (VMs).
Proficiency in configuring distributed storage solutions like Citus.
Experience in database partitioning to optimize large datasets.
Should have experience in configuring tablespaces in PostgreSQL.

Additional Skills:

Knowledge of containerization technologies and orchestrations such as Docker,kubernetes for PostgreSQL deployment.
Experience with cloud platforms (AWS, Azure, Google Cloud) and PostgreSQL in the cloud. Familiarity with scripting languages like Python, Bash, or Shell scripting for automating database operations.

Summary: This role is pivotal for ensuring the seamless operation of PostgreSQL databases and their integration into scalable, high-performance solutions. The candidate s expertise in advanced PostgreSQL features, cloud platforms, and distributed database solutions will contribute significantly to achieving our organization s goals.

Employment Type: Full Time, Permanent

Read full job description

Prepare for SQL Database Administrator roles with real interview advice