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