Lead Production Dba

3 weeks ago

Hoffman Estates, United States CDK Global Full time

The Production Database Administrator (DBA) lead will have technical leadership responsibilities for a team of ~10 highly qualified DBAs. This role involves a balance of hands-on technical activities and management responsibilities. The DBA will oversee a range of tasks related to database administration, maintenance, and optimization, while also leading a team and managing strategic initiatives.

**Key Responsibilities**:

- ** DBA activities (75%) & Management Responsibilities (25%)**:

- Having eyes on glass 24/7 to enable swift response to any alerts or anomalies
- Team Leadership & Project Management: Manage database-related projects from planning to execution, ensuring deadlines and quality standards are met
- Stakeholder Communication: Collaborate with stakeholders and provide strategic guidance on database solutions. Provide continuous feedback to team members
- Should be open to work in shift timings to support production environments
- ** Key DBA activities include**:

- ** Database maintenance (**Install, configure, and upgrade database software, performing regular backups. Monitoring databases, file growth & disk space usage, Implementing monitoring alerts and notifications to proactively identify and address potential issues)
- ** Performance tuning & optimization (**Identifying & resolving performance bottlenecks using monitoring tools & techniques, analyzing query execution & optimizing T-SQL queries for enhanced performance, data archiving, purging as per mutually agreed data retention policy)
- ** Troubleshooting and Support (**Diagnosing and resolving database-related issues, such as performance degradation, deadlock analysis etc.)
- ** Collaborating** with other IT teams to troubleshoot cross-functional issues & providing technical support and guidance to data engineers
- **Automation and Scripting (**e.g. Automating routine tasks such as database backups, index maintenance, and database health checks)
- ** Security Management**:

- ** High Availability & Disaster recovery**:

- ** Documentation and Knowledge Sharing**

**Qualifications**:

- Bachelor’s degree in Computer Science, Information Technology, or related field
- 15+ years of experience in Data Engineering areas with minimum hands-on coding experience of 5 years & mandatory experience in leading production support environments
- TSQL Expert with in-depth knowledge of monitoring & optimization databases
- Proficient on OLTP / OLAP / ER Diagrams / Internal Engine / Index Tuning / Statistics / Execution Plans / SP Optimization / Partitioning / Normalization / Denormalization
- Agile Development Process, Release Management & Continuous Integration & deployment knowledge
- Knowledge of NewRelic, AWS, Postgres SQL, SSIS, SSRS, Snowflake and other database and monitoring technologies are good to have
- Having been in Pager duty and/or managed people in pager duty is a good to have

Compensation: $115,000 - $140,000

CDK Global is committed to fair and equitable compensation practices. Compensation packages are based on several factors, including but not limited to skills, experience, certifications, and work location. The total compensation package for this position may also include annual performance bonus, benefits and/or other applicable incentive compensation plans.We offer Medical, dental, and vision benefits in addition to:

- Paid Time Off (PTO)
- 401K Matching Program
- Tuition Reimbursement

At CDK, we believe inclusion and diversity are essential in inspiring meaningful connections to our people, customers and communities. We are open, curious and encourage different views, so that everyone can be their best selves and make an impact.

CDK is an Equal Opportunity Employer committed to creating an inclusive workforce where everyone is valued. Qualified applicants will receive consideration for employment without regard to race, color, creed, ancestry, national origin, gender, sexual orientation, gender identity, gender expression, marital status, creed or religion, age, disability (including pregnancy), results of genetic testing, service in the military, veteran status or any other category protected by law.

Applicants for employment in the US must be authorized to work in the US. CDK may offer employer visa sponsorship to applicants.

  • BI Analyst, Product Management

    2 weeks ago

    Hoffman Estates, United States LaSalle Network Full time

    LaSalle Network is partnering with an organization to identify a BI Analyst, Product Management to join their team. As a Business Intelligence Analyst within the Product Management Team, you will wield data as a powerful tool, spearheading strategic financial decision-making through comprehensive analysis and insightful discoveries. Your passion for data,...

  • BI Analyst, Product Management

    2 weeks ago

    Hoffman Estates, United States LaSalle Network Full time

    LaSalle Network is partnering with an organization to identify a BI Analyst, Product Management to join their team. As a Business Intelligence Analyst within the Product Management Team, you will wield data as a powerful tool, spearheading strategic financial decision-making through comprehensive analysis and insightful discoveries. Your passion for data,...

  • BI Analyst, Product Management

    5 days ago

    Hoffman Estates, United States Heritage-Crystal Clean, Inc. Full time

    Business Intelligence Analyst, Product Management Overview As a Business Intelligence Analyst within Crystal Cleans’ Product Management Team, you will wield data as a powerful tool, spearheading strategic financial decision-making through comprehensive analysis and insightful discoveries. Your passion for data, financial analysis, and proficiency in...

  • BI Analyst, Product Management

    4 weeks ago

    Hoffman Estates, United States Crystal Clean, LLC Full time

    Job DescriptionJob DescriptionBusiness Intelligence Analyst, Product Management OverviewAs a Business Intelligence Analyst within Crystal Cleans' Product Management Team, you will wield data as a powerful tool, spearheading strategic financial decision-making through comprehensive analysis and insightful discoveries. Your passion for data, financial...

  • BI Analyst, Product Management

    1 week ago

    Hoffman Estates, United States LaSalle Network Full time

    LaSalle Network is partnering with an organization to identify a BI Analyst, Product Management to join their team. As a Business Intelligence Analyst within the Product Management Team, you will wield data as a powerful tool, spearheading strategic financial decision-making through comprehensive analysis and insightful discoveries. Your passion for data,...

  • Soldering Technician

    1 week ago

    Hoffman Estates, United States HR Manager Full time

    Job DescriptionJob DescriptionSoldering Technician (lead) – 8 am to 4:30pm - Hoffman Estates, IL$18 to $22 / HourWe are committed to delivering high-quality products and are currently seeking a skilled Soldering Technician to join our team.Job Description: We are looking for a proficient Soldering Technician to perform high-precision soldering tasks on...

  • Mechanical Engineer

    3 weeks ago

    Hoffman Estates, United States Matrixspace Full time

    MatrixSpace is addressing the next generation of AI-enabled sensing solutions using real-time edge-based sensing to sense, detect, and recognize objects and motion in any situation. MatrixSpace’s ability to combine industry leading RF sensing, AI edge processing and RF communication in real-time is a major technology breakthrough with multiple vertical...

  • Director, Payments Marketing

    3 days ago

    Hoffman Estates, United States CDK Global Full time

    Reporting to the Senior Director, this **Director, Payments Marketing **is a senior-level product marketing professional responsible for developing and overseeing the payments marketing strategy, owning: positioning, packaging, pricing, messaging, content creation and competitive differentiation for the **CDK payments offerings**. This individual will...

  • Branch Manager

    2 days ago

    Hoffman Estates, United States Huntington Bancshares, Inc. Full time

    Description Summary: Our branch banking roles offer a welcoming and inclusive team environment where you are empowered every day to help our customers achieve their financial goals. Our branch colleagues have an opportunity to share ideas and voice opinions that directly impact our customers, our bank, and our communities for the better. As a Branch Manager,...

  • Regulatory Director

    5 days ago

    Hoffman Estates, United States Sensient Technologies Full time

    Sensient Technologies, we are experts in the science, art and innovation of color and flavor. We are market savvy and visionary. We are problem solvers. And we will be better with you. We are looking for a Regulatory Director that will lead our North American region. This senior leader will manage the Americas Regulatory Compliance function and coordinate...

  • Customer Analyst

    15 hours ago

    Hoffman Estates, United States Minerals Technologies Full time

    Overview: Minerals Technologies Inc. (MTI) is a leading, technology-driven specialty minerals company that develops, produces, and markets a broad range of mineral and mineral-based products, related systems and services. MTI serves a wide range of consumer and industrial markets, including household and personal care, paper, foundry, steel, construction and...

  • Technical Service Manager, Flavors

    1 day ago

    Hoffman Estates, United States Sensient Technologies Corporation Full time

    TECHNICAL SERVICE MANAGER, FLAVORS At Sensient Technologies, we are experts in the science, art and innovation of color and flavor. We are market savvy and visionary. We are problem solvers. And we will be better with you. Sensient Technologies Savory Flavors division has a newly created opportunity for self-starter with a minimum 7-10 years' experience in...

  • Outside Sales Specialist

    4 weeks ago

    Hoffman Estates, United States Robert Half Full time

    We are seeking a dynamic and motivated Outside Sales Representative to join our team. This role is crucial in expanding our client base and increasing sales revenue. The ideal candidate will be comfortable with cold calling businesses, conducting onsite client visits, and building strong relationships with potential clients.Responsibilities:Cold Calling:...

  • Outside Sales Specialist

    2 weeks ago

    Hoffman Estates, United States Robert Half Full time

    We are seeking a dynamic and motivated Outside Sales Representative to join our team. This role is crucial in expanding our client base and increasing sales revenue. The ideal candidate will be comfortable with cold calling businesses, conducting onsite client visits, and building strong relationships with potential clients.Responsibilities:Cold Calling:...

  • Outside Sales Specialist

    4 weeks ago

    Hoffman Estates, United States Robert Half Full time

    We are seeking a dynamic and motivated Outside Sales Representative to join our team. This role is crucial in expanding our client base and increasing sales revenue. The ideal candidate will be comfortable with cold calling businesses, conducting onsite client visits, and building strong relationships with potential clients.Responsibilities:Cold Calling:...

  • Strategic Account Manager

    16 hours ago

    Hoffman Estates, United States NXP Semiconductors N.V. Full time

    Strategic Account Manager - Industrial SegmentThe NXP Strategic Account Manager will be responsible for managing industry leading accounts in the industrial vertical segment. You will have the opportunity to take the lead in shaping our future business with several large and growing accounts in the Industrial marketplace. With your knowledge and experience,...

  • Customer Analyst

    8 hours ago

    Hoffman Estates, United States Minerals Technologies Full time

    OverviewMinerals Technologies Inc. (MTI) is a leading, technology-driven specialty minerals company that develops, produces, and markets a broad range of mineral and mineral-based products, related systems and services. MTI serves a wide range of consumer and industrial markets, including household and personal care, paper, foundry, steel, construction and...

  • Customer Analyst

    1 day ago

    Hoffman Estates, United States Minerals Technologies Full time

    Overview: Minerals Technologies Inc. (MTI) is a leading, technology-driven specialty minerals company that develops, produces, and markets a broad range of mineral and mineral-based products, related systems and services. MTI serves a wide range of consumer and industrial markets, including household and personal care, paper, foundry, steel, construction and...

  • Senior Project Engineer

    6 hours ago

    Hoffman Estates, United States Sensient Technologies Full time

    Job Description At Sensient Technologies, we are experts in the science, art and innovation of color and flavor. We are market savvy and visionary. We are problem solvers. And we will be better with you. We are looking for a Senior Project Engineer . In this highly dynamic and visible role you will be responsible for managing capital projects in 10+...

  • Regional Technical Services Manager

    6 hours ago

    Hoffman Estates, United States Minerals Technologies Full time

    Overview: Minerals Technologies Inc. (MTI) is a leading, technology-driven specialty minerals company that develops, produces, and markets a broad range of mineral and mineral-based products, related systems and services. MTI serves a wide range of consumer and industrial markets, including household and personal care, paper, foundry, steel, construction and...