A complete application in a minute
Tailored resume and cover letter, ready to send.
The Excise Taxation & Narcotics Control Department, Government of the Punjab seeks an Oracle Developer to design, develop, and maintain mission-critical database applications. The role automates excise duty computation, narcotics permit tracking, and revenue reconciliation across provincial districts.
You will write optimized PL/SQL packages, build APEX dashboards for inspectors, and manage Oracle DBs (19c/21c) on Linux with partitioning and audit trails to support regulatory compliance and
The Oracle Developer in the Excise Taxation & Narcotics Control Department designs, develops, and maintains mission-critical database applications that automate excise duty assessment, narcotics permit tracking, and revenue reconciliation across provincial districts. This gazetted technical role ensures data integrity, regulatory compliance, and real-time reporting for policy-level decision-making within the department's digital transformation agenda.
Daily workflows involve writing optimized PL/SQL packages for tax calculation engines, building APEX interfaces for field inspectors to verify narcotics licenses, and managing Oracle E-Business Suite integrations with the Provincial Treasury. The developer administers 19c/21c databases on Linux, implements partitioning strategies for terabyte-scale taxpayer ledgers, and enforces audit trails per Punjab Financial Rules. Career progression leads to Senior Database Architect and Director IT (Lump Sum Contract/19) positions.
Selection follows a 100-mark MCQ written screening test covering Oracle Database 19c/21c, PL/SQL, APEX, SQL tuning, and general computer science. Candidates scoring above the departmental cutoff are shortlisted 1:3 for document verification of degrees (BS Computer Science/Software Engineering), PEC registration, and experience certificates. Final merit combines written score (70%) and Departmental Selection Committee interview (30%) assessing technical depth, problem-solving, and knowledge of government financial procedures.
Key duties and responsibilities: