SQL 2012, 2008 R2, & 2005,SSIS,Upgrading SQL 2008 R2/ SQL 2005 DTS/SSIS packages to SQL 2012 ,2017,SSRS,Visual Studio 2012 or above,Redgate SQL tools,SQL 2014, 2017,Team Foundation Server 2018
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.
Local candidates preferred but not required.
Local candidates preferred.
Qualifications: â€¢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
-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