PL-SQL Developer
Location : Bengaluru, India, India
Experience : 4 Year
Rate: $11 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Having 4+ years of total IT experience in designing and implementing the enhanced functionality on Oracle Technologies like SQL, PL/SQL using Stored Procedures, Packages on Oracle 11gDatabase as backend. Involved mainly in software analysis, design, implementation and development of Oracle Programming.
Proficient Knowledge on Creating Oracle Tables, Views, Sequences and Indexes.
Experience in writing SQL Queries using Joins, Functions, WHERE clause, GROUPBY clause and HAVING clause based on the requirement.
Experience in writing Constraints as per business requirements and widely used CHECK Constraint to implement business logic.
Good knowledge on Pseudo Column Implementations, SQL SET Operators, Materialized Views. Knowledge on Database Security like Privileges and Roles.
Expertise in Backend Programming using PL/SQL Stored Procedures, Functions, Packages, Triggers.
Experience in Exception Handling and auditing done using SQLCODE and SQLERRM.
Extensive Experience in writing Packages using Associative Array (PL/SQL Table), PL/SQL Record and Ref Cursor. .
Good knowledge on SQL Tuning Methods
Able to adapt quickly to the environment and willing to work in shifts.
Good in getting acquainted with latest technologies and strives out for getting good productivity.