The Role
Maintain authoritative subway system CAD drawings in Bentley MicroStation and synchronize infrastructure asset data with Oracle databases. Update CAD representations, Oracle tables, PL/SQL scripts, and stored procedures; validate and reconcile records; investigate discrepancies; and collaborate with engineering, maintenance, operations, signals, traction power, and facilities teams to ensure accurate transit infrastructure data and documentation.
Summary Generated by Built In
Job Title: Applications Architect (6170-1)
Duration: 12 months
Location: New York
Notes: This is a remote role.
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
Required
- Bently MicroStation
- Oracle PL/SQL
About Us:
Since 2000, Tri-Force Consulting Services (https://triforce-inc.com) has been an MBE/SDB certified IT Consulting
firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps),
systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government
and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity,
increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing
core values: integrity, diligence, and technological excellence.
Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the
Inc. 5000 list of the nation's fastest-growing companies.
Skills Required
- Experience with Bentley MicroStation
- Experience with Oracle PL/SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Tri-Force Consulting Services, Inc. is a U.S.-based IT consulting and staffing agency that provides comprehensive IT solutions, including AI-powered services, custom software development, cybersecurity, cloud technology, and IT staffing to government and commercial sectors.








