Career at Blackbox Insights

Looking for a job? We are hiring!

Data Warehouse Manager

Objective

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