PLTO Database Administrator\Report Developer: Riverdale, MD

Reports To: IT Supervisor

Salary Range: $96,000 to $106,000

Competitive Benefits Package: Health Insurance, Dental Insurance, Paid Leaves Program, and 401K Plan.

SUMMARY

Purple Line Transit Operators (PLTO) is a member of a private consortium (Purple Line Transit Partners) which holds a Public-Private Partnership (P3) contract with the Maryland Department of Transportation/Maryland Transit Administration (MDOT/MTA) for the design, construction, operation, maintenance, and financing of  the Purple Line, which is a new 16 mile/21 station light rail transit line located in Montgomery County and Prince George’s County, Maryland. (https://www.purplelinemd.com/). PLTO’s role in the Project is for the Operations and Maintenance (O&M) of the Purple Line for a 30-year O&M Period after the service opens to the public, currently scheduled for winter 2027.  Prior to this opening, PLTO is responsible for participating in system design, testing, and service start-up activities; conducting certain facilities and equipment maintenance scopes; and building the organization which will perform the O&M Period activities.

PLTO is a joint venture of two companies: Alternate Concepts, Inc (ACI) and CAF USA, Inc. (CAF). ACI is an industry leader in mass transit operations and maintenance and is the O&M provider for the only two Design-Build-Operate-and-Maintain (DBOM)/ Design-Build-Finance-Operate-and-Maintain (DBFOM) transit projects in the U.S: Tren Urbano in San Juan, Puerto Rico and Eagle P3 in Denver, Colorado. CAF USA, Inc. (a division of the international Spanish railway manufacturer Construcciones y Auxiliar de Ferrocarriles) designs, manufactures, maintains, and supplies equipment and components for railway systems and is a certified rail maintenance organization with a presence on five continents.

PLTO is conducting this recruitment for a Database Administrator\Report Developer which has been identified as a key position that is needed as PLTO builds organizational capacity to perform its 30-year O&M scope. The Database Administrator\Report Developer works with all levels of staff to develop and maintain our databases and associated applications. Must work independently and manage time effectively to accomplish department goals.

The position of Database Administrator\Report Developer will continue from the current pre-operational phase of the Purple Line project into the 30-year O&M Period and will be part of the permanent PLTO organization.

Responsibilities:

• Database administration for several mission critical SQL Server databases and associated applications
• Develop and test custom reports from various databases to extract and collect data using complicated SQL code with complex joins
• Create necessary SQL views and advanced stored procedures
• Provide support to functional teams or management by collecting and analyzing data and reporting results.
• Work closely with staff users and management to establish requirements for new systems, reports and modifications and to ensure proper testing and validation of completed reports.
• Responsible for timely implementation of data requests and provide a high level of service to all internal and external customers
• Maintain record of daily data communication transactions, problems and remedial action taken
• Develop training materials and procedures and train users in the proper use of
• Prepare evaluations of systems and recommend improvements or upgrades
• Read trade magazines and technical manuals, and attend conferences and seminars to maintain knowledge of database software and reporting tools
• Configure commercial applications for internal needs
• Answer users’ inquiries regarding computer software and hardware operation to resolve problems
• Develop, implement, and monitor management information systems policies and control to support data accuracy, security, and legal and regulatory compliance
• Develop, maintain, and test disaster recovery plans
• Support systems integration and all other assigned duties

Desired Qualifications:

• Bachelor’s degree in Computer Science or related field from a four-year accredited college or university or equivalent years of education and experience with a minimum of three years of progressive Extended work experience may be substituted for educational credentials if appropriate.
• Strong SQL Development experience and working knowledge of configuring and supporting SQL Server Clusters for HA and DR configurations.
• Experience as a SQL DBA, including data normalization, optimization, data integrity and security
• Proven ability to deliver software products, data reports and data manipulation
• Strong report writing experience using tools such as SRSS, Crystal Reports, Visual Studio, Power BI,
• Ability to analyze and evaluate data
• Proficient with personal computers in a Windows environment including Microsoft Word, Excel, PowerPoint and SharePoint
• Ability to effectively communicate, both orally and in writing with proficiency in spelling, grammar and punctuation
• Ability to plan, organize and prioritize with attention to detail and meet deadlines
• Ability to use good judgment and make sound decisions
• Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
• Demonstrated ability to work effectively in a diverse work environment
• Possession of any other certificates, licenses and registrations as required by to perform the specified functions
• Experience with other transit industry application deployment and administration is a plus
• Must possess a valid driver’s license.
• Willingness to work during evening, weekend, and holiday hours as needed.

Physical Demands

While performing the duties of this job, the employee is required to stand, walk, and sit for periods of time varying in length, walk up and down stairs, and lift and/or move up to 40 pounds.

Work Environment

Successful candidates will be expected to work in an environment where an in-office presence and frequent field visits may be required. Some travel may be required to collaborate with partners or attend trainings.

While performing the duties of this job (while in the field), the employee must be aware of his/her surroundings and may be exposed to outside weather conditions, moving mechanical systems, and building components as well as varying noise levels both within the rail maintenance yards and inside the Operations and Maintenance Facility (OMF).  Personal Protective Equipment (PPE) is always required while in the field and in construction zones.

Pre-Employment Qualifications

Successful candidates must be able to successfully pass a pre-employment background check; pass a pre-employment drug and alcohol screening test; be willing to comply with PLTO’s Drug and Alcohol Policy; and be eligible to work in the U.S.

PLTO reserves the right to revise this job description from time to time. The above statements are intended to describe the general nature and level of work performed and are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of employees assigned to this job.

PLTO is an Equal Employment Opportunity (EEO) employer. We recruit, hire, train and promote persons in all job classifications and ensure that all other personnel actions are administered without regard to race, color, religion, creed, national origin, ancestry, gender, physical or mental disability, pregnancy, sexual orientation, genetic information, veteran or military status, or any other characteristic protected by law.