MySQL Database Design & Integration Consultant

---

Objectives Design a MySQL database schema from scratch tailored to our specific business logic and client structure (no boilerplate templates). Reformat and store data exported via an external driver from Niagara, where key metadata may appear in table names or unconventional formats. Guide database infrastructure decisions with cost and performance in mind (open to AWS alternatives). Support automation for pulling time-series data at regular intervals (e.g., every 15 minutes) and writing it to the database. Ideal Candidate Qualifications Proven experience designing custom database schemas based on business logic (not using one-size-fits-all models). Experience working with time-series data from building systems, IoT platforms, or BMS (preferred). Familiarity with external data sources and integration via APIs or proprietary drivers. Strong communication skills and the ability to collaborate patiently with technical and non-technical stakeholders. Bonus: Familiarity with Niagara Framework and its data structures is a major plus. Success Criteria A normalized MySQL schema designed around our use case: Organized by client, site, user, and equipment Optimized for storing and querying time-stamped data A scalable database architecture running on a cost-efficient cloud infrastructure (current EC2 on AWS, open to alternatives) An automated workflow for moving data from Niagara to MySQL at consistent intervals Documentation that allows our team to understand, manage, and grow the system over time Technical Context Data Source: Niagara Platform via a proprietary external driver Data Characteristics: Time-series format (updated every 15 minutes, adjustable) Important metadata may be embedded in table names Server Environment: Currently hosted on AWS EC2 Future Requirements: Guidance on: Cloud migration or optimization (e.g., RDS vs. EC2 vs. other platforms) Efficient schema tuning for high-volume queries Long-term maintenance and backup best practices

Keyword: Technical Support

Database Design Database Architecture Database Administration Database Development Database Integration MySQL MySQL Programming SQL Database Programming