ORACLE/ SQL (Database Administrator) Resume

SUMMARY:

3+ years of IT experience in configuring and administering Oracle Database Products and tools such as EM (Enterprise Manager), Oracle Golden Gate, Oracle SQL Developer, Oracle Real Application Clusters.
Good knowledge and training in SQL, and PL/SQL Extensive experience on installation, document installation and configuration of Oracle database products on Windows, Linux (Red hat, ubuntu and Fedora, Kali Linux) and Unix environments. Strong knowledge in creating and maintaining table spaces, along with monitoring, sizing and adding database objects for effective space management.
Hands on experience on redo log files and archive log files management. Extensive experience in Database Backups using RMAN (Full/Incremental backups) and in traditional hot/ cold backups. Setup Oracle Enterprise Manager (OEM) 12c.
Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
Good knowledge in PATCHING AND UPGRADATION.
Expertise in upgrading Oracle Development and Production databases.
Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
In depth understanding of performance tuning and troubleshooting.
Excellent Communication skills, co - ordination and communication with system administrators, business data analysts and development teams.
Experience in Data guard configuration, implementing and maintaining standby databases.
Great with SQL/database scripting and UNIX shell scripting.

SKILLS:

Good knowledge and training in JAVA and Python. Good with the command Line interface on both Linux OS’s and Windows.

WORK EXPERIENCE:

ORACLE/ SQL (Database Administrator)

Confidential

Responsibilities:

Functions - Management databases on different environments as Development, QA, Production, Cloud.
Manage technical & functional solutions in SAP modules to business processes.
Monitoring of heavy processes and performance DB with Spotlight. Oracle backup & restore with tools: RMAN, data pump(EXPDP, IMPDP), Oracle SQL Developer. Security: management user, access control, sessions.
Installation, maintenance databases.
Query to data dictionary.
Development of scripts, store procedures, views, cursors for databases.
Implementation and validation in passes UAT, production and SAP.
SAP Business One management and support.
Elaboration reports that are extracted in SAP.
Implementation and operation of services on UNIX platform.
Performance analysis and sizing capabilities.

Technologies: Oracle 9i, 10g,11g, 12c, IBM/AIX, HP-UX, Solaris, Redhat, OEL, Centos, Suse, Ubuntu, SAP: Business One, Data Integrator, Data Designer, Business Objects, Infoview, MMC, BO Designer, Dataguard, RMAN, IBM Guardium, Sysguard, OEM, Spotlight, TOAD, plsql Developer, mputty, Moba, CRT, mputty, SQLPlus, RMAN, SQL Loader, Filezilla, Bitvise, Winscp, WinMerge, SQL Server, SQL Profiler, SSIS, DTA, TFS, W2012 R2, W2K8 R2, Activity Monitor, TeamViewer, Cisco VPN, MSTSC, Citrix, Anydesk, CA ServiceDesk, Cisco Webex.

Jr. Oracle DBA

Confidential

Responsibilities:

Installed, configured, and maintained Oracle 11gR2 and 12c under supervision Upgraded databases from 11g to 12c under supervision Restoration and Recovery of databases at the times of occurrence of critical failures.
Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
Responsible for configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
Experienced in performing Point-in-Time Recovery.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship