Senior Oracle PL SQL Developer
Senior Oracle PL SQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
solutions has announced the acquisition of APRO a specialized software for purchase requisition and
procurement management. This strategic move is designed to enhance PairSofts capabilities and broaden
its offerings to better serve its customer base.
PairSoft is expanding operations of APRO in India through their new hire:
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
400000 per annum.
Company Paid Group Personal accidental insurance for employees of INRper
annum.
Company Paid & Manager approved Career Advancement Opportunities
Best-in-the-Industry referral policy.
29 Paid leaves throughout the year
About the Company
We are a global team of innovators and advocates transforming how financial data is captured stored and manipulated with our comprehensive suite of automation technology. Our platform seamlessly integrates with your existing ERP for an unrivaled end-user experience. We do the heavy lifting so accounting procurement and fundraising teams can do their best work.
PairSofts aspires to be the strongest procure-to-pay platform for the mid-market and enterprise with close integration to Microsoft Dynamics Blackbaud Oracle SAP Acumatica and Sage ERPs.
At PairSoft we are passionate about innovation transparency diversity and advocating on behalf of our customers and communities we support. We offer exciting career opportunities and a collaborative culture that allows individuals to learn grow and create meaningful impact. We are expanding and seeking team players who are eager to jump in and contribute to our rapid growth!
PairSoft is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race color ancestry religion sex national origin sexual orientation age citizenship marital status disability gender identity veteran status or any other protected status. We also consider qualified applicants regardless of criminal histories consistent with legal requirements. If you have a disability or special need that requires accommodation please email us at:
To read our Candidate Data Privacy Notice - including GDPR - click here.
Required Experience:
Senior IC
Employment Type
Full-Time
