Database Administrator

(En français ci-dessous)_
- 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 Experience Management (XM) solutions because we believe that each experience matters. _

**What you will do as our new Database Administrator**:

- Manage SQL Server databases 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
- Capacity planning
- Perform scheduled maintenance and support release deployment activities including off hours.
- Performance monitoring

**What you need to succeed in that role**:

- 7+ years MS SQL Server Administration experience required
- PowerShell knowledge for process automation
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Azure SQL experience
- Experience working with Microsoft OLAP architectures
- Experience with Clustering
- 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
- Excellent written and verbal communicationFlexible, team player, “get-it-done” personality
- 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 and geographic office (North America, Europe, Australia, Asia) MCTS, MCITP, and/or MVP certifications a plus
- Azure components knowledge as Logic apps, elastic jobs, analytics etc.
- Excellent T-SQL knowledge
- Passion for technology and problem solving
- Ability to function under pressure

**_ Kindly note that employment is contingent upon receipt of a satisfactory background and reference check._**

**About Explorance**

Explorance is a provider of innovative experience measurement solutions. The company empowers organization’s decision-making for action by measuring employee and student voice and feedback. Through scalable automation with tools including the Blue ® solutions and Metrics That Matter, and expert-based services, Explorance facilitates continuous improvement and accelerates the insight-to-action cycle, leading to personal growth and organizational agility.

Founded in 2003, Explorance is headquartered in Montreal with business units in Chicago, Chennai, Melbourne, Amman, and London. Explorance works with 35% of the Fortune 100, and 25% of the top higher education institutions, including 8 of the world’s top 10 business schools. The company has clients in more than 40 countries. Since 2014, Explorance has been ranked consecutively as a top employer by the Great Places to Work Institute® and is currently ranked as the #1 “Best Workplace in Canada” for 2021.

Are you curious to get to know more about our approach and products? Check out our website.

******
- Joignez-vous à une entreprise avec un siège social situé à Montréal et qui aide des organisations du monde entier à établir un cheminement personnalisé qui favorise un impact et un accomplissement réels pour tous. Explorance offre des solutions innovantes de gestion de l’expérience (XM), car pour nous, chaque expérience compte._

**Ce que vous ferez en tant que notre nouveau.elle Administrateur.trice de base de données**:

- Gérer les bases de données de SQL Server à l’aide de plusieurs environnements de cycle de produits, en passant du développement aux systèmes de production essentiels à la mission.
- Installer