Oracle Databases Administrator

Shweta Pol

Email: ***********@*****.***

Phone: 857-***-****

PROFESSIONAL SUMMARY

An astute Oracle DBA with around 6 years of experience maintaining Oracle Databases, Grid Infrastructure running on UNIX/LINUX (Oracle Linux, Sun Solaris, HP-UX, AIX, RedHat Linux) and Windows.

Experience in managing and supporting database Oracle 8i, 9i, 10g, 11g, 12c, 18c with experience in very large-scale database environment and large OLTP and OLAP systems.

Experience in troubleshooting, administering and setting up Dataguard for Disaster recovery purpose.

Experience in Cloning databases using RMAN as well as User managed cloning.

Expert level skills in setting Backup and Recovery Procedures using RMAN and Flashback Databases.

Proficient in installing and configuring Oracle Enterprise Manager and Grid Control for database monitoring/performance/diagnostics.

Experience in Oracle RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).

Proficient in Import and Export backups, Online and Offline backups and recovery, Cold and Hot backups using Datapump utility.

Experience in maintaining tables, indexes, views, materialized views and optimize queries.

Involved in migrating of non-oracle databases to Oracle database.

Experience in SQL and PL/SQL, writing stored procedures, triggers and functions.

Upgraded very large number of databases to latest versions at different client location depending on the current versions available in market.

Experience in applying patch sets, Security Patches and Interim patches.

Experience of user, system and security administration processes understanding of Federal guidelines

Worked as a part of team in 24x7 production environment/on-call and day-to-day support.

Excellent communication and inter-personal skills and have ability to work under pressure and strict deadlines.

TECHNICAL SKILLS:

Database Oracle 18c/12c/11gR2 & R1/10g/9i/8i

Operating Systems RHEL, Oracle Linux, Solaris, Windows Languages SQL, PL/SQL, C

Tools/Utilities RMAN, Data Guard, OEM, ASM, TOAD, SQL*LOADER, OEM, SQL Developer Role: Oracle DBA

Client: The Walt Disney. Mar 2018 – April 2020

Database Responsibilities:

• 24 X 7 Production database support and administration and on call rotation for managing Prod/Impl/Test/Dev databases and applications support.

• Installed and configured installation and maintenance of Oracle RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery on Red Hat Linux.

• Upgraded many databases and Grid infrastructures from 11g to 18c.

• Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases maintenance.

• Experienced in performing Point-in-Time Recovery and block recovery using RMAN.

• Experience in maintaining Automatic Storage Management (ASM) for Oracle 11gR2 RAC databases.

• Involved in performing Migration from Oracle 11gR2 to Oracle 12c RAC database.

• Performed database Refreshes using Export/Import, Datapump and RMAN.

• Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.

• Experience in logical backups and database migration tools with Datapump and RMAN, Export/Import and Transportable Tablespaces.

• Performing Analysis and Diagnosis of database performance statistics.

• Performance Tuning using Explain Plan, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM, etc.,

• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.

• Administration and health monitoring of Oracle Instances, Users, Tablespaces, Memory Structures, Roll Back Segments, Redo Logs, Archive Logs and Alerts Logs to diagnosing the problem.

• Experience in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

• Applied various patches (CPU, bundle, quarterly, etc.) and upgrades on regular basis according to the suggestions from oracle support department and familiar with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.

• Experience in database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

• Worked closely with a development team to make sure the database tier is used in the right way.

Environment: Oracle 11g R2, 12c RAC, Oracle Identity Manager, RHEL 6.x, OEM Grid Control, OEM Database control, Shell Scripting, SQL Plus, TOAD and other Oracle Tools. PROFESSIONAL EXPERIENCE:

Client: ATT Feb 2017 – Mar 2018

Role: Oracle DBA

Responsibilities:

• Provided 24X7 support for all the production and development databases.

• Installed, configured, and maintained Oracle 10g and 11gR2 and upgraded databases from Oracle 10g to 11g.

• Experience in maintaining Automatic Storage Management (ASM) for Oracle 11g RAC databases for reducing disk contention and providing centralized management for disks.

• Monitoring and administrating RAC databases on Oracle 11g Clusters.

• Creating and maintained databases using DBCA and manually as well.

• Monitoring of Oracle Instances, Users, tablespaces, memory structures, roll back Segments, redo logs, archive logs and alerts logs.

• Created User accounts, Roles and granting required access permissions and privileges to the users.

• Managing backup strategy for all production databases (at least double redundancy).

• Used Datapump for Exporting and Importing schemas and tablespaces.

• Performed database Refreshes using Export/Import, Datapump and RMAN.

• Database Backup & Recovery for non-archive and archive database with RMAN.

• Experience with Backup, Cloning, and Recovery using RMAN utility.

• Performing Analysis and Diagnosis of database performance statistics.

• Tuning performance using Advisors, AWR, ADDM, SQL tuning, etc.

• Experience with SQL Review and Tuning on Oracle 10g and 11g databases.

• Experience working with PL/SQL scripting and programming.

• Applied various patches on regular basis to oracle software homes.

• Performed database Migration from Windows platform to Linux using RMAN and Datapump.

• Reading Alert Log and User trace files and diagnosing the problem.

• Involved in performing Migration from Oracle 11gR1 to Oracle 11gR2 RAC database.

• Migration of data between databases over the network.

• Efficient in using the Oracle tools like SQL Plus, TKPROF, STATSPACK, Datapump, Flashback, Dataguard, ASM and RMAN.

• Worked closely with a development team to make sure the database tier is used in the right way.

Environment: Oracle 11g R1 & R2 RAC, RHEL 5.x/6, OEM Grid Control, OEM Database control, Shell Scripting, SQL Plus TOAD and other Oracle Tools. Client: Interstate Batteries, Texas Jan 2016 – January 2017 Role: Oracle DBA

Responsibilities:

• 24x7 Oracle Database Administrator for Production, Development and Standby databases and provided on-call support.

• Installed, configured and maintained Oracle 11g software on RH Linux Servers.

• Created and monitored Physical standby databases on maximum protection Dataguard for Disaster Recovery and performing production databases maintenance.

• Monitored Standby Databases and performed switchover mechanisms of Dataguard.

• Involved in performing migration from Oracle 10g to Oracle 11g database.

• Applied different patches as they were release by oracle on regular basis.

• Monitored databases using Enterprise Manager and resolved issues based upon severity level.

• Loaded/Refreshed data into database using Export, Import and Datapump, etc.

• Experience with Full/Incremental backups using Oracle Recovery Manager (RMAN).

• Created Clone and Duplicate databases for different environments using RMAN.

• Performed Backups (Full, Cumulative, Differential), Recoveries using RMAN

• Created Materialized Views/Materialized Views Logs for data replications.

• Tuned SQL and PL/SQL code using Oracle Enterprise Manager (OEM) Tools, Query Analyzer and Explain Plans.

• Monitored and tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.

• Creating and dropping of users, granting and revoking rights as and when required on Oracle databases.

• Administrated database regarding space related issues- monitoring tablespaces, users security of data accessibility and Configuring archive log destinations and flash recovery area.

• Managed and resolved admin issues during development stage. Worked closely with developers.

Role: Junior Oracle DBA

Client: ICICI Bank, India. July 2010 – March 2012

Responsibilities

• Performed day-to-day DBA jobs for managing Production and Development databases.

• Provide database administration on production and development database servers.

• Experience in data conversion from 9i to 10g.

• Good experience with Oracle production database (physical database implementation and administration).

• Migrated Oracle 10g non-ASM Database to ASM Database using RMAN.

• Restore and recover of the databases using RMAN (point-in-time recover, media failures recover, data files recover and block recover).

• Backup & Recovery (Hot and Cold, RMAN and classic methods), involved in Disaster Recovery procedures.

• Performed Data guard set up for failover strategy.

• Estimated Storage requirement, creation of tablespaces and other database primary objects.

• Implementation and maintenance of database security. Major point of contact of database users as and when required and administers their respective quotas. Create and maintain roles and assign necessary privileges to users according to business rules.

• Clone/Refresh of production databases to testing and training environments.

• Develop/customize shell scripts to automate routine DBA tasks of taking backups, exports and monitoring space availability and database performance database.

• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.

• Creation and maintaining users, profiles and roles and maintaining system security.

• Interacted with oracle support for resolving various critical database issues. Environment: Oracle 9i/10g, Redhat Linux Server, Windows Server2003, OEM, SQL Plus. EDUCATION

• Master of Science.

Reference: Reference will be provided as required.

Contact this candidate