Job Description

Job Title: SQL Server Developer DBA

Location: KL

Job Type: Full-time

Experience Level: 4+ year

Job Summary:

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 oCers an opportunity to gain

experience in a fast-paced environment with room for growth.

Key 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. Collaborate 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 advantageous

Qualifications & Skills:

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. Excellent communication skills.

Required Skills

T-SQL : write/optimize complex queries, stored procedures/functions, transactions, error handling. Data Upload from Excel via scripts/ETL/SSIS (BULK INSERT/OpenRowset)

Schema & performance: sound database design, indexing strategies, execution plan analysis, DMVs/partitioning.

Monitoring and admin: SQL server Jobs , Security ,proactive monitoring, least-privilege hardening, automated backups/DBCC CHECKDB/patching & capacity planning, plus NICE TO HAVE --- HA/DR (Always On) with tested failovers.

Job Types: Full-time, Permanent

Pay: RM5,000.00 - RM7,000.00 per month

Work Location: In person