Senior Database and Integration Engineer 7838

Dentons is designed to be different. Our firm leads the way in a rapidly changing legal marketplace. We challenge the status quo and deliver consistent results as well as uncompromising quality and value to our clients. Our global presence is renowned as a firm with over 21000 individuals in more than 200 offices serving clients across 80 countries.

Dentons Canada is committed to its people and communities. We are consistently recognized as an employer of choice having received numerous awards including being selected as one of Canadas Top 100 Employers 2025; Canadas Top Employers for Young People 2025 and Canadas Best Diversity Employers 2025.

This role is an opportunity for you to join the worlds largest law firm a firm that offers opportunities to build your career while growing your skills and deepening your expertise.

ROLE

The Senior Database and Integration Engineer is responsible for the oversight optimization and support of SQL database systems and all relevant integrations including Azurebased and onpremises environments. This position ensures these systems deliver high performance reliability and security supporting the firms financial and operational goals.

RESPONSIBILITIES

• Technical Leadership
  • Maintain accountability for Azure and onpremises SQL databases.
  • Provide technical leadership to ensure database availability optimization and security.
  • Design implement and maintain cloudbased and onpremises database systems.
• Database Security
  • Implement and maintain robust security measures across Azure and traditional SQL databases adhering to compliance standards.
• Provisioning and Maintenance
  • Provision SQL servers instances databases and user logins following best practices.
  • Apply best practices for maintaining updating and decommissioning database systems.
• High Availability and Disaster Recovery
  • Design and implement High Availability (HA) and Disaster Recovery (DR) procedures including SQL Alwayson configurations.
  • Contribute to disaster recovery plans and ensure integration with business continuity strategies.
• Data Integration Development
  • Develop reusable scripts and processes to integrate data from diverse sources ensuring accuracy and consistency.
  • Monitor and troubleshoot ETL pipelines and integration processes for performance and reliability.
• System Monitoring and Optimization
  • Proactively monitor database health respond to alerts and troubleshoot issues.
  • Conduct query tuning performance analysis and optimization.
  • Regularly review system capacity and ensure compliance.
• Operational Support
  • Provide thirdline application and database administration support.
  • Troubleshoot and resolve escalated issues in a 24x7 support environment.
  • Manage platform upgrades patches and updates.
  • Maintain detailed documentation of workflows processes and system architecture.
  • Ongoing Improvements: Taking lessons learned to continuously improve how we position deliver and operate our technology.
  • Other duties as assigned to fully meet the requirements of the position.

SKILLS & COMPETENCIES

• Technical Skills
  • Expertise in Microsoft Azure SQL Database SQL Managed Instances and traditional SQL Server.
  • Expertise with HighAvailability backups and DR configurations.
  • Proficiency in Azure IaaS and PaaS technologies (e.g. Virtual Servers Logic Apps Azure Monitor).
  • Advanced skills in query tuning and performance troubleshooting.
  • Advanced knowledge of PowerShell scripting.
  • Knowledge of integration tools such as SSIS Azure Data Factory and Intapp Integration Builder.
  • Familiarity with Windows Server Active Directory Azure Entra ID and related technologies.
• Professional Skills
  • Strong analytical problemsolving and decisionmaking abilities.
  • Ability to build effective relationships with internal teams and external vendors.
  • Excellent written and verbal communication skills in English.
  • Proven ability to manage multiple priorities under tight deadlines.
  • Conveys a positive attitude and supports change in team and individual discussions.
  • Responds to pressure in a calm manner; recovers quickly from setbacks.
  • Strong stakeholder management skills and experience.
  • Demonstrates initiative and the ability to be proactive anticipating needs.
  • Flexibility to accommodate working in multiple time zones.

EDUCATION EXPERIENCE & CERTIFICATIONS

• Bachelors degree in Computer Science Information Systems or a related field.
• Minimum of 8 years of experience with SQL Systems in enterprise production environments.
• Azure Database Administrator Associate certification.
• ITIL certification and practical experience are highly valued.
• Familiarity with Big Data and alternative databases (e.g. MongoDB PostgreSQL) is a plus.
• Familiarity with standard legal systems (e.g. iManage DMS Elite InterAction) is a plus

We thank all applicants for their interest however only those selected for an interview will be contacted.

At Dentons we are committed to offering equitable and competitive pay we achieve this by aligning internal salary ranges for specific roles to similar positions in the external market. In the normal course our practice is to hire transfer and promote employees within the entry part of our range adjusting as needed based on the prior experience skills and competencies required for the role along with any market differentials.

Recognizing our exceptional talent means providing a comprehensive total rewards package beyond a competitive salary. We have curated our employee benefits portfolio to offer inclusive and comprehensive wellbeing and developmental programs for our people. With extended benefits and mental health plans paid time off savings plans fitness subsidy parental leave top up and more our benefits are flexible aligned to our core values and supports the various needs of our people. Additionally our personal and professional development programs include people networks mentorships and leadership series programming to help people grow their career.

Note: Availability of the benefits and perks may be subject to your location and employment type and may have certain eligibility requirements. Dentons reserves the right to alter these programs and offerings in whole or in part at any time without advance notice.

Equal Opportunity Statement

At Dentons Canada inclusion diversity equity and accessibility (IDEA) are not just ancillary values they are foundational to our business. We believe that IDEA is essential to the shared success of our team and our clients. Our forwardthinking and inclusive culture supports the professional development of all our people enhances the leading services we offer to our clients and informs our commitment to make a positive impact in the communities where we live and work. As a testament to our commitment to IDEA we have been recognized as one of Canadas Best Diversity Employers for 14 consecutive yearsas well as one of Canadas Top Employers for Young People 2024 for the seventh time.

Dentons Canada is an equal opportunity employer and we welcome your application. All employment decisions including hiring will be made without regard to age ancestry citizenship colour creed disability ethnic origin family status gender identity marital status place of origin race sexual orientation or any other characteristic protected by applicable human rights legislation.

We are committed to providing you with an inclusive barrierfree and accessible workplace to support your success. Should you require accommodation during the recruitment process for example as a result of a disability please contact us at .