MSSQL DBA(Performance Tuning

4 hours ago


Montreal Quebec, Québec, Canada Atlantis IT Group Full time

Role : MSSQL DBA(Performance Tuning & Replication)

Location : Montreal, QC

1 yr Contract

Onsite


Microsoft SQL Server Database Administrator (MSSQL DBA) + Strong knowledge in Performance & Tuning + Replication

Role name: Engineer

Role Description: Site Reliability Engineers (SRE) need database platform experience ( MSSQL), service maintenance, monitoring, process automation and incident management skill.


The key focus of this role is upon system reliability, availability, performance, and scalability.

Day to Day Operations:

1] HIGH Priority PROD Ticket Support / Database Outage Handling

2] Weekend Support

3] Change Management

4] Bug Fixes with Microsoft

5] Consultation to Users / other support team / L2 Team

6] Handling Projects ( like DB migration , Host level upgrades / migrations )

7] Script changes8] Other Technology Support ( like Delphix / HVR / RTDS )

9] L2 Runbook review

10] Medium / Low PROD/Non-PROD Escalation Handling from L1/L2 team

11] Escalation Reduction / Problem Managementt

12] Provides Training to L2/L1


teamSkills Required :

Ability to perform day to day database administration tasks with deep understanding of SQL Server internals e.g. Indexing, partitioning , filestream , Always-On , replication cctv and Mirroring technologies.

Troubleshoot and provide advice on SQL Server performance issues and be able to work with application development teams and provide recommendations.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools

Knowledge of relational databases, T-SQL, query execution plans, solving concurrency issues and deadlocks

Knowledge of administrating azure SQL databases is an added advantage.

Good communication skill and experience to handle P1/P2 outages.

MSSQL DBA Certification will be added advantage

Good in Powershell.


- Site Reliability Engineering (SRE), IT IS_AMS_Database_MS SQL Server



  • Montreal, Quebec, Québec, Canada Atlantis IT Group Full time

    Role : MSSQL DBA(Performance Tuning & Replication)Location : Montreal, QC1 yr Contract Onsite - Microsoft SQL Server Database Administrator (MSSQL DBA) - Strong knowledge & Experience in Performance Tuning & Replication


  • Montreal, Quebec, Québec, Canada Experience AI Solutions Full time

    Senior DBAStart Date: as soon as possibleType of employment: permanentLocation: Montreal, QC (hybrid position; 3 days onsite per week)Number of Positions: 1Language skills: Excellent English language skillsPerks: work for a multinational, award winning, socially responsible company with an operational presence in many countries, having been in business for...


  • Montreal, Quebec, Québec, Canada BlueRose Technologies Full time

    Description : This is an experienced Oracle Database Administrator position where the individual will be responsible for overseeing and managing the Oracle databases. In addition, this DBA will be responsible for providing 2nd and 3rd level support for all DB related issue or outages. Ensures the smooth operation of the infrastructure in order to provide...


  • Montreal, Quebec, Québec, Canada LanceSoft, Inc. Full time

    Skills Required:- Knowledge of all CICS parameters that control performance in a CICSPlex environment.- Knowledge of SMP/E, software upgrade and maintenance- Knowledge of CICS SMF record structure and the CICS Performance Analyzer tool to gather statistics necessary to tune CICS regions- Experience with CICSPlex SM implementation & customization, dynamic...


  • Montreal, Quebec, Québec, Canada Resonaite Full time

    Our client in the professional services industry is looking for a Python Automation developer on a contract basis.Location: Hybrid MontrealDuration: 12 monthsResponsibilities:Design, develop, and implement Python-based automation solutions to support data migration from unencrypted to encrypted devices.Collaborate with cross-functional teams to capture and...

  • Python Developer

    4 weeks ago


    Montreal, Quebec, Québec, Canada Quarry Consulting Full time

    Title: Bilingual Python DeveloperDuration: 10-monthsLocation: Downtown Montreal - hybrid 3x a week on-siteResponsibilities: As a Python Developer you will be working on the Data at Rest Encryption Program, Enterprise Computing's most prominent and highest priority program. You will be supported by a lead developer and working with another peer developer...

  • Java Software Engineer

    2 months ago


    Montreal, Quebec, Québec, Canada Q1 Technologies, Inc. Full time

    Role: Java Software Engineer (Montreal local only)Location: Montral This is a hybrid (on-site 3 days/week) role based in Montreal, Quebec.Role and Responsibilities:Design, develop, test, and deploy Java-based software applications using the Java Spring and Spring Batch frameworksUtilize Spring framework to build scalable and high-performance...

  • Java Software Engineer

    2 months ago


    Montreal, Quebec, Québec, Canada Bestinfo Systems LLC Full time

    Java Software Engineer_Montreal, Quebec Canada_Full-Time-Hybrid (on-site 3 days/week)_Direct HireRole: Java Software EngineerLocation: Montreal This is a hybrid (on-site 3 days/week) role based in Montreal, QuebecJob Type: Full-TimeJob Description:Role and Responsibilities:*Design, develop, test, and deploy Java-based software applications using the Java...

  • Database Administrator

    3 months ago


    Montreal, Quebec, Québec, Canada Squarepoint Capital Full time

    Department: Application EngineeringPosition Overview: Platform Applications Specialists Database role will be part of a global systems team responsible to deliver highly available, high-performance, and scalable infrastructure to support trading and research using the DevOps methodology.As part of this role will be focused on working collaboratively with...

  • Lead Java Developer

    5 hours ago


    Montreal, Quebec, Québec, Canada Accolite Full time

    Opening from Canada (Remote)Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership.Bounteous x Accolite brings together 5000+...


  • Montreal, Quebec, Québec, Canada Axelon Services Corporation Full time

    Mainframe Infrastructure Metrics EngineerMontreal,QC 12 Months Contract PositionJob Description:The Mainframe Infrastructure Capacity Planning Engineer will be responsible for ensuring the observability, performance, and efficiency of our mainframe systems. You will use your expertise in observability, performance optimization and data analysis to ensure our...


  • Montreal, Quebec, Québec, Canada VLink Inc Full time

    Title: Senior Front-end/ Lead UI DeveloperLocation: Montreal, QCDuration: Long Term ContractJob Description:Required Skills:12+ years of experience in Web UI development, 3+ years of experience in ReactJs.Proficient in JavaScript ES6, ReactJs, Redux, CSS3, HTML 4&5, Bootstrap, HTTP, Cookies, NodeJS, cypress, React Testing Library.Experience in performance...


  • Montreal, Quebec, Québec, Canada Eviden Full time

    Job Role: Senior Cloud DeveloperLocation: Montreal, CanadaType: FulltimeJob Description: -6-8+ years of hands-on professional experience using Python, Golang, Java or JavaScript/TypeScript2+ years of experience with globally dispersed teams that fall across different time zones Solid understanding of object-oriented design and developmentProficient with...


  • Montreal, Quebec, Québec, Canada LanceSoft, Inc. Full time

    Job DescriptionThe Mainframe Infrastructure Capacity Planning Engineer will be responsible for ensuring the observability, performance, and efficiency of our mainframe systems. You will use your expertise in observability, performance optimization and data analysis to ensure our mainframe infrastructure operates efficiently and effectively identifying both...

  • React Redux Developer

    4 weeks ago


    Montreal, Quebec, Québec, Canada VLink Inc Full time

    Job Title: React & redux DeveloperLocation: Montreal, QCEmployment Type: ContractAbout VLink: Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its inception, our innovative team members have been solving the most complex business, and IT challenges of our global...

  • Java Developer

    4 weeks ago


    Montreal, Quebec, Québec, Canada Vaco Full time

    Job Title: Senior Back-End Java DeveloperResponsibilities:Design, develop, and maintain back-end applications and services using Java (11 or later), Spring Boot MVC, and Microservices development.Develop complex multi-threaded applications and implement design patterns to ensure high performance and scalability.Integrate and manage PostgreSQL databases,...


  • Montreal, Quebec, Québec, Canada VLink Inc Full time

    Job Title:Senior Front-end / UI Developer Location: Montreal, QC (Face-Face Interview Required)Employment Type: (Full-time or contract)About VLink: Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its inception, our innovative team members have been solving the...


  • Montreal, Quebec, Québec, Canada QUANTEAM Full time

    About the Company:As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris,...

  • Database Engineer

    4 weeks ago


    Montreal, Quebec, Québec, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Network Team Lead

    4 weeks ago


    Montreal, Quebec, Québec, Canada MTY Food Group Full time

    Job Title: Network Team LeadJob Type: Full-time, Hybrid (Two days in office) Location: Saint-Laurent, QC, Richmond Hill, ON, Phoenix AZ, or Vancouver, WA About The WorkWe are seeking a highly experienced Network Team Lead to manage and support our global network and firewall infrastructure. In this role, you will take full ownership of designing,...