- Salary
- $128k – $192k
- Location
- The Woodlands - 9303 New Trails, Ste 200, United States of America · Watsonville, California
- Department
- Manufacturing
- Source
- Workday
Description
Building a career at Granite may be the most valuable thing you could do...
Find your dream job today, and be part of something great. Our most powerful partnership is the one we have with our employees. Our people are our most valued asset and the foundation of Granite’s century-old success. We’re building more than infrastructure; we are building your future.
General Summary
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. Enforce 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 and 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 maintain 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 ana 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 an 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
Our Benefits at a Glance:
Building tomorrow starts with you, and Granite knows that you can excel only if we support you in and out of the workplace. That is why we offer a broad benefits package that includes paid holidays, sick leave, medical, dental, vision, life insurance, disability insurance, flexible spending plans, as well as special programs for musculoskeletal health, mental wellness, and more.
Salaried employees may choose from two PPO medical plans through Anthem BlueCross, including our most popular plan, for which 100% of the premium is paid by Granite for eligible employees and dependents. Employees can also opt into a Health Savings Account (HSA) or a Flexible Spending Account (FSA).
As part of our investment in your future outside of the workplace, Granite provides a 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.
Base Salary Range:
$127,843.00 - $191,763.00Pay 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. Granite is a Drug-Free Workplace and Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, protected veteran status, or any other protected characteristic. We consider qualified applicants with arrest and conviction records in accordance with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.
For additional information on applicant/employee rights please click here.
Notice to Staffing Agencies
Granite Construction, Inc. and its subsidiaries ("Granite") will not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to Granite, including unsolicited resumes sent to a Granite mailing address, fax machine or email address, directly to Granite employees, or to Granite's resume database will be considered Granite property. Granite will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume. Granite will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. Agencies must obtain advance written approval from Granite's recruiting function to submit resumes, and then only in conjunction with a valid fully-executed contract for service and in response to a specific job opening. Granite will not pay a fee to any Agency that does not have such agreement in place. Agency agreements will only be valid if in writing and signed by Granite's Human Resources Representative or his/ her designee. No other Granite employee is authorized to bind Granite to any agreement regarding the placement of candidates by Agencies.
