If you reside in California, please see our California Applicant Privacy Policy for more information about our data handling practices and your data rights.
ResponsibilitiesMV Transportation is seeking a Database Administrator to provide support for the corporate database environment within the Infrastructure group. The individual shall be a self-starter, highly motivated and able to work in a fast-paced environment under pressure. This position will be responsible for handling various tasks including but not limited to setup and management of SQL server maintenance plans, monitoring of SQL performance, database design and administration. This position does not require travel.
Job Responsibilities:
- Establishment and monitoring of SQL database Maintenance Plans
- Monitoring of SQL performance data
- Monitoring status and results of daily scheduled SQL jobs and packages
- Support requests for unscheduled Database backups and restores
- Working closely with web and report developers
- Managing database-related release activities for staging and production systems
- Developing, configuring and maintaining databases and related systems. This includes writing well-formed, efficient SQL queries, views, jobs and stored procedures
- Adherence to policies, processes and procedures within your areas of responsibility
Talent Requirements:
- Highly organized and detail-oriented
- Excellent documentation, communication and interpersonal skills
- Excellent analytical and problem-solving abilities
- One (1) year experience performing DBA like tasks
- Two (2)+ years of broad-based IT experience
Desired Qualifications:
- Experience with SQL Language (SELECT, INSERT, UPDATE, DELETE)
- Familiarity with backups and restores including differential and transaction logs
- Experience with RDBMS - Primary Keys, Foreign Keys, Indexing
- Unique Records/Duplication
- Knowledge of transactions - Understand ACID Properties
- Basic data modeling skills
- Ability to provide on-call support outside normal business hours as needed
Work Environment:
Office location; can sit for extended periods; minimal lifting. This position works a Monday through Friday during normal business hours with evening and weekend hours as needed for critical outages.
MV Transportation is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, physical or mental disability, veteran or military status, genetic information or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. The information collected by this application is solely to determine suitability for employment, verify identity and maintain employment statistics on applicants.
Where permissible under applicable state and local law, applicants may be subject to a pre-employment drug test and background check after receiving a conditional offer of employment.
Skills Required
- One year of experience performing database administrator tasks
- Two or more years of broad-based IT experience
- Experience with SQL language, including SELECT, INSERT, UPDATE, and DELETE
- Familiarity with database backups and restores, including differential and transaction logs
- Experience with relational database concepts, including primary keys, foreign keys, and indexing
- Understanding of unique records and duplication
- Knowledge of database transactions and ACID properties
- Basic data modeling skills
- Ability to provide on-call support outside normal business hours as needed
- Strong organization and attention to detail
- Excellent documentation, communication, and interpersonal skills
- Excellent analytical and problem-solving abilities
What We Do
MV Transportation is a privately owned passenger transportation company that provides public transit services across North America. Its offerings include paratransit, fixed-route, shuttle, and school bus transportation, with operations for more than 100 public transit agencies and private companies in the United States and Canada. For the Mid Mon Valley Transit Authority, MV operates fixed-route and commuter bus service connecting residents to work, school, healthcare, and Pittsburgh.
