Oracle PL SQL Developer @ 24x7 Easy Recruitz

Job Description

Experience in Analysis, Design and Implementation.Oracle SQL, PL SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle 9i, 10g, 11g and 12c Relational Database Management System RDBMSGood knowledge of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.Good knowledge of logical and physical Data Modeling using normalizing TechniquesGood knowledge of Tables, Views, Constraints, Index B Tree, Bitmap and Function BasedGood knowledge of Complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL SQL Conversion, Aggregate, Numeric, Character, GeneralPerformance tuning.Good understanding of Joins Outer, Left Right Outer Join, Self, Inner, Cross JoinHandling errors with Exceptions.Hands on nested Subqueries, Dual Table.Experience in Oracle supplied packages, Dynamic SQL, Records and PL SQL Tables.Good command on UNIX commands grep,scp, sort, crontab, mail)User Administration. commands useradd, usermod, userdel, passwd, groupadd, groupmod, chown, chgrp Good understanding of shell scripts for invoking SQL scripts.Map , TypeTree, MDQ, Resource registry, Connectivity with multiple source target systems Text File, CSV, XML, Database etc.Debuging in case of any issue. Knowledge of Jira, Confluence and Agile methodologies, Sprint , Story Points, Task Estimations during sprint planning. Should have good communication skills, Should be vigilant to identify the issues/risks well in advance

Employement Category:

Employement Type: Full time
Industry: IT Services & Consulting
Role Category: IT Operations / EDP / MIS
Functional Area: Not Applicable
Role/Responsibilies: Oracle PL SQL Developer

+ View Contact

Keyskills:   Analysis Design Implementation Oracle SQL PL SQL Oracle 9i Oracle 10g Oracle 11g Relational Database Management System Table Partitioning Collections Tables Views Stored Procedures Cursors Triggers SQL PL SQL Conversion Numeric Character Joins Records grep scp sort mail User Administration Map Connectivity XML Database Jira Confluence Agile methodologies communication skills Oracle 12c Table Functions Indexes Analytical functions logical physical Data Modeling normalizing Techniques Constraints Index B Tree Bitmap Function Based Complex database objects Functions Packages Aggregate GeneralPerformance tuning Outer Left Right Outer Join Self Inner Cross Join Handling errors with Exceptions nested Subqueries Dual Table Oracle supplied packages Dynamic SQL PL SQL Tables UNIX commands crontab useradd usermod userdel passwd groupadd groupmod chown chgrp shell scripts SQL scripts TypeTree MDQ Resource registry Text File CSV