Oracle Developer (PL/SQL)
Location: Thane (Wagle Estate)
Experience: 3–7 Years
Employment Type: Full-Time
Job Summary
We are looking for an experienced Oracle Developer with strong expertise in Oracle PL/SQL development, database design, and high-volume data processing environments. The ideal candidate should have experience working on large-scale enterprise applications, data migration projects, and mission-critical systems. Candidates with exposure to the Aviation, Logistics, Travel, Transportation, or other high-transaction industries will be preferred.
Key Responsibilities
- Develop, maintain, and optimize Oracle SQL and PL/SQL programs.
- Design and develop Stored Procedures, Packages, Functions, Triggers, Views, and Indexes.
- Work on high-volume transactional databases handling large datasets and complex business processes.
- Participate in Data Migration and Database Transformation Projects, including data extraction, cleansing, validation, reconciliation, and migration.
- Analyze and optimize database performance through query tuning and indexing strategies.
- Support system integrations and data movement between multiple applications.
- Troubleshoot production issues and provide timely resolutions.
- Collaborate with business users, analysts, and technical teams to deliver database solutions.
- Ensure data accuracy, integrity, and compliance with organizational standards.
Required Skills
- 3+ years of hands-on experience in Oracle SQL and PL/SQL Development.
- Strong expertise in:
- Stored Procedures
- Packages
- Functions
- Triggers
- Cursors
- Views
- Indexes
- Experience working on High Volume Databases and large-scale enterprise applications.
- Experience in Data Migration Projects, Data Conversion, Data Validation, and Data Reconciliation.
- Strong knowledge of Query Optimization and Performance Tuning.
- Experience handling large datasets and batch processing.
- Excellent problem-solving and analytical skills.
Preferred Experience
- Experience in Aviation, Airlines, Airport Operations, BFSI,Travel Technology, Logistics, Transportation, BFSI, or other high-transaction environments.
- Experience with large-scale ERP, CRM, Reservation, Booking, Cargo, or Operational Systems.
- Exposure to Oracle Forms & Reports.
- Knowledge of Unix/Linux Shell Scripting.
- Experience with ETL tools and database migration activities.
Pay: ₹400,000.00 - ₹800,000.00 per year
Application Question(s):
- How many years of hands-on experience do you have in Oracle PL/SQL Development?
- Have you worked extensively on Oracle Stored Procedures, Packages, Functions, Triggers, and Performance Tuning?
- Have you been involved in any Data Migration, Data Conversion, Data Reconciliation, or Database Migration Projects?
- Have you worked on High-Volume Transactional Systems handling large datasets
- Are you comfortable working on production support, query optimization, and performance tuning for mission-critical enterprise applications?
- Describe one Oracle Data Migration project you worked on, mentioning database size, volume of records migrated, and your specific contribution.
- Are your a Immediate Joiner ? Kindly mention the last working day.
- Are you Ready to travel Thane (W)?
Work Location: In person