We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

San Antonio, TX

OVERVIEW:

  • Over 6 years of thorough experience as an Oracle Database Administrator. I have worked on Oracle 12c, 11g, and 10g versions supporting a full SDLC. DBA duties involved production support and project support. Activities include installation, configuration, backup and recovery, performance tuning, cloning, space management and security upgrades, patch management and database migration, Goldengate, Dataguard and RAC configuration.
  • Experienced with all facets of Oracle DBA day - to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
  • Extensive experience with Data Guard setup, troubleshooting, switchover, failover, active Data Guard, fast start failover and snapshot standby databases.
  • Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
  • Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
  • Installation and configuration, maintenance for Oracle Confidential .
  • Data Guard administration and maintenance.
  • Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
  • Installation, configuration, upgrade and performance tuning of Oracle 11g & 12c.
  • Installed and configured oracle Grid control (12cR1 and 11gR2) .
  • Worked on Upgrade/Migration of Databases from Oracle 11gR2 to 12cR1.
  • Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
  • Taking the RMAN incremental and cumulative backups.
  • Scheduling the databases backup using Cron tab and VERITAS net backup.
  • Perform Logical backup using full/partial export/import and data pump.
  • Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.
  • Cloning of production databases as needed for testing, development using RMAN or scripts
  • Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, data pump, Export, Import, PL/SQL, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, and Statspack.
  • Experience as 24x7 productions DBA as well the application (development) database administrator.
  • Expertise in all the phases of Software Development Life Cycle (SDLC).
  • Experienced in working with DBVERIFY utility and other method to find Data Corruption.
  • High experience in SqlServer replication using scripts.
  • Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Highly experienced in performance monitoring/tuning/troubleshooting.
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • I have created databases and tables using T Sql.
  • Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80G to 10TB
  • Experience in database patching, cloning, upgrade, migration & maintaining standby db server.
  • Experience with database backup, recovery, and setting up disaster recovery Database servers.
  • Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram,etc)

PROFESSIONAL EXPERIENCE:

Confidential - San Antonio, TX

Oracle Database Administrator

Responsibilities:

  • Installed and configured ORACLE 10g, 11g and 12c on HP-UX and Windows .
  • Database Security is my priority so I used Cloud Storage to Secure my Data.
  • Performed Upgrade of databases from Oracle 10g to 11g and 12c.
  • Planned and implemented physical backup & recovery procedures for the database using RMAN utility of Oracle 10g.
  • In my working environment I used Data on any of my devices and on any location
  • Creating the users and assigning them the required privileges.
  • Provided 24x7 on-call support as needed.
  • I have strong experience in installing, configuring Multitenant Architecture.
  • Have experience working with Financial Institutions like Credit Union.
  • Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
  • I have upgraded from 11g to 12C, install and created 12C databases.
  • I have created and patch Container and pluggable databases databases for high availability and performance.
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.
  • I have Monitor my SqlServer databases using Dell FogLight
  • Enjoy monitoring databases using tools like TOAD, SQL Developer and OEM Cloud Control
  • Replicating data from the source to the target with the use of a pump process.
  • Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Confidential .
  • I have solid experience in Grid installation, configuration and implementation.
  • Experience in Managing DDL and DML in Oracle databases.
  • Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities. .
  • Experience w ith creating, backup and recovery Mysql databases.
  • Hands on experience in EXADATA.
  • Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
  • Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, and also used Oracle Enterprise Manager(OEM) 11g and 12c to monitor single instance and RAC databases.
  • Administering and setting up of 11G RAC and 10G RAC clusterware and instances.
  • Experience with Exadata as preconfigured database cluster server.
  • Hands on Experience with OLTP and OLAP .
  • Hands on database and storage servers.
  • I have great experience in Transparent Data Encryption TDE
  • I have Encrypt data at the password, column and database level for high security before it is replicated from source to target
  • Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
  • Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Implemented 11g Interval Partitioning for monthly partitioning of large tables..
  • Experienced in PL/SQL stored procedures.
  • Experienced in OLTP and OLAP
  • Experience in ETL in Data Warehouse
  • Use Oracle GoldenGate to move reporting Load from Production environment to Data Warehouse environment.
  • I monitored and troubleshoot the Extract Process, the Trail Process for real time replication.
  • Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Confidential and worked with conventional EXP/IMP for migrating data from 10G to 11G.
  • I backed up my databases using Sql Server Management Studio.
  • Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
  • Handled Chained Rows and Row migration, and solved the database performance issues.
  • Experienced with ASM, adding, deleting disks to the disk group.
  • I have used backup strategies like Full backup, Incremental and Transactional log backup.
  • I have created functions and Procedures using Sql Server Management Studios. the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU .

Confidential- Irvine, CA

Oracle DBA

Responsibilities:

  • Installed, configured, and maintained Oracle 10g, 11g R2 on Linux and also Upgraded from Oracle 10g to 11g..
  • Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production.
  • Standby Database (Data Guard) setup and configuring DB links.
  • Developed 2 node RAC environments for a 3TB database.
  • Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
  • Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
  • Responsible for all database activities such as User management, space management, database security management.
  • Implemented the resizing the online redo logs in production and in standby database.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
  • Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Collecting performance statistics using Statspack/AWR and analyzing by ADDM .
  • Refresh/Cloning of Database from production environment to test environment and application of patches.
  • Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
  • Provided 24X7 support for all the production and development databases.

Environment: Oracle 10g, 11g, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Hire Now