Salary
$30-250
Location
Severna Park, MD, United States
Posted on
Mar 26, 2020
Profile
Amazon Web Services. SQL Database Work. Microsoft Access & Wordpress Work
I have an SQL database that holds the data for a Microsoft Access program and a Wordpress page. They are all linked to the SQL database.
I need the database cleaned up, it is in good condition now but some data needs to be cleaned from a hack that occurred a long time ago.
1a. Enable confirmation emails to be sent to facility.
1b. Facility confirmation email needs to display recap of assigned/unassigned units.
1c. Update MS Access and SQL to allow more than one email recipient at the facility.
2. Optimize the loading of the calendar.
3. Resolve issue in provider maintenance while traversing through the providers, typically around provider 386.
4. When a facility deletes the request, change the format of the email to display the facility name.
5. When a provider confirms a schedule in which no shifts were assigned, the email confirmation does not display the name of who approved the schedule.
6. Create an effective backup solution to securely backup the database to an additional separate location such as Johns computer or Google Drive.
7. Adjust Provider Availability report to stop it from displaying duplicate Providers.
8. Fix the time zone for the Schedule Approval Audit report.
9. Fix John schedule confirmation emails.
19. Create new Staff Smart Report that will list providers and where they are credentialed.
The Database is hosted on AWS, the website is a Wordpress website with PHP and the program is a Microsoft Access program.
Skills:
Microsoft Access
, PHP
, SQL
, MySQL
, WordPress
Company info
Sign Up Now - WashingtondcCrossing.com
Recruiter job
90 Day Old Job