Oracle Dba
Current• I am an Oracle Certified Associate DBA in Oracle Database 11g having solid practical hands-on with Oracle Database Architecture basics.• DQL, DML, DDL, DCL, TCL Commands.• Uses of Single row & Group functions.• Uses of Constraint column level & table level.• Joining two or more tables and inserting data into table. • Installation & configuration of Oracle 10g and 11g database• Creating an Oracle Database using DBCA.• Creating an Oracle Database Manually.• Controlling the Database (Shutdown, Startup, Mount, No mount, DBconsole)• Storage Structures (Creating and Managing Table Spaces)• Administering Users (Creating Users, Assigning Privileges, Roles Etc)• Oracle Database Security (User Profile, Password Verification Function)• UNDO management (Configuring Undo Table Spaces)• Database Auditing (General Auditing and Fine Grained Auditing)• Backup and Recovery manager (Command line use of RMAN Backup)• Using Flashback to recover the deleted Tables• Manipulating Log files (Checkpoint, Log Switch, Creating new Log files etc)• Good practical hands-on about hot backup and cold backup including logical backup using export/import and Data pump concept.• I have good idea about system automation and schedule tasking for improving daily Oracle monitoring tasks.
