SI & DB Developer

Agensi Pekerjaan Penta Consultancy Sdn. Bhd; Puchong; On-site; MYR 180,000 - 260,000; Full time

Job summary

Agensi Pekerjaan Penta Consultancy Sdn. Bhd is seeking a skilled Database Engineer to maintain and optimize SQL Server environments, both on-premises and in Azure.

You will monitor uptime, perform tuning, and ensure security and compliance across DBMS platforms for the Tech COE team. The role involves hands-on development with C#.NET for Web and Windows services, SSIS-driven ETL, data warehousing, and collaboration with internal and external teams to implement robust database solutions.

Qualifications

• Bachelor's degree in IT, software engineering, computer science, or related field.
• Minimum of 6 years of software development and system integration experience.
• Strong hands-on Microsoft SQL Server expertise, on-prem and Azure.
• Experience with MSSQL technologies: SSIS, SSAS, T-SQL, data warehousing.
• Experience developing and integrating web services, Windows services, and APIs.

Responsibilities

• Database release management and uptime monitoring.
• Optimization, tuning, security, and permission management.
• Troubleshooting, incident handling, and root-cause analysis.
• Backups, recovery, and archival management.
• Backend development using C#.NET for Web Services and Windows Services.
• SQL development with stored procedures and performance tuning.
• Database design, configuration, and implementation.
• ETL processes and SSIS-based integrations.
• Collaborate with internal and external teams to deploy and support software.
• Capacity planning, licensing assessments, and cost estimations.

Skills

SQL Server

SSIS

SSAS

T-SQL

ETL

Web services

Windows services

API integration

Database design

Education

Bachelor's degree (IT/CS)

Tools

SSIS

SSAS

Azure Cloud

Data warehousing

Job description

Provide maintenance and operational support for all DBMS/RDBMS platforms used by the Tech COE team, including but not limited to:

• Database release management.
• Database uptime and performance monitoring.
• Database optimization and tuning.
• Database security, user access control, and permission management.
• Troubleshooting, incident handling, and root cause analysis.
• Backup, recovery, and archival management.

Perform hands-on technical and advisory work related to system integration and database initiatives, including:

• User requirements analysis and solution design.
• Backend development using C#.NET for Web Services and Windows Services.
• Database design, configuration, and implementation.
• SQL development, including stored procedures and performance tuning.
• Database system upgrades and data migration projects.
• ETL processes (Extract, Transform, Load).
• Database integrations using tools such as SSIS.
• Test data preparation and management.
• Collaborate with internal development teams to design and build in-house software solutions.
• Work with external vendors to deploy, integrate, and support third-party software applications.
• Prepare and maintain project documentation while adhering to DevOps best practices.
• Evaluate, explore, and test new DBMS versions and technologies beyond Microsoft SQL Server.
• Perform database capacity planning, licensing assessments, and cost estimations.

Job Requirements:

• Bachelors Degree in Information Technology, Software Engineering, Computer Science, or a related discipline.
• Minimum of 6 years of experience in software development and system integration.
• Strong hands-on expertise in Microsoft SQL Server, both on-premises and in Azure Cloud environments.
• Solid experience with MSSQL technologies, including SSIS, SSAS, T-SQL, and data warehousing concepts.
• In-depth understanding of RDBMS principles and advanced SQL scripting (joins, subqueries, indexes, views, stored procedures, etc.).
• Proven experience developing and integrating web services, Windows services, and API platforms.