back Back to Jobs

Consulting Database Analyst

Location: Fort Worth, TX
Job # 11076215
Date Posted: 06-21-2018
BNSF is looking for a DB2 LUW Database Administrator (DBA) to join its Enterprise Information Management team.  The position will be responsible for maintaining the DB2 database components across many enterprise applications.  This includes defining, planning, implementing and supporting application databases.  Candidate should possess extensive knowledge of all aspects of DB2 including developing efficient SQL, performance tuning and monitoring. Knowledge & experience of the PureScale architecture is also required.
Duties and Responsibilities:
  • Perform physical Database Administration (DBA) tasks in DB2 standalone, Highly Available and PureScale architectures.
  • Assist in the designing of table structures and relationships.
  • Develop and test efficient SQL code to interface applications with DB2 databases.
  • Create, debug and maintain stored procedures, Extract/Transform/Load (ETL) routines and purge routines.
  • Design and build simple to complex database structures from data models.
  • Provide rotating 24x7 on-call support as necessary.
  • Identify, diagnose and resolve SQL and database production issues.
  • Participate in design reviews as required to ensure database design meets application requirements.
  • Perform database monitoring and provide solutions to performance issues.
  • Provide automation to standard tasks.  Able to develop scripts on UNIX-based platform as necessary.
  • Review and enforce adherence to the BNSF Architecture, as well as database design and usage standards.
  • Performs other duties as assigned.
 
Required Qualifications:
 
  • B.S. degree from an accredited university.
  • Four or more years of experience as a physical Database Administrator in DB2 on Linux-based operating systems.
  • Two or more years of experience as a physical DBA in DB2 PureScale technologies. 
  • Four or more years of experience as a developer of SQL application code.
  • Four or more years of experience in coding and/or debugging stored procedures.
  • Two or more years of experience in database/application performance tuning and monitoring tools.
  • Two or more years of experience in database problem identification, problem diagnosis and resolution.
  • One or more years of experience as a member of an application team utilizing Agile development methodologies.
  • Experience with Linux commands and scripting
  • Candidate has excellent communication – ability to explain technical concepts and issues to management.
  • Candidate is a positive team player. Shares knowledge. Coaches team members.
  • Candidate is self-directing.  Can accomplish tasks with minimal direction and can accept feedback and adjust accordingly.
  • Ability to be resilient and deliver results under pressure situations.
 
Preferred Qualifications:
 
  • Functional experience in the development of Transportation industry applications is desirable.
  • Experience in working on complex application issues in a multi-tiered environment.
  • Basic understanding of SAN technology.
BENEFITS
BNSF offers competitive benefit programs and services including, but not limited to 
  • Medical, Dental and Vision Coverage
  • 401(k) Plan
  • Retirement Pension Plan
  • Railroad Retirement
  • Life Insurance
  • Incentive Compensation Plan (ICP)
  • Tuition Reimbursement Program
BNSF Railway is an Equal Opportunity Employer Minorities/Women/Veterans/Disabled.
BACKGROUND INVESTIGATION ELEMENTS
  •     Criminal history 
  •     Last 7 years of driving history
  •     Last 5 years of employment history to include military service
  •     Social Security number
  •     Education
MEDICAL REVIEW ELEMENTS:
  •     Medical evaluation
  •     Drug Screen
  •     Other elements as needed


Apply/View Full Description
Gyna M. Bivens
President & Executive Director
North Texas LEAD

Did you apply?

this job portal is powered by CATS

My LEAD


About LEAD

North Texas LEAD Corporate/Community Partnership

North Texas
Employers

Photo Gallery

Letter from Mayor


LEAD Applicants

See Our Video

The Application Process

Did you apply?

Suggestions from Human Resources Experts


PayPal Donate Link

 


© North Texas LEAD All Rights Reserved 2007 Black Lotus Web Design