As a database administrator, you play a pivotal role in managing and maintaining PostgreSQL databases. Your primary responsibilities include setting up and configuring PostgreSQL instances on various platforms, including cloud environments.
The ideal candidate will possess exceptional skills in performance monitoring and optimization, ensuring query response times remain optimal. Additionally, they must develop and execute comprehensive backup strategies to ensure data can be restored in case of emergencies.
A successful system administrator will implement robust security measures to protect sensitive data, including user access controls, encryption, and audit logging. They will also collaborate with developers to design efficient database schemas, create tables, indexes, views, and triggers.
Key qualifications for this position include identifying and resolving data inconsistencies, ensuring data quality through validation checks and data cleansing processes. The selected candidate will also apply PostgreSQL updates and patches to maintain compatibility and security.
Finally, the chosen individual will investigate and resolve database-related issues reported by application teams, providing technical support to ensure seamless database operations.
* Database Installation and Configuration
* Performance Monitoring and Optimization
* Backup and Recovery
* Security Management
* Sigma Design and Management
* Data Integrity and Consistency
* Patching and Upgrades
* Troubleshooting and Support