Senior Oracle PL SQL Developer

About Company: - PairSoft, a leading provider of spend management and accounts payable automation
solutions, has announced the acquisition of APRO, a specialized software for purchase requisition and
procurement management. This strategic move is designed to enhance PairSoft's capabilities and broaden
its offerings to better serve its customer base.
PairSoft is expanding operations of APRO in India through their new hire:
❖ https://pairsoft.com/
❖ https://aprosoftwaresolutions.com/
Job Title: Senior Oracle PL/SQL Developer
Location: India (Remote)
Type: Full-time
Experience Level: Senior (6yrs and above)
About the Role:
We are looking for a highly skilled and experienced Senior Oracle PL/SQL Developer to join our growing
team.
This role is ideal for someone who thrives on building scalable and efficient database solutions, writing
high-quality SQL queries, and maintaining complex database logic in a collaborative, fast-paced
environment.
The ideal candidate will have a strong command of PL/SQL, Oracle database systems (12c or higher),
and a solid understanding of data modelling and query optimization.
You will play a critical role in designing and maintaining database procedures, triggers, and packages,
while working closely with application developers and stakeholders.
This position requires a proactive approach to troubleshooting, performance tuning, and delivering robust
data solutions that support our enterprise-level systems. Experience in the finance domain or handling
transactional systems is a plus.
Key Responsibilities:
• Design, develop, and maintain robust PL/SQL stored procedures, triggers, functions, and
packages.
• Optimize and refactor existing database logic to improve performance and scalability.
• Write complex and efficient SQL queries for data retrieval, transformation, and reporting.
• Work with Oracle databases (12c or higher) to ensure data integrity, security, and efficiency.
• Collaborate with cross-functional teams, including application developers, QA engineers, and
analysts.
• Monitor and resolve database performance issues, including query tuning and indexing strategies.
• Support application deployment and troubleshoot production issues related to data processing.
• Document technical designs, procedures, and maintenance plans for database components.
• Stay current with Oracle features and PL/SQL enhancements to leverage modern capabilities.
Requirements:
• 7+ years of hands-on experience in Oracle PL/SQL development.
• Deep understanding of Oracle EBS and Oracle financials cloud
• Strong proficiency in SQL, including complex joins, aggregations, and subqueries.
• Deep understanding of relational database design and Oracle RDBMS architecture.
• Experience with query performance tuning and database optimization techniques.
• Solid understanding of transaction management, data consistency, and indexing.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills with the ability to work across time zones and functions.
Nice to Have:
• Experience with Oracle partitioning, materialized views, and advanced analytics.
• Exposure to ETL pipelines, data warehousing, or finance-related data processing.
• Experience in Agile or SCRUM environments.
• Basic knowledge of shell scripting or job scheduling tools (e.g., Control-M, Cron).
• Experience in Oracle 23AI
What We Offer
• Opportunity to grow your career with a rapidly growing organisation.
• Exposure to working with a Microsoft gold partner organization with the latest technologies.
• People first organization culture
• Company Paid Group Mediclaim Insurance for employees, spouse and up to 2 Kids of INR
400,000 per annum.
• Company Paid Group Personal accidental insurance for employees of INR 1,000,000 per
annum.
• Company Paid & Manager approved Career Advancement Opportunities
• Best-in-the-Industry referral policy.
• 29 Paid leaves throughout the year