Oracle PL/SQL Developer

INNOVATIVE ANALYTIC SOLUTIONS LLC
Washington, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Washington, United States of America

Tech stack

Query Performance
Agile Methodologies
Amazon Web Services (AWS)
Azure
Cloud Computing
Data Integrity
Data Profiling
Data Warehousing
DevOps
Oracle Applications
Performance Tuning
Systems Development Life Cycle
Power BI
SAS (Software)
PL-SQL
SQL Databases
Tableau
Scripting (Bash/Python/Go/Ruby)
Macros
Indexer
Backend
Alteryx

Job description

This role requires deep data skills and is not a reporting role. We need a true PL/SQL senior developer.

What You''ll Own:

  • Develope and tune complex PL/SQL- packages, procedures, triggers and functions.
  • Build logical and physical models, ERDs, and deimensional schemas
  • Diagnose and resolve deadlocks , locking contention, and query performance bottlenecks.
  • Profile, normalize and reconcile massive datasets across AWS and Azure
  • Develop backend structures that feed Power BI, Tableau and Alteryx
  • Drive data integrity through advanced parson, mapping and consolidation.

Requirements

  • 10 -20 years hands-on Oracle PL sequel development
  • Expert sql, tuning, indexing and execution plan analysis
  • Strong dimensional, modeling, and data warehousing fundamentals
  • Good to have scripting, macros, Sas connect, Sas access, etc.
  • Cloud, data profiling, Aws and Azure
  • Agile/Dev ops SDLC

Apply for this position