Construction & HVAC Database Development

I need a robust database to store and manage information related to new construction houses and HVAC systems. This data will be crucial for a mobile app that communicates with job site foremen and for performance analytics of HVAC installers.

The database should include:

House construction details
HVAC system details
Foreman and installer performance records
The data needs to be accessed via an API for integration with other systems.

The mobile app should be developed for IOS and android or web client

Ideal skills and experience:
- Strong database design and management
- API development expertise
- Mobile app development for iOS
- Web client development for desktop data entry and analytics
- Experience in construction and HVAC data handling

Please provide a portfolio with relevant experience.