MBTA
EAMS Administrator
At the MBTA, we envision a thriving region enabled by a best‑in‑class transit system. Our mission is to serve the public by providing safe, reliable, and accessible transportation. MBTA’s Core Values are built around safety, service, equity, sustainability, and culture. Each employee that works for the MBTA performs their roles based on our vision, mission, and values. This includes attendance, participation, and contribution in local safety committee meetings as needed.
Job Summary Inline with 49 CFR 625, 630, and 673 requirements, the EAMS Administrator is responsible for the overall asset management, work planning, asset inventory, and application support for the EAMS software at MBTA. The EAMS Database Administrator supports and performs changes and upgrades to Transit IT environments including after‑hours support and implementation of changes and releases of new software and hardware. Document and facilitate the work of IT as it relates to vendors in the support and implementation of technology at MBTA. Duties include (but are not limited to) system performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, and audit trail monitoring. Design and implement database solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications.
Duties & Responsibilities
System performance monitoring and capacity planning, database installation and configuration, database backup and recovery, patch upgrades, security compliance, audit trail monitoring
Design and implement database solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications
Design and develop stored procedures, triggers, functions, and SSIS packages
Analyze and study complex application/database requirements to proactively design, plan, and deploy needed capabilities
Evaluate and analyze database systems for enhancements, design, develop, and maintain databases that interact with software applications
Modify database objects according to requests and perform tests
Ensure data quality and integrity in database development techniques
Prepare design specifications and functional documentation for assigned database projects
Translate technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and impact
Schedule and coordinate routine database maintenance tasks with minimal impact on users and ongoing projects
Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; and evaluating computer operating systems and hardware products
Maintain and support existing enterprise applications along with internal and external integration components
Maintain quality service by establishing and enforcing organization standards
Participate in on‑call and off‑hours production problem‑resolution activities
Responsible for all aspects of the EAMS applications related to content, process integrity, and development, as well as application troubleshooting and performance reporting
Monitor the EAMS system setup and ongoing maintenance processes regarding the installation, training, and ongoing support
Identify and communicate EAM System defects to vendor and/or IT
Archive and restore data; support and maintain EAM System reports; run queries and create ad‑hoc reports
Support all EAM environments, including testing, development, training, and production
Create data loaders for the migration of data into the EAMS
Promote a high level of customer service to ensure and drive best practices and standardization
Lead testing efforts related to new functionality, new modules, and upgrades to existing modules, including creating test plans, test cases, and ensuring the user acceptance testing (UAT) process is followed by employees
Assist MBTA’s IT department with technical support throughout the lifecycle of the system
Provide overall connectivity support for all hardware and software platforms as needed
Maintain master data standards and perform audit/education functions against those standards, adjusting standards as required to meet business and customer needs
Identify and coordinate processes for version management, system build, ACM models, backup and recovery, archiving, and change management
Maintain parts/asset data accuracy, software and hardware configuration changes, and equipment hierarchy in the system
Perform data mining and analysis that supports reliability, maintenance, and capital improvement
User setup, employees, shifts, crews, and supervisors
Enforce the Department of Asset Management policies
Occasionally be flexible to work all shifts and/or locations as assigned or directed
Respond or report to work as directed by supervisory personnel for emergencies, extreme weather conditions, or any other abnormal conditions that impair service or safety 24/7
Uphold the rights and interests of the Authority while building and maintaining an effective relationship with employees
Perform related duties and projects as assigned
Minimum Requirements & Qualifications
A Bachelor’s degree from an accredited institution in a technical field related to Computer Science, Electrical Engineering, Information Technology, or a related field
Four (4) years of professional experience with enterprise asset management software suite including project management, process improvement analysis, and software solution recommendation under enterprise software architecture
Experience with Oracle 19c, Oracle SQL Developer, SQL Server 2014/2016, SQL Management Studio (SSMS), Team Foundation Server (TFS), Visual Studio, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS)
Extensive experience writing SQL queries, views, stored procedures, functions, and triggers
Experience in full software development life cycle and working with developers, business analysts, and project managers on a regular basis
Be able to perform and develop ETL processes in the context of multiple integration systems
Ability to map middleware and front end of applications to the backend database objects
Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk
Excellent understanding and practical experience with T‑SQL, data modeling, and data analysis
Present understanding of troubleshooting, root‑cause analysis, application design, solution development, human factors/usability design, and implementation of medium‑sized projects
Strong oral and written communication skills to effectively explain technical concepts
Exceptional problem‑solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems
Microsoft SQL Server administration/development experience
Working knowledge of network infrastructure (DMZ, WAN/LAN, ODBC, etc.)
Previous experience with Windows Server 2008/2012/2016
Preferred Experience And Skills
A Master’s degree from an accredited institution in a technical field related to Computer Science, Electrical Engineering, Information Technology, or a related field
Employee or Consultant experience for a Transit/Rail agency
Asset Management and Configuration Management experience
Experience in Railroad or Transit infrastructure design and build
Basic knowledge of AREMA, Asset Management principles and EAMS
Substitutions Include
A High School Diploma or GED with an additional seven (7) years of enterprise asset management software (EAMS) suite experience substitutes for the Bachelor’s degree requirement
An Associate’s degree from an accredited institution with an additional three (3) years of directly related experience in Computer Science, Electrical Engineering, Information Technology, or a related field substitutes for the Bachelor’s degree requirement
A Master’s degree in a related subject substitutes for two (2) years of general experience
A nationally recognized certification, or statewide/professional certification in a related field substitutes for one year of experience
Job Conditions
Ability to effectively read, comprehend, communicate, and respond to instructions, orders, signs, notices, inquiries, etc. in English
Be at least eighteen (18) years of age, except if participating in an approved high school internship / co‑op program
Ability to commute to assigned work locations in the Boston, MA metro area, as required by the role
Ability to provide internal and external customers with courteous and professional experiences
Ability to work effectively, independently, and as part of a diverse workforce team (or supervise, if required)
Ability to uphold the rights and interests of the MBTA while building and maintaining effective relationships with employees and co‑workers
Ability to adhere to rules, regulations, collective bargaining agreements (if applicable), and policies of the MBTA, including EEO, anti‑discrimination, anti‑harassment, and anti‑retaliation policies
Have a satisfactory work record for the two (2) years immediately prior to the closing date of this posting, including overall employment, job performance, discipline, and safety records
Ability to pass a Criminal Offender Record Information (CORI) check, comprehensive background screening, and / or medical clinic screening, potentially including physical examination and drug and alcohol screenings
Ability to work all shifts and / or locations assigned, directed, or necessary for this position, including up to twenty‑four (24) hours per day, seven (7) days per week as necessary to accommodate severe weather conditions, emergencies, or any other circumstances that may potentially impact service or safety
Intern / co‑op staff must be enrolled full or part‑time in an accredited educational program and maintain a cumulative GPA of at least 2.5 for the entire duration of the internship / co‑op. Additionally, interns / co‑ops must have valid work authorization and U.S. Social Security Number prior to starting pre‑employment screenings / pre‑boarding, working in their positions, and throughout the duration of their program
Disclaimers and Definitions
General Disclaimer: The statements contained in this job description are intended to describe a summary, general nature, and complexity of typical job functions and do not represent an exhaustive list of all duties, tasks, and responsibilities required of staff assigned to this position.
Application Completion: It is each applicant’s responsibility to ensure application details are entered completely and correctly, including updated work and education histories (past and current). Incomplete applications may not be considered. Attachments do not substitute for application fields. The recruitment team does not have access to existing employee data / history.
Application Deadlines: Applicants should apply as soon as possible, as the MBTA may stop considering applicants after a sufficiently large applicant pool is established.
Work Environment: The physical demands and work environment characteristics described here‑in are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations can be made to enable individuals with disabilities to perform essential functions. See job description for role‑specific requirements.
Work Eligibility: All employees must be legally authorized to work in the United States and on an unrestricted basis. The MBTA does not have an employer work sponsorship program. However, if you have unrestricted work authorization, or are sponsored by a separate entity, you are welcome to apply. Further, all persons hired will require a U.S. Social Security Number prior to starting the position and employees will be required to complete a Form I‑9 to verify their identity and eligibility to work in the U.S.
Interviews: Candidates should ensure they arrive on time, are prepared, can remain for the duration, and if remote, are in a quiet place without distraction, for the interview. Candidates who do not attend their interview without advance authorization will be considered a no‑show and disqualified from consideration for the position. On a one‑time basis, and due to something emergent, you may be allowed to reschedule the interview. In addition, Human Resources may require documentation supporting the request. However, should you need to reschedule, you will need to contact your Recruiter directly by email.
Safety Sensitive Positions: Employees working in this classification will be subject to periodic physical examinations plus random drug and alcohol testing.
On‑call or 24/7 Positions: Employees working in this classification must be available to respond to page / text / call and report to work as determined by assigned department or the Authority.
Essential / Emergency Staff: During declared "states of emergency," employees working in this classification are required to report to work for their assigned work hours or as directed by management.
ADA Accommodations: The MBTA makes reasonable accommodations for applicants with disabilities. If you require an accommodation during this process, please contact the MBTA’s ADA Unit at 617‑222‑5751 or hradaaa@mbta.com.
Diversity, Equity, and Inclusion: The MBTA is an Equal Employment Opportunity Employer. For terms, descriptions, and definitions related to diversity, equity, inclusion, veteran status, and immediate family members that you may find on the application form, please visit mbta.com/careers-app-definitions.
Intern / Co‑Op Benefits: Employees taking part in an internship or co‑op at the MBTA are eligible to receive accrued paid sick leave as well as a monthly transportation pass, based on the city from which the intern / co‑op commutes to work, at no cost. However, no additional benefits are currently offered for interns or co‑ops.
#J-18808-Ljbffr
Job Summary Inline with 49 CFR 625, 630, and 673 requirements, the EAMS Administrator is responsible for the overall asset management, work planning, asset inventory, and application support for the EAMS software at MBTA. The EAMS Database Administrator supports and performs changes and upgrades to Transit IT environments including after‑hours support and implementation of changes and releases of new software and hardware. Document and facilitate the work of IT as it relates to vendors in the support and implementation of technology at MBTA. Duties include (but are not limited to) system performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, and audit trail monitoring. Design and implement database solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications.
Duties & Responsibilities
System performance monitoring and capacity planning, database installation and configuration, database backup and recovery, patch upgrades, security compliance, audit trail monitoring
Design and implement database solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications
Design and develop stored procedures, triggers, functions, and SSIS packages
Analyze and study complex application/database requirements to proactively design, plan, and deploy needed capabilities
Evaluate and analyze database systems for enhancements, design, develop, and maintain databases that interact with software applications
Modify database objects according to requests and perform tests
Ensure data quality and integrity in database development techniques
Prepare design specifications and functional documentation for assigned database projects
Translate technical database issues, requirements, limitations, and parameters for management and staff, and understand business work processes and impact
Schedule and coordinate routine database maintenance tasks with minimal impact on users and ongoing projects
Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; and evaluating computer operating systems and hardware products
Maintain and support existing enterprise applications along with internal and external integration components
Maintain quality service by establishing and enforcing organization standards
Participate in on‑call and off‑hours production problem‑resolution activities
Responsible for all aspects of the EAMS applications related to content, process integrity, and development, as well as application troubleshooting and performance reporting
Monitor the EAMS system setup and ongoing maintenance processes regarding the installation, training, and ongoing support
Identify and communicate EAM System defects to vendor and/or IT
Archive and restore data; support and maintain EAM System reports; run queries and create ad‑hoc reports
Support all EAM environments, including testing, development, training, and production
Create data loaders for the migration of data into the EAMS
Promote a high level of customer service to ensure and drive best practices and standardization
Lead testing efforts related to new functionality, new modules, and upgrades to existing modules, including creating test plans, test cases, and ensuring the user acceptance testing (UAT) process is followed by employees
Assist MBTA’s IT department with technical support throughout the lifecycle of the system
Provide overall connectivity support for all hardware and software platforms as needed
Maintain master data standards and perform audit/education functions against those standards, adjusting standards as required to meet business and customer needs
Identify and coordinate processes for version management, system build, ACM models, backup and recovery, archiving, and change management
Maintain parts/asset data accuracy, software and hardware configuration changes, and equipment hierarchy in the system
Perform data mining and analysis that supports reliability, maintenance, and capital improvement
User setup, employees, shifts, crews, and supervisors
Enforce the Department of Asset Management policies
Occasionally be flexible to work all shifts and/or locations as assigned or directed
Respond or report to work as directed by supervisory personnel for emergencies, extreme weather conditions, or any other abnormal conditions that impair service or safety 24/7
Uphold the rights and interests of the Authority while building and maintaining an effective relationship with employees
Perform related duties and projects as assigned
Minimum Requirements & Qualifications
A Bachelor’s degree from an accredited institution in a technical field related to Computer Science, Electrical Engineering, Information Technology, or a related field
Four (4) years of professional experience with enterprise asset management software suite including project management, process improvement analysis, and software solution recommendation under enterprise software architecture
Experience with Oracle 19c, Oracle SQL Developer, SQL Server 2014/2016, SQL Management Studio (SSMS), Team Foundation Server (TFS), Visual Studio, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS)
Extensive experience writing SQL queries, views, stored procedures, functions, and triggers
Experience in full software development life cycle and working with developers, business analysts, and project managers on a regular basis
Be able to perform and develop ETL processes in the context of multiple integration systems
Ability to map middleware and front end of applications to the backend database objects
Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk
Excellent understanding and practical experience with T‑SQL, data modeling, and data analysis
Present understanding of troubleshooting, root‑cause analysis, application design, solution development, human factors/usability design, and implementation of medium‑sized projects
Strong oral and written communication skills to effectively explain technical concepts
Exceptional problem‑solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems
Microsoft SQL Server administration/development experience
Working knowledge of network infrastructure (DMZ, WAN/LAN, ODBC, etc.)
Previous experience with Windows Server 2008/2012/2016
Preferred Experience And Skills
A Master’s degree from an accredited institution in a technical field related to Computer Science, Electrical Engineering, Information Technology, or a related field
Employee or Consultant experience for a Transit/Rail agency
Asset Management and Configuration Management experience
Experience in Railroad or Transit infrastructure design and build
Basic knowledge of AREMA, Asset Management principles and EAMS
Substitutions Include
A High School Diploma or GED with an additional seven (7) years of enterprise asset management software (EAMS) suite experience substitutes for the Bachelor’s degree requirement
An Associate’s degree from an accredited institution with an additional three (3) years of directly related experience in Computer Science, Electrical Engineering, Information Technology, or a related field substitutes for the Bachelor’s degree requirement
A Master’s degree in a related subject substitutes for two (2) years of general experience
A nationally recognized certification, or statewide/professional certification in a related field substitutes for one year of experience
Job Conditions
Ability to effectively read, comprehend, communicate, and respond to instructions, orders, signs, notices, inquiries, etc. in English
Be at least eighteen (18) years of age, except if participating in an approved high school internship / co‑op program
Ability to commute to assigned work locations in the Boston, MA metro area, as required by the role
Ability to provide internal and external customers with courteous and professional experiences
Ability to work effectively, independently, and as part of a diverse workforce team (or supervise, if required)
Ability to uphold the rights and interests of the MBTA while building and maintaining effective relationships with employees and co‑workers
Ability to adhere to rules, regulations, collective bargaining agreements (if applicable), and policies of the MBTA, including EEO, anti‑discrimination, anti‑harassment, and anti‑retaliation policies
Have a satisfactory work record for the two (2) years immediately prior to the closing date of this posting, including overall employment, job performance, discipline, and safety records
Ability to pass a Criminal Offender Record Information (CORI) check, comprehensive background screening, and / or medical clinic screening, potentially including physical examination and drug and alcohol screenings
Ability to work all shifts and / or locations assigned, directed, or necessary for this position, including up to twenty‑four (24) hours per day, seven (7) days per week as necessary to accommodate severe weather conditions, emergencies, or any other circumstances that may potentially impact service or safety
Intern / co‑op staff must be enrolled full or part‑time in an accredited educational program and maintain a cumulative GPA of at least 2.5 for the entire duration of the internship / co‑op. Additionally, interns / co‑ops must have valid work authorization and U.S. Social Security Number prior to starting pre‑employment screenings / pre‑boarding, working in their positions, and throughout the duration of their program
Disclaimers and Definitions
General Disclaimer: The statements contained in this job description are intended to describe a summary, general nature, and complexity of typical job functions and do not represent an exhaustive list of all duties, tasks, and responsibilities required of staff assigned to this position.
Application Completion: It is each applicant’s responsibility to ensure application details are entered completely and correctly, including updated work and education histories (past and current). Incomplete applications may not be considered. Attachments do not substitute for application fields. The recruitment team does not have access to existing employee data / history.
Application Deadlines: Applicants should apply as soon as possible, as the MBTA may stop considering applicants after a sufficiently large applicant pool is established.
Work Environment: The physical demands and work environment characteristics described here‑in are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations can be made to enable individuals with disabilities to perform essential functions. See job description for role‑specific requirements.
Work Eligibility: All employees must be legally authorized to work in the United States and on an unrestricted basis. The MBTA does not have an employer work sponsorship program. However, if you have unrestricted work authorization, or are sponsored by a separate entity, you are welcome to apply. Further, all persons hired will require a U.S. Social Security Number prior to starting the position and employees will be required to complete a Form I‑9 to verify their identity and eligibility to work in the U.S.
Interviews: Candidates should ensure they arrive on time, are prepared, can remain for the duration, and if remote, are in a quiet place without distraction, for the interview. Candidates who do not attend their interview without advance authorization will be considered a no‑show and disqualified from consideration for the position. On a one‑time basis, and due to something emergent, you may be allowed to reschedule the interview. In addition, Human Resources may require documentation supporting the request. However, should you need to reschedule, you will need to contact your Recruiter directly by email.
Safety Sensitive Positions: Employees working in this classification will be subject to periodic physical examinations plus random drug and alcohol testing.
On‑call or 24/7 Positions: Employees working in this classification must be available to respond to page / text / call and report to work as determined by assigned department or the Authority.
Essential / Emergency Staff: During declared "states of emergency," employees working in this classification are required to report to work for their assigned work hours or as directed by management.
ADA Accommodations: The MBTA makes reasonable accommodations for applicants with disabilities. If you require an accommodation during this process, please contact the MBTA’s ADA Unit at 617‑222‑5751 or hradaaa@mbta.com.
Diversity, Equity, and Inclusion: The MBTA is an Equal Employment Opportunity Employer. For terms, descriptions, and definitions related to diversity, equity, inclusion, veteran status, and immediate family members that you may find on the application form, please visit mbta.com/careers-app-definitions.
Intern / Co‑Op Benefits: Employees taking part in an internship or co‑op at the MBTA are eligible to receive accrued paid sick leave as well as a monthly transportation pass, based on the city from which the intern / co‑op commutes to work, at no cost. However, no additional benefits are currently offered for interns or co‑ops.
#J-18808-Ljbffr