We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Effective Supervising Skills: Patient managing, the ability to work independently on projects and supervising five people.
  • Effective Business Skills: Communication Skills, Organization Skills and great Microsoft skills (: Outlook, Word, Excel)
  • Computer Electronic Engineering Skills: Read and draw Schematics, Thru hole Soldering, Use test equipment such as oscilloscopes and multimeters and Troubleshoot AC and DC Circuits.
  • Leadership and Mentoring of new employees to adhere to the company’s policies and procedures effectively.
  • Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages
  • In - depth understanding of security and backup procedures to ensure database integrity.
  • Experienced in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.
  • Experience with various tools, such as SQL*Plus, Data Pump, SQL*Loader, Oracle Enterprise Manager (OEM), Recovery Manager, and Oracle Secure Backup.
  • User management, creation, monitoring and administration of database users; altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.
  • Monitoring & Reorganization of Tablespaces/Tables/Indexes.

EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

  • Supported,Security,UserManagement,Privileges,Roles,Profiling,auditing,Authentication, authorization, encryption, enterprise security.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
  • Index creation and management for optimization of DB Processes
  • Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
  • Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
  • Supported & maintained the Production/Development databases on various servers
  • Extensively worked on setting up auditing in many databases we supported
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Confidential

Oracle Database Administrator

Responsibilities:

  • Performed monthly and annual performance reports for trend analysis and capacity planning.
  • Performed housekeeping tasks like checking log and trace files.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re - organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments..
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

We'd love your feedback!