PostgreSQL Database Administrator

least 10% above the market? If so, we are excited to have bumped onto you.

Learn how we are redefining the meaning of work, and be a part of the team raved by Clients, Job-seekers and Employees.

• Jobseeker Video Testimonials
  
• Employee Glassdoor Reviews
  

If you are a PostgreSQL Database Administrator (DBA) Position looking for excitement, challenge and stability in your work, then you would be glad to come across this page.

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long term project. Here are a few details.

Check if you are up for maximizing your earning/growth potential, leveraging our Disruptive Talent Solution.

Requirements
Role:PostgreSQL Database Administrator (DBA)
Location: Hyderabad, Pune,Benguluru, Delhi,Mumbai,Kolkata,Chennai
Exp: Years

Requirements

We are seeking a skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. The PostgreSQL DBA will be responsible for the performance, integrity, and security of our PostgreSQL database systems. The ideal candidate will have hands-on experience with PostgreSQL database management in production environments, including setup, configuration, maintenance, and optimization. This role also involves ensuring high availability, data consistency, backup strategies, and disaster recovery planning.

Key Responsibilities:

• Database Installation & Configuration:
  

  • Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.
    

  • Implement replication (physical/logical) and clustering solutions for high availability and scalability.
    

• Performance Tuning & Optimization:
  

  • Monitor database performance and identify bottlenecks.
    

  • Analyze slow queries, recommend indexing strategies, and optimize SQL queries.
    

• Security & Compliance:
  

  • Ensure database security, including user authentication, access control, and data encryption.
    

  • Manage roles, permissions, and audit logs.
    

  • Ensure compliance with industry standards and data protection regulations (e.g., GDPR, HIPAA).
    

• Backup & Recovery:
  

  • Implement and manage backup and disaster recovery procedures.
    

  • Use tools like pgBackRest, Barman, or native PostgreSQL backup methods.
    

  • Conduct regular restore testing and audits.
    

• Database Maintenance:
  

  • Perform routine database maintenance tasks such as vacuuming, reindexing, and partitioning.
    

  • Apply patches and upgrades to the PostgreSQL engine and associated tools.
    

• Monitoring & Alerting:
  

  • Implement monitoring tools (e.g., pgAdmin, Prometheus, Grafana, Nagios) to proactively detect issues.
    

  • Set up alerts for critical metrics and thresholds.
    

• Collaboration & Support:
  

  • Work closely with DevOps, development, and QA teams to support application deployments and releases.
    

  • Troubleshoot database-related application issues.
    

• Documentation & Automation:
  

  • Maintain comprehensive documentation for database configurations and procedures.
    

  • Automate routine tasks using shell scripts, Ansible, or other automation frameworks.
    

Required Skills & Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or related field.
  

• 4+ years of hands-on experience as a PostgreSQL DBA in a production environment.
  

• Strong knowledge of PostgreSQL architecture, internals, and extensions (e.g., PostGIS, pg_stat_statements).
  

• Proficient in performance tuning, query optimization, and indexing.
  

• Experience with HA/DR solutions like Patroni, PgBouncer, Streaming Replication.
  

• Familiarity with cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure Database for PostgreSQL).
  

• Experience with Linux/Unix system administration and scripting (bash, python).
  

• Understanding of CI/CD, DevOps, and Infrastructure as Code concepts.
  

• Strong analytical and problem-solving skills.
  

• Excellent verbal and written communication skills.
  

Preferred Qualifications:

• PostgreSQL certification (e.g., EDB Certified PostgreSQL DBA).
  

• Experience with containerization (Docker, Kubernetes).
  

• Experience migrating from other RDBMS (e.g., Oracle, MySQL) to PostgreSQL.
  

• Knowledge of other database technologies (MongoDB, MySQL, Redis).
  

Benefits:

• Competitive salary and performance-based bonuses.
  

• Health, dental, and vision insurance.
  

• Flexible working hours and remote work options.
  

• Professional development and training opportunities.
  

• Collaborative and inclusive work culture.
  

Benefits Visit us at Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.

CEO Message: Click Here
Clients Testimonial: Click Here

---