Description
PROFESSIONAL SUMMARY 5 years of working experience in the daily administration of production Oracle 10g, 11g, 12c databases. Duties include installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN), database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard, and Oracle 12c Cloud Control for configuration and monitoring. Also responsible for patching, upgrade and database troubleshooting. Support development effort with regard to production deployment releases, database schema, role, user, and objects. Maintain database security. * Configure Data Guard on both standby and primary for 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. * Experience in multi-node and RAC environments including configuration of PCP. * Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode * Troubleshoot Database performance issues. * Import/Export and Expdp/ Impdp utilities. Excellent experience in Installation, configuration, Maintenance of Oracle 12C, 11g, 10g on Operating Systems Solaris, Linux, AIX and Windows platforms. * Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms. * Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage * Experience in Auditing and Capacity Planning, Configuring & Managing Hot Standby Databases (Data Guard) * Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability * Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another. Experienced with SRVCTL, OCR and Voting Disk of 11g RAC * Handled RAC Node hangs and node eviction issues. * Expertise in maintaining Database Security using auditing. * Experience in Data Migrations. * Performed database recovery using User-Managed, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery. * Experience in automating backup strategy using the UNIX shell scripts and Cron Utility. * Experience in schema and table designing, stored procedures, Triggers, Views, and Indexes. * Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN. * Hands on experience in performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, DBMS_STATS, Automatic workload Repository (AWR), ASH and Automatic database diagnostic monitor (ADDM)
Accomplishments
Highlights:
Keywords
