30 Aug
|
vTech Solution Canada
|
Toronto
30 Aug
vTech Solution Canada
Toronto
About the RoleWe are seeking an experienced Senior Database Administrator (DBA) to provide operational support, administration, maintenance, monitoring, and optimization of enterprise database environments supporting mission-critical applications and services.The ideal candidate will be responsible for ensuring database availability, performance, security, integrity, and recoverability across multiple database platforms, including Microsoft SQL Server, IBM DB2, and Oracle environments. This role requires close collaboration with infrastructure teams, application support teams, developers, architects, vendors, and project stakeholders to support both legacy and modernized enterprise systems.In addition to database administration responsibilities, the successful candidate will contribute to data architecture discussions, support data-driven decision-making, and help define key metrics and KPIs aligned with business objectives.Key ResponsibilitiesDatabase Operations & SupportProvide day-to-day operational support for enterprise database environments.Monitor database health, system availability, storage utilization, and performance.Troubleshoot and resolve database incidents, service requests, and production issues.Support production, development, testing, disaster recovery, and high-availability environments.Participate in on-call support and after-hours maintenance activities as required.Database AdministrationAdminister, maintain, patch, upgrade, and configure:Microsoft SQL ServerPerform database installations, migrations, refreshes, cloning, and workplace setup.Manage backup, recovery, and disaster recovery processes.Implement and maintain database security, permissions, roles, encryption, and compliance controls.Conduct capacity planning and storage management activities.Performance OptimizationAnalyze and optimize database performance, queries, indexes,
and execution plans.Identify and resolve application and database performance bottlenecks.Support clustering, failover, replication, and high-availability technologies.Implement proactive monitoring and alerting solutions.Change & Release ManagementSupport deployment, release management, and change management activities following ITIL best practices.Maintain technical documentation, operational procedures, and knowledge articles.Participate in technical reviews, root cause analysis, and post-incident investigations.Project & Modernization InitiativesSupport modernization, migration, and infrastructure upgrade projects.Collaborate on database design and implementation strategies.Assist with cloud, virtualization, and hybrid infrastructure initiatives.Support technology lifecycle and upgrade planning activities.Microsoft SQL ServerSQL Server 2019, 2022, 2025Always On Availability GroupsFailover ConfigurationsWindows Server PlatformsIBM DB2DB2 on WindowsOracleOracle 11g & Oracle 19cOracle Enterprise Manager (OEM)Must-Have SkillsStrong hands-on experience with SQL Server 2019, 2022, and 2025Experience with SQL Server Failover ClusteringDeep expertise in Always On Availability GroupsStrong understanding of Backup & Recovery and HA/DR strategiesExperience performing SQL Server upgrades and migrationsHands-on experience with at least one of:Oracle 19cDB2 for WindowsExperience designing and implementing REST API integrationsStrong troubleshooting, problem-solving, and database performance tuning skillsExperience with change management and release management processesNice-to-Have SkillsExperience supporting large-scale enterprise applicationsCloud and hybrid infrastructure experienceAutomation and scripting for database administrationExperience with monitoring and enterprise management toolsRelevant SQL Server, Oracle, or DB2 certificationsExperience in Agile delivery environments#J-18808-Ljbffr
📌 Senior Database Administrator (Toronto)
🏢 vTech Solution Canada
📍 Toronto