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. Career Level - IC2