(A) Database Developer (PL/SQL and Python)

Upscale Sdn Bhd; Petaling Jaya; On-site; MYR 150,000 - 200,000; Full time

Job summary

A leading company is seeking a Senior Database Developer skilled in PL/SQL and Python to create and optimize efficient database solutions. This role requires a minimum of 2 years of relevant experience, strong analytical skills, and the ability to work collaboratively with cross-functional teams. The candidate should have strong communication skills and a basic diploma in IT or programming, with proficiency in PostgreSQL being essential.

Qualifications

• Minimum of 2 years of experience as a Database Developer or similar role.
• Strong proficiency in programming using PL/SQL and Python.
• Solid understanding of relational database concepts and database design principles.

Responsibilities

• Develop and maintain efficient and reliable database solutions.
• Design, implement, and optimize database structures, schemas, and tables.
• Conduct database testing and troubleshooting for performance issues.

Skills

Communication

Problem Solving

Data Analysis

Database Optimization

Education

Basic diploma in IT or programming

Tools

PostgreSQL

Microsoft SQL Server

MySQL

Oracle

Job description

(A) Database Developer (PL/SQL and Python)

About the job (A) Database Developer (PL/SQL and Python)

Senior Database Developer (PL/SQL and Python)

The ideal candidate should possess a basic diploma in IT or programming and have a minimumof 2 years of relevant experience in database development.
Excellent communication skills inEnglish are required to effectively collaborate with the team.

Responsibilities:
-Develop and maintain efficient and reliable database solutions using PL/SQL and Pythonprogramming languages.
-Design, implement, and optimize database structures, schemas, tables, and views.
-Create stored procedures, functions, triggers, and packages in PL/SQL to enhancedatabase performance and functionability
-Collaborate with software developers to integrate the database layer with the applicationlogic.
-Perform data analysis and develop data models to support business requirements.
-Optimizedatabase queries, indexes, and performance tuning to ensure optimal systemperformance.
- Conduct database testing and troubleshooting to identify and resolve performanceissues and data integrity problems.
-Ensure data security and compliance with relevant regulations and best practices.
-Collaborate with cross-functional teams to gather and analyze user requirements, andprovide technical solutions.
-Document database design, development processes, and system speciation.

Requirements:
-Basic diploma in IT or programming.
-Minimum of 2 years of experience as a Database Developer or similar role.
-Strong proficiency in programming using PL/SQL and Python.
-Experience with the PostgreSQL database is essential.
- Familiarity with other databases like Microsoft SQL Server, MySQL, or Oracle is a plus.
-Solid understanding of relational database concepts and database design principles.
-Strong analytical and problem-solving skills to troubleshoot and resolve database relatedissues.
-Knowledge of data modeling and database optimization techniques.
-Familiarity with data integration and ETL processes.
-Excellent communication skills in English, both written and verbal.
-Ability to work independently and as part of a team, with strong attention to detail.