Senior Manager, Database Administrator

KrollChicago, IllinoisOn-siteFull-timeSenior, 5–8 yearsListed 18 minutes ago

Apply now

About this role

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 join One team, One Kroll .

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.

Essential traits:

- Bachelor’s degree in information technology, computer science, or a related field preferred.
- MCDBA, Azure, or AWS certification 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 escalate 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.

Your recruiter will be happy to walk you through your U.S.-specific benefits, which include:

- 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.

In order to be considered for a position, you must formally apply via careers.kroll.com.

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.

The current salary range for this position is $70,000 to $200,000

#LI-DNI