Occupation:Database Administrator |
Location:Bowie, MD |
Education Level:Associate |
Will Relocate:YES |
Description
EXPERIENCE SUMMARY . Over 6 years of hands-on experience as an Oracle Database Administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup, and recovery, cloning, space management, and database security with Oracle (10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform. Skills Summary: * Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK. * Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection. * Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities. * Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance. * Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler. * Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental and cumulative. * Excellent knowledge in Flashback Recovery, 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 Data Pump Import/Export tools. * Knowledge in configuring ASM (Automatic Storage Management) * UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs. * Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams. * 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, 10g Automatic Storage Management (ASM) required to fulfill the storage needs. * High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance. * Install, configure and upgrade to Oracle 12c consolidate multiple databases into multi-tenant database containers evaluate and implement latest database technology and new Oracle 12c features. * Perform database monitoring and tuning to ensure databases run at peak performance troubleshooting production performance issues. * Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).. Able to install configure, create and maintain databases systems and related software products in a manner consistent with existing service level agreements Excellent communications and interpersonal skills. * Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning. * Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams. * Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.Dynatrace and Splunk Installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems. * Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 2 TB. * Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions. * Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c). * Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations. * Excellent knowledge on oracle 10g and 11G architecture and administration, good understanding of new features. * Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard. * Expertise in Disaster Recovery Planning and high availability solutions by performing switchover and failover operations in Data Guard. * Experience in creating and managing Single Instance databases and RAC primary and standby databases under various business critical environments. * Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams, Golden gate. * Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database. * Good hands-on experience applying recommended Upgrade Patches as well as CPU/SPU and PSU patches to the standalone and RAC databases. design, development, system integration phase, quality assurance phase, development and production support activities. * Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB * Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.. * Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance. * Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover. * Installation and Configuration of Oracle 12c Multitenant container and pluggable databases * Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms. * Configuration and Management of Data Guard on RHEL, OEL. * Extensive skills in performing database crash recoveries techniques like Point in time/scn/cancel using full backup, level 0 and level 1 incremental differential and cumulative backups. * Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances. * Excellent skills in generating execution plan using EXPLAIN PLAN and gathering reports using TKPROF for Application Tuning and gathering optimizer statistics for SQL Tuning. * Experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports. * Experience in creating and managing control files, redolog files, data files and archive redo log files. * Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space. * Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS). * Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM). Maintain professional and technical knowledge by attending educational workshops * Proactively monitoring the database's health and taking preventive or corrective actions * Proficient in Database Design (Physical and Logical Database Design) and Normalization. * Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM). Strong Analytical Problem-Solving Skills with attention to detail * Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation. * Proficient in using various database Utilities like EXPORT/IMPORT, Data Pump, TOAD. Programming skills with strong SQL knowledge * Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility. Automated many common tasks using crontab including Backups, exports and imports
Accomplishments
Highlights:
Keywords
