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]
    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]
    Senior System Administrator

    Senior System Administrator

    InsideHigherEd • Palos Hills, Illinois, United States
    [job_card.full_time]
    Infrastructure & Network Services.Under general direction, the Senior System Administrator is responsible for reviewing the design, installation, maintenance, training, and support of Windows serve...[show_more]
    [last_updated.last_updated_30] • [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]
    Restaurant Delivery - Flexible Schedule

    Restaurant Delivery - Flexible Schedule

    DoorDash • Zion, 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]
    CDL-A Lease Driver

    CDL-A Lease Driver

    Trekker • Highwood, IL, US
    [job_card.full_time]
    Take control of your future with a lease program built for drivers who want more than miles — they want ownership.At Trekker, we know success isn’t luck — it’s focus. That’s why our Lease Purchase P...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    BCBA (Board Certified Behavior Analyst)

    BCBA (Board Certified Behavior Analyst)

    Majestic Care • Flossmoor, IL, United States
    [job_card.part_time]
    Full or Part Time- BCBA (On Site, Hybrid or Remote Options).If you are searching for a mission-driven, high-energy organization, that believes in empowering individuals with autism and their famili...[show_more]
    [last_updated.last_updated_30] • [promoted]
    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]
    Sr SAP Basis Administrator

    Sr SAP Basis Administrator

    Medline Industries - Transportation & Operations • Northbrook, IL, US
    [job_card.full_time]
    Job Summary Job Description The SAP Basis Administrator Sr.SAP solution lifecycle management and for ensuring the performance and reliability of SAP and other enterprise systems.The administrator w...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Network Administrator

    Sr. Network Administrator

    CF Industries • Northbrook, IL, United States
    [job_card.full_time]
    At CF Industries, our mission is to provide clean energy to feed and fuel the world sustainably.Our employees are focused on safe and reliable operations, environmental stewardship, and disciplined...[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]
    Board Certified Behavior Analyst (BCBA)

    Board Certified Behavior Analyst (BCBA)

    The Stepping Stones Group, LLC • Burbank, IL, United States
    [job_card.full_time]
    Make a Lasting Impact as a BCBA!.Empowering Students, Enriching Futures!.Are you a passionate Board-Certified Behavior Analyst (BCBA) looking to make a real difference? The Stepping Stones Group is...[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]