IT Dept -- Assoc. Project Engineer/Systems Engineer -- Teradata DBA

Work Location: Omaha, NE

Closing Date: August 31, 2010

Basic Purpose of Job:

This position is a technical position in the IT Department as part of the career path process. The technical career path is for employees interested in an individual contributor role, who want to work with other team members to ensure a project's success. The main elements of the technical path include: 1) No direct reports, 2) Heavy technical skills, 3) Heavy teamwork, 4) Heavy client/customer contact, 5) Heavy daily planning and execution, 6) Creativity, and 7) Participation in interviewing process.

Two Teradata DBA positions are currently available, reporting to Mike Chekal.
Positions will be filled at Band B/C level (Assoc. Project Engineer, Project Engineer, Sr. Project Engineer, Assoc. Systems Engineer, or Systems Engineer) depending upon the successful candidate's and skill set.

A successful candidate with be a highly motivated self-starter with strong verbal and written communications skills. The candidate will have good technical skills, good troubleshooting skills, and enjoy hands-on activities.

A Teradata DBA is responsible for supporting the Enterprise Data Warehouse (EDW) database. Duties include, but are not limited to, requirements gathering, analysis, database modeling/design, database/table/view creation, implementation of new objects, SQL coding, customer consulting, database backup utilizing NetBackup, and database/SQL performance tuning. Additional tasks will include assisting in the development of standards and procedures for the evolving Teradata EDW platform landscape.

Primary Accountability of the Position:

Business requirements analysis

Logical & physical database design

Data modeling using ERWin

Database object creation

Database object testing and promotion to production

Customer consulting

SQL tuning

Backup & Recovery


Required Experience/Skill Set include:

Strong written and verbal communication skills

Strong Project Management skills

Ability to lead a team in day to day activities

Strong Analytical skills in order to solve problems under pressure.

Proficient with relational database management systems (RDBMS), problem diagnosis and resolution, standards development & compliance plus hands on/detailed experience with Teradata

Strong SQL programming skills
Solid knowledge of the UNIX/LINUX operating system
Solid knowledge of the Union Pacific's mainframe environment

Solid mainframe skills (TSO/ISPF, JCL & job scheduling)


Desired Experience/Skill Set include:

3+ years with Teradata

Experience with UPRR RDBMS environments, and distributed computing environments

Current and/or future employment based sponsorship is not provided.

Accountabilities:

  • Problem Solving: Must be able to solve problems where a precedent has been set. Must be able to understand and integrate solutions in a multi-systems environment, providing a seamless look to the customer.

  • Freedom to Act: Incumbent may set his/her own priorities and may deviate from procedure if the end results meet the standards with supervisory approval. Supervisor typically reviews work product or results after completion.

  • Impact of Action: Responsible for giving advice and counsel, information, and/or analysis for decision makers. Total impact on costs or benefits is less than $4 million annually.

  • Technical Knowledge: Requires working knowledge of several components and detailed knowledge of at least one component. Incumbent can perform routine tasks with no assistance and complex tasks with minimum assistance and guidance.

  • Managerial Knowledge: Requires ability to effectively manage work time and deliver a quality product on time.

  • Business Knowledge: Requires conceptual/working knowledge of at least one UP business process. Incumbent understands and can explain how his/her component fits into the business process.

Preferred Education, Training, Experience or Skills:

  • A Bachelor Degree in Computer Science, Computer Engineering, MIS or related field. Strong applicable experience (a minimum of 6 years direct DBA experience) may be taken into account in lieu of a degree.

  • 2 year(s) experience / knowledge in Information Technology including data management experience and other technical experience/skills as noted in Basic Purpose of Position


Apply NOW for this position

Send this posting to a friend