Database Administrator - PostgreSQL

As a PostgreSQL Database Administrator (DBA) at our company, you will be responsible for designing, implementing, and managing large-scale PostgreSQL environments. Your role will involve ensuring high availability, scalability, and performance of mission-critical systems, as well as mentoring junior DBAs and collaborating with engineering teams. Key Responsibilities: - Design and implement highly available PostgreSQL architectures including replication, clustering, sharding, and partitioning. - Define database roadmaps, standards, and best practices for enterprise deployments. - Lead query optimization, indexing strategies, and capacity planning for large datasets. - Troubleshoot and resolve complex performance issues. - Oversee installation, configuration, upgrades, and patching of PostgreSQL environments. - Ensure robust backup/recovery strategies and disaster recovery solutions. - Manage database security, compliance, and auditing. - Implement monitoring, alerting, and automation for proactive issue resolution. - Develop scripts and tools to streamline DBA operations. - Work closely with application architects and developers to optimize database usage. - Mentor and guide junior DBAs and engineers. - Provide database expertise in solution design and code reviews. - Own production database uptime, incident response, and root cause analysis. - Participate in on-call rotations and provide escalation support. Additionally, if you need any further information about our company, please refer to the website (ref:hirist.tech).,