Previous Job
ArDOT SQL Database Developer
Ref No.: 18-06350
Location: Little Rock, Arkansas
Start Date / End Date: 10/01/2018 to 09/28/2019
Engagement Type: Contract

Short Description:The SQL Server DB Developer will be responsible for performing up front profiling and source target mapping that comprehensively documents data lineage, data flow and transformation solution design. Including the migration of DTS and SSIS packages.

Complete Description:Local candidates preferred but not required.

•Bachelor's Degree in Computer Science or related technical field
•The right candidate will have strong SQL Server experience with specific DTS and SSIS upgrade knowledge.
-Experience upgrading SQL 2008R2 or SQL2005 DTS/SSIS packages to SQL 2012 - 2017
-Ability to modify existing packages to support ongoing system and business changes
-Ability to participate in code review, analysis, and execution of packages and stored procedures to re-factor
inefficient code
-Ability to troubleshoot problems with existing packages running on SQL 2008R2 and SQL 2012
-Document all aspects of migrated and new SSIS packages and security required for future maintainability
•Follow data standards and architectural patterns to resolve data issues
•Experience writing reports in Reporting Services
•Experience with clustered servers
•Experience in data backup and recovery procedures
•Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource
•As performance issues arise, determine the most effective way to increase performance including server
configuration changes or index/query changes
•Knowledge of SQL Server tools (profiler, SSMS, Perfmon, DMVs, System procs)
•Ability to prioritize and manage concurrent projects, demonstrate initiative, work with DBA team and
independently with minimal supervision
•Strong written and verbal communication skills

Required / Desired Skills
Skill Required / Desired Amount of Experience
SQL 2012, 2008 R2, & 2005 Required 10 Years
SQL Server Integration Services (SSIS) Required 6 Years
Upgrading SQL 2008R2/SQL2005 DTS/SSIS packages to SQL 2012 – 2017 Required 3 Years
SQL Server Reporting Services (SSRS) Required 3 Years
Visual Studio 2012 or above Required 4 Years
Redgate SQL tools Required 3 Years
SQL 2014 – 2017 Highly desired
Team Foundation Server (TFS 2018) Highly desired
Certifications Required