Administrateur SQL Server & Oracle (Senior)
Company : SII Canada
Location : Montreal, Quebec, Canada
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
Company Overview
Partenaire technologique des grandes entreprises depuis 1979, le Groupe SII est au cœur de l'économie de l'innovation avec 16 000 collaborateurs, une présence internationale dans 20 pays, et un chiffre d’affaires supérieur à 1.621 milliards de dollars canadiens. SII Canada offre à ses clients une expertise technique avancée dans les domaines du développement applicatif, Web et Mobile, de la cybersécurité et du cloud. Nous intervenons également en ingénierie, particulièrement sur les systèmes embarqués dans divers secteurs industriels. Notre ambition : faire évoluer les systèmes d’information et contribuer à la création des produits et services de demain pour nos clients. En tant qu’entreprise de consultation en TI basée au Québec, SII Canada opère dans un environnement mondial où l’anglais est essentiel. Nous restons dédiés à la promotion et au respect de la langue française au sein de notre entreprise.
Essential Responsibilities
- Installation, configuration, management and maintenance of databases.
- Responsible for database health, resiliency, performance tuning and optimization; operational control procedures, support and inventory.
- Work closely with developers and application production support to provide technical help.
- Participate in on‑call duty, handle alerts and escalations during business hours and off‑hours, including weekends and holidays on a rotational basis.
- Setup and maintain database backup and recovery procedures.
- Provide technical documentation.
- Support and implement database changes, ensuring quality of the changes.
- Perform capacity planning for databases.
- Implement and help other team members with group / team strategy.
Compétences techniques (French)
Oracle 19C; Scripts shell Unix; Technologies EMC‑SAN; GoldenGate.Technical Skills (English)
MSSQL 2016–2022, Cluster, AlwaysOn.Postgres.Oracle 19C; RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager.Scripts shell Unix.Linux operating system.Windows Server operating system / cluster.EMC‑SAN technologies.Experience in Agile Methodology.Development Knowledge
PowerShell knowledge.Python knowledge.Unix shell scripting.Knowledge in Agile Methodology.Desired / Plus
MSSQL in Azure.Oracle Exa@CC management.GoldenGate.Experience in other RDBMS (Cassandra, MongoDB, …).Competencies
Experience working in a large, 7×24, investment bank.Must be organized, detail‑oriented, self‑motivated, disciplined, professional, and a team player capable of handling multiple tasks at once in a fast‑paced environment.Excellent written and verbal communication skills; ability to present and explain technical information.Database management experience, including installation, maintenance, migration / upgrades and database refreshes.Database architectural knowledge.Experience Needed
6+ years hands‑on experience on MSSQL (2016‑2022) databases.2+ years hands‑on experience on Postgres.3+ years hands‑on experience on Oracle (19c, 12c) on Unix / Linux.1+ year of development experience.Experience handling large databases.Experience with Oracle Optimizer plans and hints.Experience with MSSQL performance tuning.Experience building automation tools or APIs using Python.Experience with shell scripting and Linux scripts development.Education & Certifications
Bachelor's Degree in Computer Science or equivalent work experience. Desired : Certification in Database administration.
#J-18808-Ljbffr