Senior SQL Server Development DBA: T-SQL & Performance

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

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.