We are seeking a skilled Postgres Database Engineer with expertise in the installation, configuration, patching, upgrading, deployment, and management of Postgres databases. The successful candidate will play a critical role in evaluating and preparing new and upgraded Postgres and Postgres-compatible offerings for enterprise use.
Responsibilities
- Install, configure, and maintain Postgres databases in various environments.
- Perform upgrades, patches, and regular maintenance to ensure optimal database performance.
- Assess and prepare new and upgraded Postgres solutions for deployment across the organization.
- Document and communicate best practices, techniques, and patterns for database administration.
- Design and implement intra- and inter-data-center high availability configurations.
- Implement and maintain physical and logical replication solutions.
- Manage cluster configurations and automated provisioning processes.
- Develop and execute backup and restoration procedures.
- Conduct performance tuning and optimization of Postgres databases.
- Diagnose and resolve database-related issues efficiently.
- Analyze Postgres internals, including durability and replication settings, to enhance performance.
Qualifications
- Solid understanding of database management system concepts, including ACID properties, CAP theorem, and consistency models.
- Proven experience with enterprise-scale Postgres deployments.
- Familiarity with Postgres internals, including performance tuning and configuration.
- Knowledge of security mechanisms relevant to database management.
- Excellent communication skills for documenting and presenting technical concepts to various stakeholders.
Preferred Skills
- Experience with automated deployment tools and methodologies.
- Familiarity with cloud-based Postgres solutions and services.
- Understanding of industry best practices for database security and compliance.