Database architect (SQL/SSIS)

Stafflink
Hamilton, ON
$112.4K-$156.1K a year (estimated)
Full-time

Job Description

Project Overview : The client is seeking a Senior SQL / SSIS Developer / Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs).

The primary goal is to migrate the enterprise-scale infrastructure to standard smaller VMs, ensuring efficient execution and optimization of the SSIS packages within the new environment. Key Objectives :

Architecture and Strategy Development : Develop a comprehensive architecture and strategy for migrating SSIS packages to smaller VMs.

Ensure the new architecture supports scalability, reliability, and performance optimization.

Execution and Implementation : Lead the execution of the migration plan, including the setup of smaller VMs. Ensure all SSIS packages are accurately transferred and functional within the new environment.

Implement best practices for SQL Server and SSIS configuration on the new VMs.

Optimization : Optimize SSIS packages for improved performance on smaller VMs. Identify and resolve any performance bottlenecks or issues that arise during or after migration.

Conduct thorough testing and validation to ensure seamless operation post-migration.

Specific Requirements :

  • SQL Server Expertise : Extensive experience with SQL Server, including setup, configuration, and maintenance. Strong skills in writing and optimizing complex SQL queries.
  • SSIS (SQL Server Integration Services) : Proficient in developing, deploying, and managing SSIS packages. Experience with migrating SSIS packages between different environments.
  • Virtual Machines (VMs) : Knowledge of VM setup, configuration, and management. Experience with optimizing SQL Server and SSIS performance on VMs.

Expected Deliverables :

  • A detailed architecture and strategy document outlining the migration plan.
  • Successfully migrated SSIS packages running on the new smaller VMs.
  • Performance optimization reports demonstrating improved efficiency post-migration.
  • Documentation and training materials for ongoing maintenance and optimization.

Project Timeline :

  • Phase 1 : Assessment and Planning : Conduct a detailed assessment of the current SSIS packages and VM setup. Develop the migration strategy and detailed project plan.
  • Phase 2 : Execution and Migration : Set up and configure smaller VMs. Migrate SSIS packages to the new environment.
  • Phase 3 : Optimization and Testing : Optimize SSIS packages and SQL Server performance on smaller VMs. Perform comprehensive testing and validation.
  • Phase 4 : Documentation and Training : Create detailed documentation and training materials. Conduct training sessions for the client's technical team.

Qualifications :

  • Proven experience as a SQL / SSIS Developer / Architect.
  • Demonstrated ability to develop and implement architecture and strategy for SQL Server and SSIS.
  • Strong problem-solving skills and ability to optimize performance in a VM environment.
  • Excellent communication skills for documentation and training.

By engaging a Senior SQL / SSIS Developer / Architect with these capabilities, the client aims to achieve a more efficient and optimized SQL Server and SSIS environment on smaller VMs, ensuring scalability and performance are maintained at a high standard.

30+ days ago
Related jobs
Stafflink
Hamilton, Ontario

The client is seeking a Senior SQL/SSIS Developer/Architect to manage and optimize their existing SSIS packages on SQL Server and virtual machines (VMs). By engaging a Senior SQL/SSIS Developer/Architect with these capabilities, the client aims to achieve a more efficient and optimized SQL Server an...

570 The Dominion of Canada General
Oakville, Ontario

Travelers is seeking an ETL Software Engineer to join our organization as we grow and transform our Technology landscape. Two years of ETL tools programming/development experience preferred. Two years of working experience in Ab-Initio ETL tool, working knowledge of Python and Infogix. ...

JDRF Canada
Remote, CA
Remote

National Database Administrator. National Database Administrator. Breakthrough T1D if growing our IT team and we’re searching for a new team member who is experienced with CRM databases, for the role of. Develop and deliver reusable user-friendly queries for recurring or ad hoc dashboard views...

KPMG
Canada, Canada

Hands on experience with data processing and analytics using Azure Data Factory, Azure Synapse, Azure Data Lake or Azure Databricks is a plus. Contribute to the design and development of enterprise-level data solutions, including data warehouses, data lakes, and real-time analytics platforms, using ...

Cleo Consulting
ON, Canada

Certifications (10 points)</b></p> <ul> <li>Certified in one or more of the following certifications:</li> <li>Databricks Certified Data Engineer Associate</li> <li>Databricks Certified Professional Data Engineer</li> <li>Microsoft Certifie...

CGI
Ontario, Canada

Are you a Data Architect or a Senior Data Engineer interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you regularly find yourself in conversations on disparate and dispersed data sources and feel the need to create a robu...

Direct IT Recruiting Inc., WBE Canada Certified
Canada
Remote

SKILLS: Senior Developer, Ellucian Banner, PL/SQL, API Development, Ellucian Argos, Cohorts, JavaScript, HTML, CSS. Process Refinement: Evaluating and refining the English and Math processes, ensuring the correct application of transfer credits through the relevant Banner tables (PL/SQL and. Impleme...

Macropus Global
Canada

Oracle Database Administrator/Team Leader. Our client has an immediate need for an Oracle Database Administrator. The Oracle Database Administrator works closely with all data centre professionals and the successful incumbent will be a member of the data center DBA team. Oracle Database Administrato...

SIX Payment Services
Canada

Worldline is hiring a senior database administrator to join our North America IT operations team. As a Worldline DBA, you will be a critical member of the team managing our production and non-production databases. You will build, configure, and optimize SQL Server database engines in a variety of en...

RLDatix
Canada

We’re searching for a Toronto-based Software Developer to join our Global R&D team, so that we can enhance our Human Capital Management stack. The Software Developer will support the development and delivery of high-quality software solutions to drive RLDatix's mission of improving healthcare sa...