Raas Infotek
Actively Hiring
Source for IT Talent
Job Location
Remote Work Policy
In office
Visa Sponsorship
Not Available
RelocationAllowed
Skills
SQL
Git
Jira
Oracle 11g
Agile/Scrum
Data Migration
Data Validation
Oracle 12c
Oracle PL/SQL
Stored procedures
Transaction Management
Data Modeling
Data Integrity
QUERY OPTIMIZATION
Database Security
Triggers
Packages
Cursors
Oracle 19c
Views
ETL Processes
Functions
Access Controls
Oracle Database Design
SQL/PLSQL Performance Tuning
Large-Volume Data
Complex Database Environments
About the job
Experience: 10+ Years
Job Description
We are looking for an experienced PL/SQL Developer with strong expertise in Oracle database development, SQL, data processing, and performance tuning. The candidate will be responsible for developing database solutions, supporting application integrations, and troubleshooting production issues in an enterprise environment.
Required Skills
- 10+ years of experience in Oracle PL/SQL Development.
- Strong hands-on experience with SQL and complex queries.
- Experience with Stored Procedures, Functions, Packages, Triggers, Cursors, and Views.
- Strong knowledge of Oracle database design, data modeling, and data integrity.
- Experience with SQL/PLSQL performance tuning and query optimization.
- Experience with data migration, ETL processes, and data validation.
- Good knowledge of Oracle 11g/12c/19c or later.
- Experience with Unix/Linux and shell scripting is preferred.
- Experience with Git, Jira, and Agile/Scrum environments.
- Strong analytical, troubleshooting, and problem-solving skills.
- Experience working with large-volume data and complex database environments.
- Knowledge of database security, access controls, and transaction management.
- Experience supporting development, QA, UAT, and production environments.
- Ability to analyze requirements and translate them into efficient database solutions.
Responsibilities
- Develop, enhance, and maintain complex PL/SQL programs and database objects.
- Design and optimize SQL queries, stored procedures, and database processes.
- Perform database performance tuning and resolve SQL performance issues.
- Support data migration, integration, and reconciliation activities.
- Troubleshoot application and database issues and perform root-cause analysis.
- Work closely with developers, QA, BA, and DBA teams.
- Participate in code reviews, testing, deployments, and production support.
- Prepare technical documentation and follow established development standards.
- Support application releases and database deployment activities.
- Identify opportunities to improve database performance, reliability, and maintainability.
Preferred Skills
- Experience with Informatica, Oracle Data Integrator (ODI), or other ETL tools.
- Knowledge of Oracle RAC, partitioning, and large-volume databases.
- Experience with cloud or enterprise database environments.
- Experience working with batch processing and scheduling tools.
- Knowledge of REST APIs, JSON/XML, and application integration is a plus.
Key Skills: Oracle | PL/SQL | SQL | Stored Procedures | Packages | Functions | Triggers | Performance Tuning | ETL | Data Integration | Unix/Linux | Git | Agile/Scrum
