We provide IT Staff Augmentation Services!

Oracle Dba Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • A SME with over 12 years of Oracle experience and some mySQL experience in a challenging and dynamic environment
  • Tune via GRID - CONTROL/CLOUD CONTROL 12c (create recommended indexes, SPA, SQL-PROFILE, compare new/old plan, view top activities, top SQL, etc…)
  • Working knowledge of Windows Server 2008/2012/2016 Administration
  • Works independently and as a team member (with a diverse group of people)
  • Install and configure linux (Oracle linux, RHEL 4 and 5) and Oracle on physical and VM Ware.
  • Ability to learn new technologies quickly performance tuning of database tables
  • Build VM and ORACLE VM VirtualBox
  • Expertise in creating/scheduling the Cron Jobs
  • A self-motivated person who is able to work on multiple projects
  • Effective verbal and written communication skills, high level of initiative, team member, and multitasking ability in a large organization
  • Excellent troubleshooting and problem solving skills
  • Excellent attention to detail
  • Flexibility and adaptability within a changing and fast-pasted environment
  • Administer data bases on various environments (dev, test and production)
  • Experience with Virtual servers (install, configure, install OS linux, install ORACLE/create database
  • Ability to work on multiple projects simultaneously
  • Expertise in data loading via export import, SQL Loader, data pump and external tables
  • Good data modeling, skills using ER Win and on paper
  • Set up and manage database security by creating new users, roles, profiles, views
  • Synonyms and provide required user privileges
  • Expertise in database installation, configuration supporting OFA standards, proactive
  • Conduct performance monitoring and tuning, migration, storage management, user management
  • Developed enterprise requirements and standards of (backup and recovery, standup new instances, standup standby databases, golden gate replications, how to trouble shoot known issues, similar file system layout on all servers, etc....)

TECHNICAL SKILLS

  • MySQL, RDB, Strong problem solving skills, Expert Golden Gate 11g & 12c, RAC, OpenVMS, Expert Data guard: logical, physical, active and snap-shot standby databases, Failover, switchover ASM Oracle 12c, 11g,10g, 9i, 8i RDBMS, Shell Scripting, SQL, MS SQL, Streams replication, Enterprise Manager, Grid Control, Sqlplus, Toad, Putty, Exceed, OID/LDAP, SQL Loader, Warehouse Builder
  • DOS, Windows 95, 98, NT 4.0, and 2000, Windows XP, windows 7, UNIX, Solaris 2.x, Linux (RHEL3,4, and 5) and AIX, Installed Linux (Oracle, REDHAT 32/64 bit)Builded VM and ORACLE VM VirtualBox

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

  • Created backup and recover document (step by step data-guard failover to DR site, recover from multiple issues.. datafiles, tablespaces, control files, online redo logs, archived redo logs, tables, etc..
  • Implemented FRA (flash back technology)… make sure to keep your eye on FRA
  • Configured TDE. This need a wallet and a key is needed for the wallet data protection
  • ENCRYPTION WALLET LOCATION is needed for TDE
  • Secure password configured via wallet (all apps and RMAN passwords are stored in oracle wallet and not in scrips or any files on the platform
  • Worked with developers to implement DATA REDACTION (used to mask critical columns
  • Configured snap-shot standby database for testing performance/application using production data and systems
  • Configured DR site for disaster recovery data-guard is needed
  • Configure Active database for reports on standby site
  • Strong golden gate skills (tuned hung GG processes, add tables to GG groups
  • Add multiple GG replicat groups for better performance, resolved replicat issues, etc..)
  • Migrated from character set 11g WE8 ISO8859P15 to 12c AL32UTF8 via csscan tool
  • Corruption Prevention, Detecting and Repairing via active dataguard, init.or parameters, flash back technology, RMAN, etc…
  • Experience with MySQL
  • Configured Golden Gate wallet (only use with 12C)
  • Created 12C PDB via copying and plugging in (copying files from seed, cloning a PDB locally and remotely< -- i -->) and (plugging in an unplugged PDB, plugging in a non-CDB as a PDB
  • Installed and configured 11g and 12c GOLDEN GATE in production, QA and testing environments
  • Upgraded GoldenGate from 11.1 to 11.2 and also installed 12c golden gate on multiple environments
  • Configured golden gate replication from 11g to 12c oracle database
  • SQL tuning using SPM and sql profile
  • Recovered over 300 missing archived log sequences from backup and applied them to standby database to resolve gap issues
  • Recoverd missing archived logs for GoldenGate extract process, on the extract site (Golden gate extracting from the standby. Standby has to be in active role)
  • Trouble-shot GOLDEN GATE mapping issues (missing indexes on target sites can cause this problem as well as other things etc..)
  • Perform SQL tuning and instance tuning
  • Applied OPatch and PSU to production and test environments
  • Tuned golden gate replicat (ggadmin waiting to write, used golden gate tuning parameters, tuned the database for better performance on replicat site, etc…)
  • Tuned golden gate lag time (two weeks lag time down to 0 seconds)
  • Configured golden gate to extract from REDO LOGS (non standby database) and ARCHIVED REDO LOG (standby database)
  • Trouble shooting data guard issues (primary cannot write to standby, gaps, etc…)
  • Set up to three standby which receive logs from one primary database (This way I was able to switch one of the standby to snapshot for testing)
  • Configured various data-guard environments (physical, snapshot 11g, active 11g and logical standby)
  • Installed data-guard manually (take backup, configure parameters, etc..) and with RMAN duplicate for standby
  • Strong data-guard trouble shooting experience
  • Switch physical standby database to snip-shot standby and back to physical standby (This was done for performance testing live data from primary production db
  • OID/LDAP: good knowledge of OID/LDAP
  • OID/LDAP: configured over 282+ databases/services into OID/LDAP
  • OID/LDAP: Trouble shot OID/LDAP errors (ORA-28043: invalid bind credentials for DB-OID connection, ORA-12514: TNS, ORA-28030: Server encountered problems accessing LDAP directory service
  • Works with 200 Tb database
  • TUNING: strong tuning skill (using performance views ASH etc…, Top performance events, run explain plan, AWR report, ADDM recommendation, SQL Profile, etc…)
  • Adding disk to ASM diskgroup via ASMCA, SRVCTL, ASMCMD, and SQLPLUS
  • Understanding and working with Grid Infrastructure
  • Registered a single-Instance Database in OCR Using SRVTL
  • Administer temporary tablespace/Online Redo logs in RAC environment
  • Enable archive log in a the Oracle RAC Environment
  • Administer and creating services for RAC
  • Administer SCAN listeners
  • Administer Cluster Ready Services
  • Oracle RAC backup and recovery

Confidential, VA

Oracle DBA

Responsibilities:

  • Participated in core game (TEST: tested recovery procedures to prepare for disaster Data guard/App swing form primary to standby)
  • Made sure daily reports were delivered with no issues
  • Worked on data guard issues
  • 24/7dba (troubleshooting alerts, investigating incidents and fixing it)
  • Used user manage backup and recovery
  • Worked with 8 Tb database

Confidential, Mclean VA

Oracle DBA

Responsibilities:

  • Configured primary and physical standby databases (Data guard)
  • Expertise in performing database refreshes and cloning
  • Resolved dead lock issue (via AWR snip shot of the database and identified top events that were causing dead locks and other performance issues
  • Diagnosed Row Migration & Row Chaining issues and fix them
  • Planed upgrade from development, QA to production.
  • Worked with RAC
  • Created and administer encrypted tablespaces for federal clients
  • Cloned and renaming multiple databases via RMAN, online RMAN backups,and user manage cloning
  • Provided critical tuning and database recommendations
  • PIT recovery when needed via (RMAN and Flashback technology)
  • Creates restore point, guaranteed restore point (ensure the database will flashback after the flashback retention period has pass) or RMAN restore to a SCN or past date
  • Installed Grid Control along with agents ( Registered instances into the OMS)
  • Strong analytical and problem solving skills
  • Shell scripts/Automated and refine regular processes
  • Automated database creations, automate process to tar, gz, and remove obsolete logfiles (oracle, system, RMAN backup logs files) so it does not fill up the file system
  • Set up effective RMAN weekly backup process in the cron table
  • Monitored development, QA and production databases performance via Grid Control.
  • Performed SQL tuning.
  • Loaded data into the databases via sqlldr, datapump (DIRECT IMPORT), and export and import
  • Performed Database and data migrations.
  • Work with Developers and production release team for production release (support and assistance)
  • Work with Operations to troubleshoot complex issues related to the entire environment including OS, storage and servers.
  • Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.
  • Provide off hours On-Call support to resolve production issues within the stated SLA.
  • Automate and refine regular processes, track issues and documented changes

Confidential, New Carrollton, MD

Oracle DBA

Responsibilities:

  • Gathered Statistic and rebuild indexes (Help improve performance) to notified the CBO of changes with in the db.
  • Worked on vmware platform that are hosting Oracle databases
  • Recovered corrupted tablespaces and datafiles
  • Backup and recovery via RMAN/configured Grid Control to backup multiple databases
  • Monitored databases, file system, host performance and application server via OEM Grid Control
  • Installed, upgraded, configured, managed and maintained all non-production and support on production databases
  • Monitored database for performance issues and tuned SQL/instance
  • Loaded data into the databases via sqlldr and PL/SQL scripts
  • Installed, patched and upgraded Oracle binaries and databases

Confidential, VA

Oracle DBA

Responsibilities:

  • Administered a 4 terabyte database
  • Monitored and administered development and production databases using Grid Control, and Toad
  • Configured and trouble shoot high availability (Data Guard)
  • Configured and administered Streams replication ( Schema replication, Downstream and upstream)
  • Put script in place to proactively monitor the performance of the database for resource contention
  • Managed tablespaces/datafiles capacity database migration, patching and upgrading databases
  • Migrated from Dictionary-managed to locally managed tablespaces
  • Installed Oracle’s software via response files and Oracle Universal Install (OUI) on Linux, AIX, Solaris and Windows
  • Installed Oracle’s client-only and Instant client via response file and Oracle Universal Installer on Linux, AIX, Solaris and Windows 2008
  • Create database manually (for large environments and extra parameters configurations) and via DBCA
  • Performed backup and recovery, online and offline backup (RMAN or user manage), set up RMAN’s recovery catalog, automating RMAN’s backup scripts in crontab export and import and datapump
  • Set up Flash Recovery Area for RMAN used SQL*Loader (Direct or Conventional Path) and External Tables to load data into the database
  • Monitored database for performance issues and tuned SQL (Partitioned tables, Indexes, Table compression, and Materialized views
  • Instance Tuning, configure parameters for optimal usage, worked with ADDM, AWR and Statpack Developed SQL AND Shell scripts (Very good SQL and Shell Scripting skills) Partitioned tables, added partition to partitioned tables, created partition Index
  • Work on project lock down for Confidential (securing and monitoring the listener log for reloads and failed connections, set password for the listener file, check for default username and password in the db that are know to hackers, create profiles, roles, view and enable database auditing )
  • Created, modified, and managed database and objects on Oracle, MS SQL 2000 and 7.0
  • Loaded flat files into the database on UNIX - Solaris 2.x, Linux, and Windows NT platform by using SQL*Loader and External Tables
  • Managed database schema by creating users, roles, profiles, and provide required user privileges in development, test, training and production environments on both Oracle and MS
  • SQL Server
  • Installed, created and configure Oracle 10g and 9i database on Windows NT and UNIX
  • Created and monitor the usage of indexes
  • Created and manage table-spaces
  • Used Oracle Enterprise Manager (OEM) to schedule database tasks (backing up the full database)
  • Performed offline and online (hot/cold) backups, with RMAN, user manage, data pump, and
  • Performed export and import
  • Performed data modeling, database design
  • Performed performance tuning, installed statspack, gathered statistics via
  • Statspack and AWR.

We'd love your feedback!