Oracle Database Administrator Resume Example Company Name

ORACLE DATABASE ADMINISTRATOR

Experience

Oracle Database Administrator, 09/2013 to 05/2018
Company Name – City, State

As a Sr DBA, manage Oracle database administration assignments for one of the US Pharma giant XXX.
Client coordination for new requirements, technical and functional business.
Database migration planning, design and implementation of DR solutions, perform restores, implement recovery procedures, and handle performance tuning, conduct regular system backups and providing solution within SLA.
Responsibilities: Installed Oracle DB 10g, 11g.12c RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Managing Data Guard, Replication, Backup and Recovery support and performance tuning etc.
Applying Quarterly patches and Version change patch bundles.
Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
Worked on Disaster Recovery by converting physical standby databases to Snapshot standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
In addition, tested disaster recovery with database failover and switchover also tested Golden gate (OGG) replication using DBFS Filesystem and ACFS for GG binaries.
Responsible for setting up and maintaining the user accounts and providing required privileges for database access.
Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) , and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4).
As part of performance improvement by utilizing the new features.
Migration of databases from Non-ASM (filesystem also referred as Logical Volumes) to ASM i.e.
Automatic Storage Management.
Applied the Clusterware (GI), Database (RDBMS) Patches i.e.
PSU patches and one-off patches (for Bug resolution) using opatch.
24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Cloned and refreshed development and staging databases from production for development and testing.
Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation. is documented for future reference.
Determine time estimates and schedule for own work and resolve issues in timely manner.
Providing assistance in activities such as knowledge sharing and knowledge transfer.

Oracle Database Administrator, 06/2012 to 08/2013
Company Name

1 years and 3 month) Associated with Aricent technology LTD to take care of database administration assignments for Indian telecom MTS Mobile.
Ensure DB 99.9% DB uptime, patching, upgrade, DR simulation, perform restores, implement recovery procedures.
Provided 24 X 7 Production support and acting as Shift lead for team of 10 DBA's.
Responsibilities: Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control (OEM) OMS Installation.
Administration of 2-Node 11g R2 RAC with ASM on Exadata(OEL).
Administration of 8-Node 11g R2 RAC with ASM on HP-UX.
Administration of 11g R2 Active-Active standby Databases.
Cloning of databases from production to test environments.
Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
Worked on OEM 11g grid for monitoring the Listeners present in the oracle environment.
Worked in troubleshooting RAC and implemented ASM features.
Addition and removal of nodes to RAC.
Applied necessary Patches during installation and in up-gradation of databases.
Applying Quarterly patches and Version change patch bundles.
Well Experienced in taking Backups for a very huge 15-Tb Database.
Daily backups using RMAN.
Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
Having good experience in user management, Table space Management, Session Management, undo Management issues.
Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
Involved and Upgraded Analytical Databases from 10g to 11g.
Handy in utilizing Data Pump tool for exporting and importing the data between databases.
Used Data Pump for schema refresh and RMAN for database refresh and used RMAN for backing up databases.
Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
Having good exposure in user management, Table space Management, Session Management, undo Management issues.
Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
Generated AWR , ADDM and ASH reports for database issues Installed 12c agents on hosts and discovered targets.
Environment : Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC,ASM, Grid, Dataguard, Net-Backup, Team quest tool.

Oracle Database Administrator, 07/2010 to 06/2012

DBA team lead Access Infotech india (P) Ltd, Chandigarh, INDIA Client: Spice digital/IAI/ MAX Specialty /IDEA/Ihsystem/IDS Infotech Manage Oracle database administration assignments for various clients like Spice digitel, Max specialty products,Ihsystem, Idea and DBA assignment for AG Accounts.
Ensure DB 99.9% DB uptime, patching, upgrade, DR simulation, perform restores, implement recovery procedures.
Provided 24 X 7 Production support.
Responsibilities: Involved in Installation and customization of Databases (11g &10g).
Periodic data refresh from production to testing environments, Re-organizing database structures.
Involved in Schema management, Table space Management, User Creation.
Involvement in space management, rectification of lock problems, managed quotas for tablespaces as per needed.
Implemented Data-Guard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases at the times of up-gradation and migration.
Upgraded and applied patches as and when required.
Database Refreshes from Prod to Dev.
Troubleshooting Day-to-Day Users Issues in various modules.
Evaluated the hardware requirements before upgrading/migrating the database.
Good experience with recovery managed backups i.e.
RMAN Cloning of Databases using RMAN.
Scheduling the databases backup using Crontab.
Migrated the database from non-Oracle to Oracle i.e.
SQL Server to Oracle.
Maintained and audited Application and data servers.
Documented the complete project including all pre installation, post installation and database configuration steps.
Manage users, privileges, profiles, and schemas.
Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
Used analyze table, analyze indexes to tune queries and increase performance.
Environment: Toad, Oraclecle9i/10g/11g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, Shell Scripting.

Education

Master of Computer Application: July 2009
Uttar Pradesh Technical University -

Summary

Over 8+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform. Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems Administration of 2-Node 11g R2 RAC with ASM on Exadata(OEL). Administration of 8-Node 11g R2 RAC with ASM on HP-UX. # Administration of 3-Node 11g R2 Extended RAC with ASM on Rhel 6.6 Administration of 11g R2 Active-Active standby Databases. # Implementation and configuration of Oracle Golden Gate to replicate the data for reporting purpose. RAC Installation and Maintenance, setting up and configuring Dataguard, performing all kinds of Backups and Recoveries, Cloning databases. Hands on experience in Oracle 10g and 11g RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to this cluster database for High Availability and Recovery. Migrated Single Instance databases to RAC Environment. Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases. Sound knowledge of database patching (PSU, CPU, bugfix, Rolling patching) methods in RAC and non RAC DB's. Good experience in UPGRADATION from 10.2.0.x to 11.2.0.x & 11.2.0.x to 12.1.0.x Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate. Standby/Failover Administration. Creating standby database, data guard and performing DR simulation. Have good knowledge about Physical and Logical structure of a database. Configured and Maintained RMAN Catalog Database and schemas and involved in registering the Databases to RMAN Catalog. Experience in Performance Tuning, Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-TRACE, TKPROF, ADDM and Explain Plan Methods. Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance. Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN). Experience in Database migration using tools like DATA PUMP, Export/Import and Transportable Tablespaces and RMAN Duplication. Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner. Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS). Experience in database cloning with RMAN, Database Refresh and Patch management. Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment. Experienced in maintaining databases on large Production, Testing and DEV environments. Experience as On-Call 24x7 production DBA support, application/development DBA. Proficient in working with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments. Excellent oral and written Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams Accountable for Database Servers Administration including DB binaries installation, post installation and troubleshooting. Supporting more than 200 Database's, as primary DBA, including both Production and Development ranging from 500 GB to 50TB. Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery. Cloning and refresh of Oracle Database. Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures. Good work exposure on Service Now/Remedy, a ticketing tool for Incident / Request / Change Tickets.

Highlights

Databases Oracle 12R1 and R2,Oracle 11g R1 and R2, Oracle 10g and Oracle 9i
Administration Tools RMAN, Export/Import, Datapump, OEM, TOAD, SQL*Loader,
TKPROF, SQL*PLUS, AWR, ADDH, ASH, Shell Scripting, Crontab utility tool
Languages PL/SQL, SQL,
Web Tools XML, HTML, TCP/IP
Operating System Oracle Enterprise Linux (OEL), RHEL, Unix, Sun Solaris & Windows
Technologies Oracle Exadata, RAC - Real Application Clusters, ASM - Automatic Storage Monitoring, Dataguard, DG Broker, RMAN

Skills

IBM AIX, AIX5.1, ASM i, ASM, Backup, c, catalog, hardware, Client, clients, database administration, DBA, Databases, Database, Disaster Recovery, XML, features, functional, HP-UX, HTML, IDS, team lead, Linux 5.5, Linux, Managing, MAX, Access, Windows, Migration, MTS, Enterprise, Operating System, Oracle 9, Oracle i, Oracle, Oracle database, Oracle DB, DB, PL/SQL, organizing, processes, quest, RDBMS, read, real-time, requirement, Scheduling, Servers, Shell Scripting, simulation, SLA, Sun Solaris, sql, SQL Server, SQL*Loader, Switch, TCP/IP, telecom, TOAD, Troubleshooting, UNIX, upgrading, upgrade, utilities, Net-Backup

Additional Information

Achievements: Awarded as Technical Excellence in the area of Tech Ltd. Part of team awarded as Star Team of the month Tata Consultancy Services. Awarded as Employee of the month Aricent Technology. Awarded as Best Team lead for Access InfoTech India.

Resume Overview

School Attended

Uttar Pradesh Technical University

Job Titles Held:

Oracle Database Administrator

Degrees

Master of Computer Application : July 2009

Oracle Database Administrator Resume Example

Resume Score: 90%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes