A complete application in a minute
Tailored resume and cover letter, ready to send.
The Senior Oracle PL/SQL Developer at the Excise Taxation & Narcotics Control Department Lahore designs, develops, and maintains Oracle database applications that underpin the department's revenue collection and regulatory functions.
Day-to-day, the developer writes and optimizes PL/SQL packages, procedures, functions, and triggers for challan generation, demand and collection entries, and vehicle registration workflows.
The Senior Oracle PL/SQL Developer at the Excise Taxation & Narcotics Control Department Lahore designs, develops, and maintains the Oracle database applications that underpin the department's revenue collection and regulatory functions. The role supports systems for motor vehicle registration, token tax, property and professional tax, demand-collection-recovery records, and narcotics licensing. By building reliable, secure, and auditable database solutions, the developer ensures accurate taxpayer data, timely revenue reporting, and dependable service delivery across the department's field and head-office operations.
Day-to-day, the developer writes and optimizes PL/SQL packages, procedures, functions, and triggers for challan generation, demand and collection entries, and vehicle registration workflows. Using Oracle SQL Developer, Toad, and SQL Plus, the role tunes slow queries, manages indexes, builds materialized views for MIS dashboards, and supports nightly batch jobs and backups. The developer coordinates with taxation officers to translate business rules into code, maintains data integrity through constraints and validations, and follows service standards for uptime and data security. Career progression leads toward Senior Database Administrator roles.
Selection is made through a competitive process administered under the department's recruitment rules. Candidates first appear in a 100-question multiple-choice written screening examination covering Oracle database concepts, PL/SQL programming, SQL, and general aptitude. Those who qualify are shortlisted on merit in proportion to the advertised vacancies. Shortlisted candidates then undergo document verification of their degrees, experience certificates, and domicile, followed by an interview before the Departmental Selection Committee, which assesses technical depth, problem-solving ability, and suitability for the post before final merit-based selection.
Key duties and responsibilities: