Global Database Administrator

3 weeks ago


Toronto, Canada Dentons Full time

INTRODUCTION

The Global Database Administrator will maintain the database services used by Dentons, including a mixture of cloud and on premises solutions. The individual will be accountable for the monitoring of database performance, database optimization, and responding to queries around the data held in these systems.

WHY DENTONS

Dentons is designed to be different. We are driven to always be the firm of the future, to challenge the status quo, and to provide holistic business solutions to our clients in new and innovative ways. We are the lightbulb moments. The bold ideas. We are the world's largest global law firm, with 21,000+ people across 80+ countries. Driven by the diverse perspectives of our people, our clients, and our communities, we combine local knowledge with global insight.

ROLE

Reporting into the Global Director, Integration Services and working within the Global Data and Integration team, the Global Database Administrator will assume a technical leadership role across numerous initiatives to help ensure systems and services meet Firm requirements and adhere to industry best practices. The Administrator will collaborate with peers and other technology professionals to achieve these objectives.

The Global Database Administrator will also be accountable for responding to service incidents or critical outages when escalations are necessary.

**Requirements**:
KEY RESPONSIBILITIES & ACCOUNTABILITIES

Key Deliverables
- Manage Microsoft SQL databases, on-premises and in the cloud (Azure SQL).
- Configure and maintain database servers and processes, optimization scripts, and overall performance monitoring.
- Monitor system's health, ensuring high levels of performance, availability, sustainability, and security.
- Analyze, solve, and correct issues in real time.
- Perform scheduled maintenance and support release deployment activities.
- Work closely with the Global Applications Management team to ensure that all production systems are well maintained, and new functionality is implemented in a way to ensure performance and availability.
- Ensure any new development implemented by Dentons transformation program teams is well understood and assume the support of these new capabilities in production.
- Refine and automate regular processes, track issues, and document changes.
- Working with a team, provide multiple time zone support for critical production systems. This role will require on-call availability in case of critical system downtime.
- Build and maintain excellent working relationships with key stakeholders.
- Provide regular input as to developing technology trends in data and database solutions that are used in, or of interest to the firm.
- As part of the Development and Integrations team, the Global Database Administrator will help other members of the team in terms of supporting global systems, to help cover different time zones.

Design, Strategy, and Planning
- Maintain knowledge of Dentons' strategic business objectives to help ensure that services are engineered and supported in alignment with Dentons standards and best practices.
- Challenge the "status-quo" in support of Dentons platforms to establish innovative approaches to systems and service delivery. Think out of the box, and challenge others (vendors and team members) to do the same to come up with the best solutions and technical approaches.
- Be proactive while supporting services to ensure potential risks are mitigated in advance through careful planning and monitoring of systems and services.
- Ensure systems remain highly resilient to meet availability expectations of Dentons in accordance with defined business requirements. This includes the oversight of disaster recovery testing.
- Ensure systems are making the best use of the cloud, taking advantage of capabilities such as auto-scaling and service automation.

Build, Test, Deploy
- Provide hands on leadership during the upgrade or updating of supported platforms and services.
- Develop automation templates, scripts, and processes to enable the optimized and consistent delivery of supported platforms.
- Manage and coordinate vendors activities to ensure the successful support of platforms.
- Ensure platforms are maintained according to defined architectures, aligned with budgets, and tested

Operational Support
- Participate in the Global Change Control process to help manage change across the environment.
- Provide operational assistance and oversight in support of globally supported data systems.
- Work with the operations team on ensuring database systems are monitored, patched, and efficiently administered.
- Monitor, plan and deliver platform upgrades and updates with the support of the Global Operations team.
- Support the Global Security Operations team with the monitoring and response of security incidents.

SKILLS & COMPETENCIES

The Global Database Administrator must possess strong technical skills with significant hands-on experience working with



  • Toronto, Canada Global Pharma Tek Full time

    Position: Database Administrator - Application - Senior Location: Toronto, ON (Hybrid) Duration: Business Days + Possible Extension Job Description: Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience. Demonstrated experience in modifying database structures using information provided by application developers. ...


  • Toronto, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionEnhanced performance due to Database Offload in ExadataReduced size of database without compromising performance by leveraging compression technologyProvided trustworthy data from...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need:• The Global Technology Services (GTS) Tools and Monitoring group’s mandate is to provide insight to critical applications through the integration of real-time monitoring tools for our key Business Platforms with the goal of improving mean time to detect, automating response coordination, preventing impacts, and reducing mean time...


  • Toronto, Canada Capgemini Full time

    **About Capgemini**: Capgemini is a global leader in consulting, technology services and digital transformation, is at the forefront of innovation to address the entire breadth of clients opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50 year heritage and industry specific expertise, Capgemini enables...


  • Toronto, Canada Travelzoo Full time

    Do you feel - Capable of managing the SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Manage Always On, Replication, and Azure connectivity - Excited to configure and maintain database servers and processes, including monitoring system health and performance, to ensure...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: • The GTEP – Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day.• We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on.• The team is seeking a Database...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...


  • Toronto, Canada CareRx Full time

    Job Details Description CareRx is actively seeking a highly experienced and committed Database Administrator (DBA) to manage a portfolio of applications and various integrations, architect Data Warehouse. This position plays a pivotal role in constructing an innovative, adaptable, and scalable IT function to drive our business forward. We...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...


  • Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...


  • Toronto, Canada Atlantis IT group Full time

    **JD**: **Role - Database Administrator** **Location-** **Toronto, ON(Hybrid)** **Duration - Contract** Desirable Skills: Experience in Agile product development in Scrum or Kanban would be an assetAWS certification(s) such as AWS Certified Database Specialty would be an asset. Thanks & regards, Jack **Apptoza Inc.** Phone: (678)-869-5418 Ext 5003


  • Toronto, Canada Ombudsman Ontario Full time

    The Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.The Cybersecurity and...


  • Toronto, Canada YouthCare Full time

    Most Important - At least 10 years of experience - Experience in database replication / Real-Time data delivery with either MSSQL or Oracle - products (5+ years)RequirementsGeneral Skills - Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL - Create, test and implement safeguards to maintain data integrity and protect...


  • Toronto, Canada Canadian Institute of Plumbing & Heating Full time

    The Canadian Institute of Plumbing & Heating is looking for a database administrator to complete a data clean up for our organization. - Excellent technical skills - Meticulous attention to detail - A logical approach to work - The ability to prioritize tasks - Problem solving skills - Good organizational skills - Previous work in the database "Your...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...