Phoenix, AZ - IT - COURTS - N/A - Senior SQL Developer at Abacus Service Corporation
Phoenix, AZ 85007
About the Job
Position Information
Requirements
Standard pre-employment checks per SLA are required.
This posting will be closed on 10/3/2018 @ 3:00pm. At that time, resumes will be pushed to the agency.
Local AND non-local Candidates - Resumes must specify the current location of the candidate, all those who do not state current location will not be considered. - AS A REMINDER - Candidates must be available to interview within 1 week of the posting close date. Candidates must also be able to start by the target start date set down in the offer email. Any non-local candidate must be willing to relocate by the targeted start date at NO FEE to the agency.
Please see the attached Cover letter that will need to be completed and submitted along with the resume. If the cover letter is not attached, or missing the required information, the candidate will be rejected.
Tentative start date will be dependent upon interviews conducted, successful background check process, and the state agency issuing a PO
***The resource MUST be able to clear a 7 year Package A background***
AZCOURTS is looking for a Senior Level SQL Developer.
Job 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
Datawarehouse design principles
Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming.
Participates in integrating activities with other IT departments for successful implementation and support of project efforts
Required 3 years of experience in Visual Studio/C#/VB, SSIS, FS 2015, .Net Framework, WCF, C# and TFS 2015
Required 3-5 years of TSQL/SQL Server
Required 5 years of MS SQL Server 2008-2017
Preferred 3 years of ETL Processing, Repository Pattern, Factory Pattern, Unit Testing, Windows and Visual Studio
Preferred 1 year of Powershell, Non-Relational DBs, Event Sourcing Pattern, Event Store and MQ Series
| Position Type | Staff Augmentation | Hours/Week | 40 |
| Billing Type | Hourly | Shift | Day |
| Projected Start Date | 10/15/2018 | Start Time | 8:00 AM |
| Projected End Date/Duration | 06/30/2019 | End Time | 5:00 PM |
| Bid Limit Per Vendor | 2 | Number of Positions | 1 |
| Desired Career Level | Senior Executive | Minimum Education Level | Bachelor's Degree |
| Weekend | None |
Requirements
| Travel Required | No | Security Required | Yes |
| Onboarding Category | N/A |
| Security Comments |
This posting will be closed on 10/3/2018 @ 3:00pm. At that time, resumes will be pushed to the agency.
Local AND non-local Candidates - Resumes must specify the current location of the candidate, all those who do not state current location will not be considered. - AS A REMINDER - Candidates must be available to interview within 1 week of the posting close date. Candidates must also be able to start by the target start date set down in the offer email. Any non-local candidate must be willing to relocate by the targeted start date at NO FEE to the agency.
Please see the attached Cover letter that will need to be completed and submitted along with the resume. If the cover letter is not attached, or missing the required information, the candidate will be rejected.
Tentative start date will be dependent upon interviews conducted, successful background check process, and the state agency issuing a PO
***The resource MUST be able to clear a 7 year Package A background***
|
Job 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
Datawarehouse design principles
Assist with the debugging and optimization of SQL queries, stored procedures and overall database programming.
Participates in integrating activities with other IT departments for successful implementation and support of project efforts
Required 3 years of experience in Visual Studio/C#/VB, SSIS, FS 2015, .Net Framework, WCF, C# and TFS 2015
Required 3-5 years of TSQL/SQL Server
Required 5 years of MS SQL Server 2008-2017
Preferred 3 years of ETL Processing, Repository Pattern, Factory Pattern, Unit Testing, Windows and Visual Studio
Preferred 1 year of Powershell, Non-Relational DBs, Event Sourcing Pattern, Event Store and MQ Series