Data Warehouse Manager / Administrator - SQL
- Recruiter
- Recruitment Genius
- Location
- Otley, West Yorkshire, England
- Salary
- £35000 - £40000 per annum
- Posted
- 18 Nov 2015
- Closes
- 16 Dec 2015
- Ref
- 00044681
- Contact
- Callum
- Sectors
- IT, IT Support, Networks & Systems, Testing
- Contract Type
- Permanent
- Hours
- Full Time
This company are looking for a Data Warehouse Manager and Administrator to join their small team, based in Otley, Leeds to manage their database processes.
As a Data Warehouse Manager you will manage the day to day running of their product builds and provide a lead in innovation and development of new products. This will primarily be across a MySQL/MariaDB environment managed via MVC CakePHP software.
This is alongside providing technical support of databases for specific user requirements by developing, implementing, and maintaining data specifications, designs, integration, testing, and documentation.
You will contribute to the translation of business processes into logical designs using data modelling and physical model creation and create, implement, and review complex database structures for assigned systems to meet business and compliance requirements.
Experience:
- 5+ years DBA experience and in-depth knowledge running large Data warehouses
- Proficient with data modeling and creating physical models from logical models
- Ability to create, implement and review complex database structures
- Complex ETL utility functions, using Pentaho
- Ability to tune complex SQL and indexes
- Strong knowledge of backups and recovery
- Ability to trend and report on capacity of assigned systems
They are based in a beautiful Mill by the river in Otley, Leeds. They are a data-driven company which applies analytics to identify, predict and prevent first party fraud, and underlying behaviour that drives un-economic, opportunistic trading by consumers. They are a fast paced company, always modifying what they do to support their staff and customers, and with a 365/7/24 service there may be some on-call time.
Get the Recruitment Genius Advantage today. As the UK's largest online recruitment advertising company placing more candidates than anyone else.
As a Data Warehouse Manager you will manage the day to day running of their product builds and provide a lead in innovation and development of new products. This will primarily be across a MySQL/MariaDB environment managed via MVC CakePHP software.
This is alongside providing technical support of databases for specific user requirements by developing, implementing, and maintaining data specifications, designs, integration, testing, and documentation.
You will contribute to the translation of business processes into logical designs using data modelling and physical model creation and create, implement, and review complex database structures for assigned systems to meet business and compliance requirements.
Experience:
- 5+ years DBA experience and in-depth knowledge running large Data warehouses
- Proficient with data modeling and creating physical models from logical models
- Ability to create, implement and review complex database structures
- Complex ETL utility functions, using Pentaho
- Ability to tune complex SQL and indexes
- Strong knowledge of backups and recovery
- Ability to trend and report on capacity of assigned systems
They are based in a beautiful Mill by the river in Otley, Leeds. They are a data-driven company which applies analytics to identify, predict and prevent first party fraud, and underlying behaviour that drives un-economic, opportunistic trading by consumers. They are a fast paced company, always modifying what they do to support their staff and customers, and with a 365/7/24 service there may be some on-call time.
Get the Recruitment Genius Advantage today. As the UK's largest online recruitment advertising company placing more candidates than anyone else.