Jobs
>
Chicago

    SQL Database Administrator - Chicago, United States - Komatsu

    Komatsu
    Komatsu Chicago, United States

    1 week 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, including TimberPro, 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.

  • Metropolitan Water Reclamation District of Greater Chicago

    Database Administrator

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

  • Saxon Global

    Database Administrator

    22 hours ago

    Saxon Global Chicago, United States

    Opportunity for a Database Administrator. Here are the details: · Position: Database Administrator · Location: Remote; Ideally hybrid onsite in Boston, MA · Duration: 6+ Months · Overview: · Creates and maintains databases for test, development and production environments. ...

  • Performix Business Services LLC

    Database Administrator

    22 hours ago

    Performix Business Services LLC Chicago, United States

    Job Description · 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. · Optimi ...

  • Patterned Learning AI

    Database Administrator

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

  • Metropolitan Water Reclamation District of Greater Chicago

    Senior Database Administrator

    3 weeks ago

    Metropolitan Water Reclamation District of Greater Chicago Chicago, United States

    General Statement · Under direction, leads the design, implementation, administration and maintenance of the District's relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also resp ...

  • CIBC

    Senior Database Administrator

    1 week ago

    CIBC Chicago, United States

    We're building a · relationship-oriented · bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have ...

  • Saxon Global

    Database Administrator V

    1 week 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 ...

  • SDI Presence LLC

    Junior Database Administrator

    1 week 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 ...

  • Request Technology, LLC

    Database Administrator

    2 weeks 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 · 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 ...

  • iManage

    Senior Database Administrator

    3 days ago

    iManage Chicago, United States

    Job Description · Job DescriptionWe offer a flexible working policy that supports the health and well-being of our iManage employees. As an organization, we value collaborating and learning from our peers in person, while providing the necessary flexibility for our employees to h ...

  • The University of Chicago

    Database Administrator

    3 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

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

  • Alliant Credit Union

    Database Administrator

    3 days ago

    Alliant Credit Union Chicago, United States

    In this role, you will be responsible for administering the SQL Server Databases. Troubleshoot database issues and develop recovery procedures by following the DBA functions and architectures and credit union policy and procedures. · ResponsibilitiesSupport Microsoft SQL databas ...

  • The Options Clearing Corporation

    Associate Principal, Database Administration

    2 weeks ago

    The Options Clearing Corporation Chicago, United States

    What You'll Do: · This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database ap ...

  • OCC

    Associate Principal, Database Administration

    1 week ago

    OCC Chicago, United States Full time

    What You'll Do: · This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database ap ...

  • Belvedere Trading

    Database Administrator

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

  • Na Oiwi Kane

    Database Administrator

    3 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 ( ...

  • The University of Chicago

    Database Administrator

    1 week 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 ...

  • Performix

    Database Administrator

    1 week 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 ...