Description
Overview of RoleTo design, implement, and support the enterprise data warehouse built up using MS SQL Server . This role will be responsible for the development of logical and physical data models and other data architecture deliverables, as well as designing, documenting, and supporting complex ETL processes.
The role also includes primary Database Administrator (DBA) responsibilities including:
- Owning, tracking and resolving database related incidents and requests
- Reviewing service related reports (eg: service tickets, database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved
- Responding to database related alerts and escalations, database security, data partitioning and working across the IT team to come up with strategic solutions.
This role is anticipated to be split 60% Data Warehousing and 40% DBA.
This person must have extensive Datamodelling experience, proven DBA skills, familiarity with all data warehousing technical components (ETL, Reporting).
Success requires initiating and performing changes in development and production systems and proactively escalating any issues that cannot be resolved within established timeframes.
JOB REQUIREMENTS:
- Bachelor's degree is required.
- 5+ years' experience in data warehouse design and development, Datamodelling, architecture, and mapping
- 3+ years' experience of core database administration in a SQL Server environment. In addition, Oracle database experience would be preferred.
- Advanced knowledge of database performance tuning and Transact-SQL
- Experience in implementing and enhancing operational automation using scripts
- Experience with leader Datamodelling tools, and ability to support Embarcadero ER/Studio
- Experience with leading ETL & BI tools would be preferred, and ability to support ETL Data Integration with external interfaces
- Experience with SQL Server Reporting Services is a plus.
- Work with application developers to design SQL databases, estimate proper table sizes, and document all aspects of the database
- Responsible for the production deployment of stored procedures including code review; maintain proper source control for all database and stored procedure changes
- Must have an in-depth and hands-on experience in troubleshooting and resolving database problems, including working with 3rd party support towards resolution
- Experience with backups, restores and recovery models; demonstrated knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server
- Setup and configure MS SQL databases and maintain the database performance criteria; perform daily monitoring of database performance
To find out more about Computer Futures please visit www.computerfutures.com