Previous Job
Previous
SQL Serve DBA
Ref No.: 18-48962
Location: Dallas, Texas
Position Type:Contract
Start Date: 07/12/2018
Job Title: SQL Serve DBA
Company: Wabtec Corporation
Location: Ontario, CA or Fort Worth, TX
Rate: $55 per/hr

Job Summary:
Develop and support real-time software applications and engineering duties for Wabtec Railway Electronics (WRE) a leading supplier of technology based products and services for the rail and transit industries. This position has an opening for a dynamic, result-oriented Sr. Software engineer with a positive attitude to getting the job done. The individual will be assigned to supporting the Train Control Office System (TCOS) product for multiple customers. This position may require domestic travel up to 5% of the time.

Essential Job Functions/Responsibilities:
  • Installation, Administration and Maintenance of SQL Server Instances.
  • Setup Test, Dev, Staging and Production Environments
    Create Users and assign permissions based on the level of database access the user would need.
  • Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
  • Design database Backup and Restoration Strategy.
  • Once created the database Backups, monitor those backups are being performed regularly.
  • From time to time recover the databases to a specific point of time, as per the requests.
  • Setup High-Availability as part Disaster Recovery Strategy for the Databases.
  • Troubleshoot various problems that arise in a day-to-day work and fix the issues.
  • Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
  • Documenting major changes to the SQL Servers
  • Apply Service Packs.

Qualifications:
  • Strong 5+ year's overall SQL Server DBA experience
  • Strong Computer Science fundamentals in DB design, data structures, design patterns and algorithm design.
  • Familiarity with and proficiency in Linux is a plus.
  • High degree of attention to detail.
  • Strong debug and troubleshooting skills.
  • Team player and works well with others.
  • Effective oral and written communication skills; ability to articulate clearly and concisely.
  • Self-motivated, quick learner, results-oriented and a clear focus on quality.
  • Ability to develop elevated level of credibility and strong positive relationships with peers and management.
Education, Experience and Knowledge Required:
  • The candidate needs to have 10+ years' experience in software development and support processes for enterprise-class systems.
  • College Bachelor's/Master's Degree or equivalent experience in information systems or computer science with strong experience in Time critical application development.
  • Experience and understanding of the database management systems used to support complex n—tiered systems.
Would be desirable but not mandatory that candidate has knowledge of railroad system operations