Skip to main content

Junior Application and SQL Developer

Technology
SGS (Malaysia) Sdn Bhd
2 weeks ago
Full time

Job description

Job Description

Primary Responsibilities

. Support the maintenance, enhancement and daily operation of the site's internally developed application through SQL queries, database programming and scripting.

. Understand requirements and deliver data extraction, processing and reporting solutions.

. Contribute to Computer System Validation (CSV) activities, ensuring the application and its data remain compliant with GxP and data integrity requirements.

Specific Responsibilities

. Write, test and optimize SQL queries, views, stored procedures and functions supporting application features,

data requests and reports.

. Develop and maintain Perl (or similar) scripts for data processing, automation of recurring tasks and data imports/exports from flat files and Excel.

. Investigate and resolve application and data issues reported by users document root cause and corrective actions.

. Perform data quality checks and reconciliations support data corrections and migrations under change control.

. Support CSV activities across the system lifecycle: draft and execute test scripts (IQ/OQ/PQ, UAT), record test evidence, log deviations and maintain traceability matrices.

. Apply data integrity principles (ALCOA+) and 21 CFR Part 11 / EU GMP Annex 11 requirements for audit trails,

electronic records and access controls.

. Follow change and version control practices prepare and maintain technical documentation (data models,

specifications, change records, user guides, SOP inputs).

. At all times, complies with SGS Code of Integrity and Professional Conduct. Remains familiar with SGS quality assurance procedures. Complies to all SGS QHSE and HR policies and procedures.

. Performs other related duties as may be assigned either in support of departmental goals or for his/her personal or professional training, education or development as programmed by his/her immediate superior.

Qualifications

Profile

. Bachelor's degree in computer science, Bioinformatics or related discipline, or equivalent experience.

. 2+ years of experience in SQL development and/or scripting and programming.

. Experience with or strong interest in Computer System Validation (CSV) is an advantage.

. Affinity with regulated environments (GxP, quality systems) is considered an asset.

Skills

Required

. Good verbal and written communication skills in English.

. SQL (Microsoft SQL Server or equivalent RDBMS): joins, aggregations, views, stored procedures.

. Perl or similar language (e.g., Python Delphi, VBS, C#, Java).

. Microsoft Excel (advanced) and Office tools.

. Strong problem-solving and analytical skills, critical thinking.

. Well organized, stress-resistant, and able to work autonomously.

Keywords
Microsoft ExcelMicrosoft SQL ServerTraceabilityDelphiObject PascalPythonPerlSqlJavaVbscript

Interested in this role?