Database Administrator

Launching the new Amazon EC2 instances using AWS Console.
Launching the new Amazon Oracle RDS 11.2.0.4 & 12.1.0.2 Instance using AWS Console.
Migrating the 2 node RAC 11.2.0.4 & 12.1.0.2 databases from on premise RACKSPACE to AWS CLOUD ORACLE RDS (standalone) with minimal downtime.
Using Oracle DATAPUMP to migrate RAC database from on premise to AWS CLOUD RDS.
Using AWS DMS Service for replicating ongoing changes from on premise to AWS CLOUD RDS.
Using TSUNAMI UDP for copying data pump dump files from on premise to AWS EC2 instance and from EC2 instance to RDS instance.
Resolving the performance issues in oracle RDS after cut over from on premise to AWS CLOUD RDS.
Provide status update to management on critical issues, business impact and resolution plan.
Acted as team lead during critical management situations and organize support teams towards impact mitigation.
Invoke crisis management process and follow-up on issues root cause resolution with corrective/preventive measures
Work with IT and Project teams to ensure submitted system enhancement / changes have undergone adequate functional & volume testing before release to production.
Database Refresh using oracle RMAN active duplication.
Building up the new servers with 12c grid infrastructure and 12c database.
Configured Enterprise Manager Cloud Control 12C for PROD & NON-PROD Environments to monitor on Premise and Oracle RDS Servers.
Adding cloud control agents to the on Premise and Oracle RDS servers for enabling the server and database monitoring.
Created database monitoring templates for PROD and NON-PROD in EM 12C.
Upgraded EM Cloud Control from 12.1.0.2 to 12.1.0.5 on Windows & Linux servers.
Providing 24*7 Production Support.
Resolving Jira tickets and working on Releases.

Administration and Maintenances of Production Databases.
Installation and Configuration of Oracle 11g Databases.
Configuration of Oracle 10g/11g DATA GUARD.
Interaction with client to understand their technical queries and provide assistance in resolving them.
Monitoring Archive log, Oracle Mounts to avoid downtime of the Databases.
Automating Daily jobs using Crontab
Code migration and solving Application related issues like database connectivity.
Responsible for user creation and provided privileges as per the requirement
Performing Flashback as per user requirement.
Responsible for Level0 and Level1 Backups and check the functionality of backups post monitoring.
Validating the Backup Sets
Monitoring the Data Guard Environment and solving the issues related to Redo shipping.
Configured Automatic Client Failover in Data Guard Environment.
Responsible for Schema Refresh using DATA PUMP as per user requirement
Performing Database Cloning from Prod to Non prod, Dev and Test Environments using RMAN.
Responsible for the issues related to log shipping, log apply and other issues related to Data guard.
Production Database upgradation from 10.2.0.1 to 11.2.0.3 in Data Guard environment.
Database migration from 10g (HP-UNIX) to 11g (RHEL) using RMAN, Transportable Tablespace and Golden Gate with zero down time.
Extract and Replication processes in Oracle Golden gate for table level replication.
Performing DR DRILL (Switch over and Switch back of Prod DB servers including Oracle & SQL Servers) for every quarter year as per client requirement.
Monitoring log shipping of SQL server databases.
Addition and resizing data files in SQL Server databases.
Shrinking of Log files in SQL Server databases.

Administrating & Maintaining Non RAC & RAC Databases with ASM.
Involved Oracle Database Installations 10g/11g on OEL-5.5 and RHEL -5.5.
Involved in Production Support (24x7).
Tablespace Creation and Maintenance.
Monitoring Space (Tablespaces, Extents) and allocating if needed.
Monitoring Alert log files for any Oracle errors and fixing.
Responsible for Managing users, roles and profiles.
Cloning Production Database for testing purpose periodically.
Database Security Planning and implementation.
Backup and Recovery (Manual Cold, Hot and RMAN).
Archive log Maintenance and Cleanup.
Export and Import of whole Database or Selected Schemas using Data Pump.
Creation of DB links on Production Environment.
Daily RMAN Backups (Level0 and Level1) and Export backups on all branches.
Worked closely with developers, Provided ORACLE DBA support and Technical support for multiple applications.
Monitoring the 10g 2 node RAC Databases.
OCR & VOTE DISK Backups
Addition, Deletion & Relocation of the Services and Disks to Disk group in ASM.

Other certificate

–

–

–