As a PostgreSQL Database Administrator at the L2 level, you will be responsible for maintaining the integrity, performance, and security of our PostgreSQL database systems. Your role will involve troubleshooting issues, implementing best practices, and collaborating with other teams to ensure optimal database functionality. The ideal candidate should have a strong background in PostgreSQL administration and a proactive approach to problem-solving.
Responsibilities:
1. Database Maintenance:
Perform routine database maintenance tasks, including backups, restores, and updates.
Monitor database performance and implement optimizations to ensure efficient operation.
2. Troubleshooting and Issue Resolution:
3.Security and Compliance:
4. Performance Tuning:
5. High Availability and Disaster Recovery:
6. Documentation:
7. Collaboration:
Experience: 4+ years
Skills:
- open source migration oracle to Postgres, DB2 to Postgres
- Familiarity with other database management systems.
- Knowledge of cloud database services (e.g., AWS RDS, Azure Database for PostgreSQL).
Qualification:
- Bachelors degree in Computer Science, Information Technology, or a related field.
- Proven experience as a PostgreSQL Database Administrator (L2) or similar role.
- In-depth knowledge of PostgreSQL architecture, configuration, and best practices.
- Proficient in SQL and scripting languages (e.g., Bash).
- Experience with database security and compliance.
- Strong problem-solving and troubleshooting skills.
- Excellent communication and collaboration abilities.
