Applications Architect (6170-1)

Job Description

The candidate will be responsible for maintaining and updating the authoritative CAD representation of the subway system using Bentley MicroStation.

This role ensures that infrastructure assets such as track, platforms, signals, third rail, pumps, fans, exits, and related facilities are accurately reflected within engineering drawings and synchronized with supporting Oracle database records.

Key Responsibilities

• Update and maintain subway system drawings using Bentley MicroStation.
• Incorporate infrastructure changes including track layouts, platforms, signals, third rail systems, pumps, fans, exits, and other field assets.
• Maintain the integrity and accuracy of metadata linking CAD drawings to Oracle database records.
• Update Oracle database tables and ensure consistency between CAD drawings and enterprise asset data.
• Develop, execute, troubleshoot, and maintain Oracle PL/SQL scripts and stored procedures.
• Perform data validation and reconciliation activities to ensure drawings and database records remain synchronized.
• Collaborate with engineering, maintenance, operations, signals, traction power, and facilities teams to obtain and verify infrastructure updates.
• Investigate and resolve discrepancies between CAD drawings and database information.
• Support reporting, data quality initiatives, and documentation related to transit infrastructure assets.

Skills/experience of the assigned staff: Required

• Bently MicroStation
• Oracle PL/SQL