Occupation:Database Administrator |
Location:Norcross, GA |
Education Level:Bachelor |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY * Providing DBA support to multiple Cluster, Non-cluster, and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments. * Experience in Installation, Configuration and Monitoring of Oracle ASM on UNIX, Linux, AIX and Windows Environments. * Extensive experience with Oracle database administration of Oracle 10g, 11g & 12c RAC with multiple nodes covered all aspects of administration like installations, configurations, migration, Patches, Critical Patch Updates (CPU), Upgrades, replication, sizing and space management. * Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c database with experience in very large scale database environment and mission-critical large OLTP and OLAP systems. * Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (as), TOAD, Oracle SQL Developer in various versions. * Installation, Configuration, and Maintenance of Logical/Physical standby databases in Data guard. * Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c/13c, Configuration, and Management of Data Guard 10g/11g/12c on RHEL, OEL and Sun-Solaris for Disaster Recovery. * Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3/4 Node RAC on 10g/11g/12c. * Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility. * Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid). * Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp). * Installed and configured Golden Gate v11 and 12c on AIX 6.1 and RHEL 5.8,6.7 platform and Performed Cross platform migration and used Oracle Golden Gate to migrate databases from AIX to Linux as a part of u12 Cloud migration project. * Installed and Configured Golden Gate components for transaction level DDL, DML, Uni-directional and Bi-directional replication between heterogeneous environments and maintain data synchronization using Golden Gate v10, v11 and 12c. * Configured Oracle Golden Gate for bi-directional replication and migrated databases with ZERO downtime. * Extensive troubleshooting of typical Oracle Golden Gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis. * Migration of databases to EXADATA's (cross platform), Patching, RE-IP & EXADATA maintenance activities. * Worked on EXADATA X 5, X 3-2, Quarter RACK Half RACK. X 2-2 half RACK & X 2-8 Full RACK. * Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance-level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL BASELINES, Creating and rebuilding Index's, re-organizing tables. * Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN. * Identified and fixed the logical block corruption using RMAN & PERFORMED logical backup using Data pump Expdp and Impdp Utility. * Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business. * Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. * Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics. * Proficient in SQL, PL/SQL, Perl Script, Shell Script, ERwin Data modeling, OLAP, Oracle Data Dictionary - metadata, Logical and Physical Database Design. * Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc. * Worked on MS SQL 2000 / 2005 /2008, creating backup strategies, Maintenance plans, and Job Scheduling and User maintenance. * Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific databases. Operating System HP-UX 10.x/11.x, IBM AIX 4.x/5L, Sun Solaris 2.6/8/9/10, Linux 2.x/3.x/4.x/5.x and Exadata X 3-2, X 2-2, X 3-5 RDBMS Oracle 9i, 10g, 11g, 12C, oracle 10g/11gR2/12c RAC and MS SQL server Database Servers Oracle Application Server 10g, HP 700 Series, HP Superdome, Sun Enterprise 450 &880, Sun 3500, 3800, 6800, Sun fire 4800, V1280, Dell PowerEdge.
Accomplishments
Highlights:
Keywords
