PostgreSQL Database Administrator (DBA)

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 Jobseekers 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 PuneBenguluru DelhiMumbaiKolkataChennai

Exp : 6 10 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 handson 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 databaserelated 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 :

Bachelors degree in Computer Science Information Technology or related field.

4 years of handson experience as a PostgreSQL DBA in a production environment.

Strong knowledge of PostgreSQL architecture internals and extensions (e.g. PostGIS pgstatstatements).

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 problemsolving 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 performancebased 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

PostgreSQL DBA,PostgreSQL architecture, internals, and extensions,AWS RDS / Aurora, GCP Cloud SQL, or Azure Database for PostgreSQL,CI / CD, DevOps, and Infrastructure as Code concepts.

Education

B.E /

Key Skills

Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1