Database Administrator - Riverdale, United States - Purple Line Transit Operators LLC

Description

Job Overview:
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.

The position of
Database Administrator 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

• 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
• 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
• 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 fouryear accredited college or university or equivalent years of education and experience with a minimum of three years of progressive experience. 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, etc.
• 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 manuals. 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
• 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

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
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