Key Responsibilities:
Database Management:
Administer and maintain PostgreSQL database clusters, ensuring their reliability and performance.
Monitor database health and performance, implementing improvements as necessary.
Perform regular database maintenance tasks, such as backups, indexing, and replication.
Manage database access, permissions, and security settings.
Design and implement database schemas, tables, and relationships to support application requirements.
Performance Tuning and Optimization:
Analyze and optimize database queries, indexes, and configurations to improve performance.
Implement caching strategies and other optimizations to enhance database performance.
Conduct regular performance testing and provide recommendations for improvements.
Data Security and Compliance:
Implement and enforce data security measures to protect sensitive information.
Ensure compliance with data protection regulations and industry standards.
Monitor for security vulnerabilities and apply necessary patches and updates.
Disaster Recovery and High Availability:
Develop and maintain disaster recovery plans, ensuring data integrity and availability.
Implement and manage database replication and failover strategies.
Ensure high availability of databases through clustering and load balancing techniques.
Collaboration and Support:
Work closely with development and DevOps teams to support database-related needs and deployments.
Provide database support and troubleshooting for production issues, ensuring minimal downtime.
Participate in on-call rotation for after-hours support as needed.
Documentation and Reporting:
Document database architectures, configurations, and procedures.
Generate and maintain reports on database performance, usage, and health.
Provide regular updates to stakeholders on database status and issues.
Qualifications:
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Experience:
Proven experience as a Database Administrator with a focus on PostgreSQL.
Strong knowledge of SQL and PL/pgSQL programming.
Experience with database design, schema management, and data modeling.
Familiarity with database replication, clustering, and high availability solutions.
Experience with database monitoring tools (e.g., pgAdmin, Datadog, Prometheus).
Apply via :
credrails.careers.hibob.com
