Oracle DBA
SUN PRODUCTS CORPORATION
06.2018 - Current
- Installation and configuration of Oracle 12c, and 18c/19c in UNIX/LINUX (RHEL)
- Installation and configuration of 12c Container Databases on standalone servers and clusters on Unix platforms
- Experienced in rewriting SQL queries, understanding views, stored procedures, triggers, and optimization
- Implemented data guard (Physical) for high availability/disaster recovery solution
- Managed Databases using Oracle Enterprise Manager (OEM) 13C
- Worked with daily export and import of databases and schemas as needed
- Generated AWR, and ADDM, Explain Plan, and reports for Performance tuning
- Used Explain Plan, Oracle hints, and creation of new indexes to improve the performance of SQL statements
- Identify performance issues, and recommend/implement performance improvements
- Managed, configured, and maintained Oracle databases on AWS infrastructure
- Implemented and maintained Oracle database security in the AWS environment
- Hands-on experience in cloning and upgrading 12c non-container databases to 19c pluggable databases using the PDB Metadata clone, PDB Remote Clone, and PDB Snapshot cloning feature
- Hands-on experience in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN
- Created Oracle Wallets and implemented Tablespace level TDE security
- Scheduled RMAN backups, purge jobs, and Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, and Crontab
- Designed and implemented different backup strategies like Cold, Hot, and RMAN with Flash Recovery Area and Logical Backups
- Experienced in creating and managing users and privileges in a Multitenant Environment
- Hands-on experience in patching and upgrading a multitenant container database
- Monitor and troubleshoot database issues with OEM 13C cloud control
- Cloned/Migrated databases using RMAN and traditional Data-pump export/import utilities in Oracle 19C
- Involved in Performance Tuning by using tools/utilities by Automated Workload Repository
- Worked on database migration projects, moving on-premises Oracle databases to AWS using AWS Database Migration Service
- Perform/schedule database maintenance, maintain/execute backups, and recoveries
- Provided 24X7 support for databases in production and operation teams
- Managed Database (User Management, Tablespace Management, Performance Related Issues)
- Utilized Oracle Support to troubleshoot and resolve critical database issues
- Monitoring Database Growth and space administration
- Mentored and cross-trained interns.
