Intetics Inc., a leading American technology company specializing in custom software application development, distributed professional teams creation, software product quality assessment, and “all-things-digital” solutions, is looking for a SQL Database Engineer (Migration & Optimization) to join its innovative team.
About the project:
We’re modernising a legacy on-premise MSSQL database as part of a cloud migration for our client. The existing .bak file is around 2.3 GB and supports ~200 users in total, with fewer than 20 concurrent users at peak load.
The old schema has grown organically over time and includes some inconsistencies and awkward design patterns. We’re rebuilding the application using Angular and NestJS, with a cleaner and more maintainable data model.
Responsibilities
- Review the existing MSSQL schema from a .bak backup
- Collaborate with the development team to understand how the new Angular/NestJS application will interact with data
- Design and implement a simplified, efficient new database schema aligned with the updated application model
- Handle data extraction, transformation, and migration from the old schema to the new structure
- Set up the new database in Azure SQL Database, following best practices for:
- Performance tuning
- Security (TDE, Private Link, RBAC)
- Cost optimization (serverless tier, scaling strategies)
- Monitoring and backup configuration
- Support testing, deployment, and contribute to documentation
- Strong experience with MSSQL and SQL Server Management Studio (SSMS)
- Proven ability to reverse-engineer and restructure legacy schemas
- Skilled in data migration, scripting, and cleansing
- Experience working with Azure SQL Database and deploying production-grade setups
- Understanding of modern database design principles and indexing strategies
- Collaborative mindset, with experience supporting migration projects alongside development teams
Bonus Points
- Exposure to Angular, NestJS, or TypeORM
- Familiarity with Azure Portal, Key Vault, or Private Link
- Experience working with GitHub, pull requests, and asynchronous team workflows
Similar Jobs
What We Do
Intetics Inc. is a leading American technology company providing custom software application development, distributed professional teams creation, software product quality assessment, and “all-things-digital” solutions built with SMAC, RPA, AI/ML, IoT, blockchain, and GIS/UAV/LBS technologies.
Based on proprietary pioneering business models of Offshore Dedicated Team® and Remote In-Sourcing®, an advanced Technical Debt Reduction Platform (TETRA™) and measurable SLAs for software engineering, Intetics helps innovative organizations capitalize on global talent with our in-depth engineering expertise based on our Predictive Software Engineering framework.
Intetics core strength lays in design of software products in conditions of incomplete specifications. We have extensive industry expertise in Education, Healthcare, Logistics, Life Sciences, Finance, Insurance, Communications, and custom ERP, CRM, Intelligent Automation and Geospatial solutions.
Our advanced software engineering background and outstanding quality management platform, along with an unparalleled methodology for talent acquisition, team building and talent retention, guarantee that our clients receive exceptional results for their projects. At Intetics, our outcomes do not just meet clients expectations, they have been exceeding them for a quarter of a century. Intetics operates from multiple offices in the USA, Europe and Latin America, hiring the best talent available worldwide.
Intetics is ISO 9001 (quality) and ISO 27001 (security) certified and a Microsoft Gold, Amazon, and UiPath Silver partner. The company’s innovation and growth achievements are reflected in winning prestigious titles and awards, including Inc5000, Software 500, CRN 100, American Business, Deloitte Fast 50, European IT Excellence, Best European BPO, Stevie People’s Choice, Clutch and ACQ5 Awards, IAOP Global Outsourcing 100 and Fortune Innovative 300 lists.
