Introduction of Mir - Oracle DBA - Oracle Certified Professional(OCP) - 9i,10g & 11g

-
                                                              

Mir Sayeed Hassan                                     
  
A self-motivated and result oriented Professional with around 7+ years of experience in Oracle DBA at IT Industry & Oracle Certified Professional(OCP) 9i,10g & 11g, which includes Oracle Database Administration, Oracle Golden Gate(OGG) & Corporate Trainer for Oracle DBA, Banking & Information Technology to align Bank’s IT strategy with business objectives.



 A fair exposure in Oracle Consulting Practices that includes Oracle Database installation, configuration, upgrade, Data Guard, ASM, RAC etc for all the major supporting Operating Systems, A good attitude towards hard work and ability to meet schedules, grasp new Concepts and technologies.

Professional Summary:

Ø  Clear understanding of DBMS
Ø  Good knowledge on Oracle Database and Oracle Golden Gate(OGG)
Ø  Planning, Design, Implementing, Managing and Monitoring the Oracle Databases in 9i/10g/11g Database versions 
Ø  Installation and configuration of Oracle servers (9i, 10g & 11g) on Linux and windows
Ø  Installing Oracle database and client software of various versions
Ø  Exposure as a core Oracle DBA in Production, Development & Pre-prod Environments
Ø  Maintain documentation of Oracle database configurations and schemas
Ø  Sound knowledge on OEM Grid 10g/11g Database configuration, User defined metrics
Ø  Proficient in configuration and Implementation of Physical and Logical standby databases
Ø  Troubleshooting database issues, Space Management/Undo Management
Ø  Enrolling users and maintaining system security
Ø  Listener configuration, RMAN backup configuration and administration
Ø  Having knowledge on User management, profile management, privilege management and Rman Backup and Recovery
Ø  Improved the quality of customer support and service request processing with promptness, Professionalism, communication, and solution to application and database issues
Ø  Performing regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles, and Roles etc
Ø  Flashback at database level, table level, transaction query level
Ø  Experience as an Oracle DBA, Oracle Golden Gate (OGG) Admin
Ø  Expertise in administering and supporting Golden Gate
Ø  Performed Experience in data pump (expdp/impdp) Utilities
Ø  Manage and monitor ASM Instance
Ø  Having Basics knowledge on RAC
Ø  Experience in taking Online, Offline and RMAN Backups
Ø  Analysing test results and reporting bugs using the AUTOMATIC TEST SYSTEM (ATS) tool
Ø  Troubleshooting the issues on Oracle database and Oracle GoldenGate for resolutions
Ø  Able to work under pressure in a multi-task environment, manage continuous change, all with a focus on providing excellent service. Team player, punctual, responsible, hard working, quick learner with good communication, interpersonal and time management skills, highly organized with attention to details.

Educational qualification:

                Bachelor of Engineering Degree, Information Science, 2010 · VTU - Karnataka, India 

Responsibility of Job @ OGG - Oracle Corporation & FANAP

Ø  Working on installation  and Administration of Oracle Database, and Oracle Golden Gate(OGG)
Ø  Performed Cross DB Replication using OGG
Ø  Creation and Maintenance of Tablespace
Ø  Worked on Oracle10g installation and administration
Ø  Maintenance of Tablespaces , Datafiles, Redolog files
Ø  Creating primary objects like tables, views, indexes etc
Ø  Creating users and Providing quotas, roles, privileges and profiles to users
Ø  Performing health checks, Oracle Application and Database for Maintenance
Ø  Installed R12 (12.0.4) on PROD server and TEST instance
Ø  Creating Database links based on customer requests
Ø  Worked with customers based upon the impact of the issues
Ø  Cloned production database for test purposes
Ø  Monitoring the scheduled backups, and refining the backups in case of failures
Ø  Creation of additional tablespaces and adding data files to tablespaces whenever required.
Ø  Application and Database Cloning as per requirement.
Ø  Taking Back-up of the Application and Database (Physical & Logical)
Ø  Having experience in creation and maintenance of the users along with roles and privileges
Ø  Allocating system storage and planning future storage requirements for the database System
Ø  Creation and Administration of High Availability Services
Ø  Modifying the database structure as necessary
Ø  Creation and Administration of Physical Standby Databases
Ø  Installation and preparing db for replication
Ø  Data pump Export and Import
Ø  Taking regular and scheduled Cold & Hot backups
Ø  Managing Backup & Recovery in RAC database using RMAN Scripts
Ø  Cloning from production database to test database by using Rman cloning methods
Ø  Allocating system storage and planning future storage requirements for the database System
Ø  Working on installation  and Administration of Oracle Golden Gate(OGG)
Ø  Handled Oracle Goldengate 12.1.0.0 release  in Linux and Sun Solaris platforms
Ø  Responsible for Oracle Goldengate 12.1.0.0 Tier-2  release  in AIX and HPUX_IT platforms
Ø  Responsible for OGG Regression Testing in multiple OS platform like Solaris(x86 and Sparc), Linux, Windows and AIX
Ø  Performing execution of Oracle Universal Installer (OUI) in multiple OS platform
Ø  Analysing test results using the AUTOMATIC TEST SYSTEM (ATS) tool
Ø  Responsible to ensure Upgrade compatibility of OGG from lower versions
Ø  Collectively publishing analysis report of test results and product bugs in CertMatrix and PPT
Ø  Worked with developer to fix the issue
Ø  Modifying the database structure as necessary and Troubleshooting database, Operating System and ATS  issues

Technical Skills:
  Database : Oracle  9i, 10g, 11g
Languages  : SQL,C
High Availability : Oracle Enterprise Manager, Export/ Import,
                    VM Ware and 3rd Party software
                    Like Putty, Tellurian.
Operating System : Unix (RHEL, AIX, SunOS(x86,Sparc), HPUX) and Windows
Backup And Recovery : RMAN, Manual Backup and Recovery, OS   Tools
                                            Like HP Data protector, Data domain.
Applications : Oracle Applications 11.5.10.2, 12.1.1, 12.1.2

Oracle Certification Report:

ORACLE 9i OCP:
Oracle Testing id : OC0901669, Registration : 238350510, Centre id : 56571
Introduction to Oracle9i : SQL
1Z0-007
84%
Oracle 9i Database : Fundamental 1
1Z0-031
95%
Oracle 9i Database : Fundamental 11
1Z0-032
93%
Oracle 9i Database : Performance Tuning
1Z0-033
93%



ORACLE 10g & 11g  :  OCP:

10g : Oracle Testing ID: OCO901669, Registration : 249154089, Centre id : 63609
11g : Oracle Testing ID: OCO901669, Registration : 286595869, Centre id : 74654
Oracle Database 10g : New Features for  Administrators

Oracle Database 11g : New Features for  Administrators
1Z0-040

1Z0-050
93%

100%


Oracle DBA – Corporate Training Experience:



Oracle DBA Corporate Training provided for IT Companies in India are McAfee, System Domain, ODB Training & Software Services LLP & IDS System Pvt Ltd etc.



McAfee Software (India) Pvt. Ltd:      

http://www.mcafee.com/in/index.html


Embassy Golf Links Business Park Pine Valley” – 2nd Floor, off Indiranagar    
Koramangala Ring Road Bangalore – 560071 Karnataka – India
                                                                                         
IDS SYSTEM Pvt Ltd

http://idsin.net/temp/


#14/2, Wellington Street, Richmond Town, Bangalore – 560025 - Karnataka -  India
ODB Training & Software Services LLP

http://www.odbtraining.com/


#5/A, 2nd Floor, KHB Colony, Koramangala, Bangalore – Karnataka - India
System Domain Pvt. Ltd

http://www.systemdomain.net/


#54/54, 2nd Floor P.R Complex, 17th Cross Next to Canara Bank
M C Road Vijayanagar Bangalore Karnataka – India


Personal Information:

Title                                          Mr
First Name                             Mir
Middle Name                        Sayeed                                            
Last Name                              Hassan
Mobile                                     +91-9986993860/+98-9039794438
Email-id                                  sayeeddbaocp@gmail.com
Post Address                         #4, Tawakkal Terrace, Leonard Lane, Richmond Town
City                                           Bangalore
State                                         Karnataka
Country                                   India
Date of Birth                          14th March 1985
Nationality                             Indian
Sex                                            Male
Linguistics                            English, Persian Basic , Urdu, Kannada, Hindi, Tamil

=====================================================

My Oracle certification of 9i,10g & 11g from Oracle Corporation 

=================================================================

Oracle Certified Professional 9ig - OCA & OCP

(OCA - Oracle Certified Associate, OCP - Oracle Certified Professional)

 

 

   Oracle Certified Professional 10g - OCP  -- (Oracle Certified Professional)

  

  Oracle Certified Professional 11g - OCP -- (Oracle Certified Professional)

If there is any clarification in any of my blog or personal information.

 Please revert me back 24/7 Via E-mail : sayeed202@gmail.com or Skype ID: mirsayeed2 or Gtalk: sayeed202

===================Hence My Profile End====================

Comments

  1. UnknownApril 25, 2017 at 5:48 AM

    hi,
    Very well written and explained that why Oracle DBA Corporate Training is compulsory.

    ReplyDelete
  2. Mir - Senior Oracle DBA May 2, 2017 at 4:13 AM

    Dear Naveen Yadav,

    Thanks for your valuable comment.

    Oracle DBA Corporate training is very much essential to enhance up-to date technology in Oracle Domain from the Certified Professional & Hence it improve the performance productivity of work !

    If there is any clarification, Please revert me back E-mail: sayeed202@gmail.com

    Thanks,
    Mir

    ReplyDelete
  3. abril josephAugust 30, 2017 at 3:01 AM

    This is seriously good, you have really highlighted some of the great points one should know. Awesome work
    Wonderful suggestions and guidance. We are Besant Technologies and we focus on recruiting and training for Pearson Vue exams. We provide online coaching for test preparation for Adobe, Oracle , Linux, Pegasystems, CompTIA, Nokia Siemens, EMC, Cloudera, NetApp, Zend Technologies etc. We guide each candidate individually through the entire process. We have tie-ups with most of the Company. Please visit us online and feel free to contact us. Pearson Vue Exam Center in Bangalore |
    Pearson Vue Exam Centers in Bangalore |

    ReplyDelete
  4. UnknownDecember 13, 2017 at 12:37 AM

    nice post
    SQL Server DBA Online Course

    ReplyDelete
  5. UnknownDecember 26, 2017 at 1:13 AM

    nice blog thank you for sharing
    SQL Server DBA Online Training bangalore

    ReplyDelete
  6. KavithaJanuary 3, 2018 at 12:03 AM

    thank you for sharing
    SQL Server DBA Online Training hyderabad

    ReplyDelete
  7. sunshineprofeNovember 27, 2018 at 9:13 PM

    Do you have any recommendations for newbie blog writers? I’d appreciate it.
    nebosh igc courses in chennai

    ReplyDelete
  8. Realtime ExpertsFebruary 11, 2021 at 9:26 PM

    This Post is really supportive to all of us. Eager that these kind of information you post in future also. Thanks for Sharing Otherwise if anyone want To Learn SAS Training
    Oracle DBA Training in Bangalore

    ReplyDelete
  9. Keerthi55May 20, 2021 at 11:02 PM

    Im thankful for the article post.Thanks Again. Fantastic.
    SSAP PP online training
    data science training
    teradata training
    oracle bpm training
    angular js training
    sql server dba training
    oracle golden gate training

    ReplyDelete
  10. TechystickDecember 25, 2021 at 7:23 AM

    cloudkeeda
    what is azure
    azure free account
    azure data factory
    azure data factory interview question
    azure certification path
    azure traffic manager
    azure bastion

    ReplyDelete
  11. taranstechMarch 7, 2022 at 12:06 AM

    Whenever I get into complex client circumstances that influence blends of Oracle DBA administrations., Oracle DBA Certification has permitted me to quickly add esteem.

    ReplyDelete
  12. AnonymousMay 30, 2022 at 10:03 AM

    Smm panel
    smm panel
    iş ilanları
    İnstagram Takipçi Satın Al
    hirdavatciburada.com
    BEYAZESYATEKNİKSERVİSİ.COM.TR
    servis
    TİKTOK JETON HİLESİ İNDİR

    ReplyDelete
  13. AnonymousJune 2, 2022 at 7:19 AM

    ataşehir samsung klima servisi
    tuzla daikin klima servisi
    ümraniye beko klima servisi
    beykoz lg klima servisi
    pendik arçelik klima servisi
    kadıköy mitsubishi klima servisi
    kartal vestel klima servisi
    pendik lg klima servisi
    ataşehir daikin klima servisi

    ReplyDelete
  14. vbetDecember 22, 2022 at 7:28 AM

    Good content. You write beautiful things.
    vbet
    hacklink
    korsan taksi
    mrbahis
    sportsbet
    sportsbet
    taksi
    hacklink
    mrbahis

    ReplyDelete
  15. bonus veren sitelerJanuary 8, 2023 at 5:02 PM

    Good article text write content successfull... thanks.
    tipobet
    kralbet
    slot siteleri
    mobil ödeme bahis
    betmatik
    betpark
    poker siteleri
    kibris bahis siteleri

    ReplyDelete
  16. The Skill PediaApril 18, 2023 at 1:23 AM

    Very helpful content.Thanks for the sharing useful information.
    Oracle dba Training

    ReplyDelete
  17. kemalJuly 15, 2023 at 8:26 AM

    niğde
    kırklareli
    osmaniye
    siirt
    urfa
    DJZ5

    ReplyDelete
  18. fatihJuly 30, 2023 at 10:08 PM

    çorum
    antep
    ısparta
    hatay
    mersin

    N8VLBD

    ReplyDelete
  19. PakizeAugust 12, 2023 at 4:44 PM

    salt likit
    salt likit
    dr mood likit
    big boss likit
    dl likit
    dark likit
    ADY3

    ReplyDelete
  20. denizSeptember 18, 2023 at 4:14 PM

    https://izmitone.com
    kuşadası
    sex hattı
    50T

    ReplyDelete
  21. AnonymousSeptember 24, 2024 at 1:20 AM

    YTTHJUYTHGJY
    شركة تسليك مجاري بالاحساء

    ReplyDelete
  22. AnonymousNovember 11, 2024 at 2:55 AM

    شركة تركيب طارد الحمام بخميس مشيط Rjp2tmEtOS

    ReplyDelete

Post a Comment

Popular posts from this blog

ORA-01110: data file 1: '/oradata/datafiles/system01.dbf'

-
ORA-01110: data file 1: '/oradata/datafiles/system01.dbf' Error occur while restoring the database from the backup of RMAN RMAN> alter database open resetlogs; using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 09/03/2017 16:05:14 ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oradata/datafiles/system01.dbf' To resolve this error fallow the below procedure – Hopefully you will succeed If you’re primary database is flashback & it has the standby – Fallow below procedure RMAN> run { 2> recover database; 3> } ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter datab
Read more

Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4)

-
Expdp from Higher version 12c (12.1.0.2) to lower version 11g (11.2.0.4) Export on 12c (12.1.0.2)   – Tested in our env : 10.20.0.82 ==================== SQL> select instance_name,version from v$instance; INSTANCE_NAME    VERSION ---------------- ----------------- ora12c           12.1.0.2.0 SQL> conn sys/sys as sysdba Connected. SQL> conn hassan/( password ); Connected. SQL> select table_name from user_tables; TABLE_NAME -------------------------------------------------------------------------------- TEST SQL> select * from test; COLUMN1              NAME -------------------- -------------------- 1                    abc 2                    xyz [oracle@ora12c u02]$ mkdir dump [oracle@ora12c u02]$ chmod -R 777 dump/ [oracle@ora12c u02]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 25 16:22:46 2017 Copyright (c) 1982, 2014, Oracle.  All
Read more

Solutions: error while starting of Oracle Single instance ASM Database

-
1 st – Starting ASM [root@asmdb ~]#su - grid [grid@asmdb ~]$ asmcmd Connected to an idle instance ASMCMD> ls ASMCMD-08102: no connection to ASM; command requires ASM to run ASMCMD> [grid@asmdb ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:44:30 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Automatic Storage Management option SQL> conn / as sysasm Connected to an idle instance SQL> startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SQL> exit Disconnected 2nd : Starting DB [oracle@asmdb ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 23 17:15:15 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Gl
Read more