Oracle Developer

Excise Taxation & Narcotics Control Department, Government of the Punjab

Lahore

On-site

PKR 1,200,000 - 2,000,000

Full time

4 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 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

Qualifications

  • BS CS/Software Eng with PEC registration and degree verification.
  • Document verification of degrees and experience certificates.
  • Hands-on experience with Oracle database technologies and PL/SQL.

Responsibilities

  • Design and implement normalized database schemas for excise, narcotics, and taxpayer data.
  • Develop high-performance PL/SQL packages, triggers, and procedures for tax computation.
  • Build Oracle APEX interfaces for field inspectors and online tax filing.
  • Manage E-Business Suite integrations with Provincial Treasury.
  • Perform SQL tuning, indexing, partitioning, and AWR analysis.
  • Maintain Data Guard, RMAN backups, and apply security patches for uptime.

Skills

PL/SQL
Oracle
APEX
SQL tuning
Linux
Partitioning
RMAN
Data Guard
Oracle database 19c/21c

Education

BS Computer Science/Software Engineering

Tools

Oracle 19c/21c
Oracle E-Business Suite

Job description

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:

  • Design and implement normalized database schemas for excise duty modules, narcotics permit registries, and taxpayer master data
  • Develop high-performance PL/SQL stored procedures, triggers, and packages for automated tax computation and penalty logic
  • Build and maintain Oracle APEX applications for online tax filing, narcotics license renewal, and district-level dashboards
  • Execute database performance tuning: SQL plan management, index optimization, partitioning, and Automatic Workload Repository analysis
  • Administer Oracle Data Guard, RMAN backup strategies, and security patches to ensure 99.9% uptime for revenue systems
  • Collaborate with functional teams to translate Punjab Excise Act rules into technical specifications and audit-compliant data models
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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, Government of the Punjab • Lahore

On-site
PKR 1,000,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
Software Developer - e-Excise & Compliance Platforms
Software Developer - e-Excise & Compliance Platforms

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

On-site
PKR 1,000,000 - 2,000,000
Network Manager
Network Manager

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

On-site
PKR 1,800,000 - 2,400,000
Senior IT Systems Engineer - High Availability & Networks
Senior IT Systems Engineer - High Availability & Networks

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

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

Apex Rankers • Lahore

On-site
PKR 781,000 - 1,228,000
Associate Software Engineer
Associate Software Engineer

Finance Department • Gilgit Division

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

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

On-site
PKR 3,000,000 - 4,500,000
Database Administrator (BS-16)
Database Administrator (BS-16)

Social Welfare & • Lahore

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