Talent.com
Lead SQL Server Database Administrator
Lead SQL Server Database AdministratorCCC Information Services • Chicago, IL
Lead SQL Server Database Administrator

Lead SQL Server Database Administrator

CCC Information Services • Chicago, IL
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

About CCC

CCC Intelligent Solutions is a leading technology company helping to improve the insurance claims process for millions of people. Our award-winning SaaS platform connects more than 30,000 businesses, including insurance carriers, repair facilities, automakers, part suppliers, lenders, and others to streamline the process from start to finish.

Our advanced capabilities in AI, IoT, telematics, blockchain, data, and analytics drive continual innovation across our platform, as we work to advance the multi-trillion-dollar P&C insurance economy’s digital transformation.

At CCC, our mission is to keep people’s lives moving forward when it matters most. Diversity of experience and perspective are key to our pursuit so we can deliver a future of possibilities for our customers. Find out more about CCC Intelligent Solutions by visiting .

Job Description Summary

CCC is seeking a dynamic Lead SQL Server DBA having experience in all aspects of administering SQL Server databases in a cloud environment including : installation, maintenance, tuning, performance analysis, backup / recovery, security and high availability. The right candidate should be a highly motivated, flexible, and organized individual excited to learn and grow in their field in a fast-paced, large IT organization.

Job Duties

  • Understand CCC's business systems and impacts of infrastructure on business operations
  • Install, maintain, upgrade, troubleshoot and support SQL Server database technologies on Azure
  • Ensure that database systems are implemented to meet CCC's internal and external standards and service level requirements
  • Ensure databases are replicated and backed up to meet CCC's operational and disaster recovery requirements
  • Perform database hygiene and maintenance to ensure optimum performance & availability
  • Design and implementation of a monitoring and automation framework to ensure optimized performance and minimize service disruption
  • Superior analytical and debugging skills for continued improvement of stored procedures, database scripts and applications, including conflict resolution
  • Document database designs and related processes
  • Participate in 24x7 DBA support on-call rotation
  • Participate in technical incident calls to restore service related to application and infrastructure problems in production environments under time-bound situations
  • Consulting development teams in the design of solutions to maintain performance and scalability

Qualifications

Qualifications

  • Bachelor’s degree in Information Technology or related field required or, an equivalent combination of education and experience sufficient to successfully perform the key accountabilities of the job
  • Minimum 10 years’ experience in SQL Server database administration (2008R2-2022)
  • Minimum 3+ years working with Azure cloud data platform
  • Minimum 6+ years’ information systems experience in a large enterprise systems environment supporting mission-critical systems and applications
  • Has operated and ran a large SQL database upgrade project
  • Experience with SQL Server Transactional Replication
  • Experience with SQL Server AlwaysOn technologies (FCI and AG)
  • Operated a large, OLTP database handling high concurrency front ends and 5k / sec or higher throughput
  • Strong skills in database tuning, performance management, and database reorganization
  • Solid skills in backup and recovery of large databases
  • Deep understanding of database architecture, including new developments and best practices
  • Preferred Qualifications

  • Experience with SSIS / SSRS is a plus
  • About the company’s Commitment to its employees :

    CCC Intelligent Solutions employees are part of an inclusive culture that brings together diverse backgrounds and perspectives. Our team is defined by our values of : Integrity, Customer-Focus, Innovation, Diversity & Inclusion, and Tenacity. Together, we help our clients and each other achieve new goals.

    CCC is committed to providing employees with opportunities to advance their careers and skillsets. CCC team members receive access to training and education reimbursement is available.

    CCC offers competitive compensation and generous benefits. Health insurance, PTO, 401K, are just some of the benefits available to team members.

    Each team member plays an important role in the company’s success and each team member has a voice. CCC employee engagement and job satisfaction ratings consistently exceed industry norms – underscoring the value CCC places on its employees.

    #LI-HC1

    [job_alerts.create_a_job]

    Lead SQL Server Database Administrator • Chicago, IL

    [internal_linking.similar_jobs]
    Restaurant Delivery - Flexible Schedule

    Restaurant Delivery - Flexible Schedule

    DoorDash • Highwood, IL, United States
    [job_card.full_time] +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Databrics Architect

    Databrics Architect

    PamTen • Chicago, IL, United States
    [job_card.full_time]
    Data Architect you will be a part of an Agile team to build healthcare applications and implement new features while adhering to the best coding development standards. ZURE, Medallion Architecture, ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Caregiver / CNA

    Caregiver / CNA

    Sunrise Senior Living • Highland Park, IL, United States
    [job_card.full_time]
    When you join Sunrise Senior Living, you will be able to use your unique skills to empower residents to live longer, healthier, and happier lives. Not only will you build meaningful relationships wi...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Warehouse Manager - Overnights

    Warehouse Manager - Overnights

    Uline, Inc. • Highwood, IL, US
    [job_card.full_time]
    Pay from $124,000 to $180,000 per year.Street, Pleasant Prairie, WI 5138.Find fulfillment in your Warehouse career - at Uline!. As Warehouse Manager, you’ll direct our dedicated distribution center ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Director, Enterprise Data Management Platforms & Governance Tooling

    Director, Enterprise Data Management Platforms & Governance Tooling

    Bank of Montreal • Chicago, IL, United States
    [job_card.part_time]
    WE'RE BACK IN OFFICE! Please note this role is subject to Hybrid Work Model (2-3 days per week in office) and further subject to any company policy changes in the future. BMO is transforming how the...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Cloud Data Architect Lead — Snowflake, GCP & ELT

    Cloud Data Architect Lead — Snowflake, GCP & ELT

    SIDRAM TECHNOLOGIES • Chicago, IL, United States
    [job_card.full_time]
    A leading technology firm is seeking a Data Architect to design and manage database systems, lead data migrations, and develop ETL pipelines. The ideal candidate will have 5-8 years of experience in...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Complete Online Surveys For Cash (Up to $25 / per)

    Complete Online Surveys For Cash (Up to $25 / per)

    Earn Haus • Zion, IL, US
    [job_card.full_time] +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...[show_more]
    [last_updated.last_updated_30] • [promoted]
    .NET Technical Lead

    .NET Technical Lead

    VDart Inc • Chicago, IL, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Net Engineer Location : Chicago, IL (Hybrid) Fulltime Job Description : <...[show_more]
    [last_updated.last_updated_variable_days]
    Database Developer - SQL PostgreSQL, SSIS, SSRS

    Database Developer - SQL PostgreSQL, SSIS, SSRS

    Cloud think technologies LLC • Chicago, IL, United States
    [job_card.temporary]
    [filters_job_card.quick_apply]
    We need a Database Developer for a 12 month contract, working hybrid (2 days per week) onsite at office near in Chicago.Required : Oracle, PostgreSQL, SSRS, SSIS Desired : C#, VB.N...[show_more]
    [last_updated.last_updated_variable_days]
    Board Certified Behavior Analyst (BCBA) in Clinic

    Board Certified Behavior Analyst (BCBA) in Clinic

    Key Autism Services • Highland Park, IL, United States
    [job_card.full_time]
    Key Autism Services is hiring BCBAs across multiple states.Are you a passionate BCBA eager to make a meaningful impact? At Key Autism Services, we offer a collaborative and supportive environment w...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Information Technology Professional (IT Support)

    Information Technology Professional (IT Support)

    US Navy • Highland Park, IL, United States
    [job_card.full_time]
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America's Navy. Information Professionals who oversee the seamless opera...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Development

    Database Development

    TradeJobsWorkForce • 60546 Riverside, IL, US
    [job_card.full_time]
    Database Development Job Duties : Database Developers are responsible for data gathering before development of ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Banquet Server

    Banquet Server

    ClubCorp • Chicago, IL, United States
    [job_card.full_time] +1
    Ready to join a dynamic company in the hospitality and service industry where people help drive the success of the business? Since its inception in 1957, Invited has operated with the central purpo...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Architect (F500 Client) - North, NJ / Chicago, IL

    Senior Data Architect (F500 Client) - North, NJ / Chicago, IL

    Two95 International Inc. • Chicago, IL, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Location : North, NJ / Chicago, IL.Salary : $Market (Based on the Experience).Requires bachelor's degree or equivalent experience. Expertise in technologies like Cognos / BO / HANA / Tableau.Firm underst...[show_more]
    [last_updated.last_updated_30]
    Server Assistant - Busser

    Server Assistant - Busser

    Texas Roadhouse • Tinley Park, IL, United States
    [job_card.full_time]
    At Texas Roadhouse, we are a people-first company that just happens to serve steaks.Legendary Food and Legendary Service is who we are. We're about loving what you're doing today and preparing you f...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Database Administrator

    Senior Database Administrator

    KonnectIT • Chicago, Illinois, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Senior Database Administrator (DBA).The ideal candidate will have deep expertise in.SSIS, HA / DR solutions, database security, automation, and data integration. This role involves not only managing m...[show_more]
    [last_updated.last_updated_30]
    RN

    RN

    Endeavor Health • Highland Park, IL, US
    [job_card.full_time] +1
    The hourly pay rate offered is determined by a candidate's expertise and years of experience, among other factors.We offer flexibility to fit your lifestyle and career goals.Please note that all sh...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Systems Technician

    Information Systems Technician

    U.S. Navy • Highwood, IL, United States
    [job_card.full_time]
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...[show_more]
    [last_updated.last_updated_less] • [promoted] • [new]