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.