Abdullah Janjua

Results-driven Oracle Database Administrator with more than 3 years of hands-on experience in administering, monitoring, and maintaining Oracle database environments. Skilled in database installation, configuration, backup and recovery, disaster recovery, high availability, performance tuning, user management, and troubleshooting to ensure high availability and optimal system performance. Experienced in supporting Oracle E-Business Suite environments and working with Oracle Database tools such as RMAN, Data Pump, and SQL*Plus.

Strong analytical, problem-solving, and communication skills, with a proven ability to collaborate effectively with cross-functional teams and deliver reliable database solutions in fast-paced enterprise environments.

Database Administrator - NLC Headquarter GHQ

(2025-05)

Currently working as a Database Administrator at NLC Headquarters (GHQ), where I manage, administer, and support Oracle and Microsoft SQL Server databases across a diverse enterprise environment. With 3 years of hands-on experience, I have worked extensively with Oracle Database 11g, 12c, and 19c, as well as Microsoft SQL Server, ensuring database security, high availability, and optimal performance. My responsibilities include database installation, configuration, upgrades, patch management, backup and recovery using RMAN, performance monitoring and tuning, user and security administration, troubleshooting database issues, and supporting day-to-day production operations.

I also collaborate with application and infrastructure teams to ensure reliable database services and business continuity.

• Installed, configured, and administered Oracle Databases (11g, 12c, 19c) and Microsoft SQL Server environments
• Database provisioning and administration on Oracle Cloud Infrastructure (OCI).
• Database migration from on premises to OCI DBCS.
• Possess 3+ years of hands-on experience in Oracle Database Administration
• Performed Oracle database backup and recovery using RMAN and Data Pump
• Managed Oracle Data Guard environments with strong hands-on experience for disaster recovery and high availability
• Executed Oracle database migrations and cloning using RMAN and logical backups
• Installed, configured, and administered Oracle RAC, Data Guard, and SQL Server environments
• Demonstrated basic understanding of Oracle RAC administration
• Created and managed database users, roles, and privileges
• Handled database space management, storage planning, and capacity monitoring
• Defined and implemented database auditing policies and security standards
• Created and maintained database standards, procedures, and operational policies
• Supported database design, creation, and testing activities
• Provided day-to-day DBA operational support to end users
• Monitored database health and managed availability and performance, including incident and problem management
• Performed basic performance tuning to optimize database performance
• Administered database objects to ensure optimal resource utilization
• Executed Oracle patching and database upgrades
• Successfully completed Oracle APEX upgrade from version 20 to 24 and Oracle Database upgrade from 12c to 19c, retaining all existing data
• Upgraded Oracle Forms & Reports and Oracle WebLogic from 11i to 12.4, along with Oracle Database upgrade from 11g to 19c

Database Administrator - Orasol - Islamabad

(2023-02 - 2025-04)

Worked as an Oracle Database Administrator at Orasol, providing administration and support for mission-critical Oracle Database environments (11g, 12c, and 19c) with a focus on high availability, security, and performance. Hands-on experience in configuring and administering Oracle RAC, Data Guard, and Oracle GoldenGate for disaster recovery and data replication. Successfully performed Oracle Database upgrades from 11.2.0.3 to 11.2.0.4 in Oracle E-Business Suite (EBS) 12.2.4 environments, managed ADOP online patching cycles, and implemented SSL for Oracle E-Business Suite to enhance application security.

Responsible for day-to-day database administration, including user and security management, space management, performance monitoring, backup and recovery support, and proactive troubleshooting. Applied quarterly Release Updates (RUs), Patch Set Updates (PSUs), and interim patches to maintain system stability and security. Implemented robust security policies involving user accounts, password profiles, roles, and privileges to ensure compliance with organizational standards.

Experienced in Oracle Database features such as Partitioning, LogMiner, Schema Management, and advanced secur

• Oracle 11gR2 RAC to RAC Dataguard Setup and Administration
• SSL setup for Oracle E-Business Suit 12.2.4
• ADOP patching cycle
• Database upgrade from 11.2.0.3 to 11.2.0.4 with EBS 12.2.4
• Mission critical 24/7 Oracle database 11g/12c/19c support
• Fulfilled DBA daily activities including user management, space management, monitoring etc
• Golden Gate setup and administration
• Implemented high security policies for user accounts, passwords, profiles, roles and privileges across the Oracle database environments.
• Quarterly patching on oracle products and interim patching for various bug fixes on database products.
• Good exposure to coding standards & naming conventions in oracle.
• Experienced in using 11g features like Partitioning, LogMiner, Schema Management, Case sensitive passwords and Security.

BS - Computer Science - IUIC (2019 - 2024)

ICS - Computer Science (2016 - 2018)