profile-img

MAJED SEDKY

Senior Database Administrator at ROYAL PAINTS COMPANY (RPC) D

Giza, Egypt

Work Experience

  • Senior Database AdministratorFull Time

    ROYAL PAINTS COMPANY (RPC) D

    Jan 2020 - Present -5 yrs, 6 months

    • data administratorFull Time

      GLOBAL GROUP

      Jun 2009 - Jun 2017 -8 yrs

      • Job Details:User management, RMAN, Export and Import utility.  Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM, SQL Navigator and TOAD.  Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), 4 Standby Database, Database Upgrade from 9i to 11g, troubleshooting and basic knowledge of networking and security.  Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK  Creation of databases, instances, table spaces, data files, rollback segments.  Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers and procedures.  Design and implementation of Backup & Recovery using RMAN and SQL scripts.  Proficiency in using Log miner, SQL *Loader and Export/Import utilities.  Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.  Setting up Standby Database / Oracle Data Guard to protect againstfailures. Configured the Standby Database in such a way that the Database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.  Experience in Migration of Oracle 9i and 10g databases to 11gr2.
    • Database AdministratorFull Time

      ALTAYYAR GROUP

      Feb 2007 - Feb 2009 -2 yrs

      • Database AdministratorFull Time

        : ARAB GROUP FOR HUMAN DEVELOPMENT (AGHD)

        Jan 2006 - Jan 2007 -1 yr

        • Job Details:Manage oracle, MySQL PostgreSQL and SQL Server databases  Configure and maintain database servers and processes  Monitor system's health and performance  Ensure high levels of performance, availability, sustainability and security  Analyze, solve, and correct issues in real time  Provide suggestions for solutions  Refine and automate regular processes, track issues, and document changes  Assist developers with query tuning and schema refinement  Provide 24x7 support for critical production systems  Perform scheduled maintenance and support release deployment activities after hours
      • Education

        • Master's Degree in :Information Technology

          University Of Liverpool

          Jan 2020 

        Skills

        • Power BI
        • oracle, MySQL, PostgreSQL and SQL SERVER
        • Oracle
        • SQL
        • Database
        • Database Administrator
        • Information Technology (IT)

        Languages

        • Arabic

          Fluent
        • English

          Fluent
        Share this Profile