Microsoft SQL Server Development DBA

Responsibilities

• Design, develop, and maintain complex stored procedures, functions, views, and advanced T-SQL scripts.
• Analyze and optimize database queries and execution plans to improve performance and efficiency.
• Design and implement database schemas, relational models, and normalization standards based on application requirements.
• Develop and maintain indexing strategies and query optimization techniques to reduce CPU, memory, and I/O usage.
• Perform database code reviews to ensure development standards, performance optimization, and best practices.
• Manage database schema changes and release deployments across Development, UAT, and Production environments.
• Collaborate with developers and application teams to improve database design, query efficiency, and scalability.
• Maintain database documentation, architecture standards, and operational procedures for ongoing support and governance.

Requirements

• 7+ years of experience in Microsoft SQL Server database development or Development DBA roles.
• Strong hands-on experience with Microsoft SQL Server (2016 / 2017 / 2019 / 2022).
• Advanced expertise in T-SQL programming and complex stored procedure development.
• Strong understanding of database design, normalization, and relational data modeling.
• Experience with query performance tuning, execution plan analysis, and index optimization.
• Experience implementing database constraints, primary keys, foreign keys, and relational integrity rules.
• Experience managing database schema deployments, versioning, and release processes.
• Ability to create and maintain technical documentation and database development standards.