We are seeking a highly experienced Senior Oracle Database Administrator to own the stability, performance, security, and availability of a large-scale, mission-critical Oracle database estate. The environment spans Oracle Exadata, Oracle RAC clusters on both physical hardware and virtual machines, and is protected end-to-end by Oracle Audit Vault and Database Firewall (AVDF). This is a hands-on, production-heavy role for someone who thrives on ownership, complex troubleshooting, and operational excellence at enterprise scale.
Key Responsibilities
Exadata & RAC Administration
Administer, monitor, and optimize Oracle Exadata Database Machine environments
Build, configure, and support Oracle RAC clusters across physical servers and virtualized (KVM/VM) hosts.
Manage Oracle ASM, Grid Infrastructure (CRS), and cluster resources; perform break/fix and root-cause analysis on cluster failures.
Plan and execute capacity planning, high-availability design, and Exadata-specific optimizations (Smart Scan, Hybrid Columnar Compression, IORM, Storage Indexes).
High Availability, Backup & Disaster Recovery
Design, implement, and maintain Data Guard / Active Data Guard configurations for disaster recovery with defined RTO/RPO targets.
Own backup and recovery strategy using RMAN, Data Pump, and export/import; conduct regular recovery testing.
Lead DR failover/failback exercises and post-incident reviews.
Patch, Upgrade & Lifecycle Management
Plan and execute Oracle Database and Exadata quarterly patching, security updates, and major version upgrades (e.g., 19c ? 23ai) with minimal production disruption.
Manage Oracle Grid Infrastructure and firmware lifecycle across the Exadata estate.
Coordinate patching windows with Oracle Support and internal change management
Performance & Operations
Perform proactive performance tuning using AWR, ASH, SQL Tuning Advisor, and Exadata-specific diagnostics.
Conduct regular database health checks and capacity/growth monitoring across production, DR, and non-production environments.
Maintain and expand monitoring via Oracle Enterprise Manage.
Provide L2/L3 production support, including participation in a 24/7 on-call rotation for critical incidents.
Security, Audit & Compliance
Administer and maintain Oracle Audit Vault and Database Firewall (AVDF) — audit policy configuration, firewall rule/profile management, alert triage, and compliance reporting.
Implement and enforce database access controls, encryption (TDE), and the principle of least privilege across all environments.
Ensure database environments align with internal data governance policy and external regulatory requirements (e.g., PCI-DSS, SOX, GDPR-equivalent local regulation).
Support internal/external audit requests with evidence from AVDF audit trails and database access logs.
Automation & Documentation
Develop and maintain automation for routine DBA tasks using Shell/Python/Ansible, reducing manual toil.
Maintain comprehensive, current documentation for architecture, runbooks, and standard operating procedures.
Mentor junior DBAs and contribute to knowledge-sharing across the team.
Collaboration
Work closely with infrastructure, network, security, and application teams to ensure seamless database integration and performance.
Liaise directly with Oracle Support/Oracle Professional Services on complex issues, patch validation, and Exadata lifecycle events.
4 Years Bachelor's or Master degree in Computer Science, Software Engineering, Information Technology, or a related discipline.
6+ years of hands-on Oracle DBA experience, including at least 3 years on Oracle Exadata in production.
Oracle Certified Professional (OCP) — Database Administration.
Preferred/Nice to have
Experience with Oracle GoldenGate for replication.
Background in a regulated industry (banking, government, tax/revenue authority, telecom).
Experience supporting large-scale data governance or data security compliance programs.
Deep, current expertise in Oracle RAC, ASM, Data Guard, RMAN, and Grid Infrastructure.
Proven experience administering Oracle Exadata (X-series or ExaCC) — patching, health checks, migrations, performance optimization.
Hands-on experience with Oracle Audit Vault and Database Firewall (AVDF) — deployment, policy configuration, and reporting.
Strong SQL and database performance tuning skills (AWR/ASH/SQL Tuning Advisor).
Solid Linux/Unix systems administration skills.
Scripting proficiency (Shell, Python, or Ansible) for automation.
Experience managing databases across both physical and virtualized (VM) infrastructure.
Familiarity with Oracle versions 19c and above.
Experience working within ITIL-based Change and Release Management processes.
Excellent troubleshooting skills under pressure in a high-availability, time-critical environment.
Strong written and verbal communication skills; ability to produce clear documentation and liaise with auditors/regulators.
We are looking for a dynamic Senior Network Engineer with a minimum of 4 years of hands-on experience to design, implement, and maintain our robust IT infrastructure. You will work extensively with multi-vendor environments, managing core routing, switching, data center networks, and enterprise-grade security appliances.
Key Responsibilities
-Manage, configure, and troubleshoot enterprise routing (including OSPF and BGP) and switching.
-Administer and maintain Huawei Firewalls and Switches, Fortinet Firewalls and Fortinet FortiClient EMS for endpoint security.
-Oversee data center network operations, hosting technologies, and Software-Defined Networking (SDN) environments.
-Drive Network Operations Center (NOC) monitoring, incident resolution, and performance tuning.
-Implement open-source tools and Linux-based networking utilities for automation, monitoring, and infrastructure management.
-Deploy and manage network security policies, VPNs, and threat mitigation strategies across Fortinet and Huawei ecosystems.
-Automation of operational tasks.
-Minimum 4 years of relevant professional experience.
-Bachelor’s degree in Computer Science (BS CS), Information Technology (BS IT), Artificial Intelligence (BS AI), Software Engineering (BS SE), or an equivalent relevant field.
-Proven hands-on expertise with Huawei, Fortinet, and Cisco platforms.
-Strong working knowledge of Linux and Windows environments (preferred).
-Relevant industry certifications (e.g. Huawei HCIP, Fortinet NSE 4/7. CCNP) will be preferred.
-Excellent teamwork, communication, and interpersonal skills are mandatory.
-High adaptability and a strong hunger to learn emerging networking and security technologies.
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.
• Minimum 4 Years bachelor’s or master’s degree in information technology, Computer Science, or a related field.
• 5 years of relevant experience
• Enterprise LAN and Campus Networks
• WAN Technologies
• MPLS Networks
• SD-WAN Solutions
• TCP/IP Protocol Suite
• IPv4 and IPv6
• Routing Protocols (BGP, OSPF, EIGRP)
• VLANs and Inter-VLAN Routing
• Layer-2 and Layer-3 Switching
• VPN Technologies (IPSec, SSL VPN)
• Wireless LAN Technologies
• QoS (Quality of Service)
• DNS, DHCP, NTP
• Load Balancing
• Network High Availability
• Enterprise Firewalls
• Network Access Control (NAC)
• Network Monitoring Tools
• Structured Cabling Standards
We are hiring Database Developers – Junior / Mid-Level / Senior 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.
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.
• Minimum 4 Years bachelor’s or master’s degree in information technology, Computer Science, or a related field.
• 2+ years of relevant experience
• Oracle Database (10g, 11g, 12C, 19C, 21C, 23ai) Development experience required.
• Experience with software Agile methodology and software development common practices (code reviews, unit testing etc.).
• Experience with logical and physical data modeling and strong knowledge of ORDBMS/RDBMS.
• Experience in designing and maintenance of Database Modeling (ER-Win Data Modeler, Toad Data Modeler etc.).
• Firm understanding of the overall architecture required to support common schema-based objects used to store data and implement business logic.
• Ability to provide guidance, oversight, and peer review to more junior database developers and direction to other technical resources as required.
• Aptitude for debugging problems in complex, unfamiliar code.
• Solid work ethic, self-driven, can function independently with minimal oversight and direction.
• Experience with PL/SQL analytical functions.
• Strong SQL experience and proficient in writing and optimizing SQL statements.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Sound knowledge of performance optimization, indexing & partitioning.
• Being able to plan technical solutions.
• Excellent written and verbal communication.
• Ability to organize and plan work independently.
• Ability to work in a rapidly changing environment.
• Ability to multi-task and context-switch effectively between different activities and teams.
• Knowledge and experience in other relational databases will be a plus point. Taxation domain will be a plus point.
We offer market-based compensation and benefits. Our benefits include generous health insurance coverage for self, spouse, children and parents (inpatient and outpatient), unrivaled group life insurance, above average annual salary raises, lucrative annual bonuses, gratuity, loans and leave encashment etc.
We foster an open and friendly environment that encourages diversity and equal employment opportunity. We put extra efforts and energy to create a workplace that focus on employees well-being physical and mental health, high level of engagement through HR best practices.
Our Software Development Life Cycle (SDLC) offers unique learning opportunity to every team member to learn and become a specialist of either any specific technology or multiple tools and technologies. That creates unparalleled opportunities for career advancement. We aim to invest significantly on our employees learning and development.
Over the years, we have achieved and maintained an outstanding work life balance, yet we do not miss our timelines. In fact, this is helping us to do our work more efficiently maintaining productivity and quality. We are also flexible to opt for remote/ hybrid working whenever there is a requirement or need.
©2022 PRAL, All rights reserved.