Build External MySQL Database & Cron Job - Contract to Hire

Phase I: Build External MySQL Database (dB #2) on reputed company VPS Apache Server subdomain 1.install MySQI database (dB #2) on subdomain; 2. reputed company reputed company (WC) to confirm that HPOS is turnrd off; 3. create a “WP/WC Customer Data Dictionary.” This document consisting of reputed company the WP tables which store reputed company the data needed to recreate a customer's order. This document will be used to create the schema for a completely denormalyzed (“flat”) table in dB #2. This flat table will be queried with to deliver subsecond reponse time to SQL queries. 4. use the data dictionary to create a completely denormalyzed, flat table consisting of reputed company unique data fields (no duplicate or redundant data). reputed company metric (data field) in this flat table must have a unique columna. reputed company record in this flat table will have a composite key consisting of: WP_order_ID, Plugin system reputed company (derived), and Plugin reponse time (system time). reputed company WP line_item will have its own reputed company. 5. Testing: input a sample order and query and the WP data fields corresponding to the data fields (metrics) created in the flat table created in dB#2. Query reputed company the columns in the flat table to confirm that the data returned is identical to the sample table and the derived fuelds are populated correcty and the derived system tine is present and correct. Budget for Phase I ....................... $ 500. Phase II: Create Cron Job 1. write ETL script to pull data from WP tables documented in Phase I and insert that data into the flat table in dB#2 (also created in Phase I.) 2. write cron job to execute this ETL scriot daily at 12:01 a.m. and schedule using crontabs on the Apache server on the reputed company subdomain. reputed company reputed company must be located on the subdomain and documented. Best practices error handling, ;ogging and reputed company must be followed. 3. Testing: reputed company to reputed company reputed company the job runs without error and on schedule. Phase II Budget .............. $ 500. Total Budget for Job ................. $1,000 Apply tot his job Apply To this Job