MySQL Database Development with Enhanced Security -- 2
Budget: $750 – $1,500 USD
A proficient and trusted MySQL developer is required to design a database with specified inputs and outputs.
Project Requirements:
Database Design:
-The database must handle 7+ inputs and generate approximately 19 outputs in formats such as CSV, Excel, PDF, and JSON.
-Outputs include various reports and dashboards, with some requiring complex calculations and aggregations.
-Outputs need to be updated in real-time or at specified intervals (daily, weekly).
User Access:
-Accessible by multiple users through a desktop application or Microsoft SharePoint.
-User roles include read-only, read-write, and admin, with an estimated 15-20 concurrent users.
Integration and Data Input:
- Future integration with existing systems via APIs for automated data collection (capability will be needed to be built in)
-Manual data input, CSV file import, and automated data input from external sources (refer to attached database inputs document)
Data Output Requirements:
Output Formats: Outputs should be available in multiple formats, including but not limited to CSV, Excel, PDF, and JSON
Output Types: These will include detailed reports, summary dashboards, and data exports tailored for different user needs.
Update Frequency: Outputs must be dynamically updated to reflect the latest data changes, either in real-time or at scheduled intervals (daily, weekly).
Accessibility: Outputs must remain active in Microsoft SharePoint folders, ensuring that any updates made in the database are immediately reflected in SharePoint.
Example Outputs: Refer to Database Outputs document attached to ensure clarity and alignment with expectations.
Security Specifications:
-Data encryption at rest and in transit.
-Two-factor authentication for user access.
-Additional suggested security features are welcome.
Performance and Scalability:
-Expected high performance with quick query responses.
-Scalable design to handle growing data volumes and user loads.
Development and Maintenance:
-Development using specified tools (e.g., MySQL Workbench).
-Detailed documentation, including database design, user guides, and maintenance procedures.
-Provision for ongoing maintenance and support.
Ideal Candidates:
-Extensive experience in MySQL database setup, data encryption, and two-factor authentication.
-Proficiency in integrating multiple data input methods and handling large volumes of data.
-Familiarity with creating databases that work seamlessly with Microsoft SharePoint.
Project Requirements:
Database Design:
-The database must handle 7+ inputs and generate approximately 19 outputs in formats such as CSV, Excel, PDF, and JSON.
-Outputs include various reports and dashboards, with some requiring complex calculations and aggregations.
-Outputs need to be updated in real-time or at specified intervals (daily, weekly).
User Access:
-Accessible by multiple users through a desktop application or Microsoft SharePoint.
-User roles include read-only, read-write, and admin, with an estimated 15-20 concurrent users.
Integration and Data Input:
- Future integration with existing systems via APIs for automated data collection (capability will be needed to be built in)
-Manual data input, CSV file import, and automated data input from external sources (refer to attached database inputs document)
Data Output Requirements:
Output Formats: Outputs should be available in multiple formats, including but not limited to CSV, Excel, PDF, and JSON
Output Types: These will include detailed reports, summary dashboards, and data exports tailored for different user needs.
Update Frequency: Outputs must be dynamically updated to reflect the latest data changes, either in real-time or at scheduled intervals (daily, weekly).
Accessibility: Outputs must remain active in Microsoft SharePoint folders, ensuring that any updates made in the database are immediately reflected in SharePoint.
Example Outputs: Refer to Database Outputs document attached to ensure clarity and alignment with expectations.
Security Specifications:
-Data encryption at rest and in transit.
-Two-factor authentication for user access.
-Additional suggested security features are welcome.
Performance and Scalability:
-Expected high performance with quick query responses.
-Scalable design to handle growing data volumes and user loads.
Development and Maintenance:
-Development using specified tools (e.g., MySQL Workbench).
-Detailed documentation, including database design, user guides, and maintenance procedures.
-Provision for ongoing maintenance and support.
Ideal Candidates:
-Extensive experience in MySQL database setup, data encryption, and two-factor authentication.
-Proficiency in integrating multiple data input methods and handling large volumes of data.
-Familiarity with creating databases that work seamlessly with Microsoft SharePoint.