We are seeking a skilled and experienced Database Administrator (Oracle) to support enterprise Oracle database environments. The position will also require strong software development knowledge to effectively collaborate with development teams, troubleshoot application-related database issues, optimize application performance, and support enterprise business applications.
The incumbent will be responsible for ensuring the availability, reliability, performance, security, integrity, and continuity of Oracle databases while supporting business applications and organizational requirements.

Key Responsibilities

SQL & PL/SQL Development
Develop, maintain, and optimize complex SQL and PL/SQL queries, stored procedures, functions, packages, triggers, and database scripts.
Analyze and optimize SQL queries and execution plans to improve application and database performance.
Support development teams in database design, query optimization, and integration of applications with Oracle databases.
Automation & Scripting
Develop and maintain scripts and automation tools for database deployment, monitoring, maintenance, backup, recovery, reporting, and routine administrative activities.
Automate repetitive database administration and operational processes where appropriate.

Enterprise Network Design
• Design, implement, and maintain enterprise-grade network infrastructure.
• Plan network architecture for headquarters, regional offices, and disaster recovery sites.
• Develop scalable, resilient, and secure network solutions aligned with organizational objectives.
• Recommend improvements based on industry best practices.
Network Administration
• Manage enterprise LAN, WAN, WLAN, MPLS, Internet connectivity, and SD-WAN environments.
• Configure, monitor, and troubleshoot Layer-2 and Layer-3 networks.
• Administer enterprise routing and switching infrastructure.
• Ensure high availability and redundancy of critical network services.
Network Security
• Implement network security standards and best practices.
• Manage firewalls, VPNs, IDS/IPS, NAC, and network segmentation.
• Coordinate vulnerability assessments and remediation activities.
• Ensure compliance with organizational security policies.
Infrastructure Operations
• Monitor network utilization, latency, bandwidth, and performance.
• Maintain network documentation, diagrams, and asset inventories.
• Coordinate preventive maintenance and firmware upgrades.
• Manage enterprise network monitoring systems.
Vendor Management
• Evaluate networking products and technologies.
• Coordinate with telecom operators and service providers.
• Review technical proposals, BoQs, and procurement specifications.
• Supervise implementation by vendors and contractors.
Incident & Problem Management
• Diagnose and resolve complex network issues.
• Perform root cause analysis for major incidents.
• Participate in disaster recovery exercises.
• Ensure adherence to Service Level Agreements (SLAs).
Documentation & Compliance
• Prepare network architecture documents.
• Maintain standard operating procedures.
• Develop implementation and rollback plans.
• Produce technical reports and management dashboards.
 

We are seeking an experienced Senior BI Developer with strong expertise in Business Intelligence, enterprise reporting, and data analytics. The ideal candidate will have hands-on experience with Oracle Analytics Server (OAS), Tableau, Apache Superset, advanced SQL, and data modelling. This role involves designing enterprise analytics solutions, supporting BI platforms, and collaborating with business stakeholders to deliver actionable insights.
Key Responsibilities
• Design, develop, and maintain enterprise BI dashboards, reports, and analytical solutions using Oracle Analytics Server (OAS), Tableau, and Apache Superset.
• Design and implement scalable data models and semantic layers to support enterprise reporting and self-service analytics.
• Gather business requirements and translate them into robust BI solutions and analytical data models.
• Contribute to the design and implementation of enterprise Data Warehouse solution and real-time reporting solutions.
• Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
• Integrate and analyse data from multiple enterprise systems using technologies such as Kafka, Flink, ClickHouse, or similar platforms.
• Design and support real-time and near real-time dashboards for operational monitoring and decision support.
• Present analytical insights, executive dashboards, and strategic reports to senior management and executive stakeholders.
• Ensure BI solutions are scalable, secure, and optimized for performance.
• Administer Tableau Server and Oracle Analytics Server, including user management, security, scheduling, and platform monitoring.
• Support high-availability BI environments through platform upgrades, maintenance and performance tuning.
 

1. Job Purpose
To plan, execute, and manage the end-to-end procurement process for PRAL's acquisition of goods, works, and services ensuring compliance with the applicable policies and SOPs. The position will be responsible for procurement planning, market research, preparation of specifications and bidding documents, solicitation, bid evaluation support, award, and contract management support, ensuring transparency, fair competition, timely acquisition, and value for money. The role will also drive data-driven, digital and sustainable procurement practices that enhance efficiency and transparency.
2. Key Responsibilities
2.1 Planning and Requirement Definition
• Prepare the annual procurement plan with user departments, aligned with budgets, and publish it on EPADS or as per prevailing policy and SOPs.
• Assess requirements, conduct market research and cost estimates, and recommend the appropriate procurement method within the prescribed financial limits.
• Develop clear specifications and TORs with technical and user departments.
2.2 Solicitation and Bid Management
• Prepare bidding documents (RFPs/RFQs etc.) as per prevailing SOPs with evaluation criteria, terms, and securities, and obtain required approvals.
• Publish notices, bidding documents, and addenda on EPADS (or other systems mandated by prevailing policies/SOPs) within prescribed timelines.
• Manage bidder queries , pre-bid meetings, bid receipt, opening, and custody of bid securities.
2.3 Evaluation, Award and Grievances
• Support evaluation committees and facilitate preparation of evaluation reports and award recommendations.
• Publish technical and final evaluation results , handle grievances, process award and contract signing, and support the contract management process.
2.4 Compliance, Records and Reporting
• Ensure compliance with applicable rules, SOPs, internal policies, and integrity requirements..
• Maintain auditable procurement records , keep systems and records (e.g., EPADS) updated, and facilitate audits.
• Report on procurement status, timelines, savings, and compliance and advise management on risks and suggested improvements.
2.5 Vendor and Contract Support
• Maintain the vendor database and coordinate with relevant internal and external stakeholders.
• Maintain vendor performance records and evaluate vendor and contract performance.
• Support in contract administration, variations and closure, as required.
2.6 Innovation and Continuous Improvement
• Data-driven procurement: build and maintain an analytics dashboard from EPADS or other tools and internal data (cycle time, bids per tender, single-bid rate, savings against estimates, grievance outcomes) to inform planning, reporting and management decisions.
• Demand consolidation: consolidate recurring and common-use requirements into category plans and propose open or closed framework agreements to reduce repeat tendering and cycle time, without artificial division of requirements.
• Value for money: introduce should-cost models, whole-life-cost evaluation and performance-based specifications for IT systems and software, and recommend two-stage bidding for large, complex requirements.
• Compliance by design: develop standard checklists and a pre-audit compliance gate at each stage (plan, specification, notice, opening, evaluation, award) to detect potential material deviations before they occur.
• Integrity analytics: apply red-flag screening for collusion indicators, abnormally low bids and conflicts of interest, and refer cases through due process.
• Market and vendor engagement: conduct equal-opportunity market-sounding and vendor orientation sessions, maintain internal vendor performance scorecards, and promote SME inclusion and environment-friendly criteria in line with Federal Government policy.
• Digital tools: use approved digital tools, including AI-assisted drafting and document review with human verification and securities and contract expiry trackers, while safeguarding the confidentiality of bid information.
• Knowledge management: maintain a lessons-learned register and procurement playbooks, and orient user departments and committee members on procedures.
 

The Network Administrator will be responsible for supporting the day to day operation, maintenance, monitoring, and troubleshooting of the PRAL/FBR Enterprise Network infrastructure. The position requires a technically capable resource who can independently handle routine network administration and IT support activities, while also assisting in the management and configuration of routers, switches, firewalls, wireless infrastructure, and related network devices.

The candidate should have a minimum of 5 years of relevant hands on experience in an Enterprise or Corporate IT environment and should be capable of taking ownership of assigned network administration and technical support tasks.

Key Responsibilities
Configure, manage, and troubleshoot routers, Layer-2/Layer-3 switches, firewalls, wireless access points, and related network devices.
Perform network configuration activities including VLANs, IP addressing, routing, DHCP, DNS, NAT, ACLs, VPNs, and basic network security policies.
Support configuration and troubleshooting of static routing, OSPF and other enterprise routing protocols where applicable.
Assist in managing firewall policies, NAT rules, VPN connectivity, access control, and Internet gateway configurations.
Monitor network performance, availability, bandwidth utilization, and connectivity using available Network Monitoring and Management Systems.
Troubleshoot network outages, performance issues, connectivity problems, and device-related incidents.
Provide Level-1/Level-2 technical support to users for network and IT-related issues.
Coordinate with ISPs, and internal IT teams for resolution of network and infrastructure issues.
Perform network device installation, configuration, backup, firmware upgrades, and basic maintenance.
Maintain updated network diagrams, IP address records, device inventories, configuration backups, and technical documentation.
Assist in implementing network security controls and ensure compliance with organizational IT security policies.
Support network expansion, new office connectivity, server/network integration, and other infrastructure deployment activities.

We are hiring Database Developers to design efficient database structures and ensure data quality and integrity. They will collaborate with development teams to build scalable, high-performance database solutions aligned with business needs. The role includes maintaining best practices in database design and optimizing system performance. Candidates will contribute to strengthening and modernizing data infrastructure for reliable operations.

Job Description:
This role demands a strong focus on designing efficient database structures, enhancing system integration capabilities, and maintaining data quality assurance standards. The successful candidate collaborates closely with software development teams to align database solutions with organizational goals while optimizing performance and scalability. The successful candidate also plays a crucial role in overseeing development processes and ensuring adherence to best practices in database design and implementation. Expertise will directly contribute to the modernization and reliability of Pakistan Revenue Automation’s data infrastructure, supporting critical revenue management functions with robust and optimized database systems.

Responsibilities
Development & optimization of database objects, performance tuning, ER modeling, system integration, data quality assurance, and technical mentorship.
• Maintaining and developing new database objects (tables, packages, procedures, functions, views etc.) by following Database standards.
• Write complex queries, refactor existing procedures, tuning and schema refinement.
• Develop and maintain database ER Modeling and data dictionaries.
• Understanding of existing and new business processes.
• Identify any issues related to database performance and provide corrective measures.
• Evaluate existing database and recommend improvements for performance efficiency.
• Develop best practices for database design and development activities.
• Perform space management and capacity planning for database systems.
• Refine and automate regular processes, track issues, and document changes.
• Ensure data quality and integrity in databases.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Analyze business processes and procedures to recommend technical system/software solutions.
• Review proposed database structure changes by development teams and approve or modify based on company standards and best practices.
• Provide support for software releases.
• Research interfaces to identify and code required updates to support integration.
• Provide quick and quality work for critical production systems.
• Share domain and technical expertise, providing technical mentorship and cross-training to other team members.