Professional Summary 804-300-0910 Juliette_tita27@yahoo.com * 5 years of experience in the field of Database Technology with experience in performance tuning, backup and recovery, installation and patches, database migration and database security. * Planned and implemented high availability solutions such as Dataguard, Golden gate and RAC. * Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM). * High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance. * Extensively managed users, privileges, profiles, schemas using OracleEnterprise Manager (OEM). * Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 12c) for monitoring multiple databases and application servers. * Highly experienced in using Oracle 11g features Flash-Back Recovery and Recycle Bin. * Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump. * Configure Data Guard on both standby and primary for numerous production databases. * Fail over and switch over between standby and primary databases. * Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins. * Backup & Recovery using RMAN which includes hot backups and Cold backups. * Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard. * Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database. * Proficient with Database Cloning, Migration, and Patching of Oracle Databases. * Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC. * Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes. * Experience in Multitenant Databases (Oracle 12c Container and pluggable databases) * Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc * Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features. * Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature. * Expert in RMAN backups including full, incremental and cumulative. * Excellent knowledge in FlashbackRecovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases. * Extensively worked on Import/Export and DataPump Import/Export tools. * Knowledge in configuring ASM (Automatic Storage Management) * UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs. * Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility. * Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance. * Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC) * Provided valuable inputs for various performance tuning issues. * Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning) * Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF. Technical Proficiencies Experience Summary

Highlights:

• cron
• Database
• Management
• Monitoring
• Oracle
• Oracle Database Administration
• Scheduling
• Security
• Structured Query Language
• Triggers
• sql