Sign in

SQL Developer

Company:
vTech Solution Inc
Location:
Phoenix, Arizona, United States
Posted:
December 05, 2018

Description:

Client: State of Arizona - Administrative Office of the Courts (AOC)

Job title: SQL Developer/SR (Job ID: 53130)

Location: 1501 W. Washington, Phoenix, Arizona

Duration: 8 Months

Interview: In- Person Only

Description:

• Development and implementation of new and existing database solutions

• Create SSIS projects and packages to perform ETL related tasks and prepare SSIS projects for deployment

• Design database import / export processes used to generate client data warehouse deliverables

• Create and maintain conceptual, logical, and physical database models

• Managing and versioning the database projects using Visual Studio Team Foundation Server 2015

• Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration

• Write ad-hoc SQL queries and scripts to support various job functions

• Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming.

Tools

• Windows - Intermediate - 3 years

• PowerShell - beginner - 1 year

• Visual Studio/C#/VB - Intermediate - 3 years

• SSIS - Advanced - 3 years - required

• TSQL / SQL Server - Advanced - 3 to 5 years - required

• MS SQL Server 2008-2017 - Advanced - 3 years - required

• Non-Relational (No-SQL) DBs - beginner - 1 year

• Event Sourcing Pattern, Event Store - beginner - 1 year - required

• ETL Processing, Repository Pattern, Factory Pattern, Unit testing - Intermediate - 3 years

• .Net Framework, WCF, C# - Intermediate - 3 years - required

• TFS 2015 - Intermediate - 3 years - required - Running Unit Tests

• MQ Series - beginner - 1 year