Các Phúc Lợi Dành Cho Bạn
Mô Tả Công Việc
Your daily duties will be:
• Build PostgreSQL database clusters of high availability and quality in cloud environment (Docker + Kubernetes in AWS/AliCloud).
• Database architecture analysis and optimisation:
o Define and implement database operations SOPs with minimal downtime.
o Analyse and optimize configurations of implemented architecture.
o Act as a responsible and proactive support resource for training users/developers and firefighting in data management.
o Monitor database performance, implement changes and apply new patches and versions when required.
• Backups and consistency management:
o Use high-speed transaction recovery techniques.
o Design and be involved in implementation of automated processes for DB management (backup, backup tests, load tests, etc.)
o Setup automated tests and evaluations regularly to ensure data security, privacy and integrity.
Yêu Cầu Công Việc
• 5+ years of proven working experience as a Database Administrator.
• 1+ year of experience with balancing/pooling connection technologies (pgpool, pgbouncer, etc.)
• 1+ year experience with replication management and knowledge of different replication strategies (Multi Master, Master/Slave, etc.)
• 1+ year experience with data backup, recovery, security and integrity solutions.
• 1+ year experienced with database design and documentation of own work.
• Understanding on PostgreSQL internals (checkpoints, timelines, WAL, etc.)
• Understanding of functionality extendability through the use of popular and proven extensions.
• Problem solving skills and ability to think algorithmically.
• Knowledge of programming languages and Bash is a plus