Junior Database Administrator

Job Purpose:

• As a Junior PostgreSQL Database Administrator, you will be a part of a growing international team based in Kuala Lumpur Center mainly supporting PostgreSQL PaaS subscriptions on Google cloud and on Azure cloud. We are seeking candidates with wide range of expertise and skills in PostgreSQL PaaS cloud database support such as day-to-day administration, performance tuning, monitoring, Backup/restore and SQL programming know-how.

Key Activities:

• Database Administration support with main focus PostgreSQL databases on Google cloud or Azure cloud.
• Database Maintenance, housekeeping, troubleshooting.
• Identify and resolve database performance issues, including tuning SQL queries, optimizing indexing, and implementing necessary database changes.
• Incident, problem and change management of database-related incidents and problems, both in collaboration with other technical teams.
• Provide operational support, including capacity planning, system performance analysis, and resource utilization monitoring.
• Develop and maintain documentation related to database administration procedures, configurations, and troubleshooting steps.
• Installation, configuration and lifecycle migrations/upgrades and patch management
• Conduct ongoing monitoring and proactive management of database systems to ensure high availability and performance.
• Support database backup and recovery activities, ensuring appropriate backup strategies and disaster recovery plans are in place.
• SQL (PLSQL) database programming
• unix, PHP, python shell scripting
• Participate in an on-call rotation schedule to ensure 24/7 availability and response to critical incidents.
• implement and maintain PostgreSQL disaster recovery and high availability solutions.
• Ensure compliance with data protection regulations.

Qualifications/Skills:

Essential Skills

Sufficient and proven experience in
PostgreSQL
database administration in particular:

• At least 5 years of experience working in PostgreSQL database administration with basic skills on Google or Azure Cloud
• basic Skills in supporting Cloud PaaS subscriptions
• familiarity with cloud platforms (Google or Azure)
• PostgreSQL Administration, backup/recovery and Monitoring
• problem analysis resolution and error debugging including skills in raising support requests with vendors.
• database performance tuning (configuration related and application code tuning)
• database installation and configuration including patching
• profound skills in PostgreSQL's HA availability solutions
• backup and recovery, cloning and duplication
• data transfer/extract features for PostgreSQL
• space management analysis and object reorganization
• database patching and migrations
• database user management (authorisation and authentication)
• analysis of database performance reports
• basic unix shell scripting, PHP or Python programming skills
• basic SQL database programming skills
• Comprehensive knowledge in database security.
• Knowledge of Cloud key rotation concepts and network traffic encryption

additional preferred Skills (technical, methodology and business):

• Knowledge of another database technology: Oracle, Cassandra, Redis Cache is a plus.
• Experience in software methodology, processes and quality assurance
• knowledge in the area of IT security
• Profound interest in new technologies and self-motivated troubleshooting

Personal Skills:

• Goal-oriented and organised working methods
• Good analytical skills

Critical Skills/Work Attitude

• English language skills
• Teamwork
• Cloud technology knowledge

Education:

• Official acknowledged university / college qualifications
• Certified corresponding post education or training in PostgreSQL database administration areas.