Job Summary
Senior SQL Server Programmer (58220654)
Location: Toronto, ON Category: Content/Document Management
Job Type: Temporary/Contract Reference: CA_EN_6_17450_58220654
Posted: August 03,2017 Salary: N/A

Print image email image
Apply Now

Modis, on behalf of our client is looking for a Senior SQL Server Programmer
Senior SQL Server Programmer (58220654)
Contract Duration: (7 months)
Location: Toronto, ON
• Act as a Subject Matter Expert around database design, configuration and optimization
• Develop end-user reports using MS-SSRS
• Integrate new data sources into data marts utilizing T-SQL stored procedures, MS-SSIS or third-party ETL tools
• Contribute input to data modeling to ensure that the solution is scalable, highly performing and extensible
• Document the technical design decisions and prepare all required SDLC artifacts
• Play the role of a technical advisor / subject matter expert
• Liaise with the DBA team to ensure a correctly configured and tuned database instance
Required Qualifications/Experience
• Engineering of high throughput DB solutions, employing appropriate design patterns, multi-core processing and administration of large data sets.
• Expert level knowledge of MS SQL Server TSQL, including stored procedures and triggers
• Experienced with Microsoft SQL Server suite of tools – SSIS, SSRS, SSAS
• Prior experience in setting up and administering SQL Server instances an asset
• Prior exposure to IBM DataStage – nice to have
• Able to diagnose and resolve performance issues surrounding CPU, I/O, memory or other contention issues
• Familiar with data modeling techniques, using Erwin or a similar software package
• Post-secondary education ideally specializing in Computer Sciences or an Engineering discipline
• Experience working with business users/clients/developers to perform analysis and recommend solutions.
• Excellent communication skills, both verbal and written
• Ability to plan work and keep to a schedule.
• The successful candidate will be able to work as part of a dynamic group, interact effectively with technical systems and business personnel,
• Adapt/integrate new technologies and broaden the scope of his/her mandate as required to meet the needs of the business
• Previous experience in finance / capital markets an asset
Please note that Candidates must be legally eligible to work in Canada. Your resume will not be forwarded to any of our clients without your explicit permission. We thank all applicants, but only suitable applicants with the above qualifications clearly identified in their resumes will be contacted. Modis Canada is an Equal Opportunity Employer.
We’re at the center of exceptional IT connections. Every day, Modis connects premier IT professionals to great opportunities at leading companies. Put our connections to work for you!

Print image email image
Apply Now