SUMMARY:

• Overall experience of 8 + years in industry as a Oracle Database administrator with a specialization in Database administration extensively, Oracle Installation in standalone and RAC Environment, Backup and Recovery (Logical, User Management and OEM), Tablespace & Datafiles Management, Schema, Privilege, Role & Profile Management & Database object Management, Oracle Advance Security.
• A database administrator professional offering nearly 8+ years of qualitative experience Analyzing and Administering Oracle Databases Supporting Oracle 8i, 9i, 10g & 11g(standalone & RAC) and 12c.
• Hands on experience in systems and database administration of systems, migrating & upgrading databases and providing technical support for the business applications.
• Excellent skills in database administration, backup and recovery activities including RMAN, performance tuning of Oracle, patching and troubleshooting. Strong problem solving & technical skills.
• Up - gradation of production databases from 9i to 10g, 9i to 11g, 10g to 11g (Standalone & RAC) Building standby (standalone & RAC). 11g to 12c (Standalone )
• Extensively hands-on experience in oracle utilities viz. AWR, DATAPUMP, Oracle Enterprise Manager for performance monitoring, DB Advisor, STATSPACK tracing .
• Exposure to installing and configuring Golden Gate.
• Knowledge in Relational database design concepts and data modeling.
• Expertise at the entire life cycle of the project, integration & implementation of projects / products, database creation, modeling and capacity planning.
• Entry level of experience in MySQL and Hadoop Administrator.

TECHNICAL SKILLS:

Operating Systems: RHEL (4, 5, 6 ) Suse Linux, Windows 2000, HP UX, AIX, Sun Solaris

Databases: Oracle 9i, 10g, 11g & 12c with RAC, MS Access, SQL Server.

Tools: OUI, OEM, DBCA, Grid Control, TOAD, EXP / IMP, Performance Tuning Using ADVISOR/ TKPROF / EXPLAIN PLAN / STATSPACK, ADDM, AWR, DATAPUMPLanguages: SQL, PL / SQL, Shell ScriptingGUI: 12c Cloud Administration.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Sr Oracle DBA

Responsibilities:

• Handling 4 node of RAC cluster environment with Stream Replication and Data guard .
• Handling all Oracle Database performance issues. At present handling more than 100+ databases with a team of 6 members.
• Responsible for fine-tuning databases, refreshing of development / testing databases with latest production data for application testing through import or export or by cloning.
• Releasing scripts for application change requirements in production databases, installing the oracle software & creating databases, upgrade & migration of Oracle databases and working with the end users in solving their problems.
• Devising the precise warehouse tool, to collect all the database statistics pertaining to database round the clock.
• Ensuring backup and recovery scripts using datapump, exp, imp for Oracle databases, performance tuning, capacity planning, SQL Tuning and partitioning of Tables / Indexes.
• Database creation & capacity planning as per user requirement.
• Golden Gate with bi-directional Replication .

Confidential, Hoffman Estate IL

Sr Oracle DBA

• Worked on UDAS Application Support.
• Creating database for Production/Quality/Development.
• Database migration, Up-gradation.
• Creating the Clone of database.
• Creating new users and manage roles and privileges.
• Creation of Database Objects as per the Requirement.
• Managing Import / Export Depending up on Requirement.
• Managing Rollback Segments, Redo logs, Control files, and Tablespaces.
• Auditing On users, Lock Management and space management.
• Monitoring Users, tablespaces, rollback segments and tuning SGA Target and Memory Target.
• Backup of initialization / configuration files, Control files, Password files and archived log files.
• Testing Recovery Strategies by Simulating Database Crashes on Development Systems.
• Continuously Monitor the System response time and detect for any bottlenecks along with possible solutions.
• Package and Patch Administration, Adding Patches as per requirement.

Confidential

Sr Oracle DBA

• Managing and maintaining all the Oracle Database including BCA Business Critical Application for J&J.
• Installing Oracle software like 10g, 11g, 12c configuring and creating database.
• Interact with customers from different regions (NA, EMEA and APAC) for understanding their requirement & provide solution
• Oracle software installation, configuration and database creation on HP-UNIX/Linux/Windows platforms
• Setup Active standby database using Oracle data guard for Disaster Recovery
• Upgrading the databases to the latest version using DBUA or manually
• Apply both PSU as well as CPU patches
• Implement and manage backups using RMAN and logical backups
• Database Cloning
• Character set Migration as per the request
• Manage user accounts, roles, profiles and database privileges to ensure database security and integrity.
• Schema refresh and Database refresh from Production to lower environment
• TDE implementation Data Encryption
• Analyzed tables, indexes for improving the performance of the Query.
• Involved data center migration activity from Mops to Brussels
• Database performance analysis and tuning using AWR, ADDM and STATSPACK.
• Automate and schedule various DBA activities using Crontab.
• Analyze and resolve Sev 1 issues reported on Production/QA/Dev databases.
• Deinstall Oracle Software/Binaries.
• Implementing RMAN backup, Data pump
• Schema Decommission.