We are currently seeking a Database Administration Specialist to join our team in Tiverton, Ontario (CA-ON), Canada (CA).
Job Description: Database Administration Specialist (Oracle/SQL server)
Hybrid in Tiverton, Ontario
A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.
Minimum 6 years of progressive database administration experience, including production support, performance tuning, backup and recovery, disaster recovery planning, and database maintenance activities.y
Responsibilities
- Manage and administer production, QA, and development database environments ensuring high availability and optimal performance.
- Perform database performance tuning, query optimization, indexing, and capacity planning to improve system efficiency.
- Perform Oracle RMAN and SQL Server backup/recovery operations and regularly validate restoration procedures.
- Manage Oracle and SQL Server security, user access, roles, and database permissions.
- Implement and maintain backup, recovery, and disaster recovery (DR) strategies to ensure business continuity.
- Monitor database health, storage utilization, replication, and system performance using enterprise monitoring tools.
- Plan and execute database upgrades, migrations, patching, and maintenance activities with minimal downtime.
- Troubleshoot and resolve database incidents, performance bottlenecks, and data integrity issues within defined SLAs.
- Collaborate with application, infrastructure, and security teams to support releases and system enhancements.
- Develop and maintain database standards, documentation, SOPs, and operational runbooks.
- Support compliance, audit, security, and access management requirements across database platforms.
- Participate in on-call support and provide proactive recommendations for continuous service improvement.
Requirements and skills
- 6+ years of hands-on experience as a Database Administrator supporting enterprise-scale production environments.
- Strong hands-on experience administrating Oracle Database and Microsoft SQL Server environments, including installation, configuration, performance tuning, backup/recovery, patching and upgrades.
- 6+ years of experience with database backup/recovery, replication, clustering, and high-availability solutions.
- Proven expertise in SQL query tuning, performance troubleshooting, and database optimization.
- 6+ years of experience supporting mission-critical applications in 24x7 production environments.
- Knowledge of cloud database technologies (Azure SQL, AWS RDS, Oracle Cloud, etc.) is an asset.
- 6+ years of experience with database monitoring and administration tools.
- Familiarity with ITIL processes, incident management, change management, and release management.
- Excellent stakeholder communication and documentation skills.
- Preferred to have Level1 Security Clearance
Spe cialiste en administration de bases de donne es
Description du poste
Un administrateur de bases de donne es (DBA) professionnel assure le fonctionnement continu et fluide de la base de donne es 24 heures sur 24, 7 jours sur 7. L'objectif est de garantir un flux d'informations fluide au sein de l'entreprise, en prenant en compte a la fois la structure des donne es dorsales (backend) et l'accessibilite frontale (frontend) pour les utilisateurs finaux.
Minimum de 6 ans d'expe rience progressive en administration de bases de donne es, incluant le support de production, l'optimisation des performances, la sauvegarde et la restauration, la planification de la reprise apre s sinistre et les activite s de maintenance des bases de donne es.
Responsabilite s
- Ge rer et administrer les environnements de bases de donne es de production, d'assurance qualite (QA) et de de veloppement en garantissant une haute disponibilite et des performances optimales.
- Effectuer l'optimisation des performances des bases de donne es, l'optimisation des reque tes, l'indexation et la planification de la capacite afin d'ame liorer l'efficacite du syste me.
- Exe cuter les ope rations de sauvegarde/restauration Oracle RMAN et SQL Server, et valider re gulie rement les proce dures de restauration.
- Ge rer la se curite Oracle et SQL Server, les Cliente s utilisateurs, les ro les et les autorisations de base de donne es.
- Mettre en œuvre et maintenir les strate gies de sauvegarde, de restauration et de reprise apre s sinistre (DR) pour assurer la continuite des activite s.
- Surveiller l'e tat de sante des bases de donne es, l'utilisation du stockage, la re plication et les performances du syste me a l'aide d'outils de surveillance d'entreprise.
- Planifier et exe cuter les mises a niveau, les migrations, l'application de correctifs (patchs) et les activite s de maintenance des bases de donne es avec un temps d'arre t minimal.
- Diagnostiquer et re soudre les incidents de base de donne es, les goulots d'e tranglement de performance et les proble mes d'inte grite des donne es dans le respect des accords de niveau de service (SLA) de finis.
- Collaborer avec les e quipes d'application, d'infrastructure et de se curite pour soutenir les de ploiements et les ame liorations du syste me.
- De velopper et maintenir les normes de base de donne es, la documentation, les proce dures ope rationnelles standard (SOP) et les manuels d'exploitation (runbooks).
- Soutenir les exigences de conformite , d'audit, de se curite et de gestion des Cliente s sur l'ensemble des plateformes de bases de donne es.
- Participer au support d'astreinte et fournir des recommandations proactives pour l'ame lioration continue du service.
Profil recherche et compe tences
- Plus de 6 ans d'expe rience pratique en tant qu'administrateur de bases de donne es, en soutien a des environnements de production a l'e chelle de l'entreprise.
- Solide expe rience pratique de l'administration des environnements Oracle Database et Microsoft SQL Server, incluant l'installation, la configuration, l'optimisation des performances, la sauvegarde/restauration, l'application de correctifs et les mises a niveau.
- Plus de 6 ans d'expe rience avec les solutions de sauvegarde/restauration de bases de donne es, de re plication, de mise en grappe (clustering) et de haute disponibilite .
- Expertise ave re e dans l'optimisation des reque tes SQL, le de pannage des performances et l'optimisation des bases de donne es.
- Plus de 6 ans d'expe rience dans le support d'applications critiques au sein d'environnements de production 24x7.
- La connaissance des technologies de bases de donne es cloud (Azure SQL, AWS RDS, Oracle Cloud, etc.) est un atout.
- Plus de 6 ans d'expe rience avec les outils de surveillance et d'administration de bases de donne es.
- Familiarite avec les processus ITIL, la gestion des incidents, la gestion des changements et la gestion des de ploiements.
- Excellentes compe tences en communication avec les parties prenantes et en re daction de documentation.
- Habilitation de se curite de niveau 1 fortement souhaite e.
This posting relates to an existing vacancy within our organization.
NTT DATA provides a reasonable range of compensation for Canada-based positions. The starting pay range for this role is [32-56 $ CAD]. Actual compensation will depend on a number of factors, including the candidate's relevant experience, technical skills, and other qualifications.
This position is eligible for NTT DATA's Employee Assistance Program (EAP) and Discount Perks.
We do not use artificial intelligence tools to screen, assess, or select applicants.
About NTT DATA:
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.
