Senior Oracle Developer
zartechnology - Jersey City, NJ

This job posting is no longer available on Find similar jobs: Senior Oracle Developer jobs - zartechnology jobs

Position: Senior Oracle Developer

Location: New Jersey, NJ

Duration: Full time


Participate in the full development cycle ofPlanning, Analysis, Design, Development, Testing,Implementation, debugging and tuning of data centric applicationsParticipate inLogical & Physical Database Layout DesignDevelop AdvanceOracle SQL DDL/DML scripts, PL/SQL packages, functions, procedures, triggers and materialized views to implement data integrity constraints and business logicWrite complex queries, views, and data manipulationstatements. Understand and use local and distributed truncations in multiuser environmentDevelop transactional data APIs. Work collaboratively with other application developers to provide them with necessary queries, views and stored procedures and the necessary insight into the data layerFine-tune procedures and SQL statements for optimal performanceImprove the performance of existing applications by making changes on the database side

Required Skills:

Solid experience in SQL, PL/SQLDevelopment, Analysis, Design and Implementation of Business Applications using the Oracle RDBMSExperience inDatabase Application Development, logical and physical data design, Optimization and Performance TuningExpertise in application development using Oracle11r2g/10g SQL, PL/SQL, SQL*PLUSExcellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand Data Wheelhouse applicationsExperience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniquesStrong Experience in developing database objects liketables, indexes, Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQLExperience in effective usage ofQuery factoring, Analytical functions, Table Functions, Collections, Compound triggers, Partition Tables and Materialized ViewsExperience in the development of materialized viewsfor data replication in distributed environmentsExperience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.Knowledge of using large Partitioned Tables andadvanced partition techniquesExperience in SQLperformance tuningusing Cost-Based Optimization (CBO)Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution Plans,Indexes and optimizer HINTSExperience incomplete System Development Life CycleExcellentcommunication,interpersonal,analyticalskillsandstrongabilitytoperformaspartof ateam

Education Qualifications:

BS or equivalent - 14 months ago - save job