migrating some databases from Oracle to Exadata

• Upgraded Exadata machine from a half rack to a full rack
• Worked closely with the network team to ensure Exadata machine runs effectively
• Carry out both logical and physical database modeling using Microsoft Visco and Sql Developer
• Experienced in physical database design by creating materialized views, indexes, partitions and clusters
• Installation, upgradation, troubleshooting and configuring of Golden Gate 12c software
• Configuring Golden Gate Downstream Mining and integrated components for active-passive and active-active replication
• Administered seamless switchovers through skillful configuration of Data guard and Broker
• Oversaw 24/7 on-call support for 12 databases using Oracle 12c Cloud Control for alert monitoring and notification.
• Implemented logical database design to ensure data integrity and flexibility
• Installed and configured Golden Gate to work with Agent on OEM Golden Gate plugin
• Monitored and troubleshot Golden Gate replication issues
• Upgraded databases from 10g to 12C
• Configure RAC with its services like TAF for high availability and scalability
• Upgraded GI and databases from 11g to 12c while keeping physical standby databases in place
• Upgrade the ASM instance using rolling upgrade
• Monitor and troubleshoot RAC databases to maintain availability of production databases
• Migrated systems to Multitenant Architecture using CDB and PDB applications
• Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues
• During production hours, resolved lock and resource contention issues
• Provided tuning recommendations to application teams through troubleshooting systems using SQL baselines, SQL profiles, and SQL Tuning Advisor
• Identified root causes of SQL performance issues by analyzing EXPLAIN PLAN, SQL-TRACE, and TKPROF trace files
• Aided troubleshooting of performance issues through analysis of AWR, ASH, and ADDM reports
• Cloned and migrated small databases using import/export utilities, and used Data pump import/export for 11g/12c databases
• Applied patches (including Opatch), upgrades, and maintenance on all databases
• Utilized production data to refresh development and test instances regularly
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Provided technical assistance for installation and upgrading of existing Oracle databases.
• Performed database management functions such as maintenance, access issues and security.
• Experience installing, administering the Enterprise DB release of PostgreSQL
• Extensively utilized Oracle 11gR2 features, including Real Application Testing, Enhanced RMAN, Oracle Data Pump, EM Grid Control, and various others daily, and enhanced features in 12c such as table and partition recovery
• Implemented Oracle TDE to provide transparent encryption of stored data
• Managed the monitoring and troubleshooting of database replication issues
• Optimized results using EXPLAIN PLAN, SQL-TRACE, TKPROF, and STATSPACK to performance tune Oracle Database Objects
• Collaborated with application development teams to support and resolve any issues encountered
• Used Oracle Enterprise Manager to perform database monitoring, maintenance, replication processes, and performance tuning Florida Blue Jacksonville, FL Oracle Database Administrator December 2012
• January 2017
• Experience with migrating from on premise to Exadata machine using Golden Gate
• Converted non-RAC single instance to RAC database instances
• Installation, upgradation, troubleshooting and configuring of Golden Gate 12c software
• Configuring Golden Gate Downstream Mining and integrated components for active-passive and active-active replication
• Implemented procedures for automation of database management through tables and indexes.
• Executed processes for evaluation of system space, database allocation and storage metrics.
• Maintained all existing databases and new installations at current and stable production levels
• Installed 11gR2 RAC while performing disk group management in ASM
• Monitored health checks of OCR and VOTING DISKS while troubleshooting issues in RAC environment
• Ensured the secure and efficient operation of Oracle Database Systems
• Performed daily tasks such as resolving tickets, development support, and collaboration with application tuning
• Extensively monitored grid control database, error notification configuration, listener installation, and addition to grid control
• Created and implemented recovery strategies, and successfully recovered databases using RMAN
• Utilized RMAN utility to schedule and monitor physical backups in the CRON tab
• Created users, groups, roles, profiles, and granted privileges according to job needs
• Optimized and tuned SQL queries using SQL-TRACE, TKPROF, and EXPLAIN PLAN utilities
• Used integrity constraints and database triggers to maintain data integrity and security
• Applied security patches such as Patch set, Critical Patch Updates, and Patch Set Updates
• Used Transportable Table space (TTS) to quickly move a user's table space across Oracle databases
• Implemented data refreshes using RMAN, Data pump, and conventional export/import for Oracle 11g and 10g
• Installed and configured Oracle 11.2.0.1 database on AIX, SOLARIS, LINUX, and UNIX platform
• Successfully migrated from Oracle 11g to 11gR2 RAC database and 12c non-CDB to pluggable databases
• Upgraded databases from 11g to non-CDB 12c
• Successfully used materialized views and Oracle Streams in Oracle 10gR2 to perform data replication
• Implemented Table space level TDE security and created Oracle wallets
• Constantly monitored the performance of databases through viewing alert log and trace files
• Ran scripts to check status of databases, including free and used space, fragmentation, and oth