SQL Server DBA (Development & Production)

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

Job summary

A leading technology consulting firm in Kuala Lumpur is looking for an experienced SQL Server DBA to manage both development and production environments. Responsibilities include administration of SQL databases, ensuring security compliance, database backup and recovery, and performance tuning. The ideal candidate should have 4-7 years of experience in SQL Server, strong T-SQL skills, and familiarity with Crystal Reports/SSRS/SSIS. This position offers a collaborative environment to integrate database solutions effectively.

Qualifications

• 4-7 years of experience in SQL Server database administration and development.
• Strong experience with T-SQL, stored procedures, triggers, and functions.
• Hands-on experience with Crystal Reports and SSRS/SSIS.
• Familiar with backup strategies and performance tuning.

Responsibilities

• Manage administration and maintenance of SQL Server databases.
• Ensure database security and compliance according to company policies.
• Handle database backup and recovery tasks.
• Assist in database design, indexing, and optimization.

Skills

T-SQL

SQL Server 2016 and above

Crystal Reports

SSRS

SSIS

Powershell

Performance tuning

Backup and recovery

Job description

SQL Server DBA (Development & Production)

About the job SQL Server DBA (Development & Production)

The ideal candidate will be responsible for managing development and production environments and experience in SQL Server database administration, performance tuning, backup and recovery, and Crystal Reports/SSRS/SSIS.

Responsibilities:

• Would be responsible for Administration and maintenance of SQL Server databases in both development and production environments.
• Will ensure database security and compliance followed as per company policies.
• Responsible for database backup and recovery tasks, Data Import/Export, migration.
• Will Work on Crystal Reports, SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services).
• Would be assisting in database design, indexing, and optimization for better performance.
• Collaborate with developers to ensure smooth integration of database solutions.
• Will be responsible for Troubleshoot issues related to database connectivity and performance .
• Knowledge of replication, mirroring, and clustering for high availability will be add on.
• Should have knowledge of Change Management processes to implement database configuration.
• Will monitor and respond to MSSQL database Alerts.
• Knowledge of Powershell will be preferred.

Requirements

• 4-7years of experience in SQL Server database administration and development.
• Should have Strong experience of T-SQL, stored procedures, triggers, and functions, with SQL Server 2016 and above.
• Should have Hands-on experience with Crystal Reports and SSRS/SSIS.
• Should be Familiar with backup strategies, recovery models, and performance tuning.
• Strong analytical and problem-solving skills.
• Ability to work independently and in a team-oriented environment.