About the role
The client is a prominent global technology solutions provider, renowned for its comprehensive range of services and products tailored to meet the diverse needs of businesses.
The company's core focus revolves around assisting organizations in managing and optimizing their IT operations, thereby driving productivity, efficiency, and innovation. It offers an extensive array of services, including strategic consulting, technology implementation, cloud computing, data center management, cybersecurity, software licensing, and hardware procurement.
In addition to its business-to-business (B2B) services, it also serves as a valuable resource for IT professionals and decision-makers, providing valuable insights and thought leadership through its various publications, webinars, and events.
Rate:
Job Description:
- We are seeking an experienced SQL Server Migration Specialist to lead a comprehensive database migration project from SQL Server 2016 to SQL Server 2022.
- This is a hands-on technical role requiring deep expertise in database migration, reporting services, and integration platforms.
- You will work independently to ensure a smooth, validated transition of critical database infrastructure and associated components.
- Execute full migration of SSRS (SQL Server Reporting Services) reports from legacy SQL Server 2016 environment to SQL Server 2022, including comprehensive testing and validation
- Migrate and optimize SSIS (SQL Server Integration Services) packages to the new SQL Server 2022 platform, ensuring all workflows function correctly post-migration
- Assess, redesign, and migrate SSIS packages to Azure Data Factory, modernizing data integration processes for cloud-based operations
- Develop, test, and maintain custom scripts and utilities using VB.NET or C#.NET to support migration activities and post-migration operations
- Write and optimize complex queries and stored procedures using T-SQL and PL/SQL
- Conduct thorough testing and validation of all migrated components to ensure data integrity and system functionality
- Document migration processes, configurations, and lessons learned
- Work independently with minimal supervision while maintaining regular communication with stakeholders
- Minimum 5 years of professional experience with SQL Server administration, development, or migration projects
- Demonstrated expertise in SQL Server 2016 and SQL Server 2022 environments
- Hands-on experience migrating SSRS reports and SSIS packages in production environments
- Proven experience with Azure Data Factory and cloud-based data integration
- Strong proficiency in T-SQL and PL/SQL query development and optimization
- Solid programming skills in VB.NET or C#.NET (or both)
- Experience with database migration planning, execution, and validation methodologies
- Ability to work independently and manage multiple migration workstreams
- Strong problem-solving skills and attention to detail
- Experience with SQL Server 2019 or other intermediate versions
- Familiarity with Azure SQL Database or other Azure data services
- Knowledge of data warehousing or business intelligence platforms
- Experience with migration tools such as SQL Server Migration Assistant (SSMA) or third-party migration utilities
- Certifications in SQL Server or Azure
- Ability to sit for extended periods at a workstation (6-8 hours per day)
- Capable of lifting and moving computer equipment, servers, and peripherals up to 50 pounds
- Ability to stand, walk, and navigate server rooms and office environments
- Comfortable working in climate-controlled data center environments
- Capable of performing repetitive tasks involving keyboard and mouse use
- Able to work in a standard office environment with standard lighting and noise levels
- Ability to climb stairs or use ladders if required for equipment installation or maintenance
- No restrictions on ability to work full-time onsite schedule.
Please note that ApTask offers subsidized insurance coverage to our employees.
About ApTask:
ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer:
At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at [email protected].
Applicant Consent:
By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or [email protected]. Message frequency may vary. Msg & data rates may apply