Oracle Database Administrator Resume Jersey City, NJ - Hire IT People

SUMMARY

Over 6 years of experience as an Oracle Database Administrator with hands on experience in database installation, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
I am also a very good team player, self - motivated person, dedicated in any work environment and excellent in documentation.

TECHNICAL SKILLS

Database administration
BACKUP AND RECOVERY
RMAN, SQL
MIGRATION
PERFORMANCE TUNING
DATAPUMP
LINUX
GOLDENGATE
UPGRADE & PATCHES
ORACLE 12C
MARKLOGIC 9.0-4
Replication
DATAGUARD
SQL DEVELOPER, TOAD
OEM 18c
RAC
SECURITY
PL/SQL
WINDOWS
SHELL SCRIPTING
SQL SERVER
EXADATA
PostgreSQL
OEM13C

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential - Jersey City, NJ

Responsibilities:

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.
I have updated database certificate on RDS created Oracle and Aurora POSTGRESQL databases on RDS migrated databases from Oracle to POSTGRESQL on RDS created DMS tasks on RDS
Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.
Troubleshoot issues related to Oracle RAC including evictions and reboots.
Strong experience supporting RAC, ASM, Data Guard and resolve production issues.
Strong Experience with the installation of MARKLOGIC SERVER 9.0-4
Create recover catalog to keep my backup information longer than the controlfiles will do.
Scheduling Physical backups (hot & cold) in CRONTAB using RMAN utility and monitoring the scheduled jobs.
Tuned Databases and SQL Statements using OEM, AWR, ADDM, ASH, SQL TRACE, TKPROF, SQL TUNING ADVISOR, EXPLAIN PLAN …
Expertise in implementing data refreshes using RMAN utility, Transportable Tablespace (TTS) feature, Datapump and conventional Export/Import of Oracle 11g, 12c.
Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Involved in Oracle Golden Gate installation, configuration and monitoring.
Provided 24X7 support for all the production and development databases.
Strong skills in applying CPU, PSU and One-off Patches using “runInstaller” and perl based utility “opatch”.
Migrated 11gR2 oracle databases to PostgreSQL 9.6 AWS (AURORA, RDS, EC2) using SCT, DMAF AND DMS
Migrated oracle database to Exadata using Goldengate, DATAGUARD.

Oracle Database Administrator

Confidential

Responsibilities:

Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activities
Troubleshoot installation errors both independently and with Oracle support (via My Oracle Support)
Production support for Oracle database 11g/12c.
Experience with upgrade of MARKLOGIC SERVER.
Implemented auditing such as standard, value-based and fine-grained for data security.
Implemented TDE and Network Encryption as advanced security measure for data protection and integrity.
Performed conversion of Single Node Instance to Multi Node RAC, add an instance to existing RAC and upgrade Oracle 10g RAC to 11g RAC.
Installed and configured 2 nodes oracle 11gR2 RAC on ASM and NFS file systems for production environment.
Database migration from Oracle to Exadata DB system using transportable tablespaces.
Monitoring database performance and database operation to prevent downtime and slowness of the services.
Implemented shell-scripts for automation of day to day activities.
Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
Created Physical Standby databases and switch to snapshot standby databases for application testing.
Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.
Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
Created and managed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL developer and SQL navigator.
Analyzing schema of databases created to collect statistics using the DBMS STATS package.
Experience working on 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.
Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Jersey City, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship