Oracle database administrator Resume Example

• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c Brought multiple disk online simultaneously and control the speed of the resync operation through Oracle ASM disk resync new feature on 12c.
• Configuration and administration of Oracle Dataguard environment Stabilized Oracle Grid Control environment Developed and tested storage strategies and disaster-recovery plan for large financial company's operational database, delivering solution that guaranteed recovery performance and high availability.
• Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• As a Sr oracle DBA with ROBA INT'l SARL I used the following oracle tools indicated below to perform specific tasks indicated with these tools but not limited to: I frequently used Oracle instance manager to have Graphic user interface (GUI) view, search and Modify access for general Instance Parameters (DB Name, Host Name, Instance Name, Version, Uptime, Startup Time etc.
• Control Files, Control File statistics, NLS Parameters, Oracle Jobs Information.
• Oracle SGA Manager to view and Search for SQL Area, Lib Cash Parameters, Lib Cash Statistics, SGA Statistics, Chart Representation of SGA and Shared Pool statistics Oracle Storage Manager to view, search and modify access for Tree table, Tablespaces, Datafiles, Objects, Fragmentation, File IO Statistics, Objects IO Statistics.
• Oracle Security manager to view Search and Modify access for tree view for users, roles, profiles, view Properties of users, role, profile, create user role profile, alter User role profile drop user role profile and etc...
• Performed SQL tunning by utilising the following steps: Identifying high load or top SQL statements that are responsible for a large share of the application workload and system resources, by reviewing past SQL execution history available in the system.
• Verifying that the execution plans produced by the query optimizer for these statements perform reasonably.
• Implementing corrective actions to generate better execution plans for poorly performing SQL statement.
• Tranported tables accross platform to provide an easier and more efficient means for content providers to publish structured data and distribute it to customers running Oracle Database on different platforms.
• This method help to simplify the distribution of data from a data warehouse environment to data marts, which were running on smaller platforms.
• Used RMAN to performs backup and recovery tasks on Oracle databases such as restoring, and recovering database files; and to automate administration of the backup strategies.
• Provided network management in Unix for oracle using Netstat to understand what is happening on the network at the current time.
• Assist in the design and implementation of database, backup and security standards.
• Monitor and optimize query and database performance.
• Communicated regularly with internal technical, applications, and operational staff, as appropriate, in order to ensure the database integrity, security and availability Provided 24×7 support to production database environments* Daily maintenance including monitoring and database maintenance tasks * Backup & Recovery * Apply patches and upgrade database versions * Install and Build database structures * Develop and maintain shell scripts * Query and performance tuning.

Improved reliability of supply chain software, systems, database and order processing.Served as sole database administrator for Sybase, Oracle and MS SQL running on various operating systems.Developed IT strategic vision and drove key departmental objectives.