Senior PL/SQL Developer

Raas Infotek LLC
Ohio City, OH, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

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

Tech stack

Unit Testing CA Workload Automation Ae Code Review Databases Data Integrity Extract Transform Load (ETL) Data Migration Data Warehousing Database Applications Database Development Database Security Software Debugging
+20 more
Python (Programming Language) Oracle Databases Oracle Rac Performance Tuning Query Optimization Shell Script SQL Stored Procedures PL-SQL SQL*Plus SQL Databases Scripting Freeform SQL System Availability Database Optimization Analytic Functions Database Performance Indexer Toad (Software) Database Tools and Utilities Control M

Job description

We are looking for an experienced Senior PL/SQL Developer with 11+ years of experience in Oracle database development, SQL programming, performance tuning, and database optimization. The ideal candidate should have strong expertise in developing complex stored procedures, functions, packages, triggers, and supporting enterprise-level database applications., * Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers.

  • Write and optimize complex SQL queries for large-scale databases.
  • Perform SQL and PL/SQL performance tuning and query optimization.
  • Work with Oracle databases, indexes, views, materialized views, and partitions.
  • Analyze and troubleshoot database performance issues.
  • Develop database solutions for business requirements and application integrations.
  • Perform data migration, validation, and transformation activities.
  • Collaborate with application developers, business analysts, and QA teams.
  • Participate in code reviews, unit testing, and production support.
  • Ensure database security, data integrity, and high availability.

Requirements

  • 11+ years of experience in Oracle PL/SQL development.
  • Strong expertise in SQL, PL/SQL, stored procedures, functions, packages, and triggers.
  • Hands-on experience with Oracle 11g/12c/19c or later.
  • Strong knowledge of query optimization and performance tuning.
  • Experience with analytical functions, cursors, collections, and dynamic SQL.
  • Knowledge of indexing, partitioning, execution plans, and database optimization.
  • Experience with Unix/Linux shell scripting.
  • Familiarity with database tools such as SQL Developer, TOAD, or SQL*Plus.
  • Strong debugging, analytical, and problem-solving skills., * Experience with ETL processes and data warehousing.
  • Knowledge of Oracle RAC and database architecture.
  • Experience with scheduling tools such as Control-M or Autosys.
  • Exposure to Python or other scripting languages.
  • Experience working in Agile/Scrum environments.

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…