PL/SQL Developer

Raas Infotek LLC
Texas City, TX, 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
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Unit Testing Code Review Databases Data Validation Data Integration Extract Transform Load (ETL) Data Migration Database Design Software Debugging Oracle Databases Oracle Forms Performance Tuning
+14 more
Query Optimization Shell Script SQL Stored Procedures PL-SQL SQL Databases Freeform SQL Enterprise Software Applications Database Optimization Analytic Functions Software Troubleshooting Database Performance Indexer Sql Tuning Database Tools and Utilities

Job description

  • Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers.
  • Write and optimize complex SQL queries for large-scale databases.
  • Perform SQL query tuning, performance optimization, and troubleshooting.
  • Work with Oracle databases, indexing, partitioning, and execution plans.
  • Develop and maintain database objects to support enterprise applications.
  • Analyze business requirements and translate them into technical solutions.
  • Perform data migration, data validation, and database integration activities.
  • Identify and resolve database performance issues and production defects.
  • Collaborate with application developers, business analysts, and QA teams.
  • Participate in code reviews, unit testing, and deployment activities.

Requirements

We are looking for an experienced Senior PL/SQL Developer with 10+ years of hands-on experience in Oracle database development, PL/SQL programming, query optimization, and database performance tuning. The ideal candidate should have strong expertise in developing complex SQL queries, stored procedures, functions, packages, and triggers., * 10+ years of experience in Oracle PL/SQL development.

  • Strong expertise in SQL and advanced PL/SQL programming.
  • Hands-on experience with Stored Procedures, Functions, Packages, Cursors, and Triggers.
  • Strong knowledge of Oracle Database architecture.
  • Experience with SQL tuning, query optimization, and performance troubleshooting.
  • Knowledge of indexing, partitioning, joins, analytical functions, and execution plans.
  • Experience with database design, data modeling, and normalization.
  • Proficiency in debugging and resolving complex database issues.
  • Experience working in Agile/Scrum development environments.

Preferred Skills

  • Experience with Oracle 12c, 19c, or higher.
  • Exposure to Unix/Linux shell scripting.
  • Experience with ETL processes and data integration.
  • Knowledge of Oracle Forms, Reports, or database utilities is a plus.
  • Experience with large-scale enterprise applications.

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…