Senior Oracle PL/SQL Developer

Long Finch Technologies

Santa Ana, CA

Posted On: Jun 19, 2024

Posted On: Jun 19, 2024

Job Overview

Job Type

Full-time

Experience

10 - 15 Years

Salary

$120,000 - $140,000 Per Year

Work Arrangement

Hybrid

Travel Requirement

0%

Required Skills

  • Oracle PL/SQL
  • SDLC
  • SQL
  • database
  • microservices
  • performance tuning
Job Description
Roles and Responsibilities
  • Provide operational maintenance, support, and upgrades for complex database management systems architected using a microservices framework.
  • Monitor and configure database systems and databases to achieve optimum performance levels; Perform indexing, data partitioning and performance tuning as required.
  • Support complex database software installations, patching and upgrades to operating systems and related database software packages
  • Document backup and recovery procedures, perform backups, automate and monitor logging.
  • Support database data integrity by implementing and managing appropriate solutions of varying complexities.
  • Support external audits and conduct audits of databases to ensure compliance with established standards, policies, and configuration guidelines.
  • Understand the data and perform data analysis to support building new reports and modify existing reports.
  • Perform code promotions and test that reports are operating correctly.
  • Coordinate cross-functional projects as assigned and interact with all areas of the organization to achieve timely results.
 
Required Experience
  • 10+ years of experience in Oracle PL/SQL development, including stored procedures, triggers, and packages.
  • Strong understanding of relational database concepts and experience working with Oracle databases.
  • Proficiency in writing efficient and optimized SQL queries and performance tuning.
  • Solid understanding of software development life cycle (SDLC) and agile methodologies.
  • Experience with version control systems and code management practices.
  • Strong analytical and problem-solving skills.
  • Excellent communication and teamwork abilities.
  • Stay updated with emerging technologies and recommend improvements to enhance system efficiency and functionality.

 

Preferred Qualifications
  • Relevant certifications in PowerBuilder or Oracle PL/SQL are a plus.
  • Experience working on enterprise-level applications and large-scale projects.
  • Familiarity with Microsoft web development technologies and other programming language.

Job ID: LF240260


Posted By

Andy

HR Manager