Overview:
The Postgre SQL DBA plays a crucial role in the organizations database management by ensuring the performance integrity and security of the PostgreSQL databases. They are responsible for implementing and maintaining the databases monitoring system performance and resolving issues to ensure seamless data availability.
Key Responsibilities:
- Design and implement PostgreSQL database infrastructure
- Perform regular database monitoring and maintenance
- Optimize database performance through indexing query optimization and configuration tuning
- Implement backup and recovery processes
- Manage user access and security settings
- Troubleshoot database issues and performance bottlenecks
- Develop and implement data migration and integration processes
- Collaborate with development teams for database design and optimization
- Document database architecture processes and procedures
- Stay updated with PostgreSQL best practices and trends
Required Qualifications:
- Bachelors degree in Computer Science Information Technology or a related field
- Proven work experience as a PostgreSQL Database Administrator or in a similar role
- Proficiency in SQL and database performance tuning
- Experience in database security and backup/recovery solutions
- Knowledge of PostgreSQL high availability solutions such as streaming replication and logical replication
- Understanding of database monitoring tools
- Strong problemsolving and analytical skills
- Excellent communication and collaboration abilities
- Ability to work in a fastpaced dynamic environment
- Relevant certifications such as PostgreSQL Certified Engineer (PCE) are a plus
database monitoring tools,database performance tuning,database security,postgresql certified engineer (pce),database administration,sql,backup/recovery solutions,communication,collaboration,database,analytical skills,problem-solving,logical replication,performance tuning,streaming replication,backup and recovery,postgresql