Senior Software Engineer - SQL/PL-SQL
Oracle
Job Title: 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.
Technical Skills Required:
Primary:
- 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)
Secondary:
- Python (Numpy/Pandas), ETL tools, Informatica Power Centre
- Google Cloud Query (BQL), Cypher Query
- Data warehousing and analytics (Oracle Analytics Cloud, Materialized Views)
Education & Certifications:
- Bachelor’s degree in Computer Science or related discipline.
- Professional certifications such as ISTQB Agile, Oracle, or Azure AZ900 are preferred.
Interpersonal Skills:
- Strong leadership, stakeholder engagement, and project management
- Excellent communication, problem-solving, and mentoring abilities
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.
Senior Software Engineer – SQL/PL-SQL & Oracle APEX We are seeking a Senior Software Engineer with over 10 years of experience in SQL/PL-SQL development and data analysis. The ideal candidate excels at designing and optimizing database solutions, building dynamic enterprise applications with Oracle APEX, and automating complex data workflows. You will be responsible for developing advanced PL/SQL code, creating secure and scalable APEX applications, and driving data-driven decision-making through robust reporting and analytics. Strong problem-solving, stakeholder engagement, and leadership skills are essential. Key Skills: Oracle SQL, PL/SQL, Oracle APEX, Data Analysis, ETL, Performance Tuning, Shell Scripting, Python (Numpy/Pandas), GitLab (CI/CD).
Career Level - IC2
Responsibilities:
- 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.