SENIOR DATABASE ADMINISTRATOR
Raqmiyat INFORMATION TECHNOLOGY
Total des années d'expérience :18 years, 9 Mois
Al ELM information security, Riyadh KSA (client of RAQMIYAT IT)
Senior Database Administrator: (August 2013 - Present)
ELM is an IT service/solution provider to Govt Sector & Ministries e.g. MOE & MOI. ELM is running Multiple ORACLE and SQL SERVER databases with TeraBytes of sizes.
• Managing Oracle EXADATA Cluster SERVERs and 4 cluster databases for Ministry of Interior and ministry of Housings.
• Managing Oracle Clusters for ORACLE BRM (Business and revenue management) applications.
• Managing Oracle ASM file system for Production database storage with multiple disk groups.
• Working to enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
• Installation and configuration of Real application cluster 11g R2 on Linux platform.
• Creating ASM Disk groups and assigning tablespace/schema to relevant diskgroups and migrating Data from Test to Production instance.
• Migrate Oracle database 10g & 11g from Non-ASM to ASM file systems.
---------------------------------------
Abu Dhabi Aircraft Technologies, UAE (client of RAQMIYAT IT)
Senior Database Administrator: (October 2012 - August 2013)
ADAT is a region’s leading aircraft service/solution provider with 1200 employees and running ORACLE EBS R12 (finance, HRMS, GTM, EAM and CMRO modules) with 3 Tera Byates size of databases.
• Managing Multi-Terabyte Oracle databases & administration assignments for diverse industry clients with Two Nodes RAC on Solaris Sparc and Six Nodes Apps (Finance and HRMS modules) on primary Site and with same configuration at DR-Site.
• Maintaining ORACLE BI Publisher & ORACLE Discoverer for Multiple Applications of aircraft industry (Etihad Airline and AMROC).
• Ensuring technical and functional designs to meet business requirements.
• Installation and configuration of real application cluster 11g with EBS R12 on Solaris 10.
• Configure physical standby with RAC Primary to RAC standby in data guard environment.
• Convert single instance to two node RAC cluster by using RCONFIG utility and manual method.
• Upgrade oracle application R12 from 12.1.1 TO 12.1.3.
• Deployed and configured 2 nodes ORACLE 11G R2 RAC On primary Site and 2 nodes RAC on Disaster Recovery Site with active dataguard with 2 terra byte size of databases.
• Upgraded oracle 10g production servers to oracle 11g R2 with zero down time using ORACLE Golden gate product.
• Upgraded oracle 11i (Financial and HRMS ERPS) production servers to oracle R12 ERP and Database Tiers upgraded to 11g R2.
• Managing 24x7 Database servers using oracle 11g R2 RAC, Dataguards and Enterprise grid controls to meet high availability and data protection of nonstop business operations over EMC SAN and centera.
• Managing Sql Server 2008 Two node Cluster database.
• Installing, Configuring, patching, upgrading and migrating live DB servers with minimal Down time.
• Managing online backups of servers, testing, validating and storing on tape to keep historical Data safe.
• Managing different remote servers and ongoing projects of different clients e.g. METRO CASH AND CARRY PAKISTAN, SOCIAL SECURITY HOSPITAL, SHIFA INTERNATIONAL, REHMAN MEDICAL INSTITUTE, NATIONAL INSTITUTE OF HEALTH DEPARTMENT AND MAROOF HOSPITAL.
Day to day support, capacity planning and performance tuning for Oracle Databases.
• Backup and Recovery Administration
• Install, Configure and Administer Oracle Clusterware / Grid Infra Structure
• Migrate Database for R12 from single instance to RAC using RCONFIG.
• Clone R12 from RAC to non-RAC.
• Implement load balancing for the Applications database connections.
• Configure Parallel Concurrent Processing (PCP).
• Use the AD utilities to perform Oracle Applications maintenance tasks.
• Apply patches to an Oracle application and database tiers.
• Plane and Configure RMAN backups.
• Manage the Oracle E-Business Suite using Oracle Applications Manager.
• Cloned Multi node system to single node system (Rapid Clone).
• Administering through Oracle Management Server (OEM).
• Application System Administration and AOL
• Patching
Senior Database Administrator
• To lead the software programmers, web developers and software engineers team.
• To work on “COMPUTRIZATION OF DATA OF OUTGOIING EMIGRANTS AND RETURNING OF MIGRANTS” ERP Project.
• To manage production and developmental databases located at 7 Regional Offices (Quetta, Karachi, Multan, Lahore, Islamabad, Peshawar etc) with emphases on the database performance And 24x7 High availability.
• To lead and Support system development team with advice on database design, data modeling and developmental standards.
To Manage Very Large Oracle Server databases upto 7 Terabytes size of Databases.
• To Manage 40 servers running on Red Hat Linux Advance Server 2.1, 3, 4, 5 and on Windows NT 32 bit and 64 bit platforms having 125 databases located at USA, Lahore, Islamabad and Karachi linked with each other containing different complex modules.
• To Work on Multiple oracle versions e.g. oracle 8i, oracle 9i, oracle 10g.
• Implementing, administering, upgrading, patching, migrating defining/testing and verifying Backup and Recovery operations for SECURTIES AND EXCHANGE COMMISION OF PAKISTAN(SECP) Database in Lahore and Islamabad.
• Performing upgradation, patching, backup & Recovery Operations for LIZ Claiborne and KELLWOOD U.S leading Organization’s Database servers.
Working as a Visiting faculty Teacher in Punjab University, Teaching DBMS and ORACLE 9i Database Administration subject to MIT, BIT and OCP classes, organizing labs and giving hands on training to MIT and BIT classes and preparing students for ocp9i certification.
Involved in activities:
• Oracle software installation.
• Network local naming and host naming services and establishing remote network connections, working & managing multiple databases over remote servers
Master in information technology ( Msc I.T) Major subjects: Databases & Dataware housing, Advance Networks and Communication, Advance Java Programming, Financial Accounts and managements. Informations System and Audit controls etc