Senior PL/SQL Developer
Raas Infotek LLC
Ohio City, OH, 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
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦