28/08 Uvaish Khan
Recruitment Executive at Collabera

Views:81 Applications:3 Rec. Actions:Recruiter Actions:2

Pro*C Developer - Troubleshooting/Performance Tuning (2-8 yrs)

Chennai Job Code: 485653

Job Description :


Experience : 2-6Yrs and 6-8Yrs

Qualification : BE, MCA, BCA Equivalent

Location : Chennai

Pro- C :

- Database Connections, File Operations, Array/Structure Handling, Error Handling, Dynamic Query, Pro- C functions and procedure calls, Pro- C Data types, and usage, Running SQL queries using Pro- C, Pre-compilers, Compiler script, Memory Handling.

- Extensive hands-on experience on ProC programming along with PL/SQL

- Strong Debugging and troubleshooting skills

PL/SQL :

- Hands on Experience with SQL commands (DDL, DML & TCL etc) and SQL Scripts.

- Knowledge of creating packages, triggers, stored procedures Oracle Schema, Locks, SGA and materialized views

- Hands on experience on Oracle types, User defined data types/ Arrays and Collections

- Knowledge of expansions and sequences

- Knowledge of writing dynamic queries and cursors

- Must have experience on (Advance PL/SQL) Procedures, Packages, Functions, Indexes, Collections, Materialized views, Triggers Bulk Binding, Exception handling.

- Performance Tuning of queries using Explain Plan and other methods

Unix Shell Scripting : Basic Unix Commands like ls [ltr, head, tail, files/directories], scripting and file manipulation, Shell Scripting, Cron-tabs, Advance Unix command like awk, sed etc., Database connections.

Women-friendly workplace:

Maternity and Paternity Benefits

Add a note
Something suspicious? Report this job posting.