Quixy - Oracle PL-SQL Developer - Database Architecture (3-6 yrs)

Job Description :

We are seeking an experienced Oracle PL/SQL Developer to work on implementation, development, and support projects related to Oracle PL/SQL-based enterprise applications.

The ideal candidate should have a strong understanding of Oracle database technologies, excellent programming skills, and expertise in performance tuning.

Roles and Responsibilities :

- Develop and maintain Oracle PL/SQL database programs to meet business requirements.

- Create and manage database objects such as tables, views, constraints, sequences, and synonyms.

- Design and implement complex database objects, including stored procedures, functions, packages, and collections.

- Perform performance tuning for SQL queries, application programs, and database instances.

- Ensure compliance with V3 standards in database development.

- Collaborate with cross-functional teams in Agile/Scrum environments to deliver high-quality solutions.

- Handle client interactions for scoping, effort estimation, and status reporting.

- Evaluate new technologies and recommend solutions for improved system performance.

- Utilize tools like TOAD, SQLPLUS, and SQLLOADER for database operations.

- Apply knowledge of UNIX commands for basic database management tasks.

Skills and Qualifications :

Technical Skills :

- Expertise in Oracle versions 10g, 11g, 12c, and higher.

- Proficiency in Oracle functions, procedures, triggers, packages, and performance tuning.

- Hands-on experience with PL/SQL programming, including database triggers, cursors, and -user-defined exceptions.

- Knowledge of Pragma Autonomous Transactions, Bulk Collect, Oracle Hint, and Explain Plan.

- Proficient in SQL query tuning and performance optimization.

Development Tools :

- SQLPLUS, TOAD, and SQLLOADER.

Methodologies :

- Experience working in Agile/Scrum development environments.

Soft Skills :

- Strong communication and interpersonal skills.

- Ability to interact effectively with clients for requirement gathering and project updates.

Additional Knowledge :

- Basic understanding of UNIX commands and client-server application development