Offer summary

Qualifications:

Bachelor’s degree in Information Technology or related field required., Minimum 10 years’ experience in SQL Server database administration (2008R2-2022)., Minimum 3+ years working with Azure cloud data platform., Strong skills in database tuning, performance management, and backup/recovery of large databases..

Key responsabilities:

Install, maintain, upgrade, troubleshoot and support SQL Server database technologies on Azure.

Ensure databases are replicated and backed up to meet operational and disaster recovery requirements.

Design and implement a monitoring and automation framework for optimized performance.

Participate in 24x7 DBA support on-call rotation and technical incident calls to restore service.

Job description

Salary range is:

$115,564.00 - $150,000.00

This position is bonus and/or commission eligible.

CCC Intelligent Solutions Inc. (CCC) is a leading cloud platform for the multi-trillion-dollar insurance economy, creating intelligent experiences for insurers, repairers, automakers, part suppliers, and more. At CCC, we’re making life just work by empowering more than 35,000 businesses with industry-leading technology to get drivers back on the road and to health quickly and seamlessly. We’re pushing boundaries with innovative AI solutions that simplify and enhance the claims and repair journey. Through purposeful innovation and the strength of its connections, CCC technologies empower the people and industry relied upon to keep lives moving forward when it matters most. Learn more about CCC at www.cccis.com.

The Role

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.

Key Responsibilities:

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

Requirements:

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 CCC's Commitment to Employees:

CCC Intelligent Solutions understands that our employees play an integral role in our vision to shape a world where life just works. Our team is defined by our values of Integrity, Customer-Focus, Innovation, Inclusion & Diversity, Tenacity, and Connection. Through diverse perspectives, purposeful innovation, and the strength of connections, our technologies empower the people and industry relied upon to keep lives moving forward when it matters most.

At CCC, together everyone can thrive as we innovate and collaborate, creating employee experiences that just work. We are committed to providing opportunities for our people to make real-life impacts, advance in their careers, and contribute to CCC’s success.

CCC offers competitive compensation and benefits to support you and your families, including:

401K Match
Paid time off
Annual Incentive Plan Performance Bonus
Comprehensive health insurance
Adoption Assistance
Tuition Reimbursement
Wellness Programs
Stock Purchase Plan options
Employee Resource Groups

For more information about our benefits, please check out our careers site.

Here, you belong. You are seen, valued, and respected. We celebrate you for who you are and all you bring. Every voice is heard and is important to our success. You can hear what employees have to say about our culture here

If you require reasonable accommodation to complete a job application, pre-employment testing, or a job interview or to otherwise participate in the hiring process, please contact (800) 621-8070.

Required profile