Oracle DBA support

I have 1 year experience as oracle dba at the company and dba level all activity done during job

Oracle DBA support

Fresher and Junior DBA provide Support and Training. Creates and maintains all databases required for development, testing, education and production usage. Performs ongoing tuning of the database instances. Plans and implements backup and recovery of the Oracle database. Implements and enforces security for all of the Oracle Databases. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. Enforces and maintains… Show more Fresher and Junior DBA provide Support and Training. Creates and maintains all databases required for development, testing, education and production usage. Performs ongoing tuning of the database instances. Plans and implements backup and recovery of the Oracle database. Implements and enforces security for all of the Oracle Databases. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. Enforces and maintains database constraints to ensure the integrity of the database. Administers all database objects, including tables, Synonym, indexes, views, sequences, packages and procedures. Assists with impact analysis of any changes made to the database objects. Troubleshoots with problems regarding the databases and development tools. Create new database users when as required. Handled databases of various sizes running from 100GB to 1.5 TB. Was involved in Core DBA activities of both production and nonproduction databases. Oracle Server & Client Installation on Linux/Windows environments in Various version (10g/11g & 12c) Installed & Configured the Three Node RAC with Grid Infra. Applied OPatch and CPU Patches in Development, Testing & Production Environment Install EM agent and configure DB/Cluster instances in OEM. Done a migration From NON-ASM to ASM Perform logical backups (using Export/Import or expdp/impdp utilities). Cloning an Oracle Database in Test environment from Production database. Taken COLD & HOT Backup using RMAN & Manual method Wrote Unix shell scripts for database administration, backup and performance monitoring. Check Alert Log errors and make necessary actions to rectify them. Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and tablespace quotas. Show less