Oracle PL/SQL Developer

Robotic Technologies Automation; Boston (MA); On-site; USD 77,000 - 110,000; Full time

Job summary

Robotic Technologies Automation in Boston, MA is seeking an experienced Oracle PL/SQL Developer to design, develop, and maintain enterprise database applications. The ideal candidate should have strong expertise in Oracle SQL, PL/SQL programming, database performance tuning, and data integration.

Key responsibilities include building and maintaining complex SQL objects, ETL interfaces, and data mappings; optimizing execution plans; working with JSON and XML data; and supporting application teams

Qualifications

• 5+ years of experience in Oracle database development.
• Strong hands-on experience with Oracle SQL and PL/SQL.
• Experience with stored procedures, packages, triggers, and functions.
• Knowledge of query optimization and execution plans.
• Experience with Oracle database performance tuning.
• Familiarity with SQL Server, Jira, Git, and Agile methodologies.

Responsibilities

• Develop and maintain complex SQL queries, stored procedures, functions, packages, and triggers.
• Design and optimize Oracle database objects and data models.
• Perform query optimization and database performance tuning.
• Work with large datasets and support data processing requirements.
• Develop and maintain ETL processes and database interfaces.
• Work with JSON data, XML, and database integration services.
• Support application development teams with database-related requirements.
• Perform unit testing, debugging, and production issue resolution.

Skills

Oracle database development

Oracle SQL & PL/SQL

Stored procedures / packages / Tr igs

Query optimization

Database performance tuning

ETL / data integration concepts

Familiarity with SQL Server

Agile methodologies

Tools

Jira

Git

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Oracle PL/SQL Developer
Location: Boston, MA
Duration: 11 Months + Extension
Bill Rate: $68/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

We are seeking an experienced Oracle PL/SQL Developer to design, develop, and maintain enterprise database applications. The ideal candidate should have strong expertise in Oracle SQL, PL/SQL programming, database performance tuning, and data integration.

Database Development:

• Develop and maintain complex SQL queries, stored procedures, functions, packages, and triggers.
• Design and optimize Oracle database objects and data models.
• Perform query optimization and database performance tuning.
• Work with large datasets and support data processing requirements.

Application & Data Integration:

• Develop and maintain ETL processes and database interfaces.
• Work with JSON data, XML, and database integration services.
• Support application development teams with database-related requirements.
• Perform unit testing, debugging, and production issue resolution.

Skills:

• 5+ years of experience in Oracle database development.
• Strong hands-on experience with Oracle SQL and PL/SQL.
• Experience with stored procedures, packages, triggers, and functions.
• Knowledge of query optimization and execution plans.
• Experience with Oracle database performance tuning.
• Familiarity with SQL Server, Jira, Git, and Agile methodologies.

Preferred Qualifications:

• Experience with Oracle Forms, Reports, or APEX.
• Knowledge of ETL tools and data mapping.
• Experience with Jasper Reports.
• Understanding of CI/CD tools such as Jenkins or Bitbucket.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.