Jobs
>
Chicago

    SQL Database Administrator - Chicago, United States - Komatsu

    Komatsu
    Komatsu Chicago, United States

    2 weeks ago

    Default job background
    Description

    Komatsu is an indispensable partner to the construction, mining, forestry, forklift, and industrial machinery markets, maximizing value for customers through innovative solutions. With a diverse line of products supported by our advanced IoT technologies, regional distribution channels, and a global service network, we tap into the power of data and technology to enhance safety and productivity while optimizing performance. Komatsu supports a myriad of markets, including housing, infrastructure, water, pipeline, minerals, automobile, aerospace, electronics and medical, through its many brands and subsidiaries, includingTimberPro, Joy, P&H, Montabert, Modular Mining Systems, Hensley Industries, NTC, and Gigaphoton.

    Job Overview

    We have an opportunity for a SQL Database Administrator to join our global IT team. This role is working onsite at our corporate headquarters in Chicago, IL (near O'Hare) or Milwaukee, WI (Harbor District).

    Key Job Responsibilities
    • Support the implementation, configuration, maintenance, and performance of critical SQL Server systems in on-premise, Azure IaaS, and PaaS environments.
    • Ensure the availability and consistent performance of our corporate applications.
    • Collaborate with other IT teams such as network, security, architecture, and application teams to design and implement database solutions that ensure high levels of performance, availability, and security.
    • Configure and maintain database servers and processes, including monitoring of system health and performance.
    • Configure Azure Data Factory including monitoring and optimizing ETL workflows for pipelines, and transitioning SSIS packages to Azure Data Factory (ADF).
    • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
    • Refine and automate regular processes, track issues, and document changes.
    • Assist developers with complex query tuning and schema refinement.
    • Follow change management process for all production changes.
    • Participate in on call rotation if needed.

    Qualifications/Requirements
    • Bachelors Degree in MIS, Computer Science, a related major or equivalent experience. Associate degree with experience may be considered.
    • 4+ years as a database administrator with SQL Server 2016 and newer.
    • Experience using native and 3rd party monitoring and troubleshooting tools.
    • Proficient in performance tuning for MS SQL Server, with expertise in ensuring data integrity, managing data retention, conducting data analysis, optimizing data input/output processes, and enhancing SQL code performance efficiency.
    • Experience with backups, restores and recovery models.
    • Experience with Replication, Clustering, Always On and other HA architectures .
    • Experience in configuring Azure Data Factory including monitoring and optimizing ETL workflows of pipelines and adept at migrating SSIS packages to ADF.
    • Understanding SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) as well as Azure Synapse and Data Lake.
    • Understanding of DevOps workflow deployment processes including releases and stages of CI/CD pipelines.
    • Proficient in Windows Server administration, including Active Directory. Possesses working knowledge of hardware, networking, SQL Server connectivity, and the necessary tools for troubleshooting and diagnosing issues.
    • Adept at independent work planning and organization, while also collaborating effectively with other teams.
    • Strong team player with excellent verbal and written communication skills.

    Additional Information

    Komatsu is an Equal Opportunity Workplace and an Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

  • Na Oiwi Kane

    Database Administrator

    2 weeks ago

    Na Oiwi Kane Chicago, United States

    **JOB DESCRIPTION** · **Position Title**:Database Administrator · **Location**:80% Remote, 20% Chicago, IL · **Introduction**: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board ( ...

  • Performix

    Database Administrator

    2 days ago

    Performix Chicago, United States

    Job Description: · Database Engineers administer, test, and implement databases, applying knowledge of database management systems. · Database Engineer Responsibilities and Duties: · Assist in design and development of distributed database systems. · Optimize database systems for ...

  • The University of Chicago

    Database Administrator

    1 day ago

    The University of Chicago Chicago, United States

    Department · BSD BIS - Business Intelligence Services · About the Department · About the Department · The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and translational research, education, and patient care come togeth ...

  • Belvedere Trading

    Junior Database Administrator

    2 weeks ago

    Belvedere Trading Chicago, United States

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...

  • TechCoreGlobal

    SQL Database Administrator

    3 days ago

    TechCoreGlobal Chicago, United States

    **Title: SQL DBA** · **Location: Chicago, IL (Onsite - Open for relocation )** · **Good SQL DBA skills, having some experience of doing TDE data base encryption & automations in the DBA space.** · **Responsibilities**: · - Manage and maintain SQL databases including PostgreSQL, O ...

  • Patterned Learning AI

    Database Administrator

    2 weeks ago

    Patterned Learning AI Chicago, United States

    Job Description · Database Administrator - Remote Job, 1+ Year Experience · Annual Income: $60K - $65K, Onsite · A valid work permit is necessary in the US/Canada · About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It of ...

  • Request Technology, LLC

    Database Administrator

    1 week ago

    Request Technology, LLC Chicago, United States

    NO SPONSORSHIP · Associate Principal, Database Administration - DB2 / LUW · SALARY: $125K - $155K PLUS 15% BONUS · LOCATION: CHICAGO, IL · HYBRID 3 DAYS ONSITE AND 2 DAYS REMOTE · Looking for a candidate with 7 years db2 LUW on Red Hat linux and windows. 7 years postgre SQL SQL s ...

  • RIVET OPERATIONS COMPANY LLC

    Database Administrator

    2 weeks ago

    RIVET OPERATIONS COMPANY LLC Chicago, United States

    JOB DESCRIPTION · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) provi ...

  • The University of Chicago

    Database Administrator

    2 weeks ago

    The University of Chicago Chicago, United States

    This job was posted by : For more information, please see: Department · BSD BIS - Business Intelligence Services · About the Department · About the Department · The University of Chicago Biological Sciences Division (BSD) contains all elements of academic medicine. Basic and tr ...

  • Rivet Operations Company Llc

    Database Administrator

    1 week ago

    Rivet Operations Company Llc Chicago, United States

    JOB DESCRIPTION · Before applying for this role, please read the following information about this opportunity found below. · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a ...

  • Metropolitan Water Reclamation District of Greater Chicago

    Database Administrator

    2 weeks ago

    Metropolitan Water Reclamation District of Greater Chicago Chicago, United States

    General Statement · Under direction, designs, implements, administers and maintains the District's relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database p ...

  • Belvedere Trading

    Database Administrator

    1 week ago

    Belvedere Trading Chicago, United States Full time

    Belvedere Trading is a leading proprietary trading firm proudly headquartered in downtown Chicago. Our traders work hard to provide liquidity to the market through their market-making activities and are the masters of a diverse set of commodities, interest rates, exchange-traded ...

  • Belvedere Trading

    Database Administrator

    2 weeks ago

    Belvedere Trading Chicago, United States Full time

    Belvedere is looking for someone passionate about monitoring, maintaining, and providing operational support of our entire database platform. You will improve the performance and efficiency of our data storage and access systems that deliver the high-quality and reliable data tha ...

  • SDI Presence LLC

    Junior Database Administrator

    3 days ago

    SDI Presence LLC Chicago, United States

    Company · SDI Presence LLC is an IT consultancy and managed services provider (MSP) that leverages its strong team presence to advance our clients to a secure digital enterprise. With a 25-year corporate resume, SDI delivers strategic managed services, IT consulting, and hybrid ...

  • The LaSalle Group

    SQL Database Administrator

    3 weeks ago

    The LaSalle Group Chicago, United States

    We are seeking a skilled SQLDatabase Administrator to join our client's team. As a SQL Database Administrator, you will play a pivotal role in ensuring the smooth operations and optimization of valuable databases. · SQL Database Administrator Responsibilities: · Design, install, ...

  • Georgia IT Inc

    Senior Database Administrator

    1 week ago

    Georgia IT Inc Chicago, United States

    Position - Senior Database AdministratorLocation - Chicago, ILDuration - 12 MonthsSalary - DOE · US Citizens and those authorized to work in the U.S are encouraged to apply. We are unable to sponsor at this time. · Jo b DescriptionThe SQL Server Database Administrator will prov ...

  • Saxon Global

    Database Administrator V

    4 days ago

    Saxon Global Chicago, United States

    Job Title: AWS Redshift DBA · Work Location: Required to be onsite 2 days a week · Travel Expenses: Can't Pay Travel Expenses at this time · United Airlines is seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This indi ...

  • The Brixton Group, Inc.

    Oracle Database Administrator

    1 week ago

    The Brixton Group, Inc. Chicago, United States

    3 weeks ago · Be among the first 25 applicants · Leads the design, development, delivery, and optimization of databases, database instances, database clusters, database software, and related components. · Conducts Oracle application system reviews to optimize application perform ...

  • Cook County Treasurer's Office

    SQL Database Administrator

    4 weeks ago

    Cook County Treasurer's Office Chicago, United States

    Summary: · The Cook County Treasurer's Office is seeking a highly skilled and motivated SQL Database Administrator (DBA) to join our team. As a SQL DBA, you will be responsible for ensuring the performance, availability, and security of our SQL Server databases. You will work clo ...

  • RIVET OPERATIONS COMPANY LLC

    Cloud Database Administrator

    2 weeks ago

    RIVET OPERATIONS COMPANY LLC Chicago, IL, United States

    JOB DESCRIPTION · Position Title: Database Administrator · Location: 80% Remote, 20% Chicago, IL · Introduction: · Rivet Operations Company ("Rivet") has an opening for a Database Administrator. This position will be in support of the U.S Railroad Retirement Board (RRB) provi ...