PL/SQL Developer
Raas Infotek LLC
Texas City, TX, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦