SUMMARY

• Having 10 years of experience as an Oracle Admin, encompassing experience in installation, migration, maintenance, client support, analysis, designing, development, testing, and administration of oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning and space management using ORACLE 11g, 12c, performing the role of Oracle Database Admin according to the set standards and time - lines.
• Having 5+ years of experience as an Oracle Golden Gate expert, encompassing experience in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues, Golden Gate upgrades, Upgrade from oracle 11g to 12c by using GG in real time, creating reporting and disaster recovery dbs. by using data guard and Golden Gate, monitoring Golden Gate system by creating Unix Shell scripting.
• Experienced on AWS,EC2.
• Configuration and patching OEM 13c.
• Installed 12c on AWS EC2 and migrated Oracle 11g to AWS RDS .
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer.
• Migrated 40+ applications from 11g to 12.1 with ZERO downtime using GG.
• Proven working experience of RAC environment and ASM
• Extensive experience in Data Guard configuration, implementing and maintaining standby databases.
• Troubleshooting GG issues like TRIGGER suppression, Primary Key…
• Expertise in using EXPLAIN PLAN, SQL Advisors, ADDM, and AWR for query optimization and Performance diagnostics tools like SQL Trace.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• ON-CALL support for PROD issues on weekly rotation basis.
• Documenting critical tasks for future references.
• Extensive experience in patching (ONE-OFF, CPU, PSU).
• Proficient in handling ORA-600, ORA-7445 and applying patches accordingly.
• Very good knowledge in writing shell scripting to automate database tasks .
• Extensive Experience of Backup and Recovery using User Managed and RMAN (Recovery Manager) for Physical and exp, imp, expdp, impdp for Logical Backups
• Extensive knowledge in UNIX platform includes SOLARIS, LINUX,AIX.
• Educational Qualifications Masters in Computer Science from Jawaharlal Nehru Technological University, Hyderabad, India.
• Bachelor’s Degree in Computer Science from Acharya Nagarjuna University, Guntur, India

TECHNICAL SKILLS

Relational Database: Oracle 12c, 11g, 10g Operating Systems Redhat Linux, HP, IBM AIX, Sun Solaris, Linux, Windows.

Languages: PL/SQL, SQL, Shell Scripting

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, ADDM

Backup Tool: RMAN, exp, imp, expdp, impdp

Tool: TOAD, SQL developer, SQL *Loader, NetCA, DBCA, asmtool

OS, Hardware, Storage: Solaris (SPARC), Linux (Intel), Windows (Intel)

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle database Administrator

Responsibilities:

• Influence multiple groups across the organization to implement new methodologies for deployment and operational excellence for Oracle platform to improve cost effectiveness, High Availability.
• Provide Database Support to Application Teams for day to day issues.
• Troubleshooting GG issues like TRIGGER suppression, Primary Key…
• Installed 12c on AWS EC2 and migrated Oracle 11g to AWS RDS .
• Managing GG trail files on source and target systems.
• Verify and enable the source and target database archive operating mode
• Prepare the source and target databases for Oracle Golden Gate
• Download and install Oracle Golden Gate on source and target systems
• Allocating system storage and planning future storage requirements for the database system
• Resolving Archive log gap issues between Primary and Standby’s.
• Switch over and Failover activities as needed.
• Creating and Managing Database objects i.e. tables, indexes, sequences etc.
• Installed and maintained Oracle 11g/12c with ASM. Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management. Modifying the database structure as necessary
• Resolved LOCK & Blocking sessions in RAC.
• Worked on Cluster RAC, +ASM startup issues.
• Controlling and monitoring user access to the database
• Monitoring and optimizing the Performance of the database
• Logical Backup of database information using impdp, expdb
• Use export/ import and data pump utility for logical backup
• Configuring RMAN and scheduling jobs
• Use User managed and RMAN for physical backups
• Monitoring alert log files for database and user related issues
• Managing Listener and TNS Names for unexpected TIMED OUT errors.
• Performed multiplexing of Control file and Redo log files
• Adhere to change control and security policies where relevant
• Monitoring archived logs generation archived log disk partition and archived log backup
• Routine checking of backup logs of previous day
• Creating/ Managing Table Partitions as per requirement
• Creation, Maintaining, Dropping, Monitoring of Locally Managed Table space and addition/ resize of data files to table space
• Online Re-Organization of Oracle Tables
• Checking Tables/ Indexes which needs more extents and to allocate space/ reorganize/ rebuild
• Checking whether all Databases/ Listeners are available and running
• Monitoring, Maintenance, Trouble Shooting of Oracle Database server running
• Startup/ Shutdown for Oracle Database Server when needed
• Manage users login and security at the level of the oracle
• Assist in controlling storage utilization, allocate space according to application needs
• Firing Hot Backups
• Killing Sessions at Database Level

Confidential

Oracle database Administrator.

Responsibilities:

• Worked on 300+ instances including RAC & NON-RAC.
• Supported in critical issues on Production of ranges from 12 GB to 3TB sizes databases as primary contact.
• Performed 70+ RMAN refreshes for DEV & UAT use.
• RMAN cloning from RAC to non-RAC databases.
• Performed object, Schema & Full database Level Exports/Imports.
• Migrated database from non-ASM to ASM.
• Resolved network issues.
• Provide Database Support to Application Teams for day to day issues
• Allocating system storage and planning future storage requirements for the database system
• Creating and Managing Database objects i.e. tables, indexes, sequences etc.
• Creating Databases
• Modifying the database structure, as necessary
• Enrolling users, Deleting users, Updating users
• Controlling and monitoring user access to the database
• Monitoring and optimizing the Performance of the database
• Logical Backup of database information using impdp, expdb
• Use export/ import and data pump utility for logical backup
• Configuring RMAN
• Use User managed and RMAN for physical backups
• Monitoring alert log files for database and user related issues
• Managing Listener and TNS Names
• Performed multiplexing of Control file and Redo log files
• Adhere to change control and security policies where relevant
• Monitoring archived logs generation archived log disk partition and archived log backup
• Routine checking of backup logs of previous day
• Creating/ Managing Table Partitions as per requirement
• Creation, Maintaining, Dropping, Monitoring of Locally Managed Table space and addition/ resize of data files to table space
• Online Re-Organization of Oracle Tables
• Checking Tables/ Indexes which needs more extents and to allocate space/ reorganize/ rebuild
• Checking whether all Databases/ Listeners are available and running
• Monitoring, Maintenance, Trouble Shooting of Oracle Database server running
• Startup/ Shutdown for Oracle Database Server when needed
• Manage users login and security at the level of the oracle
• Assist in controlling storage utilization, allocate space according to application needs
• Firing Hot Backups
• Killing Sessions at Database Level