PL/SQL Developer

We are looking for a skilled Oracle Developer with strong expertise in PL/SQL development and database management. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining robust Oracle database solutions to support business applications and operations.

Key Responsibilities

Design, develop, test, and maintain robust PL/SQL code including stored procedures, functions, packages, triggers, and views.

Participate in database design and development activities ensuring efficient database structure and performance.

Optimize SQL queries and PL/SQL code for maximum efficiency and performance.

Identify, troubleshoot, and resolve database performance issues.

Develop and implement data migration, transformation, and ETL processes using Oracle tools and PL/SQL scripts.

Provide support for existing database applications and resolve issues within defined SLAs.

Collaborate with application developers, business analysts, and stakeholders to understand business requirements and translate them into technical solutions.

Maintain proper documentation for database designs, code, and technical processes.

Follow best practices in database development including code reviews, version control, and coding standards.

Required Skills & Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related field.

3–5 years of hands-on experience as an Oracle Developer.

Strong expertise in Oracle PL/SQL development.

Experience in writing complex stored procedures, functions, packages, and triggers.

Strong understanding of database schema design, tables, views, indexes, and constraints.

Experience with data migration, ETL processes, and data transformation.

Knowledge of Oracle backup and recovery techniques including RMAN.

Strong analytical and problem-solving skills.

Good communication and collaboration abilities.

Ability to work independently and manage multiple tasks effectively.

Preferred Skills

Experience working in performance tuning and query optimization.

Familiarity with version control and development best practices.

Exposure to Oracle tools and enterprise database environments.

Why Join Us?

Opportunity to work on enterprise-grade Oracle database solutions.

Collaborative and growth-oriented work environment.

Exposure to challenging projects and modern database practices.

Oracle Apex Developer:

• No. of Position: 3
• Budget: 12 - 16 LPA all inclusive depending on experience bracket
• Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
• Joining Time – Immediate to 45 Days
• US Client – Long term logistics domain project
• Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
• Onsite opportunity for tenured employees

Experience:

• 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
• Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA                                 

Core Competencies:

• Experience working on Oracle PL/SQL Programming and DB features
• Proficient in Oracle Apex components is a must
• Experience in Javascript, Jquery and CSS
• Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
• Exposure to DBA activities like Table space management, Export/Import etc.
• Experience in Unix Shell scripting
• Exposure to any reporting tool
• Good communication skills
• Ability to take responsibility and handle pressure 
• Ability to think creatively and solve complex problems 
• Self-motivated, fast learner with the ability to operate independently 
• Team player with strong interpersonal skills and a willingness to help others 
• Ability to thrive in a cross-functional team on business-critical projects 
• Intrinsically cares about the quality of work 
• Organized and focused on delivering tasks within defined deadlines

Specific Responsibilities:

• Would work in design, develop, enhance, test and maintain software applications
• Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
• Build and maintain Application database schema/objects and account for data migration/upgrades across versions
• Identify and automate routine maintenance tasks
• Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
• Certify all queries written by software developers to ensure optimal execution of the queries
• Research, investigate and evaluate potential database solutions to business problems/requirements
• Write Test cases for developed queries/functions using PLSQL and Quest code tester.

Job responsibility The Lead Developer contributes, to create a customer’s solution, in the building phase of the software development lifecycle. The Software Engineer is responsible for performing the detailed design of application and technical architecture components and classes in accordance to the specification provided by the Solution Architect, for coding of SW components, and for the early testing phases (component testing), and system testing support

Hands on experience in Java, Python, scripting
- Design, implement, deploy and support web-based applications and web services using server technologies stacks that include Java, MySQL
- Experience in Java/J2EE using web frameworks Play or Spring boot, REST API Development and ORM (JPA, Hibernate eBean etc.)
- In depth knowledge of Design patterns and Data structures
- Databases - MySQL, Oracle, SQL
- Solid understanding of concepts like Web Services, SOA, REST APIs, Message Queue, Caching, Distributed/Scalable Architecture
- Secure application development best practices, such as OWASP
- Document and maintain all design documents and involve in review process.
- Experienced problem solving and debugging skills.
- Good verbal and written communication and interpersonal skills
- Experience in Agile methodology is added advantage
- Knowledge of Cloud Knowledge /Azure
- Must know about Unix knowledge
- experience in Elastic search

.Overall 5+ years of experience in application development using Java with creating and deploying microservices using the Spring Boot framework







• Strong experience in Maven.







• Good experience in unit(Junit) and integration testing.







• Experience in Microservices is a must.







Experience in designing and developing REST based services / Microservice development.







• Candidate should have good communication skills (written and verbal)







Excellent analytical and problem solving skills







Any one of these database Mongo, Maria, RMQ, Postgres, or other NoSQL servers







• Experience in AWS and CI/CD







5+ Years







Design, develop, and maintain robust, scalable, and secure backend services and APIs.







• Collaborate with frontend developers to integrate user-facing elements with server-side logic.







Write clean, efficient, and maintainable code following best practices and coding standards.







• Optimize performance and ensure high availability of backend services.







• Implement security measures to protect sensitive data and prevent vulnerabilities.







Design and manage databases, ensuring data integrity and efficient query performance.







Debug, troubleshoot, and resolve issues in production and development environments.







• Conduct code reviews and provide constructive feedback to team members.







Stay up-to-date with emerging backend technologies, frameworks, and best practices.







• Participate in Agile/Scrum ceremonies and contribute to sprint planning and estimations.

.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.

Responsibilities:

 The tool development also involves working with SQL queries and web front end

Designing, developing, and testing web applications with .Net HTML, CSS and other technologies

Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )

Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments

Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost

Maintains currency in technical skills and all relevant fixed income industry sector factors

May lead the work of others and provide ideas which help to enhance TFI software applications

Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development

ORM frameworks, particularly the Entity Framework

• Basic knowledge of Oracle Forms and reports - (Must)
• Good experience on SQL*Loader.
• Should Knowledge on Agile / Scrum.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Using SQL developer tool we debugged the code and unit test
• Knowledge of oracle programming
• MySQL, Oracle,
• Knowledge of Unix platform
• PostgreSQL
• advance database knowledge.
• Writing PL/SQL and PL/MySQL
• Coding support
• Debugging & Project module management
• Deployment and fine-tuning as per team lead.

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation