Talent.com
Kroll
Manager II, Database ArchitectKroll • Toronto, Ontario, Canada
Manager II, Database Architect

Manager II, Database Architect

Kroll • Toronto, Ontario, Canada
25 days ago
Salary
CA$100,000.00 yearly
Job type
  • Full-time
Job description
Description

In a world of disruption and increasingly complex business challenges our professionals bring truth into focus with the Kroll Lens. Our sharp analytical skills paired with the latest technology allow us to give our clients claritynot just answersin all areas of business. We embrace diverse backgrounds and global perspectives and we cultivate diversity by respecting including and valuing one another. As part ofOne team One Kroll youll contribute to a supportive and collaborative work environment that empowers you to excel.

A true partner within the business our IT team works globally as one cohesive unit comprised of collaborative professionals who take pride in support and customer service. Core areas include solutions delivery and application development network operations workforce services and information services/knowledge management

At Kroll your work will help deliver clarity to our clients most complex governance risk and transparency challenges. Apply now to joinOne team One Kroll.

Day to Day Responsibilities:

  • The Senior Database Manager/Lead will be assigned to work with one or more development project this role they will be expected to:
  • The Senior Database Lead will be responsible for building supporting and managing Database solutions within Amazon AWS Microsoft Azure and other Cloud environments.
  • Working on Data related technologies including but not limited to Databricks Datalake Azure Data Factory Azure Synapse Analytics Azure Fabric AWS Athena AWS Glue and other related services.
  • Working with the Solutions Designer Development Architect and third parties as appropriate the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/project is produced.
  • Understand the business and application requirements and translate into a database and data design.
  • Ensure that all technology selected for the program conforms to the organizations technical long-term strategy.
  • Be responsible for the availability stability recoverability and performance of the database environment by ensuring all systems are monitored patched and operating optimally.
  • Design and develop complex SQL queries and appropriate database code such as stored procedures triggers functions to support complex business processes.
  • Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.
  • Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
  • Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.
  • Perform code reviews providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.
  • Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
  • Monitor business data stored in production databases ensuring integrity of the data is maintained.
  • Responsible for developing maintaining and deploying SSIS packages.
  • Guide team and participate in release of all stored procedure projects; including release documentation.
  • Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.
  • Proactively identify and act on opportunities to improve database systems and processes.
  • Contribute to standards documentation for database coding practices.
  • Prioritize multiple tasks so that aggressive deadlines are met.
  • Provide ongoing suggestions for improvement and innovation within the department.
  • Exhibit sound methodical engineering judgment and effectively manage trade-offs in a business environment.
  • Maintain and exhibit knowledge of AWS RDS Azure SQL and NOSQL database
  • Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications.
  • Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the departments production applications.

Essential Traits:

  • B.S. Degree in Information Technology Computer Science or a related discipline is preferred.
  • MCDBA/Azure/AWS Certification preferred.
  • 5-8 years of experience in database development and support in MS SQL Server environment.
  • 3 years working experience in deploying physical and cloud instances of SQL Server.
  • 2 year of working with PostgreSQL.
  • Working Knowledge of Databricks administration and Datalake is a plus.
  • Working knowledge of noSQL database technology. (Mongo Cosmos Others)
  • 3 years of experience in scripting language like Powershell VB Script Python or similar.
  • Strong understanding of Security guidelines in Cloud environment.
  • Open to work on Infrastructure projects and assist on Environment buildouts from Database and Data Analytics perspective.
  • Experience in troubleshooting and resolving database integrity issues performance issues blocking & deadlocking issues replication/log shipping issues network/connectivity issues security issues etc.
  • Experience in Performance Tuning Query Optimization using SQL Monitor Azure Tools
  • Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU memory disk IO etc.
  • Solid acquaintance with windows server security models and storage components such as SAN.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Advanced experience with TSQL language and stored procedures transactional replication multi node clustering mirroring etc.
  • Knowledge of Data Warehousing and Column store databases.
  • A broad understanding of enterprise-class Database technologies
  • Extensive knowledge and experience with large scale client facing online systems
  • Extensive knowledge and experience with Amazon AWS technologies
  • Extensive knowledge and experience with Windows based technologies
  • Ability to communicate and to interact effectively with co-workers and customers is required.
  • Ability to work and adapt in a dynamic environment and recognize priority issues escalating accordingly
  • Experience with creating standards and documentation
  • Ability to work both independently or as part of a project group with time constraints
  • Strong customer service oriented; organizational and communication skills positive and can-do attitude
  • A technical troubleshooting and prioritization skills test will be part of the interview process.

About Kroll

Join the global leader in risk and financial advisory solutionsKroll. With a nearly century-long legacy we blend trusted expertise with cutting-edge technology to navigate and redefine industry complexities. As a part of One Team One Kroll youll contribute to a collaborative and empowering environment propelling your career to new heights. Ready to build protect restore and maximize our clients value Your journey begins with Kroll.

In order to be considered for a position you must formally apply via .

Kroll is committed to equal opportunity and diversity and recruits people based on merit.

Salary range for this role is $100000 - $150000 CAD

#LI-Hybrid

#LI-SS1





Required Experience:

Manager


Employment Type : Full-Time
Department / Functional Area: Technology Operations
Experience: years
Vacancy: 1
Monthly Salary Salary: 100000 - 150000
Create a job alert for this search

Manager II, Database Architect • Toronto, Ontario, Canada

Similar jobs

Enterprise Database Architect

Computer Talk Technology Inc.Markham
Full-time

ComputerTalk has an immediate opening for an Enterprise Database Architect candidate in our Markham head office.The candidate will be responsible for the implementation, configuration, maintenance,... Show more

 • Promoted

Lead DBaaS Architect for Global Cloud Platform

RumbleToronto
Full-time

A high-growth video platform in Toronto is looking for a Principal Database Architect.This role requires owning the architecture and delivery of a Database as a Service (DBaaS) offering.The ideal c... Show more

 • Promoted

Senior Solution Architect — Business Analysis & Client Delivery

Fisent Technologies Inc.richmond hill, ON, ca
Full-time

Overview:</p><p>Fisent is seeking a highly skilled and experienced Senior Solution Architect to join our delivery team.At Fisent, this role blends senior business analysis, client solut... Show more

 • Promoted • New!

Manager II, Database Architect

KrollToronto, ON, CA
Full-time

In a world of disruption and increasingly complex business challenges, our professionals bring truth into focus with the Kroll Lens.Our sharp analytical skills, paired with the latest technology, a... Show more

 • Promoted

Complex Database Solutions Architect

AmazonToronto, ON, CA
Full-time

Lead the charge in complex database architectures as a Solutions Architect.Focus on cloud migration and strategy using AWS database services to meet diverse customer requirements.This essential rol... Show more

 • Promoted

Database Operations Leader at Intact

Intact Financial CorporationToronto, ON, Canada
Full-time

Intact invites applications for the role of Database Operations Leader, focusing on Oracle and MongoDB management.Embrace this hybrid opportunity to lead and nurture a talented team.As a Database O... Show more

 • Promoted • New!

Senior Clinical Data Manager - Warman O'Brien

Warman O'Brienrichmond hill, on, ca
Full-time

Senior Clinical Data Manager | Small CRO | Full Time | Remote, Canada.Our client is a well-established Small CRO based in the Toronto Area and known for providing top-notch clinical solutions to a ... Show more

 • Promoted

Database Architect

ScotiabankToronto, ON, CA
Full-time

Select how often (in days) to receive an alert:.Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Contributes to the overall success of the EDL i... Show more

 • Promoted

Senior Oracle DBA for Cloud Architecture Solutions

BeaconsoftwareToronto, ON, CA
Full-time

Shape the future of cloud computing as a Senior Oracle DBA.Spearhead critical Oracle database management and cloud migrations to enhance operational efficiency in a fully remote role.In this strate... Show more

 • Promoted

Senior Manager, Architecture

Tundra Technical SolutionsToronto, ON, CA
Full-time

This is a temporary contractor position for a current active vacancy.Support the Director – Enterprise Architecture by leading the development and governance of enterprise data architecture strateg... Show more

 • Promoted

Senior Infrastructure Architect Leading Middleware and Database Solutions

Source CodeToronto, ON, CA
Full-time

Drive technical excellence as a Senior Infrastructure Architect specializing in middleware and database architectures within hybrid cloud environments.Collaborate to ensure cutting-edge solutions m... Show more

 • Promoted

Senior Oracle Cloud Architect: OCI, 19c & Multi‑Tenant DB

BeaconsoftwareToronto, ON, CA
Full-time

A high-growth capital holding company in Canada is looking for a Senior Oracle DBA & Infrastructure Engineer to lead cloud-native transitions.The role requires managing database administration, clo... Show more

 • Promoted

Senior Manager - Cloud Architecture

Ernst & Young Advisory Services Sdn BhdToronto, ON, CA
Full-time

We are seeking a Senior Manager - Cloud Architecture to join EY Canada.In this role, you will be required to offer expert advice, planning, and practical assistance to EY's clients who want to move... Show more

 • Promoted

Senior Manager, Cloud & Infrastructure Architecture

Targeted TalentToronto, ON, CA
Full-time

The role of Senior Manager, Cloud & Infrastructure Architecture involves leading a team of experienced architects and people leaders.This position focuses on guiding the design and implementation o... Show more

 • Promoted

Anaplan Solutions Architect

CodexGreater Toronto Area, Canada, Canada
Full-time

Codex has partnered with a client seeking an experienced Anaplan Solution Architect to lead end-to-end design and implementation of Anaplan solutions across financial, supply chain, and operational... Show more

 • Promoted

Expert Solutions Architect – Databases

Amazon Web Services Canada, Inc.Toronto, ON, CA
Full-time

Step into a pivotal role as an Expert Solutions Architect specializing in Databases.Tackle complex challenges while helping organizations maximize their cloud capabilities with AWS.In this senior-l... Show more

 • Promoted

Database Solutions Architect in Hybrid Environment

Raenan ConsultancyToronto, ON, CA
Full-time

Transform database structures as a Database Solutions Architect in a hybrid work model.Utilize your expertise in Linux, DB software, and database management to innovate and elevate projects.This ro... Show more

 • Promoted

Principal Database Architect (DBaaS)

RumbleToronto, ON, CA
Full-time

Our mission is to restore the internet to its roots by making it free and open once again.Database as a Service (DBaaS) offering within our public cloud platform.This role will take over a product ... Show more

 • Promoted

Database Architect

Tata Consultancy ServicesToronto, ON, CA
Full-time

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c... Show more

 • Promoted

Senior Manager Solutions Architecture in Cloud

TELUS DigitalToronto, ON, CA
Full-time

Drive innovation in cloud contact center solutions at TELUS Digital as a Senior Manager of Solutions Architecture for Genesys CCaaS.This remote/hybrid position combines technical prowess with clien... Show more