Salary range is:
$115,564.00 - $150,000.00
This position is bonus and/or commission eligible.
CCC Intelligent Solutions Inc. is a leading cloud platform for the multi-trillion-dollar P&C insurance economy creating intelligent experiences for insurers, repairers, automakers, part suppliers, lenders, and more.
The CCC Intelligent Experience Cloud, powered by broad AI and an innovative event-based architecture, connects more than 35,000 businesses to power customized applications and platforms for optimal outcomes, and personalized experiences that just work. Through purposeful innovation and the strength of our connections, our 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.
Want more jobs like this?
Get jobs in Chicago, IL delivered to your inbox every week.
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.