PostgresSQL DBA Architect

Role Overview: As a PostgreSQL Database Administrator (DBA), your role involves installing, configuring, and maintaining PostgreSQL database systems. You will be responsible for monitoring database performance, optimizing efficiency and reliability, and implementing database backup and recovery processes. Collaborating with developers to design and optimize database schemas and ensuring database security and compliance with organizational policies are also key responsibilities. Troubleshooting and resolving database-related issues promptly, along with performing regular maintenance tasks, updates, and patches are part of your daily tasks. Developing and implementing disaster recovery plans, monitoring and managing database storage, capacity planning, and providing best practice guidance to development teams are crucial aspects of your role. Moreover, maintaining database documentation and standards is essential for ensuring smooth operations. Key Responsibilities: - Install, configure, and maintain PostgreSQL database systems. - Monitor database performance and optimize for efficiency and reliability. - Implement and manage database backup and recovery processes. - Ensure database security and compliance with organizational policies. - Collaborate with developers to design and optimize database schemas. - Troubleshoot and resolve database-related issues promptly. - Perform regular database maintenance tasks, including updates and patches. - Develop and implement disaster recovery plans. - Monitor and manage database storage and capacity planning. - Provide best practice guidance to development teams. - Maintain database documentation and standards. Qualification Required: - Proven experience as a PostgreSQL Database Administrator. - Strong knowledge of database design, performance tuning, and optimization. - Proficiency in writing query plans, creating indexes, and SQL commands. - Experience with database replication and PostgreSQL commands. - Ability to write scripts for database upgrades. - Experience with backup, recovery, and disaster recovery planning. - Familiarity with database security best practices. - Excellent problem-solving and troubleshooting skills. - Strong communication and collaboration skills. - Ability to work independently and as part of a team. - Knowledge of cloud database services (e.g., AWS RDS, Azure Database for PostgreSQL). - Experience with automation tools and scripting languages (e.g., Python, Bash).,