RESPONSIBILITIES:
- Ensure that new database code meets company standards for readability, reliability, and performance
- Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
- Design indexes for existing applications, able to choose when to add or remove indexes
- When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
- Conduct SQL Server lunch-and-learn sessions for application developers
- Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, queries and MDX)
- Design and deploy of datamarts, cubes and reports.
QUALIFICATIONS
- Writing and improving SQL Server T-SQL queries for at least a year. You may have technically had “C# Developer” on your job title, but you were known amongst the office as the go-to person for T-SQL questions.
- Designing tables, table partitions, predict table growth during design phase and picking datatypes.
- Design T-SQL code for high performance that satisfy business requirements.
- Using Profiler traces and other tools to find the most frequently run queries
- Understanding of DMV queries to answer questions about database health.
- Must be willing to carry a phone for On-call rotation for troubleshooting for SQL Server service performance, outages and job failures.
- Deciding whether clustering, log shipping, mirroring, replication are the right fit to solve a business problem
- Exposure to build automation tools and continuous integration software using TFS.
- Experience with scripting using PowerShell, IIS Configuration (SSL, Logging, MSDeploy).
- Experience in writing unit tests to support production code using a unit test framework.
- Experience in writing security tests (NIST, OWASP).
- Experience using TFS.
- Experience working on Agile teams using Kanban or Scrum.
- Must have experience with SSAS, SSIS, SSRS and SSRS Web Services.
- Passion for building quality software systems.
- Excellent communication skills in English; both oral and written, French is an asset.
- Effectively work multiple projects and tight deadlines.
- Excellent analytical and creative problem solving, research and reporting skills.
If you are interested in applying please forward your resume and cover letter to contactus@nustaf.com with the job title in the subject line. We thank all that apply however only those who meet the qualifications will be contacted.