SUMMARY:

• Over 7 Years of experience as Oracle D Confidential base Administrator. Oracle 11g RAC/10g RAC/9i/8i d Confidential bases running on different environments such as Sun Solaris, HP - UX, AIX, Red Hat Linux, and Windows.
• Proficient in Oracle D Confidential base Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on d Confidential base administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale d Confidential base environment and mission critical OLTP and OLAP systems.
• Excellent experience in Migrating the D Confidential bases.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Experience with D Confidential Modeling, Logical and Physical d Confidential base design.
• Having hands on experience on working with Large OLTP d Confidential bases like 5 Tb.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring
• Experience in OLTP/DSS d Confidential base systems, implementing and managing large Oracle d Confidential bases (VLDB).
• Hands On Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC
• Experienced Confidential using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL)
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM.
• Successfully implemented physical Standby d Confidential base using Oracle D Confidential Guard feature for High availability configuration.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support,Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planningand documentation.
• Experience in Flash-Back Recovery, D Confidential Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated d Confidential bases from Windows to Linux, Sun Solaris to AIX.
• Troubleshoot D Confidential base performance issues using Automated Workload Repository (AWR) and Automatic D Confidential base Diagnostics Monitor (ADDM).
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Planning and scheduling for the backup of d Confidential base information using UNIX shell script and Crontab jobs.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle d Confidential bases.
• Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g RAC environments using the OEM GridControl tools.
• Have extensive experience in performance and tuning of OLTP and D Confidential warehouse applications.
• D Confidential transferring with Export, Import, D Confidential Pump and SQL* Loader utilities.
• D Confidential base backup concepts and options such as user-managed backup, RMAN-managed backupwith or without c Confidential log, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Skilled in d Confidential base upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Refresh/Cloning of D Confidential base and applications for development and testing purpose.
• On call 24x7 Production Support Worked Confidential regular hours.
• Dealing with d Confidential base security and auditing.
• Have extensive knowledge Oracle Application Server Administration (web logic)
• Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Knows Perl scripting
• Worked As a DBA for Web Application Projects

TECHNICAL SKILLS:

• Operating Systems: HP - UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1,7.1 Red Hat Linux 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista
• Programming Languages: SQL, PL/SQL, Unix Shell Scripting.
• RDBMS: Oracle 8i/9i/10g RAC/11g RAC
• Software s, Applications and Tools: DBCA, DBUA, Oracle D Confidential Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, D Confidential Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer, Golden Gate
• Web Related and Other Tools: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, MS Visio, Perl scripting

PROFESSIONAL EXPERIENCE:

Confidential, PLANO, TX.

Senior Oracle DBA

Responsibilities:

• Providing production support for 24X7 d Confidential base availability for Oracle and SQL server D Confidential bases.
• Maintenance and monitoring of oracle 11g R2/10g d Confidential base instances hosted on Linux and Sun platform.
• Upgrade and Migration of D Confidential bases from 10g R2 to 11g R2 and applying patches as per requirement.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Simulate a copy of production d Confidential bases into test d Confidential bases for application upgrade testing.
• Support and advise the development teams on d Confidential base related issues.
• Installed and Configured GOLDEN GATE Extracts/replicate for multiple d Confidential bases.
• Configured and built heartbeat monitoring in Golden Gate .
• Configured error handling for restart, logging, production support and status reporting in Golden Gate .
• Identified and produced documentation of best practices.
• Trouble shooting and performance tuning golden gate replications
• Space Management which includes table space creation, adding new d Confidential files.
• Managed Table spaces, Rollback Segments, Redo Logs and other d Confidential base object.
• Oracle installation, creation of d Confidential base, which includes physical and logical design.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Involved in support for 1TB 2 Node production RAC d Confidential base.
• Responsible for monitoring and resizing Oracle d Confidential base objects (Table spaces, Tables, Indexes etc,
• Responsible for memory and Application tuning of the d Confidential bases using Oracle utilities like OEM,SQL Trace, TK Prof and Explain Plan.

Environment: ORACLE, SQL Server, SQL*Plus, Oracle 11g/10g, Red Hat Linux 4.x, RAC, Oracle Enterprise Manager, D Confidential Guard, ASM, PL/SQL, RMAN, Toad for Oracle Expert 12 .

Confidential, Fort Lauderdale , FL

Sr. Oracle DBA

Responsibilities:

• 24x7 on-callproduction d Confidential base support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby D Confidential bases for high availability and disaster recovery/reporting purpose.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g d Confidential bases.
• Upgraded Oracle D Confidential base from 9i to 10g, 10g to 11g.
• Logical, physicald Confidential modeling, implementation and d Confidential base administration.
• Migration of the d Confidential base from Sun Solaris to Confidential AIX, Windows to Linux.
• Expertise in recovering the d Confidential base. Performed complete and incomplete d Confidential base recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different d Confidential base servers.
• Automated the nightly RMAN backups
• Writing and modifying UNIX shell scripts , Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming ( ETL ) d Confidential from Production d Confidential bases to D Confidential Warehouse D Confidential bases.
• Using the 11g Grid control, OEM for the d Confidential base tasks like adding the d Confidential file, resizing the d Confidential file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both C Confidential log/ No c Confidential log modes.
• SQL tuning and D Confidential base performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR , ADDM and monitor the d Confidential base performance on daily basis.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import D Confidential pump utilities).

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, Confidential AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, D Confidential pump

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• 24x7 on-callproduction d Confidential base support
• Installation and Configurations of Oracle 11g, 10g.
• Installed Oracle 11g RAC, 10g RAC, Standby D Confidential bases for high availability and disaster recovery/reporting purpose.
• Implemented D Confidential Guard for Disaster recovery.
• Worked on D Confidential Modeling, Dimensional D Confidential Modeling, Star Join SchemaModeling,Snow-Flake Modeling, FACT and Dimensions Tables.
• Setup and configure Standby d Confidential base for high availability by using D Confidential Guard.
• Migrated & upgraded d Confidential bases from Oracle 10g to oracle 11g
• Installed and implemented Golden gate to replicate d Confidential between d Confidential bases.
• Replication using Oracle Streams.
• Documented instructionsfor migrating & upgrading d Confidential bases.
• Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
• Experience working on Visual Studio 2012(IDE)
• Wrote various shell scripts to automate tasks.
• Creating PL/SQL procedures for Extraction, Transformation and Loading of d Confidential
• Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup d Confidential base auditing, granted privileges to users through system/object roles.
• Implement and maintain d Confidential base security.
• Created db link for inserting large tables directly without taking export.

Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, D Confidential Pump