Sr. Cloud Database Administrator

| Chicago | Remote
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
About CCC
CCC Intelligent Solutions Inc. is the technology platform for the P&C insurance economy. CCC technology, insights, and support connect industries - insurers, automotive manufacturers, collision repairers, parts suppliers, lenders, fleet operators and more - to advance decision-making, productivity, and customer experiences for thousands of clients worldwide. Clients leverage CCC's network management, data management, AI, operational workflows and customer experience solutions to efficiently scale, interact, transact and achieve their unique business objectives. CCC was ranked a best mid-sized company to work for by Forbes (2019). BuiltIn Chicago, Austin and LA named CCC a top place to work in 2020 & 2021. Diverse perspectives and experiences are core to CCC's success and award-winning culture of more than 2,000 employees worldwide. We hold inclusion as a core value and are committed to celebrating and cultivating the diversity of our team. With a 40+ year track record of innovation, CCC's tenacious spirit and growth mindset turn next generation technology into real world solutions and empower team members to expand their knowledge and potential. Headquartered in Chicago, CCC has 7 locations worldwide and is listed on the New York Stock Exchange (NYSE: CCCIS). Find out more about CCC Intelligent Solutions by visiting cccis.com.
Job Description Summary
The CCCIS Database Services organization is seeking a Senior Cloud Database Administrator that will be responsible for participating in the design, documentation, implementation, and support of all non-production and production database systems, including SQL Server, MongoDB, AWS Aurora, Big Data (Hadoop/EMR), DynamoDB and other cloud database platforms. This position will drive major transformational initiatives, streamline processes, implement/improve automation strategies, assist with lowering OpEx, assist with building DevOps pipelines, define standards for our operating model, respond to support escalations and ensure the performance, availability, scalability and security of all production database systems. In collaboration with your peers and management, recommend the most appropriate technical strategies and approaches to support business critical systems. This position will interface with Product Management, Program Management, third party vendors, as well as SMEs from the following disciplines: Product Development, QA, Systems Administrators, Storage Administrators, Network Engineers, Security Engineers and other cloud and IT Architects. In conjunction with Program Management, lead the coordination efforts with both technical and non-technical peer groups as well as third parties to determine requirements, priorities for technical tasks and implementation guidelines in order effectively deploy database solutions.
Job Duties
  • Act as the technical lead on mid to large size projects
  • Directly interact with the technical architects and drive database infrastructure solutions.
  • Be responsible for analyzing business requirements; determining appropriate technical approach and developing specifications for implementation.
  • Designs, develops, and performs complex software installations and configuration changes.
  • Assist more junior database administrators with complex operational maintenance activities.
  • Be expected to lead technical design activities, produce sizing estimates, consult on testing plans, and participate in all related software build and deployment activities.
  • Work closely with the IT Operations staff to diagnose and resolve escalated technical issues with production systems.
  • Define strategies for backups, migration of database changes, and longer term system growth.
  • Long term planning for scalability of the database infrastructure and services.
  • Lead performance analysis and tuning of the databases and applications.
  • Develop health checks/monitors for monitoring systems
  • Maintain and improve the build, management and deployment framework and participate in the design and documentation of this environment
  • Establishes and enforces all database standards. Analyzes all informational requirements of new or production systems and develops database specifications. Establishes and enforces controls to ensure database integrity.
  • Interfaces with application owners and developers to resolve advanced technical issues.
  • Participates in the incident and event escalation process.
  • Participates in the problem management.
  • Utilizes monitoring and troubleshooting tools to restore service.
  • Participates in root cause analysis by gathering and reviewing pertinent logs and collaborating with peers and management.
  • Additional duties as assigned
Qualifications
  • Bachelor's degree and 5+ years of direct SQL Server and Cloud based database technologies experience supporting highly transactional, business critical systems.
  • Experience with complex SQL Server migrations is required (SQL 2008+ up to SQL 2019)
  • An advanced level of understanding of SQL Server implementations, maintenance, performance tuning and optimization.
  • The ability to effectively facilitate communications and collaborate with all staff levels, as well as work independently on complex projects and tasks.
  • Strong organizational skills. The ability to prioritize workload independently.
  • Initiative and an excellent attitude. Motivated to learn and apply new concepts quickly.
  • Stay informed of the latest database and related technologies and provide feedback and recommendations to peers and management
  • Excellent interpersonal, written, and verbal communication skills.
  • Expert understanding of database backup and restore concepts and implementations.
  • Expert performance tuning and optimization skills.
  • Expert understanding of index design and management.
  • Expert understanding of security concepts and implementations.
  • Expert understanding of storage layouts, throughput requirements and various storage technologies including SAN, EBS, SSD, NVME, RAID and storage protocols.
  • Expert understanding of concurrency and locking concepts.
  • Expert understanding of SQL Server installations and configurations for stand-alone, Windows/SQL clustering and Availability Groups.
  • Expert troubleshooting Windows clustering as well as transactional replication, mirroring, replication, log shipping, availability groups.
  • Advanced understanding of Windows and Linux system administration.
  • Advanced understanding of cloud architectures and database platforms, PaaS and DaaS, including MongoDB, AWS RDS Aurora MySQL, DynamoDB and Big Data technologies including EMR, RedShift and other supporting services.
  • Develops and maintains standards for implementation, maintenance, and optimization.
  • Advanced understanding of DevOps pipelines, including Azure DevOps, infrastructure as code (Terraform, Cloud Formation), and other relative CI/CD services
  • Advanced understanding and experience with implementing database automation solutions, including build, deployment, monitoring and alerting.
  • Reviews performance and capacity planning reports and makes recommendations to management. Implements approved recommendations.
  • Demonstrates strong customer service and interpersonal skills.
  • Demonstrates expertise in how multiple technologies interrelate.
  • Advanced knowledge of service levels and business impacts of system unavailability.
  • Demonstrates strong project management and influence skills.
  • Effectively communicates with multiple levels of the technical, business, and management community regarding service, process, and technical issues.
  • Remains informed of technology and process enhancements within the industry and proactively shares with peers.
  • Demonstrates advanced ability to successfully develop, plan, implement and test systems.
  • Recognizes patterns of problems, issues, or opportunities and resolves them on a scale larger than incident, e.g., problem management.
  • Creates, communicates and implements solutions to address integration, technical, service, or process issues across multiple environments. Provides significant influence in designing processes and procedures.
  • Accurately logs and tracks all problems or work utilizing existing problem management or project management tools. Proposes solutions using data analysis for increased effectiveness/efficiency. Solutions are expected to be actionable.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • KubernetesLanguages
    • DockerLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • DjangoFrameworks
    • ExpressFrameworks
    • FlaskFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • AccessDatabases
    • CassandraDatabases
    • HBaseDatabases
    • MariaDBDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • NoSQLDatabases
    • Google AnalyticsAnalytics
    • PhotoshopDesign
    • JIRAManagement
    • WordpressCMS

Location

Two city blocks and twenty-five stories of innovation and culture. theMART is interwoven into the fabric of Chicago’s history as an innovator in tech

An Insider's view of CCC Intelligent Solutions

How would you describe the company’s work-life balance?

I've been here 5 years, and I learn something new everyday. I have the opportunity to grow my skill set, the flexibility to spend time with my family, and the support to accomplish my professional goals.

Prasanthi

Senior Manager, Quality Assurance

What's the biggest problem your team is solving?

We are looking at every single aspect of the vehicle lifecycle related to insurance and collision. We’re injecting key technologies across the spectrum to create a modernized consumer experience. This includes using telematics for vehicle underwriting. detecting accidents to enable insurers and OEMs to proactively reach out to their customers.

Jason

Senior Vice President, Product Strategy and Management

How has your career grown since starting at the company?

When I started as an intern at CCC, I was trusted to work with extraordinary technology. Now, as a DevOps Manager, I get to work on those technologies and new ones with other pioneers - that type of innovation ignites my creativity.

Amin

Manager, DevOps

How do you empower your team to be more creative?

Our teams are technically adept and highly capable. Equally, if not more importantly, they have a passion and desire to learn. We're not satisfied just cranking out code, there is a strong desire to learn about our customers and be creative

John

Senior Director, Product Management

How does the company support your career growth?

Employees get to learn about multiple products across our entire customer base. This allows employees to figure out what area aligns best with their strengths and interests, and where they are looking to grow.

Susanne

Senior Manager, IT Operations

What are CCC Intelligent Solutions Perks + Benefits

CCC Intelligent Solutions Benefits Overview

Perks are fun, but they should also be highly functional. So we offer more than just free coffee and gym membership benefits (though we've got those, too). We offer comprehensive and well thought-out benefits for your health, happiness and bank account.

Culture
Friends outside of work
Eat lunch together
Daily sync
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Diversity
Dedicated Diversity/Inclusion Staff
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
CCC's Flexible Spending Accounts (FSA) help employees cover out-of-pocket expenses with pre-tax contributions for medical, dental, vision, prescription drug, and dependent care expenses.
Disability Insurance
CCC provides short-term and long-term disability insurance.
Dental Benefits
CCC provides two dental plans with Aetna, PPO and DMO.
Vision Benefits
CCC provides two vision plans with VSP.
Health Insurance Benefits
CCC offers four medical plans offered through BCBSIL (PPO, Health Savings Account [HSA], Health Care Account [HCA], and Kaiser Permanente HMO.
Life Insurance
Pet Insurance
Wellness Programs
CCC's wellness programs includes annual physicals, financial and mental wellness, and weight loss programs. All of these are provided free of charge.
Onsite Gym
Retirement & Stock Options Benefits
401(K)
CCC offers ROTH and/or pre-tax contributions.
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Flexible Work Schedule
Remote Work Program
CCC allows employees to work remotely pending their team and manager's discretion.
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
We also give all our employees an additional day of PTO as a cultural observance floating holiday, and can be used as our employees see fit.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Parking
Depending on your location (Chicago, Austin, LA) we do provide either free parking or subsided parking fees for our employees.
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
CCC offers tuition reimbursement to an accredited academic institution for all full-time employees up to $5,250 annually.
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
Online course subscriptions available
Paid industry certifications

Additional Perks + Benefits

We know that investing in employee development is crucial. Employees have access to the CCC Learning Academy. The CCC Learning Academy was created as an internal platform for you as an employee. You come here to learn new skills such as time management, cooking, financing a home or career and business development. We empower our employees to learn within these four walls, but then go out and collaborate on these ideas with friends and family

More Jobs at CCC Intelligent Solutions37 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Remote
Developer
new
Chicago
HR + Recruiting
new
Chicago
Marketing
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView CCC Intelligent Solutions's full profileSee more CCC Intelligent Solutions jobs