3 days ago
Base Salary
$70k - $200k/yr
Responsibilities
- Maintain and standardize enterprise database schemas, permissions, coding standards, and technical documentation.
- Review database schema projects, conduct code reviews, assess impacts, and translate business and application requirements into database and data designs.
- Build, support, and manage database solutions across on-premises, AWS, Azure, and other cloud environments.
- Maintain database availability, stability, recoverability, security, and performance through monitoring, patching, optimization, and troubleshooting.
- Optimize stored procedures and resolve SQL performance bottlenecks, blocking, deadlocking, replication, connectivity, integrity, and security issues.
- Develop, maintain, and deploy SSIS packages and scalable database solutions.
- Support production application monitoring, infrastructure projects, environment buildouts, outages, updates, upgrades, and modifications, including after-hours support as needed.
- Collaborate with architects, solution designers, third parties, colleagues, and customers on technical designs and database improvements.
Requirements
- 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 and at least three years of experience with scripting languages such as PowerShell, VBScript, or Python.
- Working knowledge of Databricks administration, data lakes, NoSQL technologies such as MongoDB and Azure Cosmos DB, and data warehousing and column-store databases.
- Strong knowledge of AWS technologies, Windows-based technologies, cloud security guidelines, Windows Server, security models, storage technologies, and SQL Server high availability and disaster recovery.
- Advanced experience with T-SQL, stored procedures, transactional replication, multi-node clustering, and database mirroring.
- Experience troubleshooting hardware resource contention involving CPU, memory, and disk I/O, and performing performance tuning using SQL Monitor and Azure tools.
- Extensive experience supporting large-scale, client-facing online systems and developing standards and documentation.
- MCDBA, Azure, or AWS certification is preferred.
- Ability to communicate and collaborate effectively, prioritize and escalate issues, work independently or collaboratively, and meet project deadlines.
- Completion of a technical troubleshooting and prioritization skills assessment is part of the interview process.
Benefits
- Comprehensive medical, dental, and vision coverage.
- Generous paid time off, company holidays, and parental and family leave.
- Life insurance, short- and long-term disability coverage, and accident protection.
- 401(k) plans with company matching.
- Performance-based incentives and merit-based compensation reviews.
- Benefits vary by region, department, and role; U.S.-specific benefits are reviewed with the recruiter.
Tech Stack
Categories
Data Engineering
About Kroll
Kroll provides risk and financial advisory services, including valuation, corporate finance, restructuring, investigations, cyber risk, and compliance, to enterprises, financial institutions and law firms. It earns fees for advisory, due diligence, disputes, and agency/trustee services across global capital markets. Founded in 1972 and headquartered in New York, the firm operates internationally and is known for complex valuations and forensic investigations.