Senior Manager, Database Administrator

Kroll; Chicago (IL); Presencial; USD 120.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare coverage

Generous PTO

401(k) matching

Life insurance

Disability coverage

Descripción de la vacante

Kroll is seeking an experienced Database Developer/Engineer in Chicago to support and optimize enterprise DB environments across on-prem and cloud platforms. The role requires advanced SQL Server expertise, PostgreSQL experience, scripting skills, and a strong understanding of cloud security.

You’ll contribute to scalable data solutions and collaborate with multi-disciplinary teams. The position emphasizes design, performance tuning, and robust database operations, with opportunities to work

Formación

• Bachelor’s degree in information technology, computer science, or a related field 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 Databricks administration and data lakes is a plus.
• 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.

Responsabilidades

• 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, AWS, 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.
• 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.

Conocimientos

SQL Server

Databricks

PostgreSQL

NoSQL

Azure

AWS

PowerShell

Python

T‑SQL

Performance tuning

Data warehousing

Educación

Bachelor's degree

Herramientas

Databricks

Azure Data Factory

Azure Synapse

AWS Glue

AWS RDS

MongoDB

Cosmos DB

SSIS

SQL Monitor

Descripción del empleo

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.

Day-to-day 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 (AWS), 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.

• Bachelor’s degree in information technology, computer science, or a related field 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 Databricks administration and data lakes is a plus.
• 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 I/O.
• Solid knowledge of Windows Server, security models, and storage technologies such as storage area networks (SANs).
• 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 (AWS) technologies.
• Extensive knowledge of and experience with Windows‑based technologies.
• Ability to communicate and collaborate effectively with colleagues and customers.
• Ability to adapt to a dynamic environment, identify priority issues, and elevate them appropriately.
• Experience developing standards and documentation.
• Ability to work independently or collaboratively within project deadlines.
• Strong customer‑service orientation, organizational and communication skills, and a positive, can‑do attitude.

The interview process includes a technical troubleshooting and prioritization skills assessment.

• Healthcare Coverage: Comprehensive medical, dental, and vision plans.
• Time Off and Leave Policies: Generous paid time off (PTO), paid company holidays, generous parental and family leave.
• Protective Insurances: Life insurance, short- and long‑term disability coverage, and accident protection.
• Compensation and Rewards: Competitive salary structures, performance‑based incentives, and merit‑based compensation reviews.
• Retirement Plans: 401(k) plans with company matching.

Please note that benefits may vary by region, department and role. We encourage you to speak with your recruiter to learn more about the specific benefits available for your position.

About Kroll

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.

We are proud to be an equal opportunity employer and will consider all qualified applicants regardless of gender, gender identity, race, religion, color, nationality, ethnic origin, sexual orientation, marital status, veteran status, age or disability.