Back to search

Oracle Forms and PL SQL Developer

Database developer responsible for designing, coding, optimizing, and maintaining Oracle database objects and PL/SQL code.

  • Irvine, California, United States
  • Full-time
  • On-site
  • $50–$65 per hour
  • Posted Nov 16, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise Software

Responsibilities

  • Creating and maintaining database objects such as tables, views, indexes, stored procedures, functions, packages, and triggers
  • Writing high-quality PL/SQL code and SQL queries to implement business logic
  • Tuning and optimizing slow-running SQL queries and stored procedures
  • Designing, developing, and implementing ETL processes for data migration and warehousing
  • Troubleshooting and debugging database-related issues and performance bottlenecks
  • Collaborating with business analysts, application developers, QA testers, DBAs, and stakeholders to gather requirements and design solutions
  • Creating and maintaining technical documentation for database designs, code, and procedures
  • Developing and executing unit, string, and parallel tests to ensure functionality and reliability
  • Planning, coordinating, and implementing security measures to safeguard databases

Skills

PL/SQLInformatica PowercentreInformatica PowercentrePL/SQL

Benefits

  • Inclusive and diverse work environment
  • Opportunities for professional growth and development
  • Comprehensive health and wellness benefits

More jobs nearby

Full description

Job ID: 115879-1 Job Title: Oracle Forms and PL SQL Developer Location: Onsite: Irvine, CA Duration: 06+ months Pay rate: $50-$65/hr on W2/C2C Description: Database Development and Maintenance Creating and maintaining database objects such as tables| views| indexes| stored procedures| functions| packages| and triggers. Coding and Programming Writing high-quality| complex PLSQL code and SQL queries to implement business logic| manage data| and support application requirements. Performance Optimization Tuning and optimizing slow-running SQL queries| stored procedures| and overall database performance to ensure efficient data retrieval and processing. This includes using tools and techniques like EXPLAIN PLAN| indexing| and analyzing AWR reports. Data Management and ETL Designing| developing| and implementing Extract| Transform| Load (ETL) processes for data migration| transformation| and data warehousing.Troubleshooting and Debugging Identifying| investigating| and resolving database-related issues| errors| and performance bottlenecks in a timely and accurate manner. Collaboration and Communication Working closely with business analysts| application developers (.NET| Java| etc.)| QA testers| DBAs| and other stakeholders to gather requirements| design solutions| and ensure project success. Documentation and Standards Creating and maintaining technical documentation for database designs| code| and procedures| while enforcing database development standards and best practices. Testing Developing and executing unit| string| and parallel tests to ensure the functionality| reliability| and accuracy of database components and converted data. Security and Integrity Planning| coordinating| and implementing security measures to safeguard computer databases and ensure data integrity. Skills: Informatica Powercentre, PL/SQL Experience Required: 10 & Above Company Benefits & Culture • Inclusive and diverse work environment • Opportunities for professional growth and development • Comprehensive health and wellness benefits

Oracle Forms and PL SQL Developer at Artech LLC | Referso Jobs