SQL Developer

Company: Direct IT Recruiting Inc.

Location: Mississauga

Status: Permanent

Job Reference No: 601

Job Category: SQL Developer, Back End Developer

Career Level: Intermediate to Senior

Number of Staff to Supervise: N/A

Work Experience: 5+ years Back End Developer, SQL, noSQL, Complex Stored Procedures, BCP, SSIS, SQL Profiler, SQL Agent, DevOps, RESTful, Agile

Industry: Software Development

Apply

 

SQL Developer  

 

Job Title: SQL Developer

Company: Direct IT Recruiting Inc.

Location: Mississauga

Status: Permanent

Job Category: SQL Developer, Back End Developer

Career Level: Intermediate to Senior

Work Experience: 5+ years Back End Developer, SQL, noSQL, Complex Stored Procedures, BCP, SSIS, SQL Profiler, SQL Agent, DevOps, RESTful, Agile

Industry: Software Development

                               

DESCRIPTION:
 

As a member of our one of our product group teams, the SQL Developer will work in a fast-paced environment with a team of software, service and sales professionals to create, enhance and support state of the art web and mobile applications for our customers.  The work is a highly varied mix of application maintenance, new feature development, new product development and application deployment support.  This position is focused on SQL Server objects and data manipulation for business application products, with occasional contributions to our middle tier and front-end code.

Responsibilities:

As a SQL Developer your responsibilities may include, but are not limited to, the following:

- SQL Server development

- Maintaining SQL Server 2008-2016 objects

- Create interactive visualization tools and dashboards

- Build a highly scalable framework for ingesting, transforming and enhancing data at web scale

- Develop a web services based platform that can grow with the business

- Implement machine learning models that enable customers to glean hidden insights about their data

- Level 2 and 3 application support

- This position will require after-hour and weekend availability occasionally

 

REQUIREMENTS:

- Bachelor's degree in Computer Science or related field

- 5+ years of experience programming in a modern object oriented programming language

- Experience with SQL Server, including complex stored procedures, user defined functions, ETL, data manipulation (SQL, SSIS, BCP)

- Knowledge of SQL Server tools, such as SQL Server Management Studio, SQL Agent and SQL Profiler

- Knowledge of SQL Server backup/restore; SQL Agent job scheduling

- A passion for DevOps and an appreciation for Continuous Integration/Deployment

- A passion for QA and an understanding that testing is not someone else’s responsibility

- Outstanding programming and problem solving skills

- Strong passion for technology and building great systems

- Excellent communication skills and ability to work using Agile methodologies

- Ability to work quickly and collaboratively in a fast-paced, entrepreneurial environment

- Understanding of SQL and noSQL database technologies

- Understanding of structure and usage of RESTful web services

- Experience with service-oriented (SOA) and event-driven (EDA) architectures

 

ASSETS:

- Masters or Ph.D. in related field

- Experience as an open source contributor

- Experience with Akka, stream processing technologies and concurrency frameworks

- Experience with noSQL solutions: Cassandra, HDFS and/or Elasticsearch

- Experience with Data modeling

- Experience with Chef, Puppet, Ansible, Salt or equivalent

- Experience with Docker, Mesos and Marathon

- Experience with distributed messaging services, preferably Kafka

- Experience with distributed data processors, preferably Spark

- Experience with Angular, React, Redux, Immutable.js, Rx.js, Node.js or equivalent

- Experience with Reactive and/or Functional programming

- Understanding of Thrift, Avro or protocol buffers