Senior Oracle Pl/SQL Developer

Excise Taxation Narcotics Control Department

Lahore

On-site

PKR 1,800,000 - 2,800,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

Excise Taxation Narcotics Control Department seeks a Senior Oracle PL/SQL Developer on a Lump Sum Contract to modernize its digital infrastructure. You will design and maintain robust database solutions for excise duty assessment, narcotics control data management, and automated reporting.

You will design complex PL/SQL objects, optimize SQL for high-volume processing, and ensure secure access controls while integrating legacy systems with modern interfaces.

Qualifications

  • Senior Oracle PL/SQL developer with experience in high-volume transactional systems.
  • Experience designing and implementing stored procedures, functions and packages.
  • Strong understanding of database security and access controls.

Responsibilities

  • Design and develop scalable Oracle database schemas to support tax and narcotics modules.
  • Write and optimize PL/SQL procedures, functions, and packages for automated reporting.
  • Perform performance tuning of SQL queries for high-volume transactions.
  • Implement robust exception handling and logging for audit trails.
  • Collaborate with analysts to translate requirements into database models.
  • Manage database security including role-based access controls and encryption.

Skills

PL/SQL
Oracle
SQL
Performance tuning
Security
Data modeling

Tools

Oracle Database

Job description

The Excise Taxation Narcotics Control Department recruits a Senior Oracle PL/SQL Developer at Lump Sum Contract to modernize its digital infrastructure. This role is pivotal in developing and maintaining robust software solutions for excise duty assessment, narcotics control data management, and automated reporting. The developer will ensure the integrity and security of sensitive state data while enhancing operational efficiency through advanced database engineering and application development.

Daily workflows involve designing complex stored procedures, optimizing SQL queries for high-volume transaction processing, and integrating legacy systems with modern web interfaces. The developer will manage user access controls, generate statutory reports for the Finance Department, and troubleshoot production issues. Career progression leads to senior technical leadership roles, overseeing IT projects related to tax compliance and narcotics surveillance systems within the provincial administration.

Selection begins with a 100-MCQ written screening examination testing core computer science, PL/SQL logic, and general knowledge. Candidates scoring above the cutoff proceed to document verification and merit shortlisting. The final stage involves a Departmental Selection Committee interview, assessing technical proficiency, problem-solving aptitude, and understanding of government IT security protocols. Successful candidates are offered appointment at Lump Sum Contract subject to final verification.

Key duties and responsibilities:

  • Design and develop scalable Oracle database schemas to support excise tax collection and narcotics tracking modules.
  • Write and optimize complex PL/SQL stored procedures, functions, and packages for automated duty calculation and reporting.
  • Perform performance tuning of SQL queries and database objects to ensure rapid response times for high-volume user transactions.
  • Implement robust exception handling and logging mechanisms to maintain data integrity and audit trails for compliance purposes.
  • Collaborate with business analysts to translate excise and narcotics control requirements into technical specifications and database models.
  • Manage database security, including role-based access controls and encryption of sensitive narcotics-related data in accordance with government standards.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Senior Oracle Pl/SQL Developer
Senior Oracle Pl/SQL Developer

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 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 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
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
Database Manager
Database Manager

Excise Taxation Narcotics Control Department • Lahore

On-site
PKR 1,200,000 - 2,400,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
Top locations