Database Administrator Lead Consultant - Chicago - Allstate

    Allstate
    Allstate Chicago

    14 hours ago

    Description

    At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years, our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. 

    Job Description

    We are seeking a Senior Database Administrator (DBA) to provide strategic leadership in transforming our data landscape from a traditional on-premises SQL Server to a modern, cloud-based architecture leveraging Microsoft Azure and AWS platforms. This role will report into the Data Engineering team within the Investments Technology organization, driving innovation and operational excellence in database management.

    This position is a hybrid role, meaning your schedule may consist of time in an office setting and time working remotely from your home. The hybrid model is intended to provide greater flexibility – and will mean something different to each team, job and employee. Office presence is driven by the nature of the work and team needs. You'll work from home for the remainder of the time you're not in the office. This position is eligible for a monthly connectivity reimbursement to offset the costs of internet and phone expenses.

    Key Responsibilities

    KEY RESPONSIBILITIES

    • Lead the Data Transformation Journey
      Drive migration from on-prem SQL Server to cloud platforms implementing scalable, secure, and high-performing databases.

    • Team Mentorship
      Mentor a small team of DBAs, fostering a culture of collaboration, innovation, and continuous learning.

    • Performance and Optimization
      Ensure optimal performance, availability, and security of databases across hybrid environments aligning to Allstate security requirements.

    • Governance and Compliance
      Implement best practices for data governance, security, and compliance in cloud and hybrid setups aligning to Allstate security requirements.

    • Collaboration
      Work closely with Enterprise engineering aligning Investments with enterprise data strategy. Work closely with Investments product and business teams aligning with organizational goals.

    ESSENTIAL SKILLS

    • 10+ years in database administration with strong expertise in SQL Server (Oracle experience is a plus).

    • 3+ years in Azure and/or AWS cloud platforms.

    • Exposure to Microsoft Fabric and OneLake is a strong plus.

    • Proven experience coaching DBA teams and driving large-scale database migrations.

    • Database performance tuning, high availability, disaster recovery.

    • Familiarity with Delta Lake, Parquet, and modern data architectures.

    • Strong understanding of security and compliance in cloud environments.

    • Excellent communication, stakeholder management, and strategic thinking.

    Supervisory Responsibilities

    • This job does not have supervisory duties.

    Skills

    AWS Cloud Computing, AWS Cloud Computing, Business, Cloud Platform, Coaching, Collaboration, Compliance, Data Architecture, Database Administration, Database Design, Database Management, Database Management Systems (DBMS), Database Performance, Database Performance Tuning, Databasing, Data Engineering, Data Governance, Data Modeling, Data Strategies, Data Transformation, Enterprise Data, Enterprise Data Strategy, Investments, Microsoft Azure, Operational Excellence {+ 1 more}

    Compensation

    Compensation offered for this role is 98,100.00 - 167,850.00 annually and is based on experience and qualifications.

    The candidate(s) offered this position will be required to submit to a background investigation.

    Joining our team isn't just a job — it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

    Allstate generally does not sponsor individuals for employment-based visas for this position.

    Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

    For jobs in San Francisco, please click "here" for information regarding the San Francisco Fair Chance Ordinance.


    For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.

    To view the "EEO Know Your Rights" poster click "here". This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs.

    To view the FMLA poster, click "here". This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.

    It is the Company's policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee's ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

  • Work in company

    Lead Consultant –

    Only for registered members

    · Company Description · Company: · A Global IT consulting firm with several large customer engagements across Europe and US. It provides strategic business consulting, technology, engineering and outsourcing services to help clients leverage technology and create impactful and m ...

    Chicago, IL $110,000 - $190,000 (USD) per year

    1 week ago

  • Work in company Remote job

    Lead Consultant

    Only for registered members

    UL is seeking an experienced AI/ML Assurance Expert to lead our artificial intelligence initiatives across automotive, medical, industrial, robotics, consumer and aerospace sectors. This strategic leadership role is responsible for defining and executing compliance and assurance ...

    Chicago, IL $110,000 - $190,000 (USD) per year

    1 day ago

  • Work in company

    Lead Consultant

    Only for registered members

    We are seeking a Lead Consultant to join our team in Chicago. As a key member of our consulting lifecycle, you will be responsible for defining problems and proposing solutions.You will guide teams on project processes and contribute to proposal development and client training. · ...

    Chicago

    1 month ago

  • Work in company

    Lead Consultant

    Only for registered members

    'Job DescriptionUL is seeking an experienced AI/ML Assurance Expert to lead our artificial intelligence initiatives across automotive, medical, industrial robotics consumer and aerospace sectors. · ' · Develop and drive AI assurance strategies across automotive medical industrial ...

    Chicago $135,000 - $180,000 (USD)

    4 weeks ago

  • Work in company

    Lead Consultant

    Only for registered members

    UL is seeking an experienced AI/ML Assurance Expert to lead our artificial intelligence initiatives across automotive, medical, industrial, robotics, consumer and aerospace sectors. This strategic leadership role is responsible for defining and executing compliance and assurance ...

    Chicago $135,000 - $180,000 (USD)

    1 day ago

  • Work in company

    US Lead Consultant

    Only for registered members

    · Businessfourzero, a Heidrick & Struggles Company is a fast-paced, global, purpose-driven change consultancy that works with big businesses to help them change faster than the world around them, through fuelling their people with commitment and belief in the work they do. · We ...

    Heidrick & Struggles Chicago, United States

    3 days ago

  • Work in company

    Lead Compensation Consultant

    Only for registered members

    +Dice es el destino laboral líder para expertos en tecnología en todos los estadios de sus carreras. El cliente, Resource 1, busca lo siguiente. Aplicar vía Dice hoy. · Resource 1 busca un · Consultor Principal Compensación · para apoyar una implementación Workday HCM y Finanzas ...

    Chicago, IL

    2 weeks ago

  • Work in company

    Lead Salesforce Consultant

    Only for registered members

    Job Summary · Infosys is seeking a Lead Salesforce Consultant to contribute to different phases of the consulting lifecycle. · QualificationsBachelor's degree or foreign equivalent required. · At least 7 years of experience in implementing CRM solutions on Salesforce platform. · ...

    Chicago, IL

    1 month ago

  • Work in company

    Lead Applications Consultant

    Only for registered members

    Job Description: · Capgemini America Inc. has multiple openings for · the position of Lead Applications Consultant based out of its Chicago, IL U.S. · headquarters.  The employee may also work · at various unanticipated locations.  S/he · will perform the following duties:  condu ...

    US - IL - Chicago $100,000 - $120,000 (USD) per year

    5 days ago

  • Work in company

    Lead Infrastructure Consultant

    Only for registered members

    Job Description: · Capgemini America, Inc. has · multiple openings for the position of Lead Infrastructure Consultant based out · of its Chicago, IL U.S. headquarters. The employee may also work at various · unanticipated locations. S/he will perform the following duties\: design ...

    US - IL - Chicago $80,000 - $140,000 (USD) per year

    10 hours ago

  • Work in company

    Net Lead Consultant

    Only for registered members

    · Company Description · Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, => Software Consultancy and Information Technology Enabled ...

    Chicago, IL

    3 days ago

  • Work in company

    Lead Consultant Analytics Consulting

    Only for registered members

    We are seeking a Lead Consultant to join our team in Chicago. The ideal candidate will have at least 7 years of experience with Domain Consulting or Data Consulting in the Utilities industry. · ...

    Chicago

    3 weeks ago

  • Work in company

    Lead Salesforce Consultant

    Only for registered members

    Infosys is seeking a Lead Salesforce Consultant to contribute to different phases of the consulting lifecycle. · ...

    Chicago

    1 month ago

  • Work in company

    Lead Tosca Consultant

    Only for registered members

    As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and suppo ...

    Chicago

    3 weeks ago

  • Work in company

    SharePoint Lead Consultant

    Only for registered members

    You will be an expert contributing to different phases of the consulting lifecycle. Define problems, propose solutions. · ...

    Chicago

    4 weeks ago

  • Work in company

    Lead Consultant, CFO

    Only for registered members

    The Private Equity Value Creation team accelerates operational and financial performance across portfolio companies through targeted execution-focused transformation. From optimizing accounting processes to enhancing the use of financial systems and data, the team helps companies ...

    Chicago $107,600 - $179,300 (USD)

    3 weeks ago

  • Work in company

    Lead Compensation Consultant

    Only for registered members

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Resource 1, is seeking the following. · ...

    Chicago

    2 weeks ago

  • Work in company

    Lead Cloudera Consultant

    Only for registered members

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Gurus Infotech, Inc., is seeking the following. Apply via Dice today · Lead Cloudera Consultant · Chicago, IL · Job Description: · You must have hands-on, production-grade experie ...

    Chicago

    1 day ago

  • Work in company

    Security Lead Consultant

    Only for registered members

    We are seeking a Security Lead Consultant to join our team at Net2Source Inc. · ...

    Chicago

    4 weeks ago

  • Work in company

    Lead Solutions Consultant

    Only for registered members

    Lead Solutions Consultant (Wealth Management) · Remote (US) · Chicago HQ | Full-time | $115-140K + bonus + equity · ABOUT BEEMO · Beemo is the AI implementation partner for independent RIAs and wealth management firms. We deploy AI automations directly inside each firm's cloud e ...

    Chicago $115,000 - $140,000 (USD)

    5 days ago

  • Work in company Remote job

    Lead Consultant, Professional Services

    Only for registered members

    We are seeking an expert and leader within our Professional Services organization to lead complex large-scale FMS implementations towards success. The Lead Consultant will work closely with customers to understand their business needs and deliver solutions to ensure successful de ...

    Chicago, IL

    1 month ago

Jobs
>
Chicago