We operate an integrated enterprise platform CRM, project and portfolio delivery, and financial workflows built on a SQL Server data core, a Node.js/Express API, a React web application, and a React Native mobile companion. It runs entirely on premises in a secure, offline Windows environment. You will take end-to-end ownership of this platform: evolving the database schema safely, extending the API and web application, hardening security, and running disciplined script-based deployments. This is a full-ownership generalist role for an engineer who is genuinely strong on databases and comfortable operating software in a locked-down environment not a feature-factory position
Desired Candidate Profile
- 10+ years of technical experience in designing, developing and maintaining programs and applications from front end to back end.
- Working with front-end frameworks such as React, Angular, or Vue.js.
- Building and integrating back-end services, APIs, and databases.
- RESTful endpoints in Express, with robust database access, connection-pool resilience, request validation, and server-side error handling.
- Using REST APIs or GraphQL to connect front-end and back-end systems.
- Working with databases such as SQL Server, PostgreSQL or MySQL.
- Working on Schema design and safe evolution of a substantial relational model, including migration scripting and preservation of the platform's data-integrity and audit guarantees.
- Good experience on React + TypeScript features from UI through hooks to API client, with disciplined layering and maintainable component architecture.
- Working on maintaining Security posture. Authentication, session handling, role-based access control enforced server-side, and secure-coding practice across the stack
- Full experience of Deployment and operations. Manual, script-based releases on Windows Server scheduled tasks, service management, and a vet-then-bundle dependency discipline (no runtime internet; all assets local and vetted at build time).
- Skills:
- Front-end: HTML, CSS, JavaScript, React + TypeScript. React 18, Vite, server-state management (React Query/TanStack), typed forms and validation, and data visualization.
- Back-end: Node.js & Express. Production API development with the mssql driver or comparable: pooling, timeouts, crash-resilient behavior.
- Databases: Microsoft SQL Server / T-SQL primary competency. Stored procedures, views, and sequential migration scripting without an ORM or migration framework.
- Application security fundamentals. Token-based auth, password hashing, RBAC design, XSS avoidance, CORS discipline, upload validation, and secrets handling.
- On-premise Windows delivery. PowerShell scripting, Windows service and scheduled-task management, firewall configuration, and experience deploying without cloud CI/CD.
- API development: RESTful APIs, GraphQL, JSON, authentication, and integration with third-party systems.
- DevOps/basic deployment: CI/CD pipelines, Docker, and environment configuration.
- Security: Authentication, authorization, secure coding practices, and data protection.
- Qualifications and certifications:
- A bachelor s degree in Computer Science, Software Engineering, Information Technology, Computer Engineering, or a related field
- Full Stack Engineer CV including Years of experience, Preferred Certification, and Technical Expertise:
- Front-end: HTML, CSS, JavaScript, TypeScript, React, Angular, or Vue.js.
- Back-end: Node.js, Java, Python, C#, .NET, PHP, or similar server-side technologies.
- Databases: SQL Server, PostgreSQL or MySQL.
- API development: RESTful APIs, GraphQL, JSON.
- DevOps/basic deployment: CI/CD pipelines, Docker (bidder may share more than one CV)