Description
SUMMARY: * Overall 14+ years of experience in Oracle Database Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing backup/recovery strategies, Disk space management, Memory management and Performance tuning * Extensive experience in ETL process by using Informatica 9.1.x transformation, ETL dsign and architecture, data migration * Experienced in comparing schemas in different databases using Red Gate software * Experience in monitoring and tuning multiple Oracle databases using Oracle Enterprise Manager (OEM) * Experienced in setting up Oracle Data Guard in Production environment * Experienced in setting up Cluster using the Data Guard and Real Application Cluster (RAC) * Experience in PL/SQL programming in writing stored procedures, views, triggers, UDF's and configuration of multiple instances * Involved in design and development of SSIS/DTS packages to load data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa * Involved in performance tuning of very complex SQL statements and procedures using showplan and iostatic, creating named cache and binding objects * Expertise in trouble-shooting (handling database corruption, transaction log problems, deadlocks, and Query performance problems) * Expert in Oracle Administration, which includes Installation & Configuration of Oracle database in stand-alone and RAC environment * Experienced in creating ASM instance and migrating from OCF2 to ASM on Oracle 10g/11g * Designed High Availability Databases with Oracle Standby Database, RAC * Expert in Disaster recovery using RMAN and COMMVAULT Galaxy Backup Systems * Oracle Certified Professional (OCP) DBA 11g/10g/9i/8i * Oracle Certified Professional (Managing Oracle on Linux Certified Expert) * Microsoft Certified IT Professional (MCIT DBA) SQL Server 2008/2005 * Microsoft Technical Solution Expert (MSTS) SQL Server 2005
Accomplishments
Highlights:
Keywords
