SQL Deployment Developer

Company: Direct IT Recruiting Inc.

Location: Mississauga

Status: Permanent

Job Reference No: 596

Job Category: SQL Developer, IIS, Jenkins, .NET

Career Level: Intermediate to Senior

Number of Staff to Supervise: N/A

Work Experience: 7+ years SQL 2008-2016 Developer, T-SQL, SQL Queries, SSIS, BCP, tables, views, stored procedures, functions, triggers, SQL Server Profiler, SQL Agent, Jenkins, Confluence, BitBucket, JIRA, .NET, JavaScript, IIS, Azure, Redgate

Industry: Software Development

Apply

 

SQL Deployment Developer  

 

Job Title: SQL Deployment Developer

Company: Direct IT Recruiting Inc.

Location: Toronto

Status: Permanent

Job Category: SQL Developer, IIS, Jenkins, .NET

Career Level: Intermediate to Senior

Work Experience: 7+ years SQL 2008-2016 Developer, T-SQL, SQL Queries, SSIS, BCP, tables, views, stored procedures, functions, triggers, SQL Server Profiler, SQL Agent, Jenkins, Confluence, BitBucket, JIRA, .NET, JavaScript, IIS, Azure, Redgate

Industry: Software Development

                               

DESCRIPTION:

Seeking a SQL Deployment Developer to become a member of the deployment team.  The candidate will work in a fast-paced environment with a team of software professionals to deploy state-of-the-art web-based business applications for customers.  The work is focused on deploying, configuring and testing web and SQL Server objects and data to customers’ systems.  Each deployment is unique because our software is customized for each customer.

RESPONSIBILITIES:

- New product development, product enhancement, maintain and support SQL Server programs (complex stored procedures, user-defined functions) used in applications.

- Develop and maintain SQL Server 2008-2016 objects, especially complex stored procedures and functions.

- Perform impact analysis in order to determine differences between existing deployed web/SQL Server applications and new applications to be deployed.

- Deploy database objects (tables, views, stored procedures, triggers, SQL Agent jobs etc.) into new and existing databases.

- Deploy data into SQL Server databases, including loading new data, merging new and old data, and migrating data from one environment to another.

- Configure SQL Server and IIS to meet application requirements.

- Confirm customer server readiness for deployments, including connectivity, operating system and server software requirements.

- Perform server configuration as required, including Windows Services, ODBC connections, registry entries, web config files, file system access.

- Deploy web application components (web pages, configuration files, application pools, SMTP integration).

- Perform preliminary deployment testing and troubleshoot issues with new deployments.

- Communicate and build strong relationships with team members.

- Take care to ensure that changes to customer environments will not negatively impact their operations.

- Be a very strong team player who knows what has to be done and takes the initiative to ensure the success of the team and the customer.

- Be able to multitask and work on more than one project at a time when schedule demands require it and workload allows it.

- Understand the need for extra effort and be willing and able to do what it takes to ensure success.

- This position will sometimes require after-hours and weekend availability.

SKILLS:

- University or college degree/diploma in a Computer Science or Business discipline or equivalent work experience.

- Experience developing or supporting Microsoft SQL applications.

- Experience working with Microsoft SQL Server 2008 R2 to 2016.

- Experience with installing and configuring IIS including version 7 and later.

- Experience manipulating SQL Server data (ETL, SQL queries, SSIS, BCP).

- Experience with SQL Server Profiler and SQL Agent.

- Full Stack developer experience (web apps, ASP.NET, JavaScript, AngularJS, NodeJS, jQuery, complex T-SQL, SQL stored procedures)

- Provide technical leadership

- Excellent English verbal and written skills

- Experience developing with any of ASP.NET, C#, HTML, JavaScript, WCF, TSQL, JQuery, JSON, XML is an asset

- Experience with SQL Server backup and restore, SQL Agent job scheduling a definite asset.

- Experience with Redgate SQL tools

- Experience with PowerShell

- Experience with SQL Server Profiler

- Experience with Confluence, BitBucket, JIRA

- Experience with Jenkins, Octopus Deploy and or TeamCity

- Proficiency with Google applications (Gmail, Google Drive, Google Calendar)

- Proficiency with Microsoft Office applications (Word, Excel, Outlook)