SQL Server Dba

2 weeks ago


North York, Canada Dawn InfoTek Inc. Full time

Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

We are currently seeking competent individuals to fulfill the role of Database Administrator to join our dynamic team for our client, one of the major banks.

**Description**
- Experience with Streaming Analytics, Data Factory and Azure Functions
- Experience with MS SQL 2016/2019, Azure SQL and experience upgrading SQL-based systems
- Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations
- Provides specialized technical expertise in the overall support and maintenance of systems solutions that leverage Windows administration/support and scripting etc.
- Ability to provide post-implementation support and resolve any post-implementation technical issues
- Experience creating, reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
- Debugging MS SQL Scripts/Code in a Windows-based environment including resolving performance issues
- Experience with relational and hierarchical database technologies
- Experience in the use of information retrieval packages using query languages
- Knowledge and experience with Debezium, Streaming Analytics and Azure SQL, Event Hub, Data factory, Data Bricks
- Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
- A team player with a track record for meeting deadlines

**Desirable Skills**:

- Debugging and resolving issues with Change Data Capture (CDC) and SQL 2016/2019
- Experience with middleware and gateways
- Experience conducting design walkthrough sessions with project team
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
- Ability to provide user and system documentation as required

**Must Haves**:

- Experience with MS SQL 2016/2019, Azure SQL and experience upgrading SQL-based systems.
- Experience with Streaming Analytics, Data Factory and Azure Functions.
- Ability to provide post-implementation support and resolve any post-implementation technical issue.
- Knowledge and experience with Debezium, Streaming Analytics and Azure SQL, Event Hub, Data factory, Data Bricks.

**Job Type**: Fixed term contract

**Salary**: $70.00-$80.00 per hour

Schedule:

- Monday to Friday

**Experience**:

- MS SQL 2016/2019: 5 years (required)
- Azure SQL: 5 years (required)
- upgrading SQL-based systems: 2 years (required)

Work Location: Hybrid remote in North York, ON M7A 2T1


  • Mainframe Dba

    7 days ago


    North York, Canada Sun Life Full time

    You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll...


  • North York, Canada YDC PRO Consulting Full time

    **Must haves**: - Proven hands-on experience as a Functional tester for large scale enterprise systems undergoing transformation or being built from scratch. - Knowledge and experience in REST API testing and in use of REST API to create test data and verify expected results. Experience using Rest API clients such as Postman, Curl, SOAP UI - Experience with...

  • Systems Developer

    7 days ago


    North Bay, ON, Canada Ontario Northland Full time

    Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation services. We employ over 900 skilled professionals and are over 120 years old and proud of our heritage and connection to the communities we serve. We are focused on moving forward with the goal of being a valued leader...

  • QA Specialist

    3 days ago


    North York, Canada ydc pro Inc Full time

    Hi All, We are Hiring for **QA Specialist ** position for **Toronto** Location Work type: Contact and Hybrid **Preferred Ministry Exp** Exp: 5+ Years MUST HAVES: - MANUAL TESTER At least 3+ years of experience as a **Functional tester for large scale enterprise systems **undergoing transformation or being built from scratch. - Knowledge and experience...


  • North York, Canada UNIFOR Full time

    Unifor is looking for a Bilingual IT Analyst, Information Technology (Infrastructure and Applications) to join our growing high performing team. In this position, you will play a key role in providing member focused IT Solutions and Services to Leadership and Staff that are aligned with the organizational goals to support and grow the Union. **Duties and...


  • North York, Canada Healthy Planet Canada Full time

    Troubleshoot technical issues in a timely manner (software, networking, occasional hardware issues, performance issues, etc)- - Analyze data (logs, traces) to identify problems and recommend solutionsEnsure the quality of support requests by filtering out erroneous or incomplete requests to ensure that only genuine support issues are escalated- - Maintain...


  • North York, Canada MALISON CONTRACTING INC. SOUS-TRAITANCE MALISON INC. Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years - or equivalent experience **Tasks**: - Respond to users experiencing difficulties with computer - Consult user guides, technical manuals and other documents to research and implement solutions - Provide advice and training to users in response to identified difficulties - Collect,...


  • North York, Canada MALISON CONTRACTING INC. SOUS-TRAITANCE MALISON INC. Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years - or equivalent experience **Tasks**: - Communicate electronically and in person with computer users experiencing difficulties to determine and document problems experienced - Consult user guides, technical manuals and other documents to research and implement solutions - Provide advice...


  • North York, Canada Pinnacle Full time

    Welcome to **Pinnacle**, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position as one of the globe's foremost licensed online gaming companies. With our cutting-edge offerings, we guarantee an electrifying experience that will keep you on the edge of...

  • ERP Administrator

    4 weeks ago


    North York, Canada Gertex Solutions Inc. Full time

    Come join us at GERTEX Solutions and become a part of an agile, entrepreneurial and family oriented business! We offer high quality packaging solutions and supply resources and have been in business for over 30 years! We specialize in providing shipping supplies, packaging supplies, and automated solutions to businesses and organizations. If you are looking...

  • Etl Manager

    4 weeks ago


    North York, Canada RPS Real Property Solutions Inc. Full time

    **ETL Manager** **About this role**: This role will bring value by helping to architect, build and maintain large data pipelines that transform data into RPS standard format. From input, consumption, and output, you will be a key contributor to the end-to-end design and implementation of RPS data requirements **Accountabilities**: - Help scale IT...


  • North York, Canada Nevvon Inc. Full time

    **Integrations Tech Lead** We are looking for a talented team lead/developer to join Nevvon and lead our integrations dev efforts. Reporting to the CTO, this person will join us in building our in-house tech team and scaling our system. If you are looking for the opportunity to grow and create something you can call your own, we are it. **Responsibilities...

  • Full Stack Engineer

    6 days ago


    North Bay, Canada VS Group Full time

    Are you a versatile and talented Full Stack Developer with a passion for building exceptional web applications from concept to deployment? Do you thrive in both front end and back end development, with a keen eye for creating seamless user experiences? About Us: VS Marketing is a prominent marketing agency dedicated to helping businesses excel in the digital...

  • QA Lead

    4 weeks ago


    North York, Canada Advotek Full time

    **Here is the job description** **Job title: QA Lead** **Job type : Full time permanent** **Location : Toronto,ON (hybrid)** What will you be doing? Provide overall end-to-end test management support to enable successful project delivery Lead and perform the following tasks on assigned projects: Provide accurate QA effort estimation to the Project...

  • Full Stack Engineer

    3 weeks ago


    North Bay, ON, Canada VS Group Full time

    Are you a versatile and talented Full Stack Developer with a passion for building exceptional web applications from concept to deployment? Do you thrive in both front end and back end development, with a keen eye for creating seamless user experiences? About Us: VS Marketing is a prominent marketing agency dedicated to helping businesses excel in the...


  • North York, ON, Canada iLobby® Facility & Visitor Management Full time

    Backed by a recent $100MM investment from top VC firm, Insight Partners, iLobby is experiencing rapid growth as the enterprise market leader in the Visitor and Workforce Management space. NET Software Developer who is passionate about technology and is looking to grow their career alongside a team of highly skilled professionals with projects spanning...

  • Data Architect

    4 weeks ago


    North York, Canada Project X Full time

    Role SummaryAs a Data Architect at Project X Ltd., you will be providing clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, and complex business challenges...


  • North Vancouver, Canada VeeRteq Solutions Inc. Full time

    Required Skills: Strong experience in Guidewire Policy Center V10 Configuration, Integration, Rating Engine, product model configuration and GOSU Script development Extensive experience in Guidewire integration mechanisms, Data model, Rules, Configurations, Admin data management, Performance monitoring and tuning, Guidewire application configuration...

  • Business Analyst

    4 weeks ago


    North York, Canada S&V Worldwide Inc Full time

    **Full Job Description** S&V Worldwide Inc. is a privately owned Canadian company with a long history in the consulting and contingent workforce management. Our company's global mission is to be relentless in the delivery of best services to help customer's business profitability and improve their operational efficiency. As a professional IT consulting team...


  • North Battleford, Canada Bralin Technology Soltuions Full time

    The Help Desk Technician is responsible for handling first level support of service requests. This relates to all technology, to include: workstations, servers, printers, networks, and vendor specific hardware and software. The Help Desk Technician will be a first point of contact for client service requests. - Support of disaster recovery solutions -...