DBA Developer
Previous Job
Previous
DBA Developer
Ref No.: 18-31889
Location: Toronto, Ontario
Start Date: 05/08/2018


1.        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

5.        Excellent written and verbal skills, "can do” attitude, dedicated troubleshooting efforts, ability to work independently and manage multiple projects.

6.        Power BI reports development is a plus but not mandatory