Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: The SQL Server Database Developer will be responsible for the migration of SQL databases from MS SQL 2000, 2005, and 2008R2 to MS SQL 2012. This will include the migration of DTS and SSIS packages
Complete Description: Local candidates preferred but not required
No multi-layering subcontractors - Candidates should be direct to submitting vendor
The SQL Server Database Developer will be responsible for the migration of SQL databases from MS SQL 2000, 2005, and 2008R2 to MS SQL 2012. This will include the migration of DTS and SSIS packages.
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.
? Migrate and consolidate approximately 60 databases from three SQL database versions to the SQL 2012 database.
? Upgrade approximately 100 DTS/SSIS packages
? Experience setting up replication
? Experience with clustered servers
? Experience writing database disaster recovery documentation
•Standardize data structures, procedures and processes to provide appropriate databases for migrating web application for other team members
•Experience writing and migrating reports in Reporting Services
•Experience using Change Data Capture (CDC)
•Experience in data backup and recovery procedures
•Documentation of all aspects of the migrated databases, new SSIS packages, and security will be required for future maintainability.
•Provide knowledge transfer to AHTD on SQL 2012 server
•Experience with the Highway Department’s databases and environment
•Ability to comprehend complex technical and logical concepts and adapt quickly to changes
•Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision
•Strong written and verbal communication skills
Skill | Required / Desired | Amount | of Experience |
SQL 2012, 2008 R2, 2005, & 2000 | Required | 10 | Years |
SQL Server Integration Services (SSIS) | Required | 5 | Years |
SQL Server Reporting Services (SSRS) | Required | 3 | Years |
Visual Studio 2010\2012 | Required | 4 | Years |
Team Foundation Server (TFS 2010) | Highly desired |
RedGate SQL tools | Required | 1 | Years |
