Sql server Jobs in Chicago, IL

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