Hybrid Database Operations Engineer

Posted yesterday

Apply now

About the role

  • Database Operations Engineer coordinating migration to Azure and managing SQL databases. Enhancing operational efficiency and mentoring junior team members in a flexible work environment.

Responsibilities

  • Coordinate, plan and perform database migration activities transitioning from on-premises environments to Azure (PaaS & IaaS) and across Azure subscriptions
  • Lead complex fix or raised technical issues
  • Manage backups, recovery procedures, DBCC utilities, index maintenance job/database refresh
  • Recommend on procedure optimization, performance tuning & index tuning
  • Develop monitoring strategy / implementation pattern focused on SQL database instances in Azure cloud using New Relic
  • Build and maintain customized dashboard and alerts
  • Enhance operational efficiency through the design and adoption of automated tools and Generative AI solutions
  • Works closely with IT project managers, programmers, architects on initiatives
  • Planning, developing, testing and execution of Disaster recovery processes
  • Foster the culture of reliability approach by embarking on opportunities to implement self-healing database solutions
  • Maintain security, compliance, database hardening, encryption standards, audit, and access control frameworks
  • Oversee implementation and maintenance of database setup, installation, configuration & monitoring
  • Consult, guide & mentor junior team members
  • Participate in on-call support rotation including after-hours/weekend duties every 4 weeks

Requirements

  • Minimum 5 years+ of relevant technical experience
  • SQL server, Azure (IaaS & PaaS) cloud platforms
  • SSRS reporting server
  • Programming language: T-SQL for SQL server, PowerShell, Terraform & AZ CLI
  • Database monitoring: Foglight & NewRelic (or an equivalent monitoring tool)
  • Data Migration tools
  • Azure Geo Replication for High Availability
  • High Availability Solution-Clustering
  • Database backup/restore and disaster recovery
  • SQL server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
  • Azure Active Directory & SQL authentication
  • Database hardening and security standards like TDE, SSL/TLS and auditing
  • Azure provisioning through automation tools such as IAC (Terraform), CI/CD i.e. Jenkins, Flyway, GitHub Actions
  • Cryptographic key management using Azure Key Vault (AKV)
  • Database health check, reports, and metrics

Benefits

  • health, dental, mental health, vision insurance
  • short- and long-term disability insurance
  • life and AD&D insurance coverage
  • adoption/surrogacy and wellness benefits
  • employee/family assistance plans
  • retirement savings plans including pension and global share ownership plan with employer matching contributions
  • financial education and counseling resources
  • generous paid time off including holidays, vacation, personal, and sick days

Job title

Database Operations Engineer

Job type

Experience level

Mid levelSenior

Salary

CA$86,100 - CA$136,100 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job