Oracle Developer for FDW Support

TecTammina; Hopewell Township (NJ); On-site; USD 110,000 - 150,000; Full time

Job summary

TecTammina in New Jersey is seeking an Oracle PL/SQL Developer with extensive database design and performance tuning experience. You will work on complex PL/SQL development, data modeling, and ensuring efficient query performance in a dynamic project environment.

Candidates should have strong communication skills and a Bachelor’s degree or higher. UNIX scripting and Autosys experience are a plus, with a focus on Oracle Apps General Ledger in a permanent role.

Qualifications

• Bachelor or higher in a related field.
• Strong communication and troubleshooting skills.
• Extensive Oracle PL/SQL development experience.
• Experience with Oracle RAC and database partitioning.
• UNIX command line and scripting experience; Autosys a plus.

Responsibilities

• Develop and optimize PL/SQL packages, procedures and triggers.
• Manage Oracle objects including tables, indexes, views, constraints, db links and jobs.
• Provide production support, fix job abends and respond to user queries.

Skills

Communication skills

Oracle PL/SQL

Data modeling

Query optimization

Performance tuning

Education

Bachelor or higher

Tools

Oracle RAC

UNIX

Autosys

Oracle Apps General Ledger

Job description

Strong communication skills to facilitate working in a dynamic project environment.

Extended knowledge in Oracle PL/SQL which involves Database Application Development, Query Optimization and Performance Tuning.

Logical and physical Data Modeling using normalizing Techniques.

Strong Knowledge in Packages, Materialized views, Views, Indexes and database design in ORACLE (Stored procedures, triggers, objects).

Strong Knowledge with Table Partitioning, Load Balancing in Oracle RAC implementation and other Oracle specific concepts.

Managing Oracle objects including tables, indexes, views, constraints, db links, jobs, snapshots etc.

Good in production support, fixing job abends, and providing solution to User queries.

Prefer with Good knowledge in Oracle Apps General Ledger, UNIX (commands & shell scripts) and Autosys.

Qualifications

Bachelor or higher

Additional Information

Job Status: Permanent

Share the Profiles to mdanish(at)1stitsolutions.com

Contact: 703-349-1004

Keep the subject line with Job Title and Location

Job Location