K

Kroll

Global risk management and investigations consulting

Senior Manager - Database Administrator

Database AdministrationPosted on Nov 13
Full-timeChicago, IL, USAIn-person

About the Job

Requirements

  • A bachelor’s degree in information technology, computer science, or a related field is preferred.
  • Five to eight years of database development and support experience in a Microsoft SQL Server environment.
  • At least three years of experience deploying SQL Server instances in on-premises and cloud environments.
  • At least two years of experience with PostgreSQL.
  • Working knowledge of NoSQL database technologies, such as MongoDB and Azure Cosmos DB.
  • At least three years of experience with scripting languages such as PowerShell, VBScript, or Python.
  • Strong understanding of cloud security guidelines and best practices.
  • Willingness to support infrastructure projects and environment buildouts from database and data analytics perspectives.
  • Experience troubleshooting and resolving database integrity, performance, blocking, deadlocking, replication, log shipping, network connectivity, and security issues.
  • Experience with performance tuning and query optimization using SQL Monitor and Azure tools.
  • Ability to identify and troubleshoot SQL Server hardware resource contention involving CPU, memory, and disk input/output.
  • Solid knowledge of Windows Server, security models, and storage technologies such as storage area networks.
  • Knowledge of SQL Server high-availability and disaster-recovery options.
  • Advanced experience with T-SQL, stored procedures, transactional replication, multi-node clustering, and database mirroring.
  • Knowledge of data warehousing and column-store databases.
  • Broad understanding of enterprise-class database technologies.
  • Extensive experience supporting large-scale, client-facing online systems.
  • Extensive knowledge of and experience with Amazon Web Services technologies.
  • Extensive knowledge of and experience with Windows-based technologies.
  • Experience developing standards and documentation.
  • Ability to work independently or collaboratively within project deadlines.
  • A technical troubleshooting and prioritization skills assessment is part of the interview process.

Responsibilities

  • Maintain and standardize enterprise database schemas and high-trust permissions.
  • Review all database schema projects, provide feedback, and assess impacts on existing environments.
  • Conduct timely code reviews and incorporate relevant feedback.
  • Monitor production data to maintain its data and security integrity.
  • Ensure all program technologies align with the organization’s long-term technical strategy.
  • Build, support, and manage database solutions across on-premises, Amazon Web Services, Microsoft Azure, and other cloud environments.
  • Work with data technologies such as Databricks, data lakes, Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, AWS Athena, AWS Glue, and related services.
  • Collaborate with the Solutions Designer, Development Architect, and third parties to produce technical design documentation for program and project architecture.
  • Translate business and application requirements into database and data designs.
  • Maintain database availability, stability, recoverability, and performance through effective monitoring, patching, and optimization.
  • Develop and deliver scalable, sustainable, high-quality database solutions that meet defined business needs.
  • Optimize stored procedures and resolve SQL code performance bottlenecks.
  • Develop, maintain, and deploy SSIS packages.
  • Proactively identify and implement improvements to database systems and processes.
  • Contribute to database coding standards and documentation.
  • Prioritize multiple tasks to meet demanding deadlines.
  • Recommend ongoing improvements and innovations within the department.
  • Apply sound, methodical engineering judgment and manage business trade-offs effectively.
  • Maintain strong knowledge of AWS RDS, Azure SQL, and NoSQL databases.
  • Provide after-hours support as needed for system outages, updates, upgrades, and modifications.
  • Create or improve processes to increase the efficiency of production application support and monitoring.

Desired Qualifications

  • MCDBA, Azure, or AWS certification is preferred.
  • Working knowledge of Databricks administration and data lakes is a plus.

About the Company

Kroll

Global risk management and investigations consulting

Preparing summary

Company size
5,001-10,000
Company stage
Not listed
Total funding
Not listed
Headquarters
New York City, New York
Founded
1932

Recently Posted Jobs

Explore more opportunities at Kroll

See more jobs