Sql Server DBA Developer

Job Title: SQL Server Developer DBA (experience 60% DBA and 40% SQL development)

Location: KL, Onsite, Remote

Job Type: Full-time

Experience Level: 5 to 8 years (Mid)

Notice Period: Immediate to 15 days

Job Summary:

SQL Server developer DBA

development and production environments. The ideal candidate will have experience in SQL

Server database administration, performance tuning, backup and recovery, writing complex

SPs and T-SQL queries and SSIS

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:

• 7+ 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.

The