919 | SQL Database Engineer (Migration & Optimization)
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
Average salary estimate
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
Intetics Inc. is searching for a skilled IT Project Manager to oversee the delivery of innovative technology solutions while managing client relationships and project execution.
Join Intetics Inc. as a Junior Python Engineer and help shape the future of AI-driven solutions within a dynamic team.
Join AbbVie as a Senior Cyber Security Engineer and innovate within their Cyber Threat Intelligence team to enhance security protocols.
Scale is searching for a passionate IT Support Engineer to enhance our technology capabilities at our San Francisco office.
Join a prominent nonprofit organization as a Systems Administrator specializing in Active Directory and Office 365 support.
Join DDC as a Cloud Engineer to shape innovative cloud solutions that enhance operations for federal and tribal agencies.
Shape the future of child welfare as a Systems Developer with the Administration for Children’s Services in New York City.
We are seeking a skilled Security Engineer/Architect to enhance security measures for our client, a Woman-Owned business, in a collaborative environment.
As a Senior Technical Solutions Operations Engineer at Datadog, you'll lead the optimization of a global Zendesk environment while enhancing support processes for a technical customer base.
Join Perchwell as a Senior Site Reliability Engineer to drive improvements in their modern real estate platform's technical foundation while collaborating with top-tier engineering teams.
Shape the future of cybersecurity at JPMorgan Chase as a Senior Lead Cybersecurity Architect, impacting software applications with your expert knowledge.
Join U.S. Smokeless Tobacco Company as an IT Site Manager and lead the daily operations of IT support in a collaborative environment.
Join Netskope as a Director, IT Products to lead strategic initiatives in Quote-to-Cash and Finance systems while driving process improvements in a fast-paced environment.
Lead the technical strategy for Atlas Obscura as the Chief Technology Officer, shaping the future of a beloved travel community platform.
Join Deloitte as a M365 & Intune Policy Administrator, where your expertise in endpoint management will drive IT solutions for clients.
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,...
67 jobsSubscribe to Rise newsletter
🔮
Hi, I'm Risa! Your AI Career Copilot
you, just ask me below!
