SUMMARY:

• DataGuard, Golden Gate Active Exadata Performance Tuning & Capacity Monitoring
• RMAN Backup & Recovery, Amazon, AWS Standby/Failover Administration OEM Database migration and cloning, Triggers PL/SQL, TOAD, SQL Server, SQL Developer.
• Data Profiling, querying and reporting RAC (Real Application Cluster) setup and tuning.

PROFESSIONAL EXPERIENCE:

Confidential, Georgia

Oracle DBA

Environment: Oracle RAC, IBM - AIX, Solaris, OEM Grid Control, RMAN, ASM, CRS, Webserver, Export/Import, SQL, PL/SQL, CDC, TOAD, Shareplex, AWS Amazon

Responsibilities:

• Install, Configure Oracle RAC wif ASM on Linux (Red Hat), Unix systems
• Installed and configured Grid Control to monitor RAC and Non RAC instances
• Create single instance database and real application cluster wif the requested specification.
• Monitoring database connectivity and database growth.
• Configure physical & logical standby databases using Oracle Dataguard for disaster recovery
• Switch over and fail over of Oracle Dataguard databases for Disaster recovery testing using Oracle Dataguard broker DGMGRL.
• Provided DBA implementation and support for Oracle migrations and upgrades, including environments using Oracle Data Guard.
• Monitored the database environment, ensured that the database met performance standards
• Perform database upgrade
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle
• Restore the databases, datafiles, tablespaces from the backups in case of any data loss
• Configure, Manage, and monitor RMAN backups (Cold Backups, Hot Backups)
• Refresh the test environments wif Production data using RMAN duplicate & Data pump
• Perform a cross-platform database migration wif imp/exp datapump.
• Participate in Disaster Recovery planning, implementation and recovery
• Designed Disaster Recovery strategy for application database and implemented.
• Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition tables and maintaining index's
• Identify and fix database block corruption by restoring the data from the recent backups
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized View, AWR, ADDM, ASH etc.
• Performance tuning of the Oracle databases and SQL queries by analyzing the EXPLAIN PLAN’s to improve the performance of the database and application end users.
• Analyzed database performance and tuned database wif Orachk and SQL Explain Plans.
• Involved in Security Management and monitoring all kinds of Privileges to Users, roles...
• Patch the CRS, ASM, RDBMS and Grid Infrastructure homes using Opatch utility
• Interact wif Storage team, Network team, Sysadmin team to get the prerequisites fulfilled for RAC installation
• Enabled Flashback for database to create restore points and supporting DDL changes
• Used Oracle database vault and proactively protecting application data, Created Oracle Wallet Involve in deployment meetings before application new/upgrade Releases
• Established the processes and educated the less experienced team members to take care of the activities.
• Managing table spaces, data files, redo logs, tables and its segments
• Created user, views and tablespaces, allocation of appropriate tablespace quotas wif necessary privileges and roles for Oracle databases.

Confidential

ORCLE DBA

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, 10g/11g, EDW Applications, Goldengate11g, 12c, Orachk, TFA, oratop, WebLogic console, Dataguard 11g/12c, Explain-Plan,database Vault, SQL-T, SQL-HC, GoldenGate, OPatch, SQL Developer, Encryption, Migration,, SQL profiles, Wallet-Management, Data Pump, Business Objects, putty Perform upgrade of 10g and oracle 11g and install and configure oracle 11g

Responsibilities:

• Install and configure Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point.
• Implemented Golden Gate 10g/11g replication for 104+ databases Perform schema migration
• Plan and install change control, verification of system resources, backup and recovery, disaster planning, performance tuning and troubleshooting
• Tuning of SQL queries to troubleshoot and resolve database or application problems encountered by end users.
• Designing & implementing Oracle Golden Gate 10g/11g replication to remote sites (active/passive and active/active) for disaster recovery.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Change data capture, platform migrations & load balancing
• Created dataguard physical standby database
• Performed upgrades to databases while coordinating wif Application DBAs.
• Support Banner Finance ERP System and all third third-party interfaces, reporting applications and databases.
• Setup Data Guard Broker to manage data guard environment
• Modifying database object's structures as required by developers due to business or application requirements.
• Partitioning Table to increase performance and using Advanced Compression
• Monitor database health or generate alert log, AWR or ADDR to perform tune up and resolve database performance problem
• Setting up GoldenGate extracts and replicates and monitor the lag wif automation.
• Managed Oracle databases on multiple platforms to include IBM AIX/Linux, Sun Solaris Unix, HP-UX, and Windows, as well as different versions of Oracle including Oracle 10g and 11g
• Perform oracle database patching, and cloning
• Used RMAN to perform backup and recovery and schedule cron job
• Configured ASM disk groups to store datafiles, redolog files, and control files.
• Performed database management functions such as maintenance, access issues and security.
• Conducted designing, assembly and tuning of databases in coordination wif development teams.
• Evaluated database performance for investigation of issues and further resolution for efficiency.
• 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.