Back-End - SQL Server (Support)

FLINTEX CONSULTING PTE. LTD.; Singapore; On-site; SGD 80,000 - 100,000; Full time

Job summary

A leading consulting firm in Singapore is looking for a Back-End Developer with expertise in SQL Server to design, optimize, and support database systems. The role involves creating and managing database structures, writing optimized SQL queries, and developing ETL processes using SSIS. Ideal candidates should possess strong troubleshooting skills and a degree in Computer Science or a related field, ensuring thorough support of existing systems and automation tasks.

Qualifications

• In-depth knowledge of SQL Server 2016 or above.
• Hands-on experience with performance tuning and troubleshooting.
• Degree in Computer Science or related field.

Responsibilities

• Designing database tables and creating views, functions, and stored procedures.
• Writing optimized SQL queries for integration with applications.
• Creating reports using SSRS and SSIS for ETL processes.

Skills

SQL Server

Performance Tuning

Troubleshooting

Communication

Attention to Detail

Education

Degree in Computer Science

Degree in Engineering

Tools

SSRS

SSIS

.NET Framework

JavaScript

HTML

Job description

Back-End - SQL Server

Responsibilities

• Designing database tables

• Creating views, functions and stored procedures

• Writing optimized SQL queries for integration with other applications

• Creating task schedules for use in automation

• Creating SSIS projects for ETL (Extract, Transform, Load),

• Creating reports in SSRS

• Optimize and maintain legacy systems

• Modify databases according to requests and perform tests

• Monitoring and managing user enquiries and issues on the systems helpdesk

• Troubleshooting system issues

• Extraction of reports as per the business requirements

• Support existing systems

Requirements

• In-depth knowledge on SQL server 2016 or above

• Hands-On experience on writing stored procedures, performance tuning and troubleshooting

• Experience with Microsoft SQL Server Reporting Services (SSRS) , Integration services (SSIS)

• Familiarity working with .Net Framework, JavaScript, HTML

• Understanding of Agile methodologies

• Good troubleshooting and communication skills

• Attention to detail

• Degree in Computer Science, Engineering or a related field