Database Developer Job
Overall Purpose of Role:
The candidate will ideally understand and be experienced in developing SQL and T-SQL in a business intelligence / data warehouse environment. Candidate must also possess an understanding of Data Warehouse / Data Mart ETL principles and best practice using Microsoft SQL Server 2005/2008. Experience working with large volumes of data in an incremental data extraction and process environment is essential.
The candidate will have 5 years commercial experience in a similar role and be able to work on his/her own initiative (within a small team) to develop new data extraction / process routines and extend existing routines within an integrated process framework.
You will need to be based in Dublin for a significant proportion of the role. Please only apply if this is possible.
Responsibilities/Accountabilities:
* Creation, optimization, and scheduling of stored procedures and ETL routines
* Maintenance and optimization of a production database environment
* Assist in requirements clarification
* Source system database analysis
* Preparation of typical data warehouse documentation (data dictionary, source to target mappings)
Skills/Experience Required:
* Must have expert knowledge of TSQL and MSSQL (3+ years TSQL and MSSQL) - Additional experience of other relational database technologies (Oracle / DB2 / MYSQL) will be considered.
* Experience in the full development life cycle of an enterprise data warehouse/mart adhering to star-schema design principles
* Ability to write and understand complex SQL queries
* Ability to develop stored procedures and routines that perform well on large volumes of data
* Performance Tuning – Index Creation and Optimisation
* Unit /System Testing and Data Auditing/Validation
* A systematic approach to development and the ability to work in a fast paced environment
The following, while not essential, are highly desirable:
* A knowledge of Poker and the online gaming industry
* Familiarity with at least one mainstream business intelligence reporting tool (i.e. Business Objects, Cognos, Hyperion)
* Experience using data modeling tools (i.e. Erwin, Visio)
* Experience using an “industry strength” packaged ETL tool (i.e. SQL Server Integration Services)