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.
Become a key player at Intetics Inc. as a Research and Engagement Manager focused on innovative lead generation strategies.
Intetics Inc. seeks a detailed-oriented Junior Recruiter fluent in German and English to contribute to data labeling in innovative AI projects.
Lead DevOps initiatives at Labcorp, managing a global team and driving innovation in software delivery.
Join St. Luke's Health System as a Senior Business Systems/EDI Analyst and lead the drive for efficiency in our healthcare supply chain.
Join Experian as a ServiceNow Manager and lead a dynamic team while driving innovative solutions in a hybrid work environment.
Join Arkestro as a Senior Security Engineer to enhance the security of innovative procurement solutions using AI.
Join Grammarly as a Security Intelligence Engineer to lead efforts in enhancing security through automation and offensive security practices.
As a Senior Application DBA at Node.Digital, you'll leverage your expertise in PostgreSQL and cloud-based environments to ensure robust database performance and reliability.
Become a key player at Memorial Sloan Kettering Cancer Center as an Application Analyst II, driving impactful technology solutions in cancer care.
Step into the pivotal role of Enterprise Architect at Veolia North America, where you will drive strategic technology initiatives within a leader in environmental services.
Covenant Health in Knoxville is looking for an experienced Programmer Analyst Staff to lead programming projects in a dynamic healthcare environment.
Become a vital part of UChicago Medicine as a Business Systems Analyst, where your expertise will help enhance healthcare systems and efficiency.
Join Coretek as an EUC Support Engineer to lead the charge in optimizing high-performance virtual desktop environments for enterprise clients.
Lead key digital initiatives and IT services at UC Berkeley Library as the Associate University Librarian for Digital Initiatives and Information Technology.
Join the CDC Foundation as a Systems Programmer to drive data systems that support maternal and neonatal health projects globally.
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,...
69 jobsSubscribe to Rise newsletter
🔮
Hi, I'm Risa! Your AI Career Copilot
you, just ask me below!
