Ms-SQL Database Administrator

1 week ago


Montréal, Canada Explorance Full time

Join a Montreal headquarter company that helps organizations around the world create a personalized journey of impact and fulfillment for their people. Explorance offers innovative People Insight Solutions because we believe that each experience matters.

Currently, we are looking to add a Database administrator to join our growing CloudOps team.

**What you will do as our new Database Administrator**
- Manage SQL Servers and databases in our private datacenter through multiple product lifecycle environments, from development to mission-critical production systems
- Install, Configure, and maintain database servers and processes, ensuring high levels of performance, availability, and security
- Configure, tune (performance/cost) and manage Azure SQL DBs and storage accounts
- Develop monitoring tools to achieve better visibility of the DB systems
- Proactively improve DB processes
- Deployment code review and suggest performance enhancements
- Setup/monitoring/fixing/analyzing/troubleshooting AlwaysOn/clusters
- Experience working on SQL Server including SSIS / SSRS / SSAS - MUST
- Experience in ETL development, report development, data extractions, transformations & deployment
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Database backup and recovery strategies and implementation
- Refine and automate regular processes, track issues, and document changes
- Data migration, transformation, and scripting
- Write technical design and partial architectures
- Troubleshooting production issues and bug correction
- Follow and participate in Explorance development standards and guidelines
- Become a leader, specialist, and evangelist in the following areas:

- Data handling specialist
- Teach and help developers with complex query tuning and schema refinement
- Database security (e.g. TDE) and auditing abilities (i.e. CDC)
- Capacity planning
- Perform scheduled maintenance and support release deployment activities including off hours.
- Performance monitoring

**Here's what you'll bring to the role**
- MS SQL Server Administration supporting hundreds of databases experience required
- Experience with Clustering is mandatory
- PowerShell knowledge for process automation
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- AzureSQL experience is a must
- Azure components knowledge such as Logic apps, elastic jobs, analytics etc.
- PostGreSQL experience is nice to have
- Experience working with Microsoft OLAP architectures
- Web Application architecture fundamentals
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server - e.g. Always ON troubleshooting
- Experience working with Windows server, including Active Directory
- Flexible, team player, “get-it-done” personality
- MCTS, MCITP, and/or MVP certifications a plus
- Excellent T-SQL knowledge
- Passion for technology and problem solving
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- Ability to multi-task and context-switch effectively between different activities, teams while supporting different geographic offices (North America, Europe, Australia, Asia)
- Ability to function under pressure
- Excellent written and verbal communication

**Other Requirements**
- At Explorance, we take inclusion to heart and live it each day. We put the ‘human’ first in everything we do and take pride in our authenticity and culture of inclusion. We therefore encourage persons of any race, religion, ethnicity, gender identity, sexual orientation, age, immigration status, disability or other applicable legally protected characteristics to apply. We make employment-related decisions without regard to any of these characteristics. And to ensure a safe workspace for all our employees, all employment is contingent upon receipt of a satisfactory background and reference check._

**About Explorance**

Founded in 2003, Explorance supports more than 20 million people in their individual journeys of purpose, growth, and impact. As the leading provider of Feedback Analytics Solutions, Explorance empowers organizations with actionable decision-making by measuring students’ and employees’ needs, expectations, skills, knowledge, and competencies. Explorance facilitates continuous improvement and accelerates the insight-to-action cycle leading to personal growth and organizational agility. Headquartered in Montreal with business units in Chicago, Chennai, Melbourne, Amman, and London. Explorance works with 25% of the Fortune 100 and 30% of the top Higher Education institutions, including 8 of the world’s top 10 business schools. The company has clients in more than 50 countries.


  • Sr DBA

    Found in: Jooble CA O C2 - 7 days ago


    Montréal, QC, Canada CG Consulting Group Full time

    Sr DBA - MS SQL This is with a global IT services firm for a leading health services firm Candidate must have legal work status – Citizenship, Green Card, TN or H1 Remote work, WFH, but must be located in California, USA. Work zone is Pacific Time / PST zone. 6 months contract, possible extension. Market rate Description: In addition to the...


  • Montréal, Canada CTConsultants Full time

    **CTC007099 - Database Administrator - Intermediate IT**: **Secteur industriel: Telecommunications**: **Type d'emploi: Contract**: **Durée: Two months**: **Mode de travail: On Site**: **Description**: IMPORTANT Is this work from home? (please provide details and when/if to return to office) - Work from home, except the initial setup requires the person to...


  • Montréal, Canada DataPattern Inc Full time

    JOB DESCRIPTION: - Involved in production/Stage/development environment setup, configuration and support of db2/Sybase/oracle/Sqlserver and other RDBMS; - Installation, configuration and upgrade of d**b2/Sybase/oracle/Sqlserver and other RDBMS products;**: - Perform database troubleshooting and performance monitoring; - Proactive and reactive management of...


  • Montréal, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Engineer

    Found in: Jooble CA O C2 - 2 weeks ago


    Montréal, QC, Canada Talent Toppers Full time

    We are urgently looking for “ Database Engineer ” for one of the fastest growing “Cloud Engineering Company”. Job Overview: Role: Database Engineer Experience: 8 - 12 Years Type: Permanent Work Mode: Remote Roles And Responsibilities: In this role as an experienced Database Engineer, you will have opportunity to work with our customers in...


  • Montréal, Canada Aylo Careers Full time

    We are an international tech leader developing unparalleled technologies for high traffic and high volume online products which includes one of the top 10 biggest brands in the world. Our Data Warehouse Team is looking for an Azure Data Engineer/SQL Developer. You will be working as part of a team within a dynamic, fun, challenging and creative environment...


  • Montréal, Canada Itergy Full time

    French description to follow - **Database administrator / DBA** A Microsoft (MS) partner, Itergy has built an enviable reputation with its skills in the design, integration and management of MS architectures for large and very large enterprises, always according to industry best practices. Our strong Managed Services and Project Management teams support our...


  • Montréal, Canada Tata Consultancy Services Full time

    **About TCS** TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and...

  • Dba, SQL

    2 weeks ago


    Montréal, Canada Renaud-Bray Full time

    Description de l'entreprise Avec un réseau de plus de 60 magasins et trois centres de distribution, Renaud-Bray est le chef de file de la vente de produits culturels au Québec. L’entreprise a été reconnue comme l’une des sociétés les mieux gérées au Canada et constitue l’entreprise culturelle la plus admirée des Québécois. Renaud-Bray est...

  • Développeur SQL

    Found in: Jooble CA O C2 - 1 week ago


    Montréal, QC, Canada JobItUs Full time

    Work Experience: 3.0 Year(s) Function: IT Software - Project & Program Mgt / Other Hands on Programming experience on Java, JSP, XML In-depth knowledge on Windchill Data Model Knowledge on Oracle Database and SQL Leading IT Company in India( CMM 3 level MNC)

  • Project Manager

    7 days ago


    Montréal, Canada Database Technology Full time

    **Job Title: Project Manager (FMCG-IR)** **Location: Montreal, QC** **Role/Job Description**: - Collaborating with other department leaders to define, prioritize, and develop projects. - Planning project management, including setting deadlines, prioritizing tasks, and assigning team members to various deliverables. - Status of milestones and deliverables...


  • Montréal, Canada RamzeeTech Full time

    Job Overview: **Responsibilities**: - Install, configure, and maintain operating systems, software, and hardware components - Monitor system performance and troubleshoot issues - Perform regular backups and ensure data integrity - Collaborate with IT teams to resolve technical problems - Upgrade systems with new releases and models - Evaluate and modify...


  • Montréal, Canada St. George's School of Montreal Full time

    **Database & Donations Associate** Full-time replacement position from April 11, 2023 to June 28, 2024 (possibility of extension) **Description**: Under the guidance of the Director of Advancement, the Database & Donations Associate is responsible for the upkeep of alumni, prospect, and donor data, including all gift entries, donor receipts, donor pledge...


  • Montréal, Canada Digital Plus Solutions Full time

    **Job Overview**: We are seeking a skilled Systems Administrator to join our team. As a Systems Administrator, you will be responsible for the installation, configuration, and maintenance of our organization's computer systems. You will ensure the smooth operation of our IT infrastructure and provide technical support to our...


  • Montréal, Canada Nixa Full time

    **What to do as a System Administrator** We are looking for an experienced System Administrator to help us build and manage functional systems that improve customer experience. You will be responsible for deploying product and solution updates, managing and automating common and repetitive daily systems administration tasks, identifying and resolving...

  • Data Analyst

    4 days ago


    Montréal, Canada Tekwissenllc Full time

    **Principal Duties**: - Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions - Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples) - Perform problem analysis,...

  • Expert Lotus Notes

    2 days ago


    Montréal, Canada NOVIPRO Full time

    English version below **Novipro**, une entreprise de services-conseils en technologies de l'information, est actuellement à la recherche d'un expert en Lotus Notes pour l'un de nos clients externes. Si vous êtes passionné par les systèmes IBM Notes et que vous possédez une solide expertise dans ce domaine, cette opportunité pourrait vous intéresser. ...


  • Montréal, Canada MPH Solutions Full time

    We are seeking a highly organized and detail-oriented Administrative Assistant to join our accounting firm. In this role, you will be responsible for providing comprehensive administrative support to the Founding Partner, as well as managing accounts receivables. **Responsibilities**: - Assist the Founder with various administrative tasks, including...

  • Senior Database Admin/Architect

    Found in: Jooble CA O C2 - 1 week ago


    Montréal, QC, Canada Prestige Staffing Full time

    MongoDB Administrator - Data Engineer permanent with Genpact in Montreal, QC Hybrid - 2-1 days onsite downtown Montreal, QC location Pay: CAD C$90,000 to C$100,000 w/full benefits Seniority Level - Mid-Senior Minimum Education - Bachelor's Degree Montreal, QC (Day one on-site on Hybrid) Duration: Full-time role This position is for a data...

  • Administrateur de base de données senior

    Found in: Jooble CA O C2 - 2 weeks ago


    Montréal, QC, Canada Talan Full time

    Administrateur de base de données senior - SYBASE SQL Talan est un cabinet de conseil en innovation et transformation par la technologie. Depuis plus de 20 ans, Talan conseille les entreprises et les administrations, les accompagne et met en œuvre leurs projets de transformation et d’innovation en France et à l’international. Présent sur cinq...