(A) Senior PostgreSQL Database Developer

Upscale Sdn Bhd; Kuala Lumpur; On-site; MYR 200,000 - 250,000; Full time

Job summary

A leading company in Kuala Lumpur is seeking a Senior PostgreSQL Database Developer. The successful candidate will have at least 2 years of experience in database development, focusing on design, optimization, and support of PostgreSQL databases. This role offers the opportunity to work closely with various teams while implementing best practices and staying updated with database technologies.

Qualifications

• At least 2 years of experience in developing PostgreSQL databases.
• Strong understanding of database design principles and optimization techniques.
• Proficiency in SQL and experience with query optimization.

Responsibilities

• Design, develop and maintain PostgreSQL databases and related applications.
• Monitor database performance and optimize system performance.
• Ensure database availability, security and reliability.

Skills

Database design

Optimization techniques

SQL

Problem-solving

Communication

Education

Diploma in Computer Science

Information Technology

Tools

PostgreSQL

Job description

Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

About the job (A) Senior PostgreSQL Database Developer

Job Summary:

We are seeking an experienced PostgreSQL Database Developer to join our team. The ideal candidate will have at least 2 years of experience in developing 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
• Stay up-to-date with the latest technologies and trends in database development

Requirements:

• At least 2 years of experience in developing 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 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
• Experience with programming languages such as Python