Database Engineer

Job Summary: -

1. Build and maintain scalable and reliable database architectures that meet business needs.

2. Ensure databases achieve high performance and availability through regular optimization and monitoring.

3. Implement robust data security measures to safeguard sensitive information and ensure compliance with regulations.

4. Enhance operational efficiency by automating repetitive database tasks and processes.

Job Responsibilities: -

1. Provide technical support on multiple Database platforms, maintain the operations and management for Oracle (Primary), MS SQL (Primary) and PostgreSQL (Secondary) databases.

2. Work with a diverse team of skilled Data Analytics & Application Developer professionals

3. Provide work guidance and mentoring to subordinates and junior resources.

4. Technical assessment, migration or upgrade of Oracle, Microsoft SQL Server and PostgreSQL databases.

5. Ensure day to day operations of Database maintenance, patching, hardening and service requests

6. Perform recovery of Database related issues.

7. Participate and oversee Database maintenance, security, health check and server troubleshooting activities

8. Prepare Incident Root Cause Analysis report for the any critical incidents relating to Database platform

9. Ensure proper planning and execution of Disaster Recovery support and Database maintenance activities

10. Prepare and submit required weekly and monthly reports regarding database capacity, issues and risks

11. Attend to regulatory and internal audit requirements (audit artefacts preparation) and work towards remediating audit findings relating to Database platform.

12. Recommend and propose process improvement to improve team productivity and efficiency

13. Implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft SQL Server or PostgreSQL.

14. Design and implement RESTful Web APis, adhering to best practices and industry standards. Ensure the APis are secure, performant, and scalable to handle high traffic volumes.

15. Develop code to interact with databases and other data sources to retrieve and manipulate data needed for API functionality.

16. Write clean, maintainable, and efficient code. Conduct thorough testing of APis to identify and fix bugs, performance bottlenecks, and other issues.

17. Create clear and comprehensive technical documentation for APis, including usage instructions, endpoints, request/response formats, and authentication methods.

18. Manage API versioning and handle backward compatibility while making updates or improvements.

19. Monitor API usage, performance metrics, and error logs. Respond promptly to incidents and troubleshoot issues as they

20. Stay up-to-date with the latest technologies, trends, and best practices in API development and related fields.

21. Performs other related duties as assigned.

Job requirement: -

• Bachelor's degree in IT / Computer Science with at least 3 years of Oracle, Microsoft and/or PostgreSQL database administration experience.
• Proven hands-on experience at least 1 years in developing ASP.NET Web APIs using C# and NET framework.
• Experience with middleware, data model, ETL, API development, and system integrations.
• Strong familiarity and experience with solution design and delivery using cloud platforms like AWS, Azure.
• Experience to handle scalable projects with complex integration requirements, with the ability to architect or explain complex systems interactions including data flows, common interfaces, APis and other methods.
• Ability to work independently as well as part of a team, with strong communication and collaboration skills.
• Excellent verbal and written communications skills in English.
• Takes initiative to improve current state of things and adaptable to embrace new changes.
• Prior work experience in retail industry is an added advantage.

Job Type: Full-time

Pay: RM4, RM5,000.00 per month

Benefits:

• Company car
• Maternity leave
• Professional development

Application Question(s):

• What is your expected salary? (min-max)
• What is your current / last drawn salary?
• Do you need to serve notice period? (e.g. 2 months / available immediately)
• Do you have experience with Cloud database solutions such as AWS RDS/ Redshift or Azure SQL Database?
• Do you have knowledge of NoSQL databases like MongoDB, Cassandra, or DynamoDB?
• Are you familiar with scripting languages (e.g., Python, Shell scripting) for automation?
• Do you have experience with database monitoring tools and performance tuning?
• Do you have certification in database technologies (e.., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator)?

Education:

• Bachelor's (Preferred)

Experience:

• Oracle: 3 years (Preferred)

Language:

• English (Preferred)
• Mandarin (Preferred)

Work Location: In person