Database Administrator (DBA) with six years plus experience in Oracle Database Administration, Installation, Upgradation, Configuration, Size and Space Management, Backup and Recovery, Database Replication, Performance Tuning, Data Masking, Troubleshooting.
Database Administrator – PRAL(Federal Board of Revenue)FBR Islamabad Nov 2019- Present
Involved in multiple database server of Export/Import to support developers for achieving the sales taxes recoveries.
Restored & Recover Oracle database from Full and incremental tape offsite Backups Successfully after Datacenter issue.
Installed and configure oracle WebLogic 12c and oracle database 19c on windows Server.
Experience in Upgrading databases (10g to 11g,11g R2 to 12cR1, 8i to 10gR2)
As a DBA perform configuration, maintain and Drill activity of 10g/11g Databases.
Successfully migrate oracle 11g database from VMware to Microsoft Hyper-V Server.
Deployed disaster recovery Data Guard 11g and RAC 11g/12c on Oracle enterprise Linux OEL Test environment
Installed Oracle Clusterware to provide test environment for RAC and configured 2 node Oracle 11g/12c RAC with ASM.
rearrange columns of tables
Planned and implemented high availability solutions on test environment Oracle 12c RAC, Standby Database using Oracle Data Guard
Upgrade/Migration of Databases from VMware to Hyper-V Oracle 10g to 11g
Oracle 11g, 12C client installation
Experience in using OEM, TOAD, and SQL Developer, SQL*Loader, RMAN
Applying Database Patches using OPatch utility.
Scheduling databases and other jobs via RMAN and DB Links.
Troubleshooting problems related to database.
Monitoring Alert log file and necessary trace files.
Troubleshoot Distributed Transaction mechanism two phase commit.
Troubleshoot connectivity issue client’s inbound connection of Listener and Sqlnet.
Database Administrator – Ora-Tech System, Islamabad, March 2017 – Present
Ora-Tech Systems is an IT Solution & Services provider having its offices in Islamabad, Lahore, Karachi and KSA. Ora-Tech Systems started its journey of excellence about 27 years ago and has successfully completed many national and international projects for governments, defense forces and private companies.
Oracle DBA at Pakistan Tobacco Company (British American Tobacco):
Involved in database multiple server to support developers in achieving functional requirements As a DBA perform installation, configuration of 11g / 12c Databases on Linux/Windows for databases on HP Proliant Blade Server.
Upgradation of about 32 Databases Server from Oracle 11g to Oracle 12c Installation & configuration of Oracle 11g/12c database server on Windows platform
Oracle Database Performance Tuning, Analyzing, Monitoring and Troubleshooting Created & Configured Oracle 11g,12c databases for different Leaf Areas of British American Tobacco and test through production. Creating and Maintaining Users and Roles with Appropriate Privileges and Profiles according to Company requirements
Planning, designing and implementing backup and recovery strategies for databases using RMAN Making the database efficient by performing database tuning strategies
Monitoring the database server to identify any Performance issues or bottlenecks.
Troubleshoot day-to-day database issues to ensure system availability.
Backups and recovery strategies and RMAN Scripts Developed Oracle Schedule backup (Hot,Cold,Incremental) and recovery scripts using RMAN utility
Position : Oracle DBA /DEV Peshawar WWW.Precisetech.Ca +92 915603094
Being a Database Administrator, I have the following responsibilities.
• As a DBA perform installation, configuration of Oracle Database 11g. on Linux/Windows for ASM and non-ASM databases. • Develop database backup and recovery.
• Replication Of Databases. • Taking RMAN incremental backups.
• Manage Database data migration from other Databases to Oracle, using Import/Export, Data Pump and SQL*Loader.
• Data integrity and database physical/logical structure.
• Develop Procedure, function, triggers for Databases. • Responsible for Oracle logical and Physical design, implementation and maintenance on LINUX, Windows.
• Oracle Database Performance Tuning, Analyzing, Monitoring and Troubleshooting.
• Monitoring the database server to identify any Performance issues or bottlenecks.
• Troubleshoot day-to-day database issues to ensure system stability and throughput.
• Backups and recovery strategies and RMAN Scripts.
• Developed or modified some Oracle backup and recovery scripts using RMAN utility.
• Database Designing and implementing strategies.
• Performed database tuning using sql developer, Client tools and Enterprise Manager.
• Expertise in Oracle Performance and Tuning.
• Good in health monitoring and checks of Database System.
• Skills in Linux and Unix according to Database related.
• DBA daily activities.