PostgreSQL Database Developer/Administrator
Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
HASPRIME SOLUTIONS SDN. BHD. Unit B-12-13, Tower B, Atria SOFO Suites,
47400 Petaling Jaya, Selangor, Malaysia.
Max 6k
Job Title: PostgreSQL Database Developer/Administrator
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: Full-time
Pay: Up to RM6,000.00 per month
Benefits:
- Additional leave
- Maternity leave
- Opportunities for promotion
- Professional development
Schedule:
- Fixed shift
Supplemental Pay:
- Yearly bonus
Education:
- Bachelor's (Required)
Experience:
- developing and administering PostgreSQL databases: 2 years (Required)