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]

    Database Administrator • Chicago, IL

    [internal_linking.similar_jobs]
    Senior Database Engineer

    Senior Database Engineer

    Bottomline • Chicago, IL, United States
    [job_card.full_time]
    Why Choose Bottomline? Are you ready to transform the way businesses pay and get paid? Bottomline is a global leader in business payments and cash management, with over 35 years of experience and m...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Cloud Platform Director : Lead Scalable, Secure Cloud & Team

    Cloud Platform Director : Lead Scalable, Secure Cloud & Team

    Vizient, Inc. • Chicago, IL, United States
    [job_card.full_time]
    A major healthcare solutions provider is looking for a Cloud Infrastructure Director to lead a team of engineers in enhancing cloud strategies. This role includes overseeing the adoption of cloud te...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle Database Developer Chicago, IL

    Oracle Database Developer Chicago, IL

    Career Mentors, LLC • Chicago
    [job_card.temporary]
    Hybrid (3 days onsite, 2 days remote).Local to Chicago, IL or nearby locations.The Oracle Database Developer will be responsible for delivering robust and efficient database solutions to meet compl...[show_more]
    [last_updated.last_updated_30]
    Azure Data Architect & Engineer — Scalable Cloud Pipelines

    Azure Data Architect & Engineer — Scalable Cloud Pipelines

    Akkodis • Chicago, IL, United States
    [job_card.full_time]
    A leading technology solutions provider is seeking an Azure Engineer – Database Architect for a contract in Chicago, IL (Remote). This role involves designing scalable data architectures using Azure...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Software Architect, Cloud SBL Platform

    Senior Software Architect, Cloud SBL Platform

    Medium • Chicago, IL, United States
    [job_card.full_time]
    A leading technology company in Chicago seeks a Senior Software Architect to define the architecture for its cloud-based platform. This role involves leading development efforts, collaborating acros...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Desktop Administrator

    Desktop Administrator

    Purple Drive • Chicago, IL, Illinois, USA
    [job_card.full_time]
    Job Title : Desktop Administrator Loca...[show_more]
    [last_updated.last_updated_30]
    Billing Solutions Architect

    Billing Solutions Architect

    Stripe • Chicago, IL, United States
    [job_card.full_time]
    Stripe is a financial infrastructure platform for businesses.Millions of companies—from the world’s largest enterprises to the most ambitious startups—use Stripe to accept payments, grow their reve...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Database Engineer — Scale Global Smart Mobility Data

    Senior Database Engineer — Scale Global Smart Mobility Data

    Verra Mobility Corporation • Chicago, IL, United States
    [job_card.full_time]
    Verra Mobility is a global leader in smart mobility.We develop technology-enabled solutions that help the world move safely and easily. We are fostering the development of safe cities, working with ...[show_more]
    [last_updated.last_updated_30] • [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]
    Senior Windows Administator / Platform Engineer IV

    Senior Windows Administator / Platform Engineer IV

    Hudson Manpower • Skokie, IL, US
    [job_card.full_time]
    We're hiring a Platform Engineer IV with deep expertise in Windows Administration and enterprise application support.This role supports mission-critical environments and tools like IBM FileNet and ...[show_more]
    [last_updated.last_updated_30]
    Enterprise Azure Databricks Architect | Data Platforms

    Enterprise Azure Databricks Architect | Data Platforms

    Cushman Wakefield Multifamily • Chicago, IL, United States
    [job_card.full_time]
    A leading real estate firm is looking for a highly skilled Databricks Architect to design scalable data solutions in Chicago, IL. This role involves architecting cloud-native data platforms and prov...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Hybrid Data Architect I : ETL and Analytics

    Hybrid Data Architect I : ETL and Analytics

    Ann & Robert H. Lurie Children's Hospital of Chicago • Chicago, IL, United States
    [job_card.full_time]
    A pediatric healthcare institution located in Chicago is seeking a Data Architect I responsible for designing and managing ETL jobs and data applications. You will work with various data sources, en...[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]
    Storage & Server Technician - Chicago, IL

    Storage & Server Technician - Chicago, IL

    Unisys Corporation • Chicago, Illinois, United States
    [job_card.full_time]
    What success looks like in this role : .Serves as Field Engineer for large, complex clients and across the range of company products and services. Performs server and storage break and fix.Performs VI...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Lead Associate Principal, Database Administration

    Lead Associate Principal, Database Administration

    The Options Clearing Corporation • Chicago, IL, United States
    [job_card.full_time]
    This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Healthcare Analytics Leader - SQL & Tableau Dashboards

    Healthcare Analytics Leader - SQL & Tableau Dashboards

    CH01 CHE Fresenius Medical Care (Schweiz) AG • Chicago, IL, United States
    [job_card.full_time]
    A leading healthcare analytics firm is seeking a Director of Healthcare Analytics to transform large datasets and develop insightful Tableau dashboards in a hybrid work environment.Candidates must ...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    SVP, Data Cloud Sales — AMER & EMEA

    SVP, Data Cloud Sales — AMER & EMEA

    salesforce.com, inc. • Chicago, IL, United States
    [job_card.full_time]
    A leading cloud computing company is seeking a transformative SVP of Sales to lead Data Cloud sales in AMER and EMEA.This role demands a visionary leader with deep expertise in data platforms and c...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Cloud Data Architect

    Senior Cloud Data Architect

    Mastek • Chicago, IL, United States
    [job_card.full_time]
    A data services company seeks an experienced Architect / Senior Data Engineer in Chicago to design and optimize data ecosystems. The ideal candidate should have over 8 years of data engineering expe...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]