Senior Software Engineer – SQL/PL-SQL

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

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.