SQL Database Administrator

Date: Apr 22, 2024

Location:

Milwaukee, WI, US, 53204-2941 Chicago, IL, US, 60631

Req ID: 30027

Onsite or Remote: Hybrid Position

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.