Jobs
>
Chicago

    SQL Database Administrator - Chicago, United States - Komatsu

    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.



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


  • KYYBA North Chicago, United States

    Job Description · Job DescriptionJob Title: Database Administrator (Onboarding/Administrative Assistant III) · Contract: 6 months with potential to extend · Pay Range: $25-$27 · Work Location: North Chicago, IL (Hybrid; 2 days onsite, 3 days remote) · Job Description: · Role, at ...


  • 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 an ...


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


  • Uline Chicago, United States

    Senior Database Administrator · Corporate Headquarters · 12575 Uline Drive, Pleasant Prairie, WI 53158 · Are you a project leader? Do you enjoy mentoring others? Then you belong at Uline As a Senior Database Administrator, support database solutions for North America's top distr ...


  • Hinshaw & Culbertson Chicago, United States Full time

    SENIOR DATABASE ADMINISTRATOR · Location: Flexible and in any state where the firm has an office. · Hinshaw & Culbertson LLP, a national law firm, currently has an excellent full-time employment opportunity for a Senior Database Administrator. We offer competitive compensation a ...


  • The LaSalle Group Chicago, United States

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a SQL Database Administrator their team. · The SQL Database Administrator will be responsible for maintenance and support of the SQL S ...


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


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


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


  • iManage Chicago, United States

    We 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 have a meaningful work-life balanc ...


  • Canadian Imperial Bank of Commerce Chicago, United States

    Senior Database Administrator page is loaded · Senior Database Administrator · Apply · locations · Chicago, IL · time type · Full time · posted on · Posted Yesterday · job requisition id · We're building a · relationship-oriented · bank for the modern world. We need t ...


  • Insight Global Chicago, United States

    You will be responsible for setting up database environments, deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases. Performs performance monitoring, security, tr ...


  • Komatsu Chicago, United States

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


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


  • CIBC Chicago, United States

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


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


  • Archdiocese of Chicago Chicago, United States

    Opportunities at other Organizations / Parishes / Dioceses, not with the Archdioceseof Chicago · National Religious Vocation Conference · 5416 S Cornell Avenue · Chicago, Illinois60615 · Description: · GENERAL SUMMARYTo serve our members and fulfill the mission of the Nation ...