PL/SQL Developer

Raas Infotek LLC

Austin, TX, United States

6 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Application Integration Architecture JIRA Microsoft Azure Profiling Code Review Databases Continuous Integration Extract Transform Load (ETL) Data Migration Data Mining Cursor (Graphical User Interface Elements)

+26 more

Database Schema Oracle Data Guard Software Design Documents JSON Oracle Databases Oracle Rac Oracle SQL Developer Performance Tuning Query Optimization Shell Script SQL Stored Procedures PL-SQL SQL Databases Talend Extensible Markup Language (XML) Data Processing Freeform SQL Google Cloud Enterprise Software Applications Database Performance Indexer Git Performance Monitor Data Management Restful APIs Jenkins

Job description

We are looking for an experienced Senior PL/SQL Developer with 10+ years of hands-on experience in Oracle database development, PL/SQL programming, performance tuning, and enterprise application support. The candidate will be responsible for designing, developing, optimizing, and maintaining complex database solutions., * Develop and maintain complex PL/SQL procedures, functions, packages, triggers, and cursors.

Design and optimize Oracle database schemas, tables, views, indexes, and materialized views.
Perform SQL and PL/SQL performance tuning using explain plans, indexing, query optimization, and profiling tools.
Develop complex SQL queries for data extraction, transformation, and reporting.
Analyze and resolve database performance, production, and data-related issues.
Work with business and technical teams to understand requirements and develop scalable database solutions.
Perform data migration, conversion, validation, and reconciliation activities.
Develop and maintain ETL processes and support integration with enterprise applications.
Conduct code reviews and ensure adherence to development and database standards.
Create technical documentation, design documents, and deployment procedures.
Provide production support and troubleshoot critical database issues.
Mentor junior developers and provide technical guidance to the development team.

Requirements

10+ years of experience in Oracle database development.
Strong expertise in Oracle SQL and PL/SQL.
Extensive experience with Stored Procedures, Functions, Packages, Triggers, Cursors, Collections, and Dynamic SQL.
Strong knowledge of Oracle database architecture and data modeling.
Experience with SQL/PLSQL performance tuning and optimization.
Hands-on experience with Oracle 11g/12c/19c or higher.
Strong understanding of indexes, partitions, constraints, views, materialized views, and database objects.
Experience with Unix/Linux shell scripting.
Experience with ETL/data migration and large-volume data processing.
Familiarity with Git, Jenkins, Jira, or similar development/CI tools.
Strong analytical, troubleshooting, and communication skills.

Preferred Skills

Experience with Oracle RAC, Data Guard, partitioning, and performance monitoring.
Knowledge of AWS/Azure/Google Cloud Platform database environments.
Experience with Informatica, Talend, or other ETL tools.
Exposure to REST APIs, XML/JSON, and application integration.
Experience working in Agile/Scrum environments.