SQL Server Database Architect (Remote)

About the role

BairesDev is hiring a SQL Server Database Architect for a fully remote position. You will modernize a database engine supporting a proprietary internal application by moving away from deeply nested stored procedures toward a centralized, config-driven rules engine. You will work alongside .NET and Blazor developers to redesign and refactor for performance, while planning a long-term migration from on-prem SQL Server to Azure.

Key responsibilities

• Design and maintain secure, high-performance SQL Server databases.
• Refactor existing stored procedures into modular, maintainable logic in code.
• Work on a table-driven rules engine to centralize sizing and configuration logic.
• Collaborate with .NET and Blazor developers to improve backend integration.
• Ensure best practices in data integrity, security and compliance.
• Plan and support the migration to Azure-based database services.

Required profile

• 8+ years of experience in database architecture or engineering.
• Strong background in database performance tuning, including indexing, execution plans and normalization.
• Experience with stored procedure refactoring and data architecture design.
• Advanced proficiency in English.

Required skills

• Strong expertise in SQL Server.
• Hands-on experience with C#/.NET.
• Experience with Blazor for front-end and back-end integration.
• Nice to have: experience migrating on-prem SQL environments to Azure SQL Database, familiarity with config-based rules engines, understanding of data modeling for custom applications, and knowledge of CI/CD pipelines for database scripts.

What we offer

• 100% remote work from anywhere.
• Excellent compensation in USD or your local currency if preferred.
• Hardware and software setup for working from home.
• Flexible hours and the ability to set your own schedule.
• Paid parental leave, vacations and national holidays.
• Mentorship, promotions, skill development and a multicultural environment.