Enable job alerts via email!

Data Warehouse Engineer

Blackbox BI Consultancy

Kuala Lumpur

On-site

MYR 48,000 - 72,000

Full time

Yesterday
Be an early applicant

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

Start fresh or import an existing resume

Job summary

A leading consultancy in Kuala Lumpur seeks a Database Specialist to manage and optimize databases for business applications. This role involves troubleshooting, writing complex SQL queries, and ensuring the reliability and performance of databases. The ideal candidate will have a degree in Computer Science or Information Technology, along with experience in retail data operations and proficiency in SQL.

Qualifications

  • Minimum 2 years of experience in software development/deployment.
  • Strong proficiency with MSSQL and relational database logic.
  • Exposure to the retail domain and related data operations.

Responsibilities

  • Handle and maintain databases, optimize SQL queries.
  • Create reusable table structures for future use.
  • Ensure database performance, security, and availability.

Skills

SQL Proficiency
Database Optimization
Troubleshooting

Education

Professional Certificate in Computer Science/IT
Diploma in Computer Science/IT
Degree in Computer Science/IT

Tools

Microsoft SQL
Oracle
MySQL

Job description

Your job is to handle and maintain databases, and assist in implementation of databases in projects

Responsibilities

Handle in writing and optimizing SQL queries

Create reusable table structure that can be included in future standard database structure

Create batch file for daily FTP updates

Assist team in project implementation on the database section

Quality checking and assurance on the data from our Business Intelligence models

Handle and maintain server settings such as ports forwarding, task scheduler and database connectivity between clients and our database server

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Ensure performance, security, and availability of databases.

Troubleshooting common database issues, script, and system errors.

Desired skills and experience

Possess a Professional Certificate, Diploma, Degree or higher, in Computer Science/Information Technology or in related field.

MUST have experience with Microsoft SQL or the other relational database such as Oracle, MySQL, Firebird and etc.

MUST have exposure to retail domain, understanding overall Retail operations, as well as specifics of data captured at various touch points in retail operations

Minimum 2 years of experience as part of a software development/deployment team for business

Strong proficiency with MSSQL queries and RMDBMS logic

Skilled at optimizing large and complicated SQL Statements

Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.