Project overview:

Our customer is a large, public, cyber charter school in the USA. As part of a broad initiative to enhance learning and training opportunities for employees, the school has teamed up with top specialists to create the Academy. This innovative learning environment offers course-takers convenient access to diverse training materials anytime, anywhere. It offers a digital learning environment where students can study at their own pace while receiving support from certified teachers. The Academy aims to be a comprehensive one-stop system, facilitating role-specific courses and fostering continuous development for employees.

If you’re passionate about shaping the future of learning and professional growth, this opportunity is for you!

The technology stack of the project:

• .Net 6+, EntityFramework, MsSQL Server, Redis, Azure AD, React 18, Tailwind, Storybook, Vite, Typescript – SOLID, OOP and OOD.

Methodology:

• Scrum.

Team:

• 1-2 QA, 2-4 devs, BA, Team Lead, PM/SM, UI/UX designer (on our side);
• PO and in-house development team, not involved in hands-on development of the current product (on the customer’s side).

Requirements:

• Extensive experience with SQL Server and PostgreSQl;
• Proficient in creating and managing SQL Server scripts;
• Ability to manage and administer SQL Server and Reporting server;
• Experience in running data migrations, including export and import processes;
• Skilled in writing SQL and Transact-SQL Stored Procedures;
• Strong problem-solving skills and attention to detail in database development and management;
• Excellent communication skills to collaborate with team members and stakeholders.

Responsibilities:

• Reorganizing by transferring all previous school data from the past year into the archive;
• Clearing all data down for the new school year in September;
• Ensuring data integrity and security during the archiving process;
• Collaborating with the development team to optimize database performance;
• Troubleshooting and resolving any database-related issues that may arise;
• Staying up-to-date on industry best practices and trends in database management;
•  Working closely with stakeholders to understand their data requirements and translating them into efficient database solutions.

Our benefits:

• Professional and career growth promotion;
• Competitive salary;
• Paid vacations and sick leaves;
• Internal Medical Program;
• Program for veterans (which includes mentorship, an accessible office for individuals with disabilities, legal support, and additional benefits);
• Flexible working hours;
• Regular corporate social activities;
• Regular technical training at our office;
• English courses;
• Gym, etc.