CNC Administrator

General Summary

This position is responsible for DBA and CNC tasks: DBA administers and maintains Oracle database security and integrity, resolves performance issues, and leads database management efforts. CNC manages the security and integrity of the J.D. Edwards EnterpriseOne system, and supports implementation, upgrades, and technical infrastructure.

Essential Job Accountabilities

DBA

• Administers the security of databases to ensure high availability, optimum performance, and assured security of all Database environments.
• Provides senior technical leadership to the database design teams, database programming group, IT, and the enterprise including being conversant with and cognizant of the future direction of systems, how that direction will impact the enterprise, and how future and current systems can be exploited for the benefit of the enterprise.
• Sets standards and controls the necessary infrastructure process associated with the database(s) of the enterprise.
• Enforces version control and change management processes to support internal and external audit requirements.
• Ensures both internal and external audit requirements are met.
• Works closely with other IT groups to coordinate current and future activities including coordination and technical assistance to facilitate specific development projects that involve the computing environment, the coordination of software upgrades and the installation of new products.
• Manages Database vendors in support of Granite and oversees all contract verbiage and requested work from any vendors via work ticket or direct requests.
• Designs, develops, and implements physical data model for the development and/or production systems to effectively plan for and execute any required database upgrades and migration (patches etc.).
• Supports the data loads into the databases, creates database objects and maintains their physical organization/relationships to ensure that the application and any enhancements interact efficiently with the database.
• Develops and implements database performance monitoring process and analyze monitoring data to enhance performance optimization opportunities.
• Assists in the definition of backup-recovery and archiving strategies, performs administration activities including backup and recovery and produces technical documentation and reports related to the databases, forecasting and system problems under management according to technology standards.

CNC

• Support and maintenance of multiple environments (Pristine, Dev, CRP, QA, PROD) and path codes.
• Proven experience in OMW Object Promotions, Package Builds and Deployment, Installation of ESU's / ASU's / Planner ESU's, Applying Tools Releases in Multi Foundation environment, Change Assistant, Server Manager Administration, etc.
• Support & maintenance of user profiles and security, JobQ / batch administration, print queues, etc.
• Manages CNC vendors in support of Granite and oversees all contract verbiage and requested work from any vendors via work ticket or direct requests.
• Installation of Service Packs and software fixes as well as maintenance of EnterpriseOne backups.
• Assist with issue troubleshooting, tracking and resolution, including usage of a top-tier Service Desk system (ServiceNow).
• Experience with any of the following functionality in JDE will be an asset – LAN & WAN Networking, OS Admin.
• Knowledge of User Productivity Kit (UPK), OneView Reporting (OVR) and E1 Pages.
• Expertise in standard productivity tools - MS Office, MS Project, MS Visio, MS SharePoint, etc.

Education

Bachelor's Degree in Information Systems, Computer Science, or related field.

Work Experience

7+ years of DBA administration experience with Oracle, Oracle RAC, Microsoft SQL, and other database systems, as well as 7+ years of CNC administration experience with JD Edwards implementation or upgrade projects.

Knowledge, Skills, and Abilities

• 7+ years DBA administration experience in day-to-day activities.
• Ability to express complex technical concepts effectively, both verbally and in writing.
• Experience with large databases in an Oracle RAC configuration.
• Demonstrated knowledge of interdependencies between OS security and DB security.
• Expertise in Performance Tuning.
• Oracle Certification preferred.
• MS SQL experience preferred.
• Working knowledge of networks.
• Working knowledge of Windows and Linux OS.
• Working knowledge of software version control concepts and change management processes.
• Working knowledge of ETL processes.
• Working knowledge of data modeling concepts both relational and dimensional.
• Working knowledge of UNIX shell scripting.
• Working knowledge of automated job scheduling.
• Strong experience with Oracle SQL and/or PL/SQL.
• Understanding of authentication and authorization security concepts.
• Understanding of all phases of the Systems Development Life Cycle (SDLC).
• Demonstrated expertise in change management and version control practices.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk and hear. The employee frequently is required to stand, walk, sit and use hands to operate a computer keyboard. The employee is occasionally required to reach with hands and arms. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, and ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Additional Requirements/Skills

• Ability to abide by the company's Code of Conduct.
• Detailed oriented, resourceful, motivated, and creative.
• Flexible, organized and able to handle competing priorities.
• Sound, logic-based decision making capability.
• Strong verbal and written communication skills.
• Ability to work collaboratively and cross-functionally as part of a team as well as independently.
• Ability to work proactively and reactively.
• Recognize areas of opportunity and make recommendations for improvement.
• Assess conflicting priorities and prioritize appropriately.
• Strong communication skills.
• Identify issues to management and provide possible solutions.

Benefits

• Paid holidays and sick leave.
• Medical, dental, vision, life insurance, disability insurance, and flexible spending plans.
• Special programs for musculoskeletal health and mental wellness.
• Salaried employees may choose from two PPO medical plans through Anthem BlueCross, including the most popular plan for which 100% of the premium is paid by Granite for eligible employees and dependents.
• Employees can opt into a Health Savings Account (HSA) or a Flexible Spending Account (FSA).
• 100% match on the first 6% of eligible compensation that salaried employees defer into their 401(k) plans, which vests immediately.

Benefits may vary for positions located outside of the continental United States.

Pay

Base Salary Range: $127,843.00 - $191,763.00. Pay may vary based upon relevant experience, skills, location, and education among other factors.

About Granite Construction Incorporated

Granite Construction Incorporated is a member of the S&P 400 Index and is the parent company of Granite Construction Company, one of the nation's largest heavy civil contractors and construction materials producers.