Oracle Database Administrator

• Handling day-to-day activities • Installation, Configuration of Oracle 11g Databases on LINUX. • Managing Table spaces, Rollback and undo segments, tables, indexes, views etc. • Creating users, roles, profiles, assigning roles and profiles to Users. • Table spaces and tables creation, space allocation. • Creating users, roles and profiles, granting and revoking privileges and access for database object proactively using events. • Create Database links to Users • Create and maintain the physical and logical Backups. • Point-in-time recovery using RMAN. • Database Cloning using RMAN. • Creating and Managing Pfile and SPfile. • Managing online redo log files(Creating log members and groups) • Creating control files using trace files. • Multiplexing control file in Database • Logical backup using export, import & data pump (expdp, impdp). • Taking the backup transportable tablespace. • Conversion of Database in Archive Log / No Archive Log Modes • Monitoring the alert log for the database performance and resolving the performance issues. • Basic Knowledge on ORACLE RAC (Installation, Adminstration) Show less

Database Administrator

• May 2013 - May 2016