jr dba
at
ample technology
, bangalore
Working/Currently
• Installing and configuring of Oracle software and related
products.
• Managing Physical structure of Oracle database
like Datafiles, Redolog files and
Control
files.
• Enrolling users and controlling their access to the
database.
• Administrating all Database objects like Tables,
Indexes.
• Implementation of Open/close Database Backups
(Hot/cold Backups /
Online/offline Backups).
.
• Monitoring the growth of Tablespace and taking proper
actions.
• Moving Data between Database using utilities like
Export/Import.
• RMAN utility.
• Designing
Entity-Relational diagram of schema and specifying Column names
and Integrity Constraints.
• Creating Tables with its
associated attributes, Integrity constraints.
• Retrieving
data using SQL statements and manipulating data.
• Performing
DML, DDL, TCL and DCL operations.
• Creating Sequence, views..