SQL Developer - DBMS

What you`ll do:

- Develop, optimize, and maintain complex SQL queries, stored procedures, views, functions, and triggers using T-SQL.

- Analyze and refactor legacy stored procedures to improve performance, maintainability, and scalability.

- Design normalized and scalable database architectures aligned with business requirements.

- Perform data modeling, schema design, and schema evolution to support application growth.

- Conduct performance tuning and troubleshoot bottlenecks using tools such as SQL Profiler and Extended Events.

- Collaborate with .NET/API teams to ensure seamless integration between application and database layers.

- Break down monolithic SQL codebases into modular, maintainable components during modernization initiatives.

- Implement database decoupling strategies to support microservices and bounded contexts.

- Ensure data integrity and consistency during migration and modernization projects.

- Manage schema changes, migrations, and rollbacks using tools like Flyway, Liquibase, or SSDT.

- Contribute to Agile/Scrum ceremonies including sprint planning, backlog grooming, and code reviews.

- Leverage AI tools (e.g., GitHub Copilot) to document SQL code, generate boilerplate scripts, and suggest optimizations.

What we are looking for?

- SQL Development: 8+ years of hands-on experience as a SQL Developer supporting enterprise-level applications

- T-SQL Mastery: Expert in writing complex queries, stored procedures, views, functions, and triggers using T-SQL

- Legacy Optimization: Skilled in analyzing and refactoring legacy stored procedures for performance and maintainability

- Database Design: Strong ability to translate business requirements into scalable, normalized database architectures

- Data Modeling: Proficient in relational modeling, normalization, and schema evolution

- Performance Tuning: Experienced in identifying and resolving bottlenecks using tools like SQL Profiler and Extended Events

- Collaboration: Comfortable working closely with .NET/API teams to ensure cohesive integration between app and DB layers

- Communication: Able to explain complex database concepts to both technical and non-technical audiences

- Agile Practices: Experience in Agile/Scrum teams, participating in sprint planning, backlog grooming, and code reviews

- AI-Enhanced Development: Familiar with using AI tools (e.g., GitHub Copilot) for documenting SQL code, suggesting optimizations, and generating boilerplate scripts

- Additional Skills for Legacy Monolithic Applications

- Legacy Refactoring: Experience breaking down monolithic SQL codebases into modular, maintainable components

- Database Decoupling: Skilled in isolating shared schemas and stored procedures into bounded data contexts for microservices

- Data Integrity Strategies: Knowledge of maintaining data consistency during modernization and migration

- Change Management: Experienced with schema migration tools and rollback processes to support safe transitions