Previous Job
Previous
DBA Developer
Ref No.: 18-29741
Location: Toronto, Ontario
Position Type:Contract
Start Date: 04/30/2018
 .        4+ years' experience as a DBA Developer
2.        Domain experience in Insurance (medical) is preferred.
3.        Previous experience working on data feeds and exchange projects is mandatory
4.        Proficiency with Database Development Using:
a.        SQL Server (2012 and above, 2016 experience preferred) –
                         i.      Working knowledge of SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor, BCP and Bulk Load
                          ii.      Strong knowledge of Relational Databases
                            iii.      Database Design, Stored procedures
                         iv.      Experience in coding T-SQL, stored procedures, functions, views and Triggers.
                              v.      Experience in fine tuning queries, procedures and indexes for performance improvement
                                  vi.      Enforce database security, standards & guidelines.
b.        SSIS (ETL) –
              i.      Experience in data migrations, data manipulation, and reporting for end user consumption
             ii.      Ability to export and import data from/to various formats like delimited raw/text file, MS-Excel, XML, SQL Server, MS-Access, etc. Ability to transfer data between various servers and/or data sources
c.        SSRS: Installing and configuring SSRS and development of reports
d.        SSAS  Cube and DWH development is an advantage