Location:  Colorado Springs, CO, Albuquerque, NM, or St George, UT; remote is an option

Industry:  Transportation

Responsibilities

Team Size / Dynamics

Desired Skills and Experience

  • Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with complex query tuning and schema refinement.
  • Provide 24x7 support for critical production systems (part of the on call rotation)
  • Perform scheduled maintenance and support release deployment activities after hours
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • You will be working with a small distributed team: 2 other DBA’s, 2 Business Intelligence Analysts and a variety of technical team members (systems- and developer- groups)
  • We are collaborative workers, and use Kanban for task management, Slack for team communication and Jell for team “stand-ups”.
  • Skills

Required

5+ years MS SQL Server Administration experience required Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Desired

Experience with Always On Availability Groups  Experience with Azure SQL and other data engines MCSA/MCSE certifications a plus

The other requirements (hard to quantify, but important nonetheless):

Being passionate is important… the data & systems you maintain help support our aggressive growth as a company. We want you to own the projects you work on, and make them the best they can be.  Transportation might not be the most exciting field in the world, but we are looking for somebody who can get excited about transforming it. We need somebody who communicates well. Being able to communicate well in the English language, both written and verbal, is important.  You will end up working with people other than developers & technical team members (end users, company management, etc.). We require a willingness to adapt and learn. Nobody knows everything, and we don’t expect you to either.  You will need the ability to pick things up quickly and be nimble in your approach.

Technical Environment

We are heavily invested in Microsoft technology with Windows Server, .NET, SQL Server, and Azure serving as the foundation for our systems. SQL Server 2008 R2, 2012 & 2016 (Enterprise)

  • Required
  • 5+ years MS SQL Server Administration experience required
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Desired
  • Experience with Always On Availability Groups 
  • Experience with Azure SQL and other data engines
  • MCSA/MCSE certifications a plus
  • Being passionate is important… the data & systems you maintain help support our aggressive growth as a company. We want you to own the projects you work on, and make them the best they can be.  Transportation might not be the most exciting field in the world, but we are looking for somebody who can get excited about transforming it.
  • We need somebody who communicates well. Being able to communicate well in the English language, both written and verbal, is important.  You will end up working with people other than developers & technical team members (end users, company management, etc.).
  • We require a willingness to adapt and learn. Nobody knows everything, and we don’t expect you to either.  You will need the ability to pick things up quickly and be nimble in your approach.
  • We are heavily invested in Microsoft technology with Windows Server, .NET, SQL Server, and Azure serving as the foundation for our systems.
  • SQL Server 2008 R2, 2012 & 2016 (Enterprise)