Senior SQL DBA

| Chicago

Job Description Summary

CCC is seeking a dynamic Senior SQL Server DBA having experience in all aspects of administering SQL Server databases including: installation, maintenance, tuning, performance analysis, backup/recovery, security and high availability.

The right candidate should be passionate about data and thrive in a fast-paced environment. As a senior member of the team, you will be tasked with maintaining the current SQL Server landscape while always remaining forward looking as the SQL footprint expands. This position will be joining the DBA team and be responsible for the full life cycle of all SQL Server architecture, installations, monitoring, and availability of the SQL Server environments.

 

Job Duties

  • Understand CCC's business systems and impacts of infrastructure on business operations
  • Install, maintain, upgrade, troubleshoot and support SQL Server database technologies
  • 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
  • Provide problem solving expertise and coordination as required across all implemented technologies
  • Tune databases and database queries for optimal performance
  • Document database designs and related processes
  • Fulfill availability and service level objectives associated with database systems
  • 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
  • Evaluate and recommend database tools

 

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 6+ years’ experience in SQL Server database administration (2008R2-2017)
  • Minimum 6+ years’ information systems experience in a large enterprise systems environment supporting mission-critical systems and applications
  • Demonstrate ability to complete projects both independently and in cooperation with co-workers
  • Strong understanding of Windows OS features and capabilities (2003-2016)
  • Excellent verbal and written communication skills
  • Excellent problem-solving skills across multiple disciplines
  • Strong database installation, maintenance, and upgrade skills
  • Experience with SQL and scripting skills
  • Experience installing and configuring Always On SQL Server environments
  • Experience in using Solarwinds DPA, RedGate, or similar monitoring tools

 

Preferred Qualifications

  • Experience with SSIS / SSRS is a plus
  • Experience with other database technologies including Oracle is preferred
  • One year of cloud-based experience using vendors such as Amazon AWS or Microsoft Azure
  • Experience migrating SQL Server from on-prem to the cloud is a plus

 

Why Choose CCC:

 

We promote a healthy work-life balance and offer generous benefit plans and resources designed with employee satisfaction in mind.
What we value is simple - customers, employee commitment, collaboration and clear communication.

We hire people who will embrace the company’s goals and productively contribute in ways that help us serve the customer, innovate, and stay strong.
We make it a priority to keep employees healthy, happy and enriched.

 

  • Healthy - Wellness programs, competitive medical benefit offerings
  • Happy – Recognition programs, a confidential employee assistance program, Perkspot/employee discount program and potentially flexible work arrangements such as staggered start times
  • Enriched – Tuition reimbursement, training and learning programs, and leadership development opportunities

 

Our corporate headquarters is located in downtown Chicago within the historic Merchandise Mart—a certified LEED (Leadership in Energy and Environmental Design) building.

 

Please Note: Contingent Workers, Field Inventory Representatives and Interns are not eligible for the benefits above.

 

CCC Information Services was recognized by Forbes as one of America’s Best Mid-Sized Employers in 2018 and ranked #17 in the Top 100 Digital Companies in Chicago in 2017 by Built In Chicago.

 

CCC is ready to help you shift your career into high gear. Let's get started!

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • DjangoFrameworks
    • SpringFrameworks
    • HadoopFrameworks
    • HBaseDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • NoSQLDatabases
    • SparkDatabases
    • 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

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

Manager, Quality Assurance

How do you collaborate with other teams in the company?

There is a strong focus on learning and progressing from missteps, with the ultimate goal of making sure we meet
business needs. I have the flexibility to talk directly to people outside of my immediate team which speeds up the delivery process, and aids in responsiveness.

Jennifer

Services Delivery Manager - Austin, TX

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

Director, Product Development

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

Manager, Operations

What are CCC Perks + Benefits

CCC 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.

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 bio-metric screenings, financial 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
Flexible Work Schedule
Remote Work Program
CCC allows employees to work remotely pending their team and manager's discretion.
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Game Room
Happy Hours
Monthly in-house happy hours organized by our CCC employees. Often these have themes for each month depending on time of year. March Madness, Cubs vs White Sox, Mardi Gras, and more!
Parking
Relocation Assistance
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.

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 CCC33 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Internships
Marketing
Operations
Product
Project Mgmt
Sales
Data + Analytics
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Product
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Product
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Internships
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Finance
new
Chicago