Oracle Database Administrator Resume

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 provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship