SUMMARY:

• 9 years of experience as Oracle DBA. Worked extensively on Oracle 12c, 11g and 10g involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Build and managed Active Data Guard
• Mentors the team on technology concepts and ensures team compliance to best practices for design
• Managed database using command line, SQL Developer, TOAD, OEM
• Experience in applying CPU and PSU Patching
• Maintained databases and alerts from 13c cloud control (OEM)
• Migrated standalone databases to RAC on Exadata
• Performed RDBMS and Grid upgrades
• Applied CPU, SPU, PSU, CRS Bundle patches
• Worked on Migration projects and Upgrade projects.
• Possess intermediate experience in SQL Server Database Administration.
• Worked as a lead in Data Centre Consolidation on large database systems.
• Worked as a primary support for database related issues with clients.
• Worked on multiple projects in parallel to daily DBA activities.
• Worked with RMAN on various backup policies
• Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Worked as a team member to provide 24x7 on - call production database support
• Database replication using snapshots, materialized views and advanced Replication methods
• Excellent communication and interpersonal skills
• Worked on High availability of the databases including RAC, ASM and Data Guard on Oracle Exadata
• Familiar with Oracle Cloud.
• Worked on AWS Cloud.
• Build new instances on Oracle on AWS
• Migrated in-house oracle instances to AWS instances.
• Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
• Migrated database on Exadata on-prem
• Have familiarity with RAID configurations.
• Worked on Oracle Security using Oracle Vault, Wallet and TDE.
• Good knowledge of Oracle Dictionary Views.
• Installed databases using silent install.
• Provided 24/7 support on on-call rotation.
• Upgraded Oracle databases.
• Worked on 12c Multitenant databases
• Excellent at setup and managing GoldenGate Replication
• Build 12c R2 RAC from scratch including Linux OS installation.
• Partitioning - system partition, virtual column base partition, partition, composite partition and range-range partition
• Table compression enhancement.
• Build Unidirectional and bi directional GoldenGate replication.
• Familiar with Oracle Auditing
• Familiar with Oracle TDE (Transparent Data Encryption).

TECHNICAL SKILLS:

Operating Systems: RHEL, HPUX, AIX, Sun and Windows

RDBMS: Oracle 18c, 12c, 11/10g, 9i, SQL Server

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views.

Languages: SQL, PL/SQL, UNIX Shell scripting

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, TOAD, dbconsole, asmcmd

Tuning Tools: tkprof, EXPLAIN PLAN, STATSPACK, SQL Advisor, SPA

WORK HISTORY:

Oracle DBA

Confidential, Omaha, Nebraska

Responsibilities:

• Build new database servers on AWS.
• Migrated Oracle instances to AWS.
• Managed 11g and 12c multitenant database on RAC.
• Moved databases to Exadata x7.
• Monitored Oracle databases using Oracle Enterprise Grid Control 11g and 12c cloud control.
• Managed backups restore and recoveries using RMAN.
• Very comfortable in refreshing database, schema and tables using Oracle Data Pump
• Worked with Infrastructure team to increase space on ASM and Files system disk storage.
• Applied on-off, PSU and bundle patches.
• Created indexes, rebuilding indexes, dropped indexes and analysed indexes for improvement of performance.
• Build 2-node RAC Cluster.
• Worked on logical backup using and full/ partial export/import and Data Pump.
• Configured and maintained RAC clusters on both ASM file management.
• Restored and recovered database and ARCHIVLOG using RMAN from backup on same servers and on different servers.
• Configure database backup on Commvault.
• Worked on backup, recovery and disaster recovery strategy using RMAN.
• Worked on closely on FRA and been member of team to increase FRA size.
• Managing Instances redo log files, temp files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Clone database using RMAN Duplicate.
• Worked on table partitioning
• Automate jobs using corntab, shell scripts and OEM.
• Worked on Flashback databases.
• Restore, recover tables using export/import, FRA and RMAN.
• Performed point-in-time recovery.

Oracle DBA

Confidential, San Francisco, CA

Responsibilities:

• Responsibilities include maintaining databases, monitor daily database activity, implement customer requirements, coordination, performance tuning.
• Silent install 11g databases and 12c databases.
• Installed 2 node and 4 node clusters on Exadata
• Migrated databases to another datacentre.
• Build Unidirectional and bi directional GoldenGate replication.
• Worked closely with offshore DBAs
• Worked closely with Storage Admins to space build ASM database servers
• Designed and Implemented database security using Oracle roles and privileges.
• Maintenance of the RMAN repository database and configuration of backup policies.
• Installed and administered RAC databases.
• Setup monitoring using 11g grid control and12c cloud control.
• Implemented Data Guard for DR purpose
• Implemented Incident rule creation, Mail Server registration, Email subscription from OEM
• Converted the single instance dbs to RAC clusters
• Worked on instance and SQL tuning
• Took part for database session information, table privileges permissions and database health check.
• Responsible for completing Database Refresh requests on both Oracle 12cR1 and 11gR2.
• Regularly monitoring database scheduled backup, gathering stats disk space utilization.
• Designed and maintain Database security using Oracle Roles and privileges.
• Monitored and troubleshoot issues for GG process lags or abended process and fixed issues.
• Applied patch to Goldengate.
• Written shell scripts to automate jobs
• Creating Indexes, rebuilding indexes, analysing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers
• Upgraded Databases from Oracle 10g to 11g
• Worked on Flash Recovery Area
• Performed DR switchover / failover practices using Data Broker.
• Patched Oracle databases using opatch utility.
• Generated triggers for data integrity, created views to resolve complex queries.
• Used RMAN duplicated database to clone.
• Used export import and Data pump to refresh schemas.
• Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• Worked on Materialize views
• Provided 24/7 on-call support.

Oracle DBA

Confidential, Downers Grove, IL

Responsibilities:

• Installation, configuration and troubleshooting of Oracle Database Software 9i and 10g on RHEL 3.0 and 4.0 environment and RAC setup with ASM.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Worked on backup, recovery and disaster recovery strategy using RMAN.
• Configured and maintained RAC clusters on both ASM and non-ASM file management
• Involved in upgrading data warehouse database version from 10g to 11g.
• Monitored Oracle databases using Oracle Enterprise Grid Control.
• Implemented Oracle Failsafe to setup RAC environment on windows platform.
• Responsible for completing Database Refresh requests on both Oracle and SQL Server databases.
• Involved in User Management, creating new user ids, assigning them roles and privileges, monitoring their activity.
• Working with the automated DMA patching process which includes identifying, staging Patch Binaries, applying and rollback Patches.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
• Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Extracted data from Oracle database into XML format for EDI requirement.
• Worked on logical backup using and full/ partial export/import and Data Pump.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.