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,000.00 - RM7,000.00 per month
Benefits:
- Health insurance
- Opportunities for promotion
- Professional development
Work Location: In person