Senior Oracle Pl/SQL Developer

Excise, Taxation & Narcotics Control Department, Government of the Punjab

Lahore

On-site

PKR 3,000,000 - 6,000,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

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.

Qualifications

  • Experience with Oracle PL/SQL development and database design.
  • Strong SQL query tuning and performance optimization skills.
  • Ability to implement data validation, constraints, and audit trails.

Responsibilities

  • Design and develop complex PL/SQL packages, procedures, functions, and triggers for tax and vehicle registration modules.
  • Optimize SQL/PLSQL code to improve revenue reporting and transactions.
  • Build and maintain database objects, indexes, and materialized views ensuring data integrity.
  • Coordinate with taxation officers to translate business rules into secure database solutions.
  • Perform backup, recovery, and monitoring to ensure high availability of revenue systems.

Skills

PL/SQL
SQL
Performance tuning
Data integrity

Tools

Oracle SQL Developer
Toad
SQL Plus

Job description

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:

  • Design and develop complex PL/SQL packages, procedures, functions, and triggers to support tax collection, challan generation, and vehicle registration modules.
  • Optimize SQL queries and PL/SQL code to improve the performance of revenue reporting and demand-collection-recovery transactions.
  • Build and maintain database objects, indexes, sequences, and materialized views that ensure data integrity across taxpayer and licensing records.
  • Implement data validation, constraints, and audit trails to safeguard financial data and support internal and external audits.
  • Collaborate with taxation officers and application teams to translate departmental business rules into accurate and secure database solutions.
  • Perform database backup, recovery, and performance monitoring tasks to ensure high availability of critical revenue systems.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle PL/SQL Engineer for Secure Revenue Systems
Senior Oracle PL/SQL Engineer for Secure Revenue Systems

Excise, Taxation & Narcotics Control Department, Government of the Punjab • Lahore

On-site
PKR 3,000,000 - 6,000,000
Oracle Developer
Oracle Developer

Excise Taxation & Narcotics Control Department, Government of the Punjab • Lahore

On-site
PKR 1,200,000 - 2,000,000
Senior Oracle Pl/SQL Developer
Senior Oracle Pl/SQL Developer

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,800,000 - 2,800,000
Oracle Database Architect for Tax & Compliance
Oracle Database Architect for Tax & Compliance

Excise Taxation & Narcotics Control Department, Government of the Punjab • Lahore

On-site
PKR 1,200,000 - 2,000,000
Software Developer
Software Developer

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,200,000 - 2,000,000
Software Developer
Software Developer

Excise Taxation & Narcotics Control Department, Government of the Punjab • Lahore

On-site
PKR 1,000,000 - 2,000,000
Senior Oracle PL/SQL Architect — Tax & Narcotics
Senior Oracle PL/SQL Architect — Tax & Narcotics

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,800,000 - 2,800,000
Database Manager
Database Manager

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,200,000 - 2,400,000
Public Sector Software Engineer: Revenue & Compliance
Public Sector Software Engineer: Revenue & Compliance

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,200,000 - 2,000,000
System Engineer
System Engineer

Excise Taxation & Narcotics Control Department, Government of the Punjab • Lahore

On-site
PKR 1,200,000 - 2,000,000
Top locations