Virtual Software Developer: Migrate SQL database to SQL as a Service
Preferred learners
- Canada
- Academic experience
Categories
Skills
Project scope
- What is the main goal for this project?
-
Our organization is able to offer a virtual developer opportunity for an individual or team of 2 computer science students.
The primary focus areas for the student(s) will be:
- Database Analysis and Migration - Research and choose a cloud-based SQL as a Service platform (eg. Google GCP). Migrate our existing Microsoft SQL multi-tenant Google GCP-hosted SQL database to the SQLaaS platform. Set up a sandbox lab to verify that all current blueButler application functionality is maintained. Investigate the processes and procedures required to create, update and access the platform; in particular, security permissions and restrictions.
The goal for this project is to demonstrate a working prototype of the migrated SQL database in the sandbox environment.
Our virtual student(s) is expected to have the following tools:
- Windows 10 Pro Laptop or Computer
- .NET Visual Studio
- Knowledge of SQL databases
We will plan to communicate with our virtual intern using these communication tools:
- Gmail
- blueC Slack channels
- blueC VoIP system (Ring Central)
Student's primary contact: Jeff McDonald, Senior Software Developer
Secondary contact: John McDonald, CTO
- Database Analysis and Migration - Research and choose a cloud-based SQL as a Service platform (eg. Google GCP). Migrate our existing Microsoft SQL multi-tenant Google GCP-hosted SQL database to the SQLaaS platform. Set up a sandbox lab to verify that all current blueButler application functionality is maintained. Investigate the processes and procedures required to create, update and access the platform; in particular, security permissions and restrictions.
- What is the main goal for this project?
-
Our organization is able to offer a virtual developer opportunity for an individual or team of 2 computer science students.
The primary focus areas for the student(s) will be:
- Database Analysis and Migration - Research and choose a cloud-based SQL as a Service platform (eg. Google GCP). Migrate our existing Microsoft SQL multi-tenant Google GCP-hosted SQL database to the SQLaaS platform. Set up a sandbox lab to verify that all current blueButler application functionality is maintained. Investigate the processes and procedures required to create, update and access the platform; in particular, security permissions and restrictions.
The goal for this project is to demonstrate a working prototype of the migrated SQL database in the sandbox environment.
Our virtual student(s) is expected to have the following tools:
- Windows 10 Pro Laptop or Computer
- .NET Visual Studio
- Knowledge of SQL databases
We will plan to communicate with our virtual intern using these communication tools:
- Gmail
- blueC Slack channels
- blueC VoIP system (Ring Central)
Student's primary contact: Jeff McDonald, Senior Software Developer
Secondary contact: John McDonald, CTO
- Database Analysis and Migration - Research and choose a cloud-based SQL as a Service platform (eg. Google GCP). Migrate our existing Microsoft SQL multi-tenant Google GCP-hosted SQL database to the SQLaaS platform. Set up a sandbox lab to verify that all current blueButler application functionality is maintained. Investigate the processes and procedures required to create, update and access the platform; in particular, security permissions and restrictions.
- What tasks will learners need to complete to achieve the project goal?
-
No deliverables exist for this project.
- How will you support learners in completing the project?
-
The student(s) will report to the CTO and will work directly with our lead cloud system developer.
Bi-weekly status update reports are expected.
About the company
- https://bluec802.com
- Insurance, Telecommunications, Technology, It & computing
blueC develops and distributes to the Insurance Agency/Broker market, VoIP Integration software called “blueButler”. blueButler has a comprehensive web services interface that enables it to be integrated into CRM and other third-party systems. blueButler is software that connects a company’s phone system to their CRM or other client database application. As such, blueC partners with many CRM providers (Salesforce, Applied Systems, Vertafore, Acturis) and with many VoIP providers (Cisco, Broadsoft, Netsapiens, Mitel, Asterisk, Avaya, RingCentral, GoToConnect, Net2Phone, Yovu, etc) as well as other application software providers and hosting infrastructure partners like Google GCP. blueButler securely captures all phone call meta data and call content and integrates this critical information into workflows to consistently drive key performance targets.