What are the responsibilities and job description for the Azure SQL Database Engineer position at Visionaire Partners?
Azure SQL Database Developer
We are seeking a highly skilled Azure SQL Database Developer to join our team as a contractor. This role involves helping design, develop, and optimize a new Operational (OLTP) Azure SQL Database that supports both internal and external websites and systems. The ideal candidate will work in a controlled DevOps environment, leveraging their expertise in SQL Server, CI/CD pipelines, and data modeling to deliver robust and efficient database solutions.
In this role you will: Develop and implement an Operational Azure SQL Database for internal and external systems. Collaborate in a DevOps environment using GitHub for continuous integration and delivery. Translate physical data models into database structures, including tables, stored procedures, indexes, and full-text capabilities. Establish automated processes for unit testing and data quality validation. Ensure database performance and scalability to meet operational needs.
This is a 6 month contract with opportunity to extend. You can live anywhere in the USA as long as you can work EST.
REQUIRED SKILLS:
- Proven experience working as a Sr level SQL Server developer in an Azure environment , including T-SQL, stored procedures, views, indexes, and triggers.
- Expertise in a DevOps environment with CI/CD workflows managed via GitHub.
- Experience in building GitHub Actions for SQL automation processes.
- Proficiency in building and automating SQL unit tests.
- Hands-on experience building operational databases that support external-facing websites.
- Strong skills in query tuning and optimization for performance.
- Familiarity with SQL Projects as part of the development process.
- Strong Communication skills and the ability to work in a team environment
- Familiarity with ERwin Data Modeling Tool.
PREFERRED SKILLS:
- Knowledge of Azure AI Search and its integration with SQL databases.
- Leveraging AI tools like GitHub Copilot to improve productivity.
- Experience using Postman to test and interact with APIs.
- Background in building APIs.
- Experience with Microsoft Data API Builder.
Must be authorized to work in the US. Sponsorships are not available.
