Oracle Pl/SQL Developer

Purple Drive Technologies

Westlake, TX • On-site

$48.75 - $61.50/hr

Full-time

Posted 13 days ago


Job description

Overview:
Oracle PL/SQL Developer
Key Responsibilities:
  • Develop, test, and maintain PL/SQL procedures, functions, packages, and triggers.
  • Assist in the design and optimization of complex SQL queries for data extraction and reporting.
  • Support ETL workflows using tools like Oracle Data Integrator (ODI), Informatica, or custom PL/SQL scripts.
  • Participate in data migration, cleansing, and validation activities across different systems.
  • Analyze and troubleshoot performance issues in Oracle queries and code.
  • Work with business analysts, QA teams, and senior developers to meet data and reporting requirements.
  • Create and maintain technical documentation related to database objects and ETL jobs.
  • Ensure adherence to data governance and security best practices.

Required Skills & Qualifications:
  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • 5-8 years of hands-on experience with Oracle PL/SQL.
  • Good understanding of relational databases, data modeling, and normalization.
  • Basic knowledge of ETL processes and tools (e.g., ODI, Informatica, Talend, SSIS, etc.).
  • Familiarity with data warehousing concepts is a plus.
  • Proficient in writing, debugging, and optimizing SQL queries.
  • Experience working with large datasets and an understanding of performance tuning.
  • Strong problem-solving skills and attention to detail.
  • Good communication skills and ability to work in a collaborative team environment.

Preferred Qualifications:
  • Exposure to Oracle 12c/19c or later versions.
  • Experience with version control systems (e.g., Git).
  • Familiarity with Agile/Scrum development practices.
  • Basic knowledge of Unix/Linux shell scripting.
  • Understanding of data quality and data integration challenges.



Frequently asked questions

Q: What skills or qualities help someone succeed as a Oracle PL SQL Developer?

A: To succeed as an Oracle PL/SQL Developer, key technical skills include proficiency in Oracle database management systems, expertise in PL/SQL programming language, and knowledge of database design principles. Soft skills such as strong analytical and problem-solving abilities, effective communication, and collaboration with cross-functional teams are also crucial for success in this role. By combining these technical and soft skills, Oracle PL/SQL Developers can design, develop, and implement efficient database solutions, drive business growth, and advance their careers in the field of database development.

Q: What is the career path for a Oracle PL SQL Developer?

A: A typical career progression for an Oracle PL SQL Developer involves starting as a Junior Developer, where they design, develop, and test database applications using PL SQL, and gradually moving to mid-level roles such as Senior Developer or Database Analyst, where they lead projects, optimize database performance, and implement data security measures. As they gain experience, they can transition to senior roles like Technical Lead or Database Architect, where they oversee large-scale database projects, design complex database systems, and mentor junior developers. With advanced skills and experience, Oracle PL SQL Developers can also pursue leadership positions, such as IT Manager or Director of Database Services, or transition into related fields like data science, business intelligence, or IT consulting.



Purple Drive Technologies job posting for a Oracle Pl/SQL Developer in Westlake, TX with a salary of $49 to $62 Hourly with a map of Westlake location.