|Job Ref:||742e5fe51||Employer:||Direct Solutions - Canada||Country:||Canada||County/State:||Ontario||City:||Toronto||Address:||Post Date:||16/10/2016 23:17|
This is a multi-focused role. The successful candidate will be required to maintain a legacy SQL 2000 database, which is slated for replacement. As such this will include the design and implementation of all database components of its replacement. Initially starting as 75% development, 25% admin moving to almost 100% dev. Furthermore, there is an ETL component to manage all data transformations into and out of SQL Server. This includes all aspects of our Data Warehouse, and Business Intelligence NA legacy SQL 2000 databasesDesign, maintain, and enhance Data WarehouseDesign and implement migration strategy off of SQL 2000Build Business Intelligence reports using existing BI Tool (Domo)Develop and maintain new and existing SSRS and SSIS packagesIntegrate external data sources into SQL ServerHandle database administrative tasks to maintain servers Work Experience/SkillsExtensive experience of SQL Server and its optimizationExperience upgrading from SQL Server 2000 to SQL 2008+Experience designing, implementing, and maintaining data warehousesExperience SSIS, SSRSStrong oral and written communication skillsBI Reporting and Visualization (nice to have) KnowledgeThorough understanding of the Agile Manifesto and Software Development LifecycleProficient knowledge in Team Foundation Server, TFS, Git and SVN
IQ Hunt is a trusted provider of top-tier IT Staff, on a permanent, contract or project basis. We provide top talent, sourced professionally by senior recruiters all backed by our industry leading guarantees. Our quality of hire is second to none.