Recruitment Executive at Collabera
Views:81 Applications:3 Rec. Actions:Recruiter Actions:2
Pro*C Developer - Troubleshooting/Performance Tuning (2-8 yrs)
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
- 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.