Database/Systems Administrator

Knife River • Bismarck, ND

164d

About The Position

At Knife River, we take care of our team because we know it's our people who make us successful. We are one of the 10 largest construction materials producers/contractors in the Country, and we are a PEOPLE-first company. Our team members are the key to our success, and we are committed to giving them the tools, training, and time to do their jobs productively and safely each day. Our goal is to build strong teams that, in turn, build strong communities. We are also a publicly traded company on the NYSE with the ticker symbol KNF and part of the S&P MidCap 400 index. This position is responsible for the administration and maintenance of the databases within the Knife River environment, including installation, configuration, technical development, monitoring, planning, data management, and issue resolution. This position will also be called upon to provide insight and analysis for the design, development and implementation of technical products and systems related to the Knife River's information technology strategy. Address highly complex technical issues by reviewing, analyzing, and modifying systems including encoding, testing, and debugging. Recommend technical alternatives to improve quality of products and/or procedures. Provide consultation on complex projects; a wide degree of creativity and latitude is expected.

Requirements

• Bachelor's degree in computer science or related field of study.
• A minimum of five years' experience in an Information Technology field or a combination of the two.
• Experience as a Programmer/Systems Analyst.
• Strong technical background with Oracle databases, Oracle Cloud Infrastructure, ERP systems or large software system implementations.
• Large software development and systems integration experience.
• Proficiency with Microsoft Office applications, including MS Access or Visual Basic.
• Experience with a PM package such as Microsoft Project.
• Windows based programming experience.
• Extensive knowledge of computer systems, LAN's, WAN's, and client server (windows based).
• Ability to research new technologies and determine their applicability to Knife River.

Nice To Haves

• Managing Oracle databases in Oracle Cloud Infrastructure (OCI) environment.
• Replication software/tools such as Golden Gate.
• JDE E1 ERP data support.

Responsibilities

• Provide expert judgment and analysis for the design, development and implementation of technical products.
• Work with Knife River's Business Applications teams to schedule, plan and implement IT initiatives related to Knife River's information technology strategy.
• Resolve highly complex technical issues by reviewing, analyzing, and modifying systems including encoding, testing, and debugging.
• Work with the Business Applications team and end-users to resolve issues and accomplish complex reporting and development tasks.
• Assure documentation is created to track projects, using a standard format and properly backed up and located in a standard directory structure.
• Monitor technical infrastructure, review system logs, analyze system parameters and adjust accordingly.
• Apply all relevant DB and OS patches and upgrades.
• Develop, implement, and maintain High Availability and Disaster Recovery systems and procedures for the Oracle databases.
• Work with KRC Business Application teams on development, implementation and monitoring of database system integrations using a variety of technologies including OBIEE, SQL, ODBC, OLEDB, VB, VB.NET, C# and C++.
• Administer Oracle databases; installation, performance issues, database capacity issues and requirements, replication using Data Mirror, DB MOTO, Golden Gate, DTS packages, Linux Operating system, and other distributed data issues.
• Assist in the administration of all JDE Security access and SOX compliance for Knife River companies.
• May require part-time travel with the Business Application teams.
• Responsibilities include being a backup liaison between users and technical resources, coordinating system maintenance and updates with CNC provider and Business Application teams, applying and documenting database updates, tuning of JDE processing queues, and addition/configuration of printers to be used in conjunction with JDE.
• Perform the execution of DB2 SQL scripts using IBM client access tools for JDE E1 ERP data support.
• Assist in coordination of all system maintenance and updates with CNC provider and the ERP team and maintain documentation of changes.
• Assist IT Department with network administration; installation, configuration and troubleshooting of printers, workstations and servers.
• Assist in the maintenance of database and documentation of all JDE user profiles and authorized request sheets for SOX compliance.
• Provide on-going technical support for specialized applications: log trouble calls, analyze, and correct problem or escalate problem to appropriate technician for resolution.
• Available to assist with scheduled on-call support and technical emergencies as required.
• Perform other tasks as assigned.

Benefits

• Equal Opportunity/Affirmative Action employer.
• Subject to pre-employment drug testing and background checks.

What This Job Offers

• Job Type: Full-time
• Industry: Mining (except Oil and Gas)
• Education Level: Bachelor's degree