SUMMARY:

• 11+ years of IT experience in database administration (Installation, Configuration, implementation, designing, recovery and troubleshooting).
• Extensive knowledge to handle Advanced Oracle/Sql databases.
• Ability to quickly adopt to new technology environment.
• Hands on Experience to implement the advanced oracle product features such as (RAC,ASM,Dataguard,Goldengate,OEM and OECC13c).Good Experience to work on Fusion and informatica enviroment.
• Have in - depth technical to analyze the oracle database related issue.
• Excellent technical, analytical,problem solving and communication skills.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

RDBMS: Oracle 12c RAC, Oracle 11g RAC, Oracle

Operating Systems: Solaris 9/10, Linux RHAT 10g RAC, oracle 9i, oracle 8i,Sql Server 2005 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, M icrosoft

Tuning& Monitoring Products: Windows NT, 2000/2003/2005. Oracle 10g Grid infrastructure, Oracle 11g Grid

Backup Tools : Veritas NetBackup, NetApp,, infrastructure, Oracle 12c Grid infrastructure, Tools TSM,EMC Programming

Languages: & Utilities ASM, Data Guard, Grid Control (OEM), SQL,Unix/AWK,C,C++,Asp.Net, XML, HTML,Tkprof, Stats pack, AWR, ADDM, ASSM, Oracle DHTML, Java. HARDWARE Sun Fire X 4100,Sun SQL Developer, TOAD, RMAN, Export/Import, Data Fire V104,HP Itanium, Confidential .

MiddleWare: Oracle 9iPump (expdp/impdp), SQL Loader, Lab128,Spotlight. / 10G AS,Forms6i/5i, OBIEE,Weblogic

ETL & Reporting Tools: Informatica, Power Center8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1,Oracle Data Integrator, SAS

SKILLS:

• Oracle Database Administrator Advanced 11 2017
• Windows, Unix, Linux,Aix,Mac OSX, Experience 11 2017VMWare
• Sql server Experienced 5 2014
• Oracle Application server 9i/10g/Weblogic Experience 4 2012 /OBIEE

EXPERIENCE:

Senior Oracle database adminstrator

Confidential, Orlando, FL

Responsibilities:

• Oracle RAC 10g/11g/12c installation and configuration on Linux
• Upgraded databases from Oracle 9i, 10g to 11g/12c.
• Involved on new project design and implemenation with development/ETL Team. Ø Involved to support a fusionenviroment setup
• Experienced in performing Point-in-Time Recovery.
• 24x7 Production database and applicationssupport.
• Involved on annual database SOX/PCI auditing to get completed successfully.
• Installed, configured, andmaintained Oracle 10g and 11gR2.
• Restoration and Recovery of databases at the times of occurrence of critical failures.Ø Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structuresand objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracledatabase backup & recovery solutions using RMAN and manual methods.

Database Administrator

Confidential

Responsibilities:

• Oracle RAC 10g/11g/12c installation and configuration on Linux
• Upgraded databases from Oracle 9i, 10g to 11g/12c.
• Involved on new project design and implemenation with development/ETL Team.
• Involved to support a fusionenviroment setup
• Experienced in performing Point-in-Time Recovery.
• 24x7 Production database and applicationssupport.
• Involved on annual database SOX/PCI auditing to get completed successfully.
• Installed, configured, andmaintained Oracle 10g and 11gR2.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structuresand objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracledatabase backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and databasesystems.
• Partitioned large tables for better performance and manageability.
• Clear documentation was prepared on allthe processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacityplanning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Oracle Database Administrator

Confidential

Responsibilities:

• Oracle RAC 9i/10g/11g installation and configuration on Linux/Aix platforms.
• Upgraded databases/ clusterware from Oracle 9i, 10g to 11g.
• Experienced in performing Point-in-Time Recovery. Ø 24x7 Production database and applicationssupport.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storagestructures and objects, database backup and recovery, monitoring and optimizing database performance.
• Managed theoracle CPU/PSU patch apply
• Implemented Oracle database backup & recovery solutions using RMAN and manualmethods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performedlarge batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting requiredaccess permissions and privileges to the database based on the applications they are accessing. Ø Partitioned large tables forbetter performance and manageability.
• Great experience to coordinated with oracle corporation and Confidential team due toperformance issues

Database Administrator

Confidential

Responsibilities:

• Migrate database from production to beta,test environment using RMAN
• Real Application Clusters monitoring,tuning using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views
• Designed and developed scripts tomonitor instances locks, long running queries, listener password, tablespace space, extents growth, etc
• Design andimplement of database backup strategy and performed full, incremental backups using RMAN. Troubleshooting withRMAN backup problem.
• Monitor and Tuning of Database Performance by using various optimization techniques Ø Provide database administration on production, testing and development database servers.
• Creation of database objects liketables, indexes, synonyms and views etc Ø Clone/Refresh of Production databases to dev and training environments
• Perform tuning of databases based on analysis of utilities
• Interacted with OracleSupport for resolving various critical database issues.
• Installation support for Confidential AIX version 5.3 and oracle related OSpatches.
• Performed memory level application tuning
• Designed partition and migrated database using exp/imp
• Report sever implementation and tested using RMAN
• Setup and configured Physical standby database
• Databasecreation and database migration.
• Configured OMS console.
• Performance tuning has been done in OS and database