Keywords
Skills
- Overall 8+ years of IT experience as a DBA on a variety of Unix (Linux, AIX), Windows platform having in-depth expertise with all facets of ORACLE 9i/10g/11g/12c Database design, administration, Production support, Installation, Configuration, Patches, Migration, Performance Tuning, Backup and Recovery, Cloning, Space Management, Database security, File System Management and Monitoring.
- Professional Certification – OCA DBA 10g.
- Working experience in Oracle Backup & Recovery methodologies using complex RMAN Backup/Recovery, Import/Export, Oracle Data Pump and data loading using SQL *LOADER.
- Implementation of High Availability solutions with Oracle Data Guard, Oracle Real Application Clusters (RAC) and Oracle ASM (versions 10g/11g/12c).
- Administration of Weblogic Server 7/11g/12c and Oracle IAS 10g in different OS environments.
- Installation and management of Oracle Enterprise Manager DB/Grid Control/Cloud Control 13c.
- Experience in Database performance tuning and SQL Tuning.
- Strong Application Development experience using ORACLE DEVELOPER 6i/10g and extensive experience of creating complex functions, stored procedures, database triggers, packages in PL/SQL using SQL *Plus, Toad etc.
- Experience in administering MS SQL Server 2005-2016; creating databases, backup/restore, managing user and security, import and export data.
- Oracle Application DBA support, applying patches, multi-tier installations, cloning, and Apps DB daily backup and recovery tasks.
- Administration skills of Red Hat Linux/Oracle Enterprise Linux, IBM-AIX, Windows, Solaris shell scripting.
- Excellent English and communication skills.
Project history
April 2015 – To date Askari Bank Limited, Pakistan
AMG (Database Administrator)
Job Description:
Deputy Manager I.T (Database Administrator)
Job Description:
Database Administrator
Job Description:
Application Developer cum DBA
Job Description:
Inventory Management System Finance Management System
Hospital Management System Shipping Management System
Jun 2007- May 2008 Millennium Software Pvt. Ltd.
Software Developer
Job Description:
Internee + Student (Part Time)
Job Description:
AMG (Database Administrator)
Job Description:
- Overall maintenance and administration of Clustered Oracle 11g/12c (RAC) Flexcube and its Reporting databases on Red Hat Enterprise Linux 6/7 platform for OLTP applications in production environment with Oracle ASM. As well as administration of important databases like Askari Credit card, IRIS, HOTSCAN and other dozens of other databases.
- Implementation and administration of Oracle 11g/12c Active Data Guard.
- Designing and administering backup and recovery procedures using RMAN as well as Oracle Data pump.
- Installation, configuration and monitoring of Oracle Grid Control 11g/Cloud Control 12c and monitoring of all databases and applications.
- Management, backup configuration and administration of Oracle Enterprise Manager Cloud Control 12c.
- Administration of all Weblogic application including Flexcube applications.
- Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers.
- Monitoring and administration of SQL Server 2008-2016 databases including Backup/Restoration, Log Shipping, Mirroring, and other daily tasks.
Deputy Manager I.T (Database Administrator)
Job Description:
- Overall maintenance and administration of Oracle 10g/11g databases on Red Hat Enterprise Linux 4/5 platform for OLTP applications in production environment with Data Guard and Oracle ASM.
- Implementation and administration of Oracle 11g Active Data Guard (primary in plant-standby in HO and vise versa).
- Upgraded and migrated all Oracle 10g databases to 11g.
- Designing and administering backup and recovery procedures using RMAN as well as Oracle Data pump.
- Tuning of database and SQL code and assisting developers in writing and tuning SQL queries.
- Installing, configuring, creating and managing Virtual machines using VMWare ESXi Server 4.
- Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers.
- Oracle Application DBA support, applying patches, multi-tier installations, automatic routines DBA task, oracle support dealing with functional , developers and end users.
- Successfully upgraded Oracle e-Business suite Database/Application from release 10.2.0.2/12.0.6 to 11.2.0.3/12.1.3 with Oracons Consulting team on Linux RedHat 4.5.
- Administration and monitoring of Oracle iAS 10g on RHL.
- Also served in Windstream USA as a Remote DBA.
Database Administrator
Job Description:
- Administration of Oracle 10g databases on Linux, IBM AIX platforms for Data Warehousing, OLTP applications in production, Standby/Data Guard, Staging and development environments.
- Creating and administration of Oracle Data Guard.
- Implemented Oracle Vault and Syslog auditing as per company Security compliance.
- Monitoring all databases and also performs ongoing tuning of the database instances and SQL Tuning/ DB Tuning.
- Creating and Managing complex database objects like table and index partitioning and optimizing them for performance benefits and tuning SQL code/queries.
- Plan and implement backup and recovery procedures using RMAN.
- Implement and maintain database security (create and maintain users and roles, assign privileges) and also plan growth and changes (capacity planning).
- Provide technical support to application development team and creation and maintenance of database links across different databases.
- Synchronize the test/Dev databases periodically by cloning the data from the production databases using conventional methods as well as RMAN.
- Monitoring and Administration of Weblogic Server 7 and Oracle Weblogic 11g.
- Working with Oracle Technical Support to resolve any Oracle related problems and contact Oracle support MetaLink if required.
Application Developer cum DBA
Job Description:
- Designing, development, implementation of new and existing applications using Oracle Developer 6i/10g.
- Creating complex stored procedures, PL/SQL libraries and triggers on database level as well as on Oracle Forms and Reports 6i/10g.
- Handling DBA level activities like User rights, import/export backup and performance tuning of Oracle Databases on client side.
- Administration and maintenance of production databases in all Group Companies.
- Upgrade/migration of all the databases at Marine Group of Companies from Oracle 8i/9i to Oracle 10g.
- Deputed in Trade Development Authority of Pakistan (TDAP) as a Database Administrator.
- Responsible for development, customization and overall Oracle Administration like Oracle installation, database creation & configuration, application maintenance, user creation and rights, performance tuning, RMAN backup & Recovery of Expo Management System.
- Deputed in Mitsui & Co. Ltd. in Lahore and Islamabad as a Database Administrator.
- Responsible for the overall development and database administration of Finance Management System, Inventory and HR/Payroll system.
Inventory Management System Finance Management System
Hospital Management System Shipping Management System
Jun 2007- May 2008 Millennium Software Pvt. Ltd.
Software Developer
Job Description:
- Development, customization, support and implementation of HRMS & Payroll Software.
- Developed a large number of reports using Oracle Reports 6i/10g.
- Involved in migration of HRMS and Payroll system from Oracle 8i/6i to Oracle 10g.
- Resolving client issues and user training and providing technical support.
- Maintenance and configuration of Oracle databases, User privileges, Import/Export and Data Loading on client side.
Internee + Student (Part Time)
Job Description:
- Developed new forms and reports for Inventory Management System using Oracle 9i as a back-end and Oracle Developer 6i as a front-end.
- Learned administering Oracle databases on Linux/Windows, Import/Export, backup/recovery and other development and administration tasks of Oracle database related.
- Learned Database administration skills.
Local Availability
Only available in these countries:
Pakistan
Remote jobs
