Database Developer

Agensi Pekerjaan Penta Consultancy Sdn. Bhd; Kuala Lumpur; On-site; MYR 60,000 - 110,000; Full time

Job summary

Agensi Pekerjaan Penta Consultancy Sdn. Bhd, based in Kuala Lumpur, seeks a seasoned Database Developer to design, develop, and maintain robust data architectures and ensure data integrity across systems.

The role emphasizes SQL development, performance tuning, ETL processes, and reporting with SSIS/SSRS, requiring collaboration across architecture, project, and business teams. Candidates should have 3+ years of database development experience, strong SQL skills, and hands-on experience with SQL

Qualifications

• 3+ years of database development experience.
• Strong SQL querying, optimization, and performance tuning.
• Experience with Microsoft SQL Server, SSMS, SSIS, SSRS.
• Data modeling and database design experience.
• Solid understanding of ETL processes and data integration.
• Experience debugging and optimizing SQL code.
• Familiarity with data replication and data integration processes.
• Experience supporting financial or insurance systems is a plus.
• Excellent analytical and problem-solving skills.
• Ability to work independently and cross-functionally.

Responsibilities

• Design, develop, and maintain database structures, including tables, relationships, and data models.
• Develop, optimize, and maintain SQL queries, scripts, stored procedures, and views to ensure database performance and efficiency.
• Support data aggregation processes for MFRS 17 and ITSR, ensuring alignment across systems.
• Develop and enhance reporting solutions using SSIS and SSRS.
• Perform ETL processes by extracting data from multiple sources, transforming it into the required format, and loading it into databases or data warehouses.
• Assist in data mapping and ensure data accuracy and consistency across systems.
• Design and set up new databases to support reporting and business requirements.
• Develop scripts for report generation and file processing to support ITSR and MFRS 17 reporting needs.
• Perform debugging and troubleshooting of SQL code, stored procedures, and database-related issues using SSMS.
• Conduct end-to-end testing for databases, scripts, and reporting solutions.
• Collaborate with architecture, project, and business teams on technical design, documentation, and implementation.
• Support data replication processes (e.g. PMACS to EDS) to meet MFRS 17 requirements.

Skills

SQL

SSMS

SSIS

SSRS

ETL

Data modeling

Query optimization

Debugging

Data integration

Communication

Team collaboration

Tools

SQL Server

SSMS

SSIS

SSRS

Data replication

Job description

• Design, develop, and maintain database structures, including tables, relationships, and data models.
• Develop, optimize, and maintain SQL queries, scripts, stored procedures, and views to ensure database performance and efficiency.
• Support data aggregation processes for MFRS 17 and ITSR, ensuring alignment across systems.
• Develop and enhance reporting solutions using SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
• Perform ETL (Extract, Transform, Load) processes by extracting data from multiple sources, transforming it into the required format, and loading it into databases or data warehouses.
• Assist in data mapping and ensure data accuracy and consistency across systems.
• Design and set up new databases to support reporting and business requirements.
• Develop scripts for report generation and file processing to support ITSR and MFRS 17 reporting needs.
• Perform debugging and troubleshooting of SQL code, stored procedures, and database-related issues using SQL Server Management Studio (SSMS).
• Conduct end-to-end testing for databases, scripts, and reporting solutions.
• Collaborate with architecture, project, and business teams on technical design, documentation, and implementation.
• Support data replication processes (e.g. PMACS to EDS) to meet MFRS 17 requirements.

Job Requirements:

• Minimum 3 years of experience in database development or a related role.
• Strong proficiency in SQL (Structured Query Language), including querying, optimization, and performance tuning.
• Hands-on experience with Microsoft SQL Server, including SSMS, SSIS, and SSRS.
• Experience in database design and data modeling, including defining tables, relationships, and data structures.
• Solid understanding of ETL processes and experience handling data from multiple sources.
• Experience in debugging and optimizing stored procedures, queries, and database performance issues.
• Familiarity with data replication and data integration processes.
• Experience supporting financial or insurance systems (e.g. MFRS 17, ITSR) is an added advantage.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work independently as well as collaborate effectively with cross-functional teams.
• Good communication skills to interact with technical and non-technical stakeholders.