Deskripsi Pekerjaan
Are you a database expert passionate about building high-performance, scalable solutions? Mindteck is looking for a skilled Oracle PL/SQL Developer to join our dynamic team in Malaysia. This is a fantastic opportunity to work on complex enterprise systems, leveraging your expertise in database architecture and advanced programming techniques.
As an Oracle PL/SQL Developer, you will play a critical role in designing, developing, and maintaining robust database applications. You will collaborate with cross-functional teams to translate business requirements into efficient technical specifications. We value innovation, attention to detail, and a commitment to writing clean, maintainable code. If you thrive in a collaborative environment and are eager to tackle challenging data-driven projects, we want to hear from you.
At Mindteck, we offer a professional growth environment where your technical skills will be pushed to the next level. You will work with modern Oracle technologies and contribute to high-impact projects that drive business value for our global clients.
Tanggung Jawab
- Design and develop complex database objects including stored procedures, packages, functions, and triggers using PL/SQL.
- Optimize SQL queries and perform performance tuning to ensure maximum application efficiency and speed.
- Implement advanced PL/SQL features such as collections, VARRAYs, and bulk processing for high-volume data handling.
- Collaborate with front-end developers and system architects to integrate database solutions with external applications.
- Develop and execute unit tests, ensuring code quality and adherence to security best practices.
- Perform data migration, transformation, and loading (ETL) tasks from various source systems.
- Debug and resolve production issues, providing timely technical support for database-related problems.
- Maintain technical documentation and version control for all database scripts and schemas.
Kualifikasi
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Minimum of 3-5 years of professional experience in Oracle PL/SQL development.
- Strong expertise in SQL, including advanced sub-queries, complex joins, and Oracle built-in functions.
- In-depth knowledge of PL/SQL programming: collections, exception handling, cursors, and package design.
- Experience with Oracle Database versions 12c, 18c, or 19c.
- Familiarity with performance tuning tools like Explain Plan, TKPROF, and AWR reports.
- Excellent analytical and problem-solving skills with a high degree of attention to detail.
- Effective communication skills and the ability to work in a collaborative team environment.