Job Description

Job Responsibilities:

1. Database Design and Development

Design and implement database schemas, tables, views, indexes, and stored procedures. Create and maintain efficient SQL queries, scripts, and functions. Ensure databases follow normalization and indexing best practices for performance and scalability. Design data models (conceptual, logical, and physical).

2. Database Maintenance and Optimization

Monitor database performance and tune SQL queries for speed and efficiency. Identify and resolve performance bottlenecks using execution plans and indexing strategies. Perform regular database maintenance tasks (backups, indexing, partitioning, etc.).

3. Data Integration and ETL (Extract, Transform, Load)

Develop and manage ETL processes to move data between systems. Work with tools like SSIS (SQL Server Integration Services), Informatica, or custom scripts. Ensure data accuracy, consistency, and integrity across multiple systems.

4. Data Security and Compliance

Implement access controls and user permissions. Ensure compliance with data privacy and security regulations (e.g., GDPR, HIPAA). Manage data encryption, auditing, and secure data transfers.

5. Reporting and Analytics Support

Build and optimize database queries for reporting tools (Power BI, Tableau, etc.). Support data analysts and business intelligence teams by providing accurate and efficient data sets. Create stored procedures and views for dashboards and reports.

6. Collaboration and Documentation

Collaborate with application developers, data analysts, and system administrators. Participate in code reviews and database design discussions. Document database structures, processes, and best practices.

7. Troubleshooting and Support

Investigate and resolve database-related errors and performance issues. Provide production support for database systems. Monitor logs and system alerts for potential issues.

8. Continuous Improvement

Stay updated on the latest SQL features, database technologies, and optimization techniques. Recommend improvements to database design and architecture.

Skills required (must have):

SQL Development Consultant Independently communicate with business stakeholders to gather requirements and propose reasonable technical solution designs. Participate in Lenovo SCI-related projects involving data modeling development. Take responsibility for data-related operations and maintenance, including troubleshooting and resolving online incidents. Solid understanding of fundamental data warehouse concepts. Proficient in database development and performance tuning; familiarity with stored procedure development is a plus. Experience with multiple database products; hands-on experience with SAP HANA, Doris, Oracle, and PostgreSQL is highly preferred. Familiarity with big data technologies and performance tuning, such as Hadoop, Hive SQL, Spark SQL, and Presto; experience with Lenovo's LUDP platform is a strong advantage. Proficiency in 1-2 ETL tools, with the ability to design efficient ETL jobs for complex data processing workflows.
Job Types: Full-time, Contract
Contract length: 12 months

Pay: RM7,000.00 - RM9,000.00 per month

Benefits:

Health insurance Maternity leave Opportunities for promotion Professional development
Application Question(s):

1. Do you have experience with multiple database products; hands-on experience with SAP HANA, Doris, Oracle, and PostgreSQL?
Education:

Diploma/Advanced Diploma (Preferred)
Experience:

SQL Development Consultant: 3 years (Preferred)
Language:

Mandarin (Preferred)
Work Location: In person