Oracle PL/SQL Developer -Exadata

Merican Inc
San Antonio, TX, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Business Logic Batch Processing Databases Data Architecture Data Validation Data Integration Extract Transform Load (ETL) Database Applications Database Design Database Development Oracle Exadata
+13 more
Oracle Databases Oracle SQL Developer Performance Tuning Query Optimization SQL Stored Procedures PL-SQL SQL Databases Data Processing Snowflake Database Optimization Git Toad (Software) AWS Data Analytics

Job description

Seeking an experienced Oracle PL/SQL Developer with strong expertise in database development, complex SQL, stored procedures, packages, functions, data modeling, and performance tuning. The role focuses on implementing detailed business logic within Oracle databases and supporting high-volume transactional systems., * Develop and maintain Oracle PL/SQL solutions.

  • Create and optimize stored procedures, packages, functions, triggers, and views.
  • Design logical and physical data models.
  • Write complex SQL and implement detailed business logic.
  • Perform query optimization and database performance tuning.
  • Troubleshoot production issues and support enterprise database applications.

Requirements

  • Oracle PL/SQL
  • Stored Procedures, Packages, Functions, and Triggers
  • Advanced SQL Development
  • Query Optimization and Performance Tuning
  • Execution Plan Analysis
  • Data Modeling (Logical and Physical)
  • SQL Developer / TOAD
  • Git and Agile methodologies

Required Experience

  • Strong hands-on PL/SQL development experience.
  • Expertise in building complex business logic in the database layer.
  • Experience with high-volume transactional systems.
  • Strong database design and performance tuning skills.

Top 5 Must-Have Skills

  • Oracle PL/SQL
  • Stored Procedures, Packages, and Functions
  • Advanced SQL Development
  • Query Optimization and Performance Tuning
  • Data Modeling (Logical and Physical)

In short-

  • Expertise in Oracle SQL, PL/SQL, data modeling, and performance tuning.

  • Experience with ETL development, data integration, and batch processing frameworks.

  • Experience with data validation, reconciliation, certification, and quality controls.

  • Knowledge of Snowflake and AWS data technologies.

  • Strong understanding of scalable data architecture and large-volume data processing.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…