Job Directory SQL Developer - Constructive Companies

SQL Developer - Constructive Companies
Chicago, IL

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About

Job Description

Position Summary:

The SQL Developer is responsible for wide range of tasks, which include: migration of data from legacy systems, data cleansing and normalization, development of stored procedures or use of other architectural approaches to provide reliable and secure mechanisms of data access from web applications and microservices, optimization of data access mechanisms to achieve optimal response times including indexing, capacity planning, development of reports

Qualifications:

* Working knowledge of database platforms including MS SQL Server, MySQL or Postgres
* Extensive experience creating stored procedures or triggers
* Experience executing high volume data migrations including data cleansing, deduplication and change data capture
* Ability to identify query performance bottlenecks and resolve them through index creation or other optimization approaches
* Experience creating and reading Entity Relationship Diagrams (ERD)
* Experience maintaining database objects in source control repository (TFS, SVN, Git)
* Proven ability to resolve issues in timely manner
* Flexible to respond adequately to changing requirements invalidating the original plans
* Capacity to handle multiple tasks and manage competing priorities
* Self-motivated with a demonstrated ability to work independently or in a team situation
* Creative and takes innovative approaches to problem solving
* Strong customer-service mentality and goal oriented
* Excellent analytical skills with a high capacity for continuous learning

Qualifications Required:

* Bachelor's degree or related experience
* 5-8 years of experience as a database developer using MS SQL Server
* 3-5 years of experience designing and building databases to support high volumes of transactions

Essential Functions & Responsibilities:

* Extensive experience creating stored procedures and data migration SQL scripts
* Working knowledge of data integration or migration (ETL) tools
* Working knowledge of database reporting tools such as MS SQL Reporting Services, Power BI or Cognos
* Experience creating and tuning high transaction volume (e-Commerce) solutions
* Collaborate directly with business to define and document task requirements

Nonessential Functions:

* Familiarity with Continuous Integration and Continuous Delivery concepts : preferred
* Prior experience working in an agile development environment: desirable
* Familiarity with Big Data concepts and no-SQL databases: desirable
* Prior experience with Jira: desirable

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.