Microsoft SQL Server Development DBA

Krisvconsulting Services Pte Ltd; Kuala Lumpur; On-site; MYR 180,000 - 240,000; Full time

Job summary

Krisvconsulting Services Pte Ltd seeks an experienced Microsoft SQL Server Development DBA to design, develop, and maintain complex database objects. The role emphasizes T-SQL development, performance tuning, and robust data models.

You will work across Development, UAT, and Production environments, collaborating with developers to improve query efficiency, ensure relational integrity, and maintain comprehensive documentation.

Qualifications

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

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.
• Design and implement database schemas, relational models, and normalization standards.
• Develop and maintain indexing strategies and query optimization techniques.
• Perform database code reviews to ensure standards and best practices.
• Manage database schema changes and release deployments across environments.
• Collaborate with developers to improve database design, query efficiency, and scalability.
• Maintain database documentation, architecture standards, and operational procedures.

Skills

T-SQL

SQL Server

Query optimization

Data modeling

Database design

Tools

SQL Server 2016/2017/2019/2022

Job description

About the job 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 .