Senior Oracle SQL/PLSQL Developer – ETL & Performance

Robotic Technologies Automation; Weehawken (NJ); On-site; USD 96,000 - 152,000; Full time

Job summary

Robotic Technologies Automation in Weehawken, NJ is seeking a Senior Developer for Oracle SQL/PLSQL to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS. The role emphasizes performance tuning, complex SQL, and JSON data handling in Oracle and SQL Server.

Collaborate in an Agile environment, document technical solutions, and work with tools like Jira and Bitbucket; 8+ years of experience required, with a 12-month plus extension

Qualifications

• 8+ years Advanced Oracle SQL and PL/SQL, including BULK COLLECT and JSON handling
• 8+ years Complex Oracle SQL query optimization, including SGA/PGA/TempSpace efficiency
• 8+ years SQL Server development and database experience
• 8+ years Development testing, unit testing, and technical documentation
• 8+ years Agile software development
• 4+ years Storing, querying, and manipulating JSON data in Oracle tables
• 5+ years Jira and Bitbucket
• 2+ years Nomad

Responsibilities

• Design, develop, optimize, and maintain enterprise database applications, ETL processes and reports.
• Support TSDS with Oracle performance tuning and complex queries.
• Handle JSON data processing in Oracle and SQL Server.
• Collaborate in Agile development, with testing and documentation responsibilities.

Skills

Oracle SQL

PL/SQL

Performance tuning

JSON handling

Agile development

Unit testing

Technical documentation

Jira

Bitbucket

Nomad

SQL Server

Tools

Jasper Reports

ETL tools

Job description

Robotic Technologies Automation in Weehawken, NJ is seeking a Senior Developer for Oracle SQL/PLSQL to design, develop, optimize, and maintain enterprise database applications, ETL processes, and reports supporting TSDS. The role emphasizes performance tuning, complex SQL, and JSON data handling in Oracle and SQL Server.

Collaborate in an Agile environment, document technical solutions, and work with tools like Jira and Bitbucket; 8+ years of experience required, with a 12-month plus extension