Oracle Database Administrator Resume Profile

PROFESSIONAL SUMMARY:

8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation on Linux, SUN Solaris, AIX, HP-UX and Windows operating systems.

Experience in Real Application Cluster RAC environment Oracle 10g, 11g and 12C.
Upgraded databases from Oracle 11g to 12c.
Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts.
Experience in Adding Nodes for Existing RAC cluster.
Experience in installing and configuring Oracle Enterprise Manager OEM .

Experience in Implementing and Maintaining Golden Gate replications across multiple Oracle and Non-Oracle databases.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical.
Installed, Configured, Administration, Monitoring Support Oracle GRID for maintaining Oracle Databases supporting multiple applications.
Implemented RMAN backup Full, differential and cumulative .
Experience in performing recovery, incomplete recovery and disaster recovery using Standby database.
Experience in recovering database using Flashback technology.
Expertise in Performance tuning of the database - SQL Tuning, Used Tuning utilities like AWR, ADDM, ASH, ASMM, Statspack, TKProf, Explain Plan, SQL Trace, Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
Experience on Data Replication using Snapshot, Materialized views, import/export.
Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
Good experience in Data Migration using traditional export/import, data pump, SQL Loader from flat files.
Experience in writing UNIX Shell scripts and Perl scripts.
Implemented automated backup strategy and database monitoring scripts using UNIX shell script and scheduled in CRON.
Proficient in SQL, PL/SQL, Stored Procedures, Functions, Materialized Views, Cursors and Triggers.
Management of schemas, Data modeling, objects partitioning the tables indexes.

Security user Management, Privileges, Roles, Auditing, Profiling and Authentication.

24 7 production database support with Support to developers end-users.
Experience in using the oracle support Metalink for technical assistance requests TAR by uploading the system activity reports SAR and database log files related to performance issues.
Scheduled jobs in the database using DBMS JOBS.
Resolved database network problems.
Knowledge in Microsoft SQL Server databases.
Excellent personal time management, organizing, problem solving skills, team player and ability to learn.
Strong ability to understand new concepts and applications. Good communication skills to work independently and in a team environment.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship