Senior Database Architect, Cloud & Data Solutions

Kroll

Chicago (IL)

On-site

USD 120,000 - 180,000

Full time

40 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Healthcare coverage
Generous PTO
401(k) matching
Life insurance
Disability coverage

Job summary

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

Qualifications

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

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

Skills

SQL Server
Databricks
PostgreSQL
NoSQL
Azure
AWS
PowerShell
Python
T‑SQL
Performance tuning
Data warehousing

Education

Bachelor's degree

Tools

Databricks
Azure Data Factory
Azure Synapse
AWS Glue
AWS RDS
MongoDB
Cosmos DB
SSIS
SQL Monitor

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Cloud Database Engineer (PostgreSQL)
Senior Cloud Database Engineer (PostgreSQL)

Saransh Inc • Reading

On-site
USD 120,000 - 150,000
Senior DB Architect - SQL/Postgres, Kubernetes, FinServ
Senior DB Architect - SQL/Postgres, Kubernetes, FinServ

Staffing Solutions USA, Inc. • New York (NY)

Hybrid
USD 140,000 - 210,000
Head of Database Platform & Cloud Modernization
Head of Database Platform & Cloud Modernization

CCC Information Services • Chicago Heights (IL)

Hybrid
USD 140,000 - 180,000
401K Match
Paid time off
Annual Incentive Plan
+3
Database Platform Lead – SQL Server, Cloud & Hybrid
Database Platform Lead – SQL Server, Cloud & Hybrid

Kirkland & Ellis • Houston (TX)

Hybrid
USD 153,000 - 191,000
Healthcare benefits
Paid time off
Retirement plan
+1
Senior Database Engineer: Cloud & Data Architecture
Senior Database Engineer: Cloud & Data Architecture

Columbia Technology Partners • Annapolis (MD)

On-site
USD 120,000 - 180,000
Medical plans
Vision & Dental
401k plan
+2
Senior Database Architect - PostgreSQL & Cloud
Senior Database Architect - PostgreSQL & Cloud

Adaptiva • Seattle (WA)

On-site
USD 110,000 - 120,000
100% company-paid health insurance
Performance-based bonuses
401(k) retirement plan
+1
Senior Database Engineer - Multi-Cloud, High Availability
Senior Database Engineer - Multi-Cloud, High Availability

MeridianLink, Inc. • United States

Hybrid
USD 110,000 - 170,000
Database Administrator (DBA) - Chicago
Database Administrator (DBA) - Chicago

Yeah! Global • Chicago (IL)

On-site
USD 80,000 - 100,000
Database Engineer: MSSQL/MySQL/PostgreSQL (Cloud & On‑Prem)
Database Engineer: MSSQL/MySQL/PostgreSQL (Cloud & On‑Prem)

Floor & Decor • Georgia

On-site
USD 110,000 - 150,000
Bonus opportunities
401k with company match
Employee Stock Purchase Plan
Senior PostgreSQL Reliability Engineer - Cloud & Kubernetes
Senior PostgreSQL Reliability Engineer - Cloud & Kubernetes

Tata Consultancy Services Limited • Skokie (IL)

On-site
USD 100,000 - 130,000