Postgresql Database Administrator

Description:

Key Responsibilities:
1. Install, configure, and maintain PostgreSQL database systems.
2. Perform database tuning, performance monitoring and optimization to ensure system efficiency.
3. Ensure that databases are backed up regularly and that backup processes are effective for data recovery.
4. Develop and implement security policies, including user access control and security configurations, to safeguard sensitive information.
5. Monitor database logs for unusual activity and troubleshoot any issues.
6. Work closely with development teams to design and optimize database schema, queries, and connections.
7. Assist in capacity planning and predicting future database growth.
8. Implement and maintain High Availability (HA) and Disaster Recovery (DR) solutions.
9. Develop and maintain documentation related to database architecture, data flow, and configurations.
10. Provide technical support, training, and assistance to other team members and departments.
11. Keep up to date with the latest industry trends and technologies related to PostgreSQL and databases.
12. Perform scheduled maintenance, upgrades, and migrations without compromising data integrity.
Qualifications:
- Bachelor’s Degree in Computer Science, Information Technology, or a related field.
- Minimum 2-3 years of experience as a PostgreSQL Database Administrator or similar role.
- Deep understanding of PostgreSQL and database principles.
- Knowledge of backup and recovery methodologies, and database performance tuning.
- Familiarity with Linux/Unix operating systems.
- Knowledge of High Availability (HA), Replication, and Disaster Recovery (DR) solutions for PostgreSQL.
- Familiarity with scripting languages such as Shell, Python, or Perl.
- Strong analytical, problem-solving, and communication skills.
- Experience with cloud services such as AWS, Azure, or GCP is a plus.
- PostgreSQL certification is a plus.