Design, develop, and optimize Oracle SQL/PLSQL database solutions. Translate business requirements into technical/functional specs, perform performance tuning, participate in reviews, collaborate with clients and teams, and learn Majesco product and Dev Studio to deliver robust, scalable database components.
Job Summary
The Oracle PL/SQL Developer role is responsible for designing, developing, and optimizing database solutions that support business and product requirements. This role requires deep expertise in Oracle SQL and PL/SQL, strong analytical capability, and the ability to translate complex functional requirements into scalable technical solutions. The individual will work closely with stakeholders and clients to understand requirements, prepare technical and functional specifications, and deliver high-quality solutions within planned timelines. Experience in the insurance domain will be an added advantage, along with openness to learning Majesco product functionality and related tools such as Dev Studio.
Key Responsibilities- Develop, maintain, and enhance complex SQL and PL/SQL programs, including stored procedures, packages, functions, triggers, views, and materialized views
- Work extensively on advanced PL/SQL programming concepts such as bulk handling, pipelined functions, analytical queries, collections, object types, and ref cursors
- Analyze complex requirements and break them down into structured technical solutions and delivery plans
- Perform performance tuning, profiling, and monitoring of slow-performing SQL queries and database programs
- Prepare technical and functional specification documents based on business and system requirements
- Collaborate with internal teams and clients to gather, clarify, and refine requirements
- Participate in code reviews, unit test plan reviews, and other quality review processes to ensure robust and reliable delivery
- Identify, track, and escalate issues that may impact development, testing progress, or delivery timelines
- Contribute to design and implementation activities with a strong focus on functionality development
- Continuously build understanding of Majesco product functionality and related development frameworks, including Dev Studio
- Strong experience in Oracle Database with advanced SQL and PL/SQL knowledge
- Expertise in developing complex SQL queries and PL/SQL-based database components
- Hands-on experience with performance tuning and optimization of SQL and PL/SQL code
- Strong analytical and logical thinking skills, especially in data analysis and understanding functional code
- Experience in functionality development, design, and implementation
- Ability to prepare technical and functional specifications from business requirements
- Experience in client communication for requirement gathering and clarification
- Insurance domain experience will be a significant advantage
- Willingness to learn new tools, frameworks, and Majesco product functionality
- Ability to work effectively in quality-focused environments with active participation in review processes
- Strong analytical thinking
- Ownership and problem-solving mindset
- Learning agility and openness to new tools
- Curiosity to understand product functionality deeply
- Ability to simplify complex requirements into clear delivery plans
Similar Jobs
Financial Services
Lead design, build, and run secure, scalable backend services and APIs (Python/Django/FastAPI). Automate network infrastructure and provisioning, improve reliability via observability and automation, lead system design, mentor engineers, enforce CI/CD, security, and AI-assisted development best practices, and partner across teams for vendor evaluation.
Top Skills:
AkamaiAWSCi/CdCloudflareDjangoFastapiPythonRabbitMQReactTerraform
Marketing Tech • Design
Lead the architecture and implementation of a production-grade generative AI media platform. Build reproducible, versioned pipelines, train LoRAs, integrate control techniques (ControlNet, IP-Adapter, inpainting), automate QC against product references, deploy internal tools, and partner with design to own the technical roadmap and enable creative teams.
Top Skills:
BlenderCadCode-First PipelinesComfyuiControlnetDiffusersGpu EnvironmentsInpaintingIp-AdapterLlm OrchestrationLoraNode-Based PipelinesPythonReference ConditioningVlm
Professional Services • Real Estate • Consulting
Lead Cost Engineer provides independent owner-side cost engineering for a multi-billion renewable and transmission program. Responsibilities include independent estimating, cost control, forecasting, EVM, contingency and risk modelling, contractor cost assurance, cash-flow management, performance reporting, and commercial assessment across Solar PV, BESS, substations, transmission, subsea interconnector and marine works.
Top Skills:
Cash Flow ForecastingCost Estimating And Forecasting ToolsEarned Value Management (Evm)Project Controls SystemsQuantitative Cost Risk Analysis And Contingency Modelling
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
