Manager II, Database Architect

{
  "content_hash": "168e3ee94e7caa246557b35de6c72caa19b0cbfd8cde4eb4e3b26e007a845782",
  "source_hash": "fb54cd7b0d7ca156171694a77bc37f760c064de72d4c5e8b5296a2592de244f5",
  "last_changed_at": "2026-05-31T18:03:49.729Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Toronto, ONT, Canada",
    "city": "Toronto",
    "region": null,
    "country": "Canada",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": 150000,
  "salary_min": 100000,
  "inferred_at": "2026-06-17T11:31:55.574Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Toronto, ONT, Canada",
      "city": "Toronto",
      "region": null,
      "country": "Canada",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "Canada"
    ]
  },
  "remote_policy": "hybrid",
  "salary_period": "year",
  "workplace_type": "hybrid",
  "salary_currency": "USD"
}

{}

{
  "detail": {
    "Id": "21013567",
    "Title": "Manager II, Database Architect",
    "media": [],
    "skills": [],
    "JobType": null,
    "Category": "Technology",
    "JobGrade": null,
    "JobLevel": null,
    "JobShift": null,
    "WorkDays": null,
    "WorkHours": null,
    "WorkYears": null,
    "Department": null,
    "HotJobFlag": false,
    "StudyLevel": null,
    "WorkMonths": null,
    "WorkerType": null,
    "GeographyId": 300000107500510,
    "JobFamilyId": 300000007050828,
    "JobFunction": "Technology Operations",
    "JobSchedule": "Full time",
    "BusinessUnit": null,
    "ContractType": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [
      {
        "Country": null,
        "Region1": null,
        "Region2": null,
        "Region3": null,
        "Building": null,
        "Latitude": "",
        "Longitude": "",
        "LocationId": null,
        "PostalCode": null,
        "TownOrCity": null,
        "AddressLine1": null,
        "AddressLine2": null,
        "AddressLine3": null,
        "AddressLine4": null,
        "LocationName": null
      }
    ],
    "ContentLocale": "en",
    "HiringManager": null,
    "LegalEmployer": null,
    "RequisitionId": 300002738110820,
    "WorkplaceType": "",
    "BusinessUnitId": 300002214657060,
    "OrganizationId": 1,
    "GeographyNodeId": 100003320282300,
    "JobFunctionCode": "IFS-IT-TOG",
    "LegalEmployerId": 300000002450743,
    "PrimaryLocation": "Toronto, ONT, Canada",
    "RequisitionType": "Experienced",
    "NumberOfOpenings": null,
    "WorkplaceTypeCode": null,
    "BeFirstToApplyFlag": false,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ExternalContactName": null,
    "ShortDescriptionStr": "",
    "ExternalContactEmail": null,
    "ExternalPostedEndDate": null,
    "OtherRequisitionTitle": null,
    "requisitionFlexFields": [],
    "ApplyWhenNotPostedFlag": false,
    "DomesticTravelRequired": null,
    "ExternalDescriptionStr": "<p style=\"background-color: white; line-height: normal; margin-bottom: 0in; vertical-align: middle;\"><span style=\"color: black; font-family: &quot;Nunito Sans&quot;;\">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 clarity—not just answers—in all areas of business. We embrace diverse backgrounds and global perspectives, and we cultivate diversity by respecting, including, and valuing one another. As part of&nbsp;<i>One team, One Kroll</i>, you’ll contribute to a supportive and collaborative work environment that empowers you to excel.&nbsp;</span></p><p style=\"background-color: white; line-height: normal; margin-bottom: 0in; vertical-align: middle;\"><span style=\"color: black; font-family: &quot;Nunito Sans&quot;;\">&nbsp;</span></p><p style=\"background-color: white; line-height: normal; margin-bottom: 0in; vertical-align: middle;\"><span style=\"color: black; font-family: &quot;Nunito Sans&quot;;\">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</span></p><p style=\"background-color: white; line-height: normal; margin-bottom: 0in; vertical-align: middle;\"><span style=\"color: black; font-family: &quot;Nunito Sans&quot;;\">&nbsp;</span></p><p style=\"background-color: white; line-height: normal; margin-bottom: 0in; vertical-align: middle;\"><span style=\"background-color: white; color: black; font-family: &quot;Nunito Sans&quot;;\">At Kroll, your work will help deliver clarity to our clients’ most complex governance, risk, and transparency challenges. Apply now to join&nbsp;<i>One team, One Kroll</i>.</span><span style=\"color: black; font-family: &quot;Nunito Sans&quot;;\">&nbsp;</span><br><br>&nbsp;</p><p><span style=\"font-family: &quot;Nunito Sans&quot;;\"><strong><u>Day to Day Responsibilities:&nbsp;</u></strong></span></p><ul style=\"list-style-type: disc; padding-left: 24px;\"><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">The Senior Database Manager/Lead will be assigned to work with one or more development project teams. In this role they will be expected to:</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">The Senior Database Lead will be responsible for building, supporting and managing Database solutions within Amazon AWS, Microsoft Azure, and other Cloud environments.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">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.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">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.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Understand the business and application requirements and translate into a database and data design.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Ensure that all technology selected for the program conforms to the organization’s technical long-term strategy.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally.&nbsp;</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Monitor business data stored in production databases, ensuring integrity of the data is maintained.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Responsible for developing, maintaining and deploying SSIS packages.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Guide team and participate in release of all stored procedure projects; including release documentation.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Proactively identify and act on opportunities to improve database systems and processes.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Contribute to standards documentation for database coding practices.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Prioritize multiple tasks so that aggressive deadlines are met.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Provide ongoing suggestions for improvement and innovation within the department.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the department’s production applications.&nbsp;</span></li></ul><p><span style=\"font-family: &quot;Nunito Sans&quot;;\"><strong><u>Essential Traits:</u></strong></span></p><ul style=\"list-style-type: disc; padding-left: 24px;\"><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">MCDBA/Azure/AWS Certification preferred.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">5-8 years of experience in database development and support in MS SQL Server environment.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">3+ years working experience in deploying physical and cloud instances of SQL Server.&nbsp;</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">2+ year of working with PostgreSQL.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Working Knowledge of Databricks administration and Datalake, is a plus.&nbsp;</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Working knowledge of noSQL database technology. (Mongo, Cosmos, Others)</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">3+ years of experience in scripting language like Powershell, VB Script, Python, or similar.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Strong understanding of Security guidelines in Cloud environment.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Open to work on Infrastructure projects and assist on Environment buildouts from Database and Data Analytics perspective.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Experience in troubleshooting and resolving database integrity issues, performance issues, blocking &amp; deadlocking issues, replication/log shipping issues, network/connectivity issues, security issues, etc.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Experience in Performance Tuning, Query Optimization using SQL Monitor, Azure Tools</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Solid acquaintance with windows server, security models, and storage components such as SAN.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Knowledge of Data Warehousing and Column store databases.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">A broad understanding of enterprise-class Database technologies</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Extensive knowledge and experience with large scale client facing online systems</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Extensive knowledge and experience with Amazon AWS technologies</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Extensive knowledge and experience with Windows based technologies</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Ability to communicate and to interact effectively with co-workers and customers is required.</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Experience with creating standards and documentation</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Ability to work both independently or as part of a project group, with time constraints</span></li><li><span style=\"font-family: &quot;Nunito Sans&quot;;\">Strong customer service oriented; organizational and communication skills, positive and can-do attitude</span></li><li><p><span style=\"font-family: &quot;Nunito Sans&quot;;\">A technical troubleshooting and prioritization skills test will be part of the interview process.</span></p><p>&nbsp;</p><p>&nbsp;</p></li></ul><p><span style=\"font-family: &quot;Nunito Sans&quot;;\"><strong><u>About Kroll</u></strong></span></p><p><span style=\"font-family: &quot;Nunito Sans&quot;;\">Join the global leader in risk and financial advisory solutions—Kroll. 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, you'll 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.</span></p><p style=\"background-color: white; line-height: normal;\"><span style=\"color: rgb(51, 51, 51); font-family: &quot;Nunito Sans&quot;;\">In order to be considered for a position, you must formally apply via careers.kroll.com.&nbsp;</span></p><p style=\"background-color: white;\"><span style=\"background-color: white; color: black; font-family: &quot;Nunito Sans&quot;;\"><i>Kroll is committed to equal opportunity and diversity, and recruits people based on merit.</i></span></p><p style=\"background-color: white;\">Salary range for this role is $100,000 - $150,000 CAD</p><p style=\"background-color: white;\">#LI-Hybrid</p><p style=\"background-color: white;\">#LI-SS1</p><p>&nbsp;</p>",
    "ObjectVerNumberProfile": "1",
    "PrimaryLocationCountry": "CA",
    "CorporateDescriptionStr": "",
    "ExternalPostedStartDate": "2026-04-02T22:16:25+00:00",
    "ExternalQualificationsStr": "",
    "InternalQualificationsStr": "",
    "OrganizationDescriptionStr": "",
    "primaryLocationCoordinates": [
      {
        "Latitude": "43.66907",
        "Longitude": "-79.47203",
        "CountryCode": "CA",
        "GeographyId": 300000107500510,
        "GeographyNodeId": 100003320282300
      }
    ],
    "ExternalResponsibilitiesStr": "",
    "InternalResponsibilitiesStr": "",
    "InternationalTravelRequired": null
  },
  "list_job": {
    "Id": "21013567",
    "Title": "Manager II, Database Architect",
    "JobType": null,
    "Distance": 1775088000000,
    "JobShift": null,
    "Language": "US",
    "WorkDays": null,
    "JobFamily": null,
    "Relevancy": 4,
    "WorkHours": null,
    "Department": null,
    "HotJobFlag": false,
    "PostedDate": "2026-04-02",
    "StudyLevel": null,
    "WorkerType": null,
    "GeographyId": 300000107500510,
    "JobFunction": null,
    "JobSchedule": null,
    "BusinessUnit": null,
    "ContractType": null,
    "ManagerLevel": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [
      {
        "Country": null,
        "Region1": null,
        "Region2": null,
        "Region3": null,
        "Building": null,
        "Latitude": null,
        "Longitude": null,
        "LocationId": null,
        "PostalCode": null,
        "TownOrCity": null,
        "AddressLine1": null,
        "AddressLine2": null,
        "AddressLine3": null,
        "AddressLine4": null,
        "LocationName": null
      }
    ],
    "LegalEmployer": null,
    "MediaThumbURL": null,
    "WorkplaceType": "",
    "BusinessUnitId": 300002214657060,
    "OrganizationId": 1,
    "PostingEndDate": null,
    "LegalEmployerId": 300000002450743,
    "PrimaryLocation": "Toronto, ONT, Canada",
    "WorkDurationYears": null,
    "WorkplaceTypeCode": null,
    "BeFirstToApplyFlag": false,
    "WorkDurationMonths": null,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ShortDescriptionStr": "",
    "requisitionFlexFields": [],
    "DomesticTravelRequired": null,
    "PrimaryLocationCountry": "CA",
    "ExternalQualificationsStr": null,
    "ExternalResponsibilitiesStr": null,
    "InternationalTravelRequired": null
  },
  "detail_meta": {
    "url": "https://hcxs.fa.us2.oraclecloud.com/hcmRestApi/resources/latest/recruitingCEJobRequisitionDetails?expand=all&onlyData=true&finder=ById;Id=%2221013567%22,siteNumber=CX_1",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 15839
  },
  "detail_errors": []
}