Postgres Database Administrator

- Install, configure, and maintain PostgreSQL database systems across multiple environments (development, testing, production).
- Monitor database performance, troubleshoot issues, and implement optimizations to enhance performance and scalability.
- Ensure data integrity, availability, and security through regular backups, replication, and disaster recovery planning.
- Develop and implement database partitioning, indexing, and performance tuning strategies.
- Create and maintain database documentation, including design specifications, data dictionaries, and operational procedures.
- Collaborate with application developers to design and optimize database schemas and queries.
- Implement and manage user access controls, roles, and permissions to ensure data security and compliance.
- Manage database migrations, upgrades, and patches, ensuring minimal downtime and disruption to operations.
- Provide support for troubleshooting and resolving database-related incidents and service requests.
- Stay updated on PostgreSQL best practices, features, and available tools, and assess their applicability to our organization.
- Participate in on-call rotation and provide support to resolve high-impact database incidents.