Oracle PL/SQL Developer

Raas Infotek LLC

Houston, TX, United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

dice.com

Tech stack

Java (Programming Language) Agile Methodology Amazon Web Services Microsoft Azure Big Data Unix Cloud Computing Code Review Computer Programming Databases Data Validation Data Integrity

+34 more

Extract Transform Load (ETL) Data Mining Data Warehousing Database Applications Cursor (Graphical User Interface Elements) Database Design DevOps Python (Programming Language) Oracle Data Service Integrator Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Query Optimization Power BI Standard Sql Shell Script SQL Stored Procedures PL-SQL SQL Databases Subversion Tableau (Software) Data Processing Database Optimization Indexer Sap Business Objects Git Data Lakes Information Technology Bitbucket Database Replication Tools for Reporting Oracle Cloud Infrastructure Software Version Control

Job description

Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and views.
Develop and optimize SQL queries for high-performance data processing and reporting.
Analyze business requirements and translate them into technical database solutions.
Perform database performance tuning, query optimization, and troubleshooting.
Develop ETL processes for data extraction, transformation, and loading.
Work closely with business analysts, application developers, and data architects.
Support production environments and resolve database-related issues.
Create and maintain database design documents, technical specifications, and deployment procedures.
Implement data validation, data quality, and data integrity controls.
Participate in code reviews and ensure adherence to coding standards and best practices.
Mentor junior developers and provide technical leadership on database initiatives.
Collaborate with DevOps and application teams for deployment and release activities.

Requirements

We are seeking an experienced Oracle PL/SQL Developer with 12+ years of hands-on experience in designing, developing, optimizing, and supporting enterprise database applications. The ideal candidate should have strong expertise in Oracle Database, PL/SQL programming, performance tuning, data modeling, ETL processes, and database architecture. Experience working in large-scale enterprise environments is highly preferred., * 12+ years of experience in Oracle Database Development.

Strong expertise in Oracle PL/SQL programming.
Extensive experience with:
Stored Procedures
Functions
Packages
Triggers
Views
Cursors
Collections
Dynamic SQL
Strong knowledge of SQL query optimization and performance tuning.
Experience with Oracle 11g, 12c, 19c, or higher.
Expertise in indexing strategies, partitioning, and execution plan analysis.
Experience with ETL/Data Warehousing concepts.
Strong understanding of database design, normalization, and data modeling.
Experience in Unix/Linux environments and shell scripting.
Knowledge of source control tools such as Git, SVN, or Bitbucket.
Excellent troubleshooting and problem-solving skills., * Experience with Oracle Data Integrator (ODI), Informatica, or other ETL tools.
Experience with Oracle GoldenGate or data replication technologies.
Exposure to cloud platforms such as AWS, Azure, or Oracle Cloud.
Experience working in Agile/Scrum environments.
Knowledge of Python or Java for database integration.
Oracle Certification is a plus., * Banking, Healthcare, Insurance, Telecom, or Retail domain experience.
Experience with reporting tools such as Tableau, Power BI, or Business Objects.
Exposure to Data Lake and Big Data technologies., * Bachelor’’s or Master’’s degree in Computer Science, Information Technology, Engineering, or a related field.

Keywords: Oracle PL/SQL, SQL, Oracle Database, Performance Tuning, Query Optimization, ETL, Data Warehousing, Data Modeling, Indexing, Partitioning, Unix, Shell Scripting, ODI, Informatica, Oracle 19c, Git, Agile, Cloud, Oracle GoldenGate.