Senior Software Engineer – SQL/PL-SQL

Overview

Senior Software Engineer – SQL/PL-SQL & Oracle APEX Developer (Data Analysis)

Profile:

We are seeking a highly skilled Senior Software Engineer with 10+ years of hands-on experience in data analysis, Oracle SQL/PL-SQL development, and enterprise application delivery. The ideal candidate brings robust expertise in designing and optimizing ETL pipelines, developing scalable PL/SQL solutions, and building secure, user-friendly applications using Oracle APEX. You will work closely with cross-functional teams to deliver business-critical data solutions, streamline processes, and help drive the organization's digital transformation.

Key Responsibilities:

• Design, develop, and optimize complex SQL/PL-SQL code, including packages, procedures, triggers, functions, and performance-tuned queries for large-scale systems.
• Architect, build, and deploy secure, user-centric applications using Oracle APEX, incorporating advanced UI features and RESTful integrations.
• Lead efforts on data extraction, transformation, and loading (ETL), ensuring data integrity, quality, and alignment with business requirements.
• Analyze business and functional requirements, translate them into comprehensive ER models and effective database solutions.
• Implement automation for recurring manual tasks using shell scripting, PL/SQL, and Python-based ETL tools.
• Collaborate with stakeholders, DB architects, and cross-functional teams to deliver high-quality, scalable, and secure applications.
• Generate analytical reports and dashboards for end users using SQL, Oracle APEX, and Oracle Analytics tools.
• Oversee release support, data migration, and reconciliation efforts; ensure robust test coverage and timely defect resolution.
• Mentor junior team members, advocate best practices, and contribute to team knowledge-sharing.
  
  
  

• Oracle SQL, PL/SQL, Oracle APEX (application development & RESTful integrations)
• Performance tuning, query optimization, and data modeling
• Shell scripting (Korn/Bash), C, Pro*C, Autosys, GitLab (CI/CD)
  
  
  

• Python (Numpy/Pandas), ETL tools, Informatica Power Centre
• Google Cloud Query (BQL), Cypher Query
• Data warehousing and analytics (Oracle Analytics Cloud, Materialized Views)
  
  
  

• Bachelor’s degree in Computer Science or related discipline.
• Professional certifications such as ISTQB Agile, Oracle, or Azure AZ900 are preferred.
  
  
  

• Strong leadership, stakeholder engagement, and project management
• Excellent communication, problem-solving, and mentoring abilities
  
  
  

• Design, develop, and maintain complex SQL/PL-SQL code, including procedures, functions, and packages for enterprise-scale applications.
• Build secure, user-friendly enterprise applications using Oracle APEX, incorporating advanced UI features and RESTful integrations.
• Analyze business requirements and translate them into effective database solutions and data models.
• Develop and optimize ETL data pipelines to ensure accuracy and integrity of business data.
• Automate manual data processing tasks using PL/SQL, shell scripting, and Python-based ETL tools.
• Create and maintain reports, dashboards, and data reconciliation solutions in Oracle APEX and Oracle Analytics Cloud.
• Collaborate with cross-functional teams (business analysts, DB architects, QA) to ensure timely and high-quality software delivery.
• Support data migration, system integration, and release management activities.
• Mentor junior team members and promote best practices in software and database development.
• Troubleshoot, debug, and resolve database and application issues to ensure optimal performance and reliability.
  
  
  

Career Level - IC2

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.