Occupation:Database Administrator |
Location:Washington, DC |
Education Level:Bachelor |
Will Relocate:YES |
Description
Profile I am a Certified Oracle Database Administrator with hands-on experience. Worked on Oracle 12c, 11g, 10g, versions involving database administration production support, installation and configuration, performance tuning, upgrades and patches, migration on same and different platforms, backup and recovery, cloning, database and schema refreshes, space management, auditing and security. Skills Summary * Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN. * Experience with RAC Cluster ware configuration and patching, RAC Backup and Recovery. * Experience in Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load Balancing and designing failover systems on UNIX platforms. * Worked on Data transferring with export/import utilities and Data pump. * Highly experienced in performance monitoring/tuning/troubleshooting. * Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform. * Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems. * Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill the storage needs. * UNIX Systems Administration - Database and application integration efforts. UNIX shell scripting, CRON jobs. * Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures. * Experience in cloning/replicating Production database using RMAN. * Performed Tablespace point in time recovery (TSPITR) using RMAN * Proficient in using Flashback technology to provide faster recovery of database. * Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows. * Performance Tuning of Oracle database using OEM GC, Cost optimizer, SQL analyze, Performance Manager, Stats pack, AWR, ADDM, ASH, Explain plan TKPROF, SQL TRACE and Oradebug. * Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities. * Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems. * Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics. * Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM. * Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance. * Developing shell scripts and SQL scripts to carry out routine checks on databases. * Implemented proactive monitoring scripts for production databases. * Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan. * Utilized SQL Loader to migrate or load data to Oracle. * Experience in using SQL, PL/ SQL procedures, functions, triggers and packages. * Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage. * Configured Manager, Replicate and Extract processes and implemented unidirectional, replication using Oracle11g Golden Gate on RHEL 5 platform. * UNIX shell scripts for hot backups, SQL*Loader, export and import of database. * Proficient with Database Cloning, Migration, and Patching of Oracle Databases. * Extensive Experience with RMAN Backups, Hot Backups and Logical Backups. * Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
Accomplishments
Highlights:
Keywords
