Software Engineer

Job DescriptionWe are seeking a skilled and experienced Software Engineer to join our dynamic team. The ideal candidate will have a strong background in Node.js, database management, and frontend development. This role involves significant work in database migration, particularly from SQL Server to PostgreSQL, and transitioning our frontend technology stack from AngularJS to React.Key Responsibilities● Node.js Development: Develop and maintain applications using Node.js, ensuring code efficiency and scalability.● Database Management: Manage SQL Server and PostgreSQL databases. This includes understanding their features, limitations, and best practices.● ORM Tool Usage: Utilize Sequelize for data modeling and management.● SQL and Database Design: Write complex SQL queries and maintain a strong grasp of database design principles, including normalization and optimization techniques.● Database Migration: Lead and execute database migration projects, especially from SQL Server to PostgreSQL, ensuring minimal downtime and data integrity.● Software Architecture: Apply software architecture principles in service-oriented architecture, MVC patterns, and ensure proper separation of concerns.● Code Refactoring: Refactor and restructure large codebases, transferring business logic from stored procedures into application code.● Automated Testing: Write and maintain automated tests to guarantee application stability during the migration process.• Performance Tuning: Optimize database and application performance, benchmarking and adapting to new environments.● Version Control: Utilize Git for version control and source code management.● Problem Solving: Tackle challenges during migration and development phases with strong analytical and problem-solving skills.● Team Collaboration: Work collaboratively in a team environment, coordinating with different roles and departments.Continuous Learning and Adaptability: Demonstrate a willingness to learn and adapt to new challenges and solutions in database migration projects.● Frontend Development: Work with AngularJS and transition to React, demonstrating expertise in both technologies.Requirements● Proven experience in Node.js, SQL Server, PostgreSQL, and frontend technologies (AngularJS and React).● Experience in ORM tools, specifically Sequelize.● Strong knowledge of SQL, database design, and optimization techniques.● Prior experience in database migration, particularly from SQL Server to PostgreSQL.● Understanding of software architecture, MVC patterns, and code refactoring.● Proficiency in automated testing and performance tuning.● Familiarity with Git and version control systems.● Excellent problem-solving, communication, and teamwork skills.● Adaptability and a commitment to continuous learning. Minimum Qualifications● Bachelor's degree in Computer Science, Information Technology, or a related field.● 5 years experience in Engineering● Must know MSSQL and Postgres databases● Ability to work on a team and communicate effectivelyWhat We Offer:● Competitive and Comprehensive Benefit Package that includes: Medical, Vision, Dental and Life Insurance● Unlimited PTO● Remote workforcehttps://biotrack.com/