SQL Database Administrator

3 months ago

Chicago, United States Komatsu Full time

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.

  • SQL Database Administrator

    1 week ago

    Chicago, United States Stardom Employment Consultants Full time

    About the job SQL Database Administrator Job Description: As a SQL Database Administrator, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems. Your primary role is to ensure the availability and consistent performance of various corporate applications. You will also be responsible for...

  • SQL Database Administrator

    2 months ago

    Chicago, Illinois, United States Komatsu Full time

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

  • SQL Database Engineer

    1 month ago

    Chicago, United States Planet Technology Full time

    Perm role -Green Card or USCLocation: 3 days / week on-site (Tuesday - Thursday) – North ChicagoSQL Database EngineerWork collaboratively with technology and business to conceive, design, engineer, and implement data, software, and technology solutions. Design and implement MS SQL Server database software that drives productivity and efficiency. Looking...

  • SQL Database Engineer

    4 weeks ago

    Chicago, United States Planet Technology Full time

    Perm role -Green Card or USCLocation: 3 days / week on-site (Tuesday - Thursday) – North ChicagoSQL Database EngineerWork collaboratively with technology and business to conceive, design, engineer, and implement data, software, and technology solutions. Design and implement MS SQL Server database software that drives productivity and efficiency. Looking...

  • Database Administrator

    4 weeks ago

    Chicago, Illinois, United States Taft Stettinius & Hollister LLP Full time

    Taft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office.Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...

  • Database Administrator

    4 weeks ago

    Chicago, United States Taft Stettinius & Hollister LLP Full time

    Taft is currently seeking a Database Administrator to join the Information Technology team in our Chicago, Cincinnati, Cleveland, Columbus, Dayton, Detroit, Indianapolis or Minneapolis office. Responsible for the management and maintenance of firm databases ensuring that all are functional at all times. Provides support, maintenance and implementation and...

  • Database Administrator

    3 weeks ago

    Chicago, United States Stash Talent Services Full time

    Role: Snowflake AdministratorLocation: Chicago, IL (Hybrid)Duration: 12 months contractJob DescriptionDatabase Administration and ManagementManage and administer Snowflake databases and warehouses for multiple environments, ensuring high performance, availability, and security.Implement and maintain database security by creating roles, users, and managing...

  • Database Administrator

    2 months ago

    Chicago, United States NinjaTrader Full time

    Job DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...

  • Database Administrator

    3 weeks ago

    Chicago, United States NinjaTrader Full time

    Job DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...

  • Database Administrator

    2 months ago

    Chicago, Illinois, United States NinjaTrader Full time

    NinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team finds...

  • Database Administrator

    2 months ago

    Chicago, United States NinjaTrader Full time

    NinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company culture is one that our team...

  • Database Administrator

    5 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    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 policies and procedures to ensure the integrity and availability of...

  • Database Administrator

    3 weeks ago

    Chicago, United States NinjaTrader Full time

    Job DescriptionJob DescriptionNinjaTrader is an investor-backed, growth-stage fintech company with an award-winning platform and over 1.5 million users. We are building products and services that empower active traders to easily analyze and react to data from the world's leading financial markets. Located in Chicago, our unique employee-centric company...

  • Oracle Database Administrator

    2 weeks ago

    Chicago, United States MyCareersFuture Full time

    Roles & Responsibilities Role Description This role is responsible to provide support in migrating, upgrading, configuring, troubleshooting and administering the Database Platforms in non-Production and Production environments. The incumbent also needs to ensure the platform adherence to IT compliance requirements. Job Responsibilities Create new...

  • Database Administrator

    2 weeks ago

    Chicago, United States NinjaTrader Full time

    Job DescriptionJob DescriptionJOIN US ON OUR MISSION TO BECOME THE #1 RETAIL TRADING PLATFORM IN THE WORLDWelcome to the dynamic world of NinjaTrader! As an industry-leading trading platform and futures broker, we're on a mission to empower traders to take control of their financial destiny. How do we do it? We provide cutting-edge products and services...

  • Database Systems Administrator

    1 day ago

    Chicago, Illinois, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    Job SummaryThe Metropolitan Water Reclamation District of Greater Chicago is seeking a highly skilled Database Systems Administrator to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our relational database systems to support the functional requirements of our application systems.Key...

  • Senior Database Administrator

    5 months ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    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 responsible for developing, implementing, and overseeing database policies and...

  • Oracle Application Database Administrator

    2 weeks ago

    Chicago, United States TEKsystems Full time

    **Candidates must reside in or around Chicago, IL as this is an exciting opportunity based out of Downtown Chicago. Please do not apply if you are not local** Description: Project: The applicant will be assisting in implementing the Oracle advanced security features, and tuning the Oracle RAC configuration. Job Summary The Oracle Applications DBA's role is...

  • Oracle Application Database Administrator

    1 week ago

    Chicago, IL, United States TEKsystems Careers Full time

    Candidates must reside in or around Chicago, IL as this is an exciting opportunity based out of Downtown Chicago. Please do not apply if you are not local** *Project: The applicant will be assisting in implementing the Oracle advanced security features, and tuning the Oracle RAC configuration. The Oracle Applications DBA's role is responsible for supporting...

  • Oracle Application Database Administrator

    1 week ago

    Chicago, IL, United States TEKsystems Careers Full time

    *Candidates must reside in or around Chicago, IL as this is an exciting opportunity based out of Downtown Chicago. Please do not apply if you are not local**Description:* Project: The applicant will be assisting in implementing the Oracle advanced security features, and tuning the Oracle RAC configuration. Job Summary The Oracle Applications DBA's role is...