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====================