Position: Senior Fullstack Developer (Database focus) Hybrid

1, Job Requirement:

• Strong proficiency in database design, SQL, and query optimization
• Experience with database migration and legacy system modernization
• Expertise in server-side programming languages such as Node.js and Express.js
• Familiarity with front-end technologies like HTML, CSS, and JavaScript
• Experience with offline storage mechanisms and data synchronization techniques
• Knowledge of testing methodologies, frameworks, and best practices
• Understanding of software development lifecycle and collaboration tools
• Ensure seamless user experience in any internet-limited environments, enabling efficient data synchronization once connectivity is restored.
• Excellent problem-solving and communication skills
• Ability to work independently and collaboratively in a client-focused environment

2, Job information:

1. Database Design and Development

• Design and implement efficient and scalable database schemas for the operational product.
• Migrate and optimize existing database structures from the legacy system.
• Create and optimize SQL queries, stored procedures, and database functions
• Ensure data integrity, security, and performance of the database.
• Collaborate with other developers to integrate the database with the application.

2. Operational Product Feature Development

• Actively participate in the development of essential features and functionalities for the operational product.
• Migrate and upgrade existing features from the legacy system to the new technology stack.
• Write clean, maintainable, and efficient code in collaboration with the development team.
• Implement best practices for coding standards, design patterns, and performance optimization.
• Collaborate with the front-end developer to integrate the back-end functionality seamlessly.

3. Offline Mode Development

• Design and implement the offline mode functionality for the operational product.
• Implement a Progressive Web App (PWA) for our React web application, leveraging service workers and Indexed DB for robust offline functionality, including data storage and access to media files via OneDrive offline capabilities.
• Develop mechanisms for data synchronization between the offline and online databases.
• Ensure data consistency and integrity during offline usage.
• Optimize the offline mode for performance and user experience.

4. Testing and Quality Assurance

• Implement essential testing methodologies and frameworks for the operational product.
• Write and execute critical test cases to ensure the stability and reliability of the application.
• Conduct unit testing for key components and modules.
• Perform necessary integration and end-to-end testing for major system interactions.
• Collaborate with the team to identify and resolve bugs and issues.

5. Legacy System Migration

• Analyze the existing legacy system and understand its functionality, architecture, and limitations.
• Collaborate with the team to define the migration strategy and plan.
• Identify and prioritize the features and components to be migrated.
• Ensure a smooth transition of data and functionality from the legacy system to the new operational product.

6. Continuous Improvement

• Stay updated with the latest trends, technologies, and best practices in full-stack development.
• Identify areas for improvement and propose solutions to enhance the operational product's performance, scalability, and user experience.
• Collaborate with the client to gather feedback and incorporate necessary enhancements and modifications.

• Contract: Freelancer, trial 1 month full salary, 5 month contract
• Working mode: Onsite 1 month, then Hybrid( 2days on office)