Job Location: Singapore

This position is for a technically strong SQL DBA who has worked extensively in a Data Warehouse environment. The DWA will be responsible for the data warehouse / database administration functions as well as system programming, troubleshooting, and system management for all data warehouse related issues. The DWA serves as a futurist within IT, keeping the enterprise up to speed with current data warehouse and database technology. Based on your experience you may be considered for the DWA position instead.

Responsibilities:

• Plan, design and implement data warehouses and data marts including capacity planning, schema design, batch and real-time load processes, data archival and backups
• Manage the existing corporate data warehouse: backups, batch jobs, performance tuning, and schema changes
• Define, implement and maintain ETL procedures and schedules to ensure the accuracy and timeliness of data in the data warehouse and various data marts
• Ensure the quality, consistency and security of company data and data warehouse systems following a defined set of procedures and facilities (change control, security procedures, backups, etc)
• Troubleshoot and recover down data warehouse and data mart systems
• Analyze, resolve end user / system reported problems and communicate problems and their resolution to the team.

Requirements:

• B.S. Degree in Engineering, Computer Science/Information Technology or equivalent with at least five (5) years of verifiable experience in database and data warehouse administration
• Intermediate/advanced SQL skills required
• Demonstrated participation in at least one successful data warehousing projects involving inception, design, deployment and management preferably using Essbase
• Experience in data transformation / conversion / loading / unloading using ETL tools such as Informatica is preferred
• Ability to work with minimal supervision
• Highly analytical and strong problem solving skills
• Ability to interface with all levels of internal customers and external vendors
• Well organized, pro-active and a self starter; able to perform with minimal supervision independently and as part of a team
• Excellent verbal and written communication skills
• Results and Performance Driven
• Experience with Financial / Trading Systems preferred.

Tags: Data Warehouse, DBA, Informatica, SQL