We provide IT Staff Augmentation Services!

Oracle Production Dba Resume

St Paul, MN

SUMMARY

  • 12+ Yrs. of Experience in Oracle Database Administration (RDBMS)& development, MySQL & System Administration for RedHat Linux/Oracle Linux, SOLARIS 9/10, IBM AIX 5.X & HP - UNIX.
  • Technical Specialization in Oracle 10g/11g/12c RAC, ASM, shell scripting, OFA framework, oracle patching, Oracle Golden Gate, Oracle 9i/10g/11g/12c RMAN, OEM 12c &13c,Oracle 9i/10g/11g Data Guard, data modeling, Oracle streams /Replication, performance tuning & troubleshooting, monitoring, patching, cloning, AWR & PL/SQL.
  • Experience in data modeling tools Erwin & SQL developer data modeler.
  • Implemented Disaster Recover Site with Data Guard and maintained Physical and Logical Standby Databases along with Active Data Guard and Oracle Golden Gate.
  • Supporting multiple databases for Production, Development, Test and Staging purposes on Sun Solaris and Windows environments.
  • Implementing switchovers on primary and standby databases as a part of planned maintenance activities.
  • Experience in parallel processing architecture in oracle database.
  • Experience in EBS 11i/R12 & PeopleSoft
  • Installing, patching and upgrading Oracle 10/11g & 12c to support internal Production and Test environments.
  • Administer multi-terabyte Oracle 11g databases on Linux as well as 11g and 12c databases on Oracle Exadata. Apply and develop knowledge of cluster and HA technologies, including Data Guard, in multiple geographically dispersed data centers.
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for high availability, scalability and performance by determining the best Cluster architecture, and choosing the best hardware configuration for Oracle RAC.
  • Hands on experience in development of utilities using Shell and Python scripts to automate processes.
  • Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
  • Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
  • Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c and Amazon web services (AWS), SQL server

ERP: Oracle EBS 11i/R12 & peoplesoft

Languages: SQL, PL/SQL, UNIX shell scripting,Python basics

Operating Systems: Redhat Linux Enterprise/Advanced Servers & Platform SUN Solaris 8/9/10, IBM AIX 5.x,Windows Server 2000/2003, LINUX, OEL

DB Utilities: SQL Loader, Data Pump, RMAN, Opatch, TKPROF, Statspack, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, ADRCI and DBUA.

Specialization: RAC, Oracle Golden Gate, Data Guard, RMAN, Replication, Automatic Storage Management (ASM), shell programming& Performance Tuning

Middleware: Weblogic,WebSphere Application Server ND 6.0,JBOSS

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

Oracle production DBA

Responsibilities:

  • Space management (archive logs & table space/data files).
  • Managing database objects (control files, redo logs, undo management & temporary table space) & schema objects (tables, indexes, views, synonyms, triggers, partitioned tables, procedures, functions & packages)
  • Analyze table & index statistics, reorganizing tables for chained / migrated rows & rebuild indexes.
  • Implementing Backup & recovery strategy with data pump & RMAN.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 10gR2.
  • Implemented recovery strategies and successfully recovered databases from crashes and data files from media/disk failures by using RMAN.
  • Managing users, privileges & roles.
  • MySQL processes, security management and queries optimization.
  • Working on pro-active & performance tools like AWR, ADDM & tkprof.
  • Storage management with ASSM & FRA.
  • Experience working on patching & upgrading databases.
  • Working on OEM 12c&13c.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method
  • Enforced security administration and system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Created and modified multiple shell and python scripts to automate tasks, monitor, report and audit database health and compliance.
  • Installation of grid infrastructure and creation oracle RAC databases (dbca).
  • Cluster & database administration & monitoring using SRVCTL & CRSCTL
  • Monitoring and tuning RAC database parameters.
  • Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch also Migration of non ASM database to ASM database.
  • Backup and recovery of RAC databases using RMAN.
  • Upgrading & applying patch to RAC databases.
  • Setting up Golden Gate requirements and using best practices.
  • Transportable table spaces moving data files from solaris to linux.
  • Setting up physical standby data guard for RAC database.
  • Installation and setup of oracle golden gate & data guard.
  • On call support for development and production databases.
  • Archiving old data & database refreshes.
  • Shell scripting & PL/SQL.
  • Experience working on Oracle EBS R12 database administration.
  • Familiar with Microsoft Azure/AWS & oracle exadata.

Confidential, Minneapolis, MN

Oracle Development & Production DBA

Responsibilities:

  • Database administration (oracle 10g/11g/12c, MYSQL, MS SQL Server)
  • Oracle 11g/12c RAC /ASM installation and setup
  • Oracle golden gate installation & set up
  • Troubleshooting and documenting Golden Gate issues like performance, data issues or memory related issues.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24 X 7 supports for all the production and development databases.
  • Experience working on SQL plan baselines & SQL profiles.
  • Resolving the issues in Oracle 10g, 11g and 12c versions of database and oracle 10g, 11g,12c versions of Golden Gate.
  • Developed Shell scripts & PL/SQL (data masking)
  • Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method
  • Enforced security administration and system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Supporting over 100 Oracle, MariaDB, MySQL databases on Linux platforms.
  • Implemented proactive monitoring scripts for production databases.
  • Performance tuning, monitoring & troubleshooting (AWR, ADDM)
  • Environment refreshes (DEV, QA, ST), patching & cloning.
  • RMAN backups & datapump
  • Oracle OEM 12c/13c & grid alerts and notifications
  • Worked with infrastructure team in capacity planning & hardware setup for RAC implementation.
  • On call support for development & production databases.

Confidential

Senior Oracle DBA (Production DBA)

Responsibilities:

  • Configured RAC Instance Servers to Shared Storages.
  • Installed Oracle 10g Clusterware software.
  • Created Oracle 10g RAC Database.
  • Created Disk Groups for Database Files and Flash Recovery Area.
  • Placed Data and FRA Disk Groups on RAW Volumes.
  • Proactive manage the database to prevent it from deficient performance
  • Performed backup and database recovery hot/cold backups.
  • Create database, tablespaces, tables, indexes and other database objects.
  • Maintain database security, create, modify and manage users accounts; grant privilege and restrict access to database objects.
  • Placed OCR (Oracle Cluster Registry) & VD (Voting Disks) on RAW Volumes.
  • Taking RAC database instance backup using Recovery Manager (RMAN).
  • Monitor system performance, analyze, trouble shoot and resolve system related problems.
  • Tested Core Banking application with Physical Standby Database in Read-Only Mode, Read-Write Mode.
  • Tested Performance Issues in Core Banking application with Physical Standby Database in Read-Only Mode and Read Write Mode.
  • Implemented shell scripts for backup,monitoring & scheduled cron jobs.

Environment: Oracle 10g with RAC & ASM, IBM WebSphere ND 6.0, SUN Cluster 3.2 & SUN Solaris 10

Confidential

Database Administrator

Responsibilities:

  • Implemented oracle 10g RAC on windows platform
  • Setup oracle 10g data guard (physical standby)
  • Performance tuning, monitoring & troubleshooting
  • Ensured database systems operate efficiently and securely using Alert logs and Auditing.
  • Implemented SQL Developer to do several tasks including Data redaction.
  • Ensure that all databases hosted on SQL Server instances are online
  • Perform MySQL Installation, databases design, configuration, backup, recovery, security, schema changes and tuning.
  • Enforced user level security by assigning roles, privileges, profiles, and permissions.
  • Provided documentation for Installation, Backups, Patching, Performance Tuning, etc.
  • Set up RMAN backups & logical backup using datapump
  • Developed shell scripts

Environment: Oracle 10g with RAC & ASM, IBM WebSphere N.D, Windows 2003 Server Edition

Hire Now