Skills
Oracle DBAAWSRACRMAN backupLinuxAIX UnixRDSASM MigrationGoldengateDescription
SUMMARY:
- 10 years 6 Months of Database Administrator experience with excellent performance on diversity of projects.
- Handled Financial, Telecom, Health Care, Airways, Insurance, Cinema, Retail, Stock based, Product based and government projects throughout my career.
- AWS Certified Solutions Architect – Associate.
- Supported Oracle Database from 10g through 21c versions, database migrations, upgrades, backup, disaster recoveries performance.
- Hands on experience of Oracle RAC Installation.
- Upgrading of Database (12c to 19c) on demand of the client within ATS period.
- Hands on experience of Oracle Data Guard setup including switchover and failover.
- Conversant with RMAN for Backup and recovery, Data guard for Disaster recovery, Installation ,Configuration, Migration, upgrade, cloning, patching.
- Experience in Oracle Database Installation and configuration of different on Operating System.(Linux,Aix,RDS)
- Hand on experience implementation as RAC Solution in AWS (EC2).
- Hands on experience on migration of databases from on-prem to AWS environment.
- Hands on experience of Standalone Database to ASM Migration.
- Hands on experience of implementation of AWS DMS (DMS - as a Goldengate)
- Experience in Amazon (AWS) cloud Administration task Like create an Instance, Instance Termination, AMI backup, IP allocation, IP whitelisting, Migration of oracle database on premises to AWS RDS,EC2(oracle) Instance.
- Hands on experience of implementation Oracle Restart in AWS,On-Prem.
- Oracle Setup the TDE for target database.
- Oracle Cloud Monitoring and Management.
OVERALL PROFICIENCY :
- Administered over 500+ Oracle databases as well as played a role of lead in the team and performed other management related tasks as and when required.
- Presented architect level plans to client as per requirement for new and current projects.
- Worked on multiple Application releases from database perspective.
- Full Cycle implementation of Oracle Database 10g,11g,12c,18c &19c.
- Installation, maintenance & upgrades of databases starting from 10g to 11g to 12c to 18c to 19c.
- Worked extensively on different backup utilities like RMAN, export/import and Data Pump.
- Participated in reviewing current architecture and presenting suggestions followed by strategy to upgrade the Architecture and improving the performance without exposing the business to any kind of risk.
- Understanding Client’s requirements for UAT, DEV and TEST.
- Performed cloning and refresh of Oracle Databases accordingly with utmost Client satisfaction.
- Worked with Client and Users on issues to keep the business up and running hassle-free.
- Coming up with quick workarounds as per client requirement to keep the systems up and running like moving datafiles from ASM to File System in case of space crunch on Disk Groups.
- Attended CAB meeting as and when required to explain the Change request raised with the impact and roll back plans.
- Provisioning new databases on Standalone systems, RAC One Node, Multiple Nodes and Oracle Active Passive cluster for different projects.
- Planned and performed dry runs for multiple clients before going live.
- Planned Disaster recovery strategies and created Standby databases accordingly for multiple clients.
- Focused approach towards documentation to keep human error risk to minimum and to keep a check on progress.
- Patching of Standalone, RAC databases and Databases running on Linux, AIX Platform.