Database Administrator

Mandatory Skills : PostgreSQL / MYSQL

Job Summary :

We are seeking an experienced PostgreSQL Database Developer / Administrator to join our team. The ideal candidate will have at least 2 years of experience in developing and administering PostgreSQL databases, along with a strong understanding of database design and optimization principles. The successful candidate will be responsible for maintaining, optimizing and supporting our PostgreSQL database systems.

Responsibilities :

Design, develop and maintain PostgreSQL databases and related applications

Develop and optimize SQL queries and stored procedures

Monitor database performance and optimize system performance

Ensure database availability, security and reliability

Backup and restore databases, and implement disaster recovery plans

Troubleshoot and resolve database-related issues

Collaborate with developers to design efficient and effective database structures

Develop and maintain database documentation and data dictionaries

Work with team members to implement best practices and standards for database administration

Stay up-to-date with the latest technologies and trends in database development and administration

Requirements :

At least 2 years of experience in developing and administering PostgreSQL databases

Strong understanding of database design principles and optimization techniques

Proficiency in SQL and experience with query optimization

Familiarity with backup and recovery strategies, and disaster recovery planning

Knowledge of performance tuning and optimization techniques

Experience with database security and user management

Familiarity with database administration tools and utilities

Excellent problem-solving and troubleshooting skills

Strong communication and interpersonal skills

Minimum Diploma in Computer Science, Information Technology, or a related field

Preferred qualifications :

Experience with other database technologies such as MySQL

Experience with cloud-based database platforms such as Amazon RDS or Azure

Experience with Linux / Unix server administration

Experience with programming languages such as Python

Job Type : Contract

Contract length : 12 months

Pay : RM6, RM7,000.00 per month

Benefits :

• Health insurance
• Opportunities for promotion
• Professional development

Work Location : In person