Oracle Developer, Johannesburg

Job type: 3 Days in a week from office

Location: Johannesburg

About Zensar Technologies We are a digital solutions and technology services company that partners with global organizations across industries to achieve digital transformation. With a strong track record of innovation, investment in digital solutions, and commitment to client success, at Zensar, you can help clients achieve new thresholds of performance. A subsidiary of RPG Group, Zensar has its HQ in India, and offices across the world, including Mexico, South Africa, UK and USA.

Zensar is all about celebrating individuality, creativity, innovation, and flexibility. We hire based on values, talent, and the potential necessary to fill a given job profile, irrespective of nationality, sexuality, race, color, and creed. We also put in policies to empower this assorted talent pool with the right environment for growth.

Job Spec The role of an Oracle PL/SQL Developer is a specialized engineering position focused on building, maintaining, and optimizing the "brain" of an application—the database.

Job Brief We are looking for a highly skilled Oracle PL/SQL Developer to design and implement efficient database solutions. You will be responsible for developing complex stored procedures, optimizing queries for high performance, and ensuring data integrity across our enterprise systems. The ideal candidate has a deep understanding of Oracle architecture and a passion for clean, scalable code.

Key Responsibilities

Database Development: Design and develop database objects, including tables, views, indexes, and constraints.

Programming: Write and maintain sophisticated PL/SQL code using Packages, Stored Procedures, Functions, and Triggers.

Performance Tuning: Analyze and optimize slow-running SQL queries using tools like Explain Plan, SQL Trace, and TKPROF.

ETL&Integration: Build and manage Data Migration/ETL processes to move data between disparate systems and data warehouses.

Security&Integrity: Implement data security measures, including encryption and access controls, to safeguard sensitive information.

Collaboration: Work closely with Java/.NET developers and Business Analysts to translate functional requirements into technical database designs.

Technical Requirements

Core Languages: Mastery of SQL and PL/SQL. Familiarity with Java, Python, or Unix Shell Scripting is often required for modern integration.

Oracle Versions: Experience with Oracle 12c, 19c, or 23c (on-premise and Autonomous Cloud).

Tools: Proficiency with IDEs such as Oracle SQL Developer, TOAD, or PL/SQL Developer.

Modeling: Understanding of Relational Database Design and tools like Oracle SQL Developer Data Modeler.

Frameworks: (Optional but preferred) Knowledge of Oracle APEX (Low-code) or Oracle Forms/Reports for legacy system maintenance.

#J-18808-Ljbffr