Oracle PL/SQL Developer / Data Modeler

Raas Infotek LLC

Austin, TX, United States

25 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence CA Workload Automation Ae Big Data Cloud Database Databases Continuous Integration Data Validation Data Cleansing Data Integration Extract Transform Load (ETL) Data Mapping

+41 more

Data Migration Relational Databases Cursor (Graphical User Interface Elements) Database Design Oracle Exadata Github Apache Hadoop Apache Hive JSON Python (Programming Language) Microsoft SQL Server Operational Databases Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Scrum Methodology Ansible Standard Sql Shell Script SQL Stored Procedures PL-SQL SQL Databases Tableau (Software) Extensible Markup Language (XML) Enterprise Data Management Azure Data Factory Informatica Powercenter Snowflake Apache Spark Software Troubleshooting Database Performance Pandas Database Migration Pyspark AWS Glue IBM UrbanCode Deploy Physical Data Models Sql Tuning Jenkins Databricks

Job description

We are seeking an experienced Senior Oracle PL/SQL Developer / Data Modeler with strong expertise in Oracle database development, PL/SQL programming, data modeling, ETL, performance tuning, and enterprise data integration. The ideal candidate will have experience supporting high-volume financial applications and working with cross-functional development and data teams. < data-start=”711” data-end=”736”>Key Responsibilities

Design, develop, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, cursors, and stored procedures.
Develop and maintain Oracle database objects including tables, views, indexes, sequences, synonyms, and materialized views.
Design and maintain conceptual, logical, and physical data models for enterprise data platforms.
Analyze business requirements and translate them into scalable technical and database solutions.
Perform SQL and PL/SQL performance tuning using Explain Plan, SQL Trace, TKPROF, AUTOTRACE, AWR, and ASH.
Develop optimized SQL queries, joins, subqueries, and batch-processing solutions for large datasets.
Design and support ETL/data integration workflows using Informatica IDMC, Informatica PowerCenter, SQL*Loader, External Tables, and PL/SQL.
Perform data migration, source-to-target mapping, data cleansing, validation, reconciliation, and quality checks.
Support Oracle Exadata and Autonomous Database environments and optimize database performance.
Develop Unix/Linux shell scripts and integrate database processes with Autosys scheduling.
Troubleshoot production database issues, perform root-cause analysis, and implement permanent fixes.
Support database migration and modernization initiatives, including SQL Server-to-Oracle conversions.
Collaborate with DBAs, developers, data architects, QA teams, and business stakeholders.
Use Git/GitHub, Jenkins, UDeploy, Ansible, and other CI/CD tools for database code deployment.
Participate in Agile/Scrum ceremonies and provide technical documentation.

Requirements

12+ years of experience in Oracle SQL/PLSQL development.
Strong experience with Oracle database development and RDBMS concepts.
Expertise in PL/SQL packages, procedures, functions, triggers, cursors, views, indexes, and complex SQL.
Strong understanding of data modeling and database design.
Hands-on experience with SQL performance tuning and Explain Plan.
Experience with ETL, data migration, data validation, and reconciliation.
Strong experience with Informatica PowerCenter/IDMC.
Experience with Oracle Exadata and/or Oracle Autonomous Database.
Strong Unix/Linux shell scripting experience.
Experience with Git/GitHub and CI/CD tools.
Strong troubleshooting and production support experience.