PostgreSQL Database Administrator (DBA)
PostgreSQL Database Administrator (DBA)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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.
Requirements
Role:PostgreSQL Database Administrator (DBA)
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.
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/
Employment Type
Full Time
