PL-SQL Developer
First seen by Alion on Sep 25, 2026.
Role : Oracle PL/SQL Developer
We are looking for an experienced Oracle PL/SQL Developer with Global Trade Management (GTM) domain knowledge to design, develop, maintain, and support database applications related to global trade and supply chain processes.
Key Responsibilities :
- Develop, enhance, and maintain Oracle PL/SQL programs, including procedures, functions, packages, triggers, and cursors.
- Design and optimize complex SQL queries for data processing and reporting.
- Work on Global Trade Management (GTM) applications and support trade-related business processes.
- Develop and maintain database objects supporting import, export, trade compliance, and customs processes.
- Analyze business requirements and translate them into technical solutions.
- Perform query optimization, performance tuning, and database troubleshooting.
- Develop data validation, transformation, and reconciliation procedures.
- Support integration between GTM applications and other enterprise systems.
- Troubleshoot production issues and perform root cause analysis.
- Collaborate with functional consultants, business analysts, and application teams.
- Prepare technical documentation and participate in code reviews and testing activities.
Essential Skills :
- Strong hands-on experience in Oracle PL/SQL programming.
- Good knowledge of SQL, stored procedures, functions, packages, triggers, and cursors.
- Experience with Global Trade Management (GTM) applications and processes.
- Understanding of global trade compliance, import/export operations, and customs-related workflows.
- Experience in database performance tuning and query optimization.
- Good knowledge of relational database concepts.
- Strong debugging and problem-solving skills.
Good-to-Have Skills :
- Experience with Oracle Global Trade Management (Oracle GTM).
- Knowledge of Oracle Transportation Management (OTM) integration.
- Experience with XML, JSON, REST APIs, and web services.
- Knowledge of supply chain, logistics, and trade compliance systems.
- Experience with data migration, ETL processes, and enterprise application integrations.
- Familiarity with Unix/Linux scripting.
- Exposure to Agile development methodologies and tools such as Jira.
Skills
Oracle GTM, SQL, Performance Tuning, PL-SQL, GTM System