Sr. Oracle Developer

Company Name:
Prowess IT Solutions
- Participate in the full development cycle of Planning, Analysis, Design, Development,
Testing, Implementation, debugging and tuning of data centric applications
- Participate in Logical & Physical Database Layout Design
- Develop Advance Oracle SQL DDL/DML scripts, PL/SQL packages, functions, procedures, triggers
and materialized views to implement data integrity constraints and business logic
- Write complex queries, views, and data manipulation statements. Understand and use local and
distributed truncations in multiuser environment
- Develop 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 layer
- Fine-tune procedures and SQL statements for optimal performance
- Improve the performance of existing applications by making changes on the database side

- Solid experience in SQL, PL/SQL Development, Analysis, Design and Implementation of Business Applications using the Oracle RDBMS
- Experience in Database Application Development, logical and physical data design, Optimization and Performance Tuning
- Expertise in application development using Oracle 11r2g/10g SQL, PL/SQL, SQL PLUS
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and Data Wheelhouse applications
- Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
- Strong Experience in developing database objects like tables, indexes, Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
- Experience in effective usage of Query factoring, Analytical functions, Table Functions, Collections, Compound triggers, Partition Tables and Materialized Views
- Experience in the development of materialized views for data replication in distributed environments
- Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
- Knowledge of using large Partitioned Tables and advanced partition techniques
- Experience in SQL performance tuning using Cost-Based Optimization (CBO)
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, Indexes and optimizer HINTS
- Experience in complete System Development Life Cycle
- Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Engineering Manager Energy Solutions / Sr Proj...
Secaucus, NJ Johnson Controls
Senior Business Development Manager, State and...
Princeton, NJ eSystems, Inc.
Technical Recruiter - Business Development
Paramus, NJ Brains Workgroup, Inc.
Sr. Field Service Engineer
Raritan, NJ Laboratory Corporation of America
Senior Oracle Database Programmer - phone & in...