Oracle Expert Database Administrator
CurrentInstalling and configuring of Oracle 11g database server.Installing, configuring and administering of Oracle RAC software & Dataguard.Creating the logical storage structures like tables, views, users and tablespaces.Managing physical storage structures like data files and control files.Locally managed tablespaces.Creation of new users, monitoring and maintenance.Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.Installation of Oracle client tools and establishing connectivity to databases.Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases. Performance tuning for the Oracle Application concurrent Manager.Performance tuning/Reorganization for Oracle instance.Covered various aspects of Export and Import (ExpDp & ImpDp) of the database.Installation and support of RMAN.Creating triggers in the database.Maintained the Oracle instances for testing purposes as well as for helping the Product development group. Wrote and performed the written test procedures.Creating objects, Models, privileges, users and monitoring on a daily basis.Defragmentation of tables and indexes for improved performance and effective space managementSQL scripting for DBA tasks.Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers. Developing PL/SQL programs for data manipulation.Monitoring rollback segments. Adopting proactive maintenance strategies to curb extensive shrinking and wrapping of rollback segments.
