SQL Server Developer DBA

Krisvconsulting Services Pte Ltd; Kuala Lumpur; On-site; MYR 70,000 - 90,000; Full time

Job summary

A consulting services company is seeking an experienced SQL Server Developer DBA to manage both development and production environments. The ideal candidate will have 4-6 years of experience in SQL Server database administration, including performance tuning, backup and recovery, and writing complex T-SQL queries. This role offers an opportunity for growth in a dynamic environment. Responsibilities include administering databases, optimizing queries, and collaborating across teams.

Qualifications

• 4-6 years of experience in SQL Server database administration and development.
• Proficiency in writing complex queries and strong T-SQL knowledge.
• Experiences with SSIS and SQL Server 2016 or above.
• Strong analytical and problem-solving skills required.

Responsibilities

• Administer and maintain SQL Server databases in development and production.
• Develop, optimize, and troubleshoot T-SQL queries and stored procedures.
• Collaborate with cross-functional teams and maintain database documentation.
• Perform database backup and recovery tasks and implement security measures.

Skills

T-SQL

Database administration

Performance tuning

Backup and recovery

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Database design

Replication

Tools

SQL Server 2016

Powershell

Job description

We are looking for a SQL Server developer DBA who will be responsible for managing both development and production environments. The ideal candidate will have experience in SQL Server database administration, performance tuning, backup and recovery, writing complex queries, develop SPs and T-SQL queries and SSIS. This role offers an opportunity to gain experience in a fast-paced environment with room for growth.

Responsibilities

• Administer and maintain SQL Server databases in both development and production environments
• Develop, optimize, and troubleshoot T-SQL queries, stored procedures, and functions. Help write and optimize in-application SQL statements
• Collaborating with cross-functional teams to gather requirements and implement solutions. Creating and maintaining database documentation
• Strong experience in Database Migration, Import/Export and ETL. Implement database security and ensure compliance with company policies.
• Perform database backup and recovery tasks. Administrative and configuration on SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services).
• Assist with database design, indexing, and optimization for better performance. Monitor database health, jobs, and performance using SQL Server tools.
• Collabor with developers to ensure smooth integration of database solutions. Troubleshoot and resolve database connectivity and performance issues.
• Knowledge of replication, mirroring, and clustering for high availability. Follow Change Management processes to implement database configuration changes
• Follow Problem Management processes to troubleshoot and resolve recurring issues .Proactively monitor and respond to MSSQL database Alerts. Knowledge of Powershell will be advantageousli>

Requirements

• 4-6 years of experience in SQL Server database administration and development.
• Strong knowledge of T-SQL, stored procedures, triggers, and functions. Proficiency in writing complex queries.
• Experience with SQL Server 2016 and above.
• Hands-on experience with SSIS.
• Familiarity with backup strategies, recovery models, and performance tuning.
• Basic understanding of indexing, query optimization, and execution plans.
• Strong analytical and problem-solving skills.
• Ability to work independently and in a team-oriented environment.