We provide IT Staff Augmentation Services!

Oracle Dba Resume

2.00/5 (Submit Your Rating)

Austin, TX

SUMMARY:

  • Over 5 years of IT experience working as Oracle Database Administrator on Linux, Solaris, AIX, Windows platform.
  • Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU)
  • Extensive experience in implementation, maintenance, installation, administration of Oracle databases 12/11g/10g across various operating systems including UNIX, Sun Solaris, AIX and Windows
  • Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views
  • Experience in troubleshooting, system analysis, data modeling, logical and physical database design and installation, and performance analysis and optimization.
  • Data loading using Logical backups using DATAPUMP
  • Upgrading databases to higher versions, applying patches and patch sets Strong experience in Backup and Recovery strategies using RMAN, creating RMAN scripts, Export/Import, Data Pump, Hot and Cold backups
  • Move databases from one location to another successfully.
  • Participated in on - call (off hours) schedule in providing technical support.
  • Experience with SQL, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic
  • Experience with Microsoft SQL server 2008/2012/2014
  • Experience with AWS and Microsoft Azure
  • Extensive Knowledge of PostgreSQL
  • Heavy understanding of PL/SQL, SQL, and PostgreSQL

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Oracle DBA

Responsibilities:

  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future
  • Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
  • Working with Oracle Support on critical database issues.
  • Databases refresh from PROD to DEV environment for application testing and upgrades.
  • Worked on Data Guard for advance replication and high availability.
  • Monitors and manages databases access, storage and utilization using Grid Control.
  • Responsible for restoring and recovering database as required for Oracle.
  • Worked on Complete and In-Complete Recovery of production Databases of varying sizes using RMAN copy, RMAN backup sets.
  • Used shell scripting for automation of job scripts, for startup and shutdown, Health check of databases, Analyzing of Tables and Rebuilding of Indexes.
  • Proactively monitored the database and database access, and maintained the database security.
  • Extensively worked under UNIX environment to provide DBA support.

Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Data Pump, STATSPACK, AWS, MICROSOFT AZURE, POSGRESQL

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Administer Oracle 10g & 11g databases on Linux Platform.
  • Manage ASM and Oracle RAC services.
  • Managing nodes and rebuild node following hardware crashes.
  • Maintain client SLA for Database availability.
  • Maintain data guard and be certain to keep all physical standby databases in sync with production.
  • Proactive in Oracle quarterly patches.
  • Work on disaster recovery scheduled tests.
  • Provide dba support to hosted databases in UNIX, Linux environment.
  • Managing RMAN backups. Troubleshooting RMAN backup issues.
  • 24X7 on call support.
  • Configured Daily backups on standby database in Data Guard environment.
  • Supporting Application team with application upgrades.
  • Refresh non prod schemas with prod data as needed using Data Pump.
  • Upgrading databases adopting out of place upgrades in 11g.
  • Patching databases using OPatch utility.
  • Manages database security by creating and assigning appropriate roles and privileges to users.

Environment: Oracle 11gR2, 10g, LINUX (RED HAT), RMAN, TOAD, SQL LOADER, DATA PUMP.OEM/Grid Control

We'd love your feedback!