Oracle PL/SQL developer Job at Innova software Services Inc, Fountain Valley, CA

OWNVT1huSklXTG1hMVJiMVNweWw4U05sclE9PQ==
  • Innova software Services Inc
  • Fountain Valley, CA

Job Description

Role :PL/SQL Developer

Location: Fountain Valley, CA

Job Summary:

We are seeking a highly skilled and experienced PL/SQL Developer to join our growing team in Fountain Valley, CA. The ideal candidate will be responsible for designing, developing, testing, and implementing robust and efficient PL/SQL solutions for our critical business applications. This role requires a strong understanding of relational database concepts, data modeling, and performance tuning.

Responsibilities:

  • Design, develop, test, and implement high-quality PL/SQL packages, stored procedures, functions, triggers, and views.
  • Optimize existing PL/SQL code for performance, scalability, and maintainability.
  • Work closely with business analysts, data architects, and other developers to understand requirements and translate them into technical specifications.
  • Develop and maintain data migration scripts and ETL processes.
  • Troubleshoot and resolve database-related issues and performance bottlenecks.
  • Participate in code reviews to ensure adherence to coding standards and best practices.
  • Create and maintain technical documentation for all developed solutions.
  • Collaborate with QA teams to ensure thorough testing and quality assurance of developed applications.
  • Stay up-to-date with the latest Oracle database technologies and PL/SQL development trends.

Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).1
  • 5+ years of hands-on experience as a PL/SQL Developer with Oracle databases (12c, 19c preferred).
  • Strong proficiency in writing complex SQL queries, views, and DDL/DML statements.
  • Extensive experience with performance tuning and optimization of PL/SQL code and SQL queries.
  • Solid understanding of relational database design, data modeling, and normalization.
  • Experience with ETL processes and tools.
  • Familiarity with version control systems (e.g., Git, SVN).
  • Excellent problem-solving, analytical, and communication skills.
  • Ability to work independently and as part of a team in a fast-paced2 environment.

Preferred Skills (Nice to Have):

  • Experience with other database technologies (e.g., SQL Server, PostgreSQL)
  • Knowledge of data warehousing concepts.
  • Experience with Oracle APEX or other Oracle development tools.
  • Familiarity with Agile development methodologies.

Job Tags

Similar Jobs

Select Exterminating

Pest Control Technician Job at Select Exterminating

 ...We are recruiting for a Pest Control Technician to perform a driving route throughout Framingham/Boston area. The ideal candidate MUST have parking space to keep a company vehicle. The schedule is Monday through Friday with rotating Saturdays. Company Overview:... 

Sales Match

Client Care Associate Job at Sales Match

 ...We are looking for a Client Care Associate to join our work-from-home team. In this role, youll be responsible for delivering exceptional...  ...professional development ~ Flexible working hours with evening and weekend options available ~ Opportunities for career advancement... 

Synergyassure Inc

Accountant - R&D Job at Synergyassure Inc

 ...Job Title: Accountant R&D Location: Remote Employment Type: Full-Time About the Role We are currently seeking four experienced Accountants with a strong background in Research & Development (R&D) to join our growing team. This is a fully remote opportunity... 

Red Lion Inn

Bell Person Job at Red Lion Inn

The Door/Bell Person provides positive service standards including but not limited to courtesy, sincerity and enthusiasm to all guests...  ...* Communicate effectively via radio with the Front desk, Concierge, Bellmen and Guest Relations for all arrivals and departures to... 

Printfresh LLC

Freelance Bags / Soft Accessories Designer Job at Printfresh LLC

 ...is preferred. The ideal candidate will have a strong vision for translating our love of print and travel into high quality and sustainable accessory and travel items. Job Responsibilities Design from concept to creation a range of pouches, bags, and...