Job Description
To install, tailor and maintain the organizations Relational Database
Management Systems (RDBMS).
Roles and Responsibilities
Creates and maintains all databases required for development,
testing, Education and production usage.
Performs the capacity planning required to create and maintain the
Databases. The DBA works closely with system administration staff
because computers often have applications or tools on them in
addition to the Oracle Databases.
Performs ongoing tuning of the database instances.
Install new versions of the Oracle RDBMS and its tools and any
other tools that access the Oracle database.
Plans and implements backup and recovery of the Oracle database.
Controls migrations of programs, database changes, reference data
changes and menu changes through the development life cycle.
Implements and enforces security for all of the Oracle Databases.
Performs database re-organizations as required to assist
performance and ensure maximum uptime of the database.
Puts standards in place to ensure that all application design and
code is Produced with proper integrity, security and performance.
The DBA will perform reviews on the design and code frequently to
ensure the site standards are being adhered to.
Evaluates releases of Oracle and its tools, and third party products
to ensure that the site is running the products that are most
appropriate. Planning is also performed by the DBA, along with the
application developers and System administrators, to ensure that
any new product usage or release upgrade takes place with minimal
impact.
Provides technical support to application development teams. This
is usually in the form of a help desk. The DBA is usually the point of
contact for Oracle Corporation.
Enforces and maintains database constraints to ensure integrity of
the Database.
Administers all database objects, including tables, clusters,
indexes, Views, sequences, packages and procedures.
Assists with impact analysis of any changes made to the database
objects.
Troubleshoots with problems regarding the databases, applications
and Development tools.
Create new database users as required.
Manage sharing of resources amongst applications.
The DBA has ultimate responsibility for the physical database
design.
The Senior DBA should Liaise with other member of DBA Team and
should mentor as and when required
Educational Qualifications & certifications
Bachelor’s or Master’s in Information Systems, Computer
Science/IT, or a related field
Oracle Certified Database Professional is a must
Experience
Minimum 3 years of experience in Database Administration in 24×7
Environment.
Required Skills
Good experience and knowledge with Oracle database
Installation, migration, up-gradation and administration (10g,
11g,12c)
Very Good experience and knowledge in Implementations and
Upgrade projects of Oracle Application Servers and Oracle
Database 10g /11g / 12c with RAC.
Good experience and knowledge with Oracle 10g Application
server and Oracle Weblogic server Administration.
Good experience and knowledge in Oracle Database 10g/11g/12c
Performance Tuning.
Good experience and knowledge in High Availability Environments
(Using Oracle MAA) – Real Application Clusters (RAC) and Data
Guard.
Good experience and knowledge with Oracle RAC and Oracle
Grid Infrastructure.
Good experience and knowledge in Grid Infrastructure, OEM-Grid
control and Oracle enterprise Manager.
Good experience and knowledge in Automatic Storage
Management (ASM) and RAW Device shared storage in RAC
Environment.
Good experience and knowledge with RMAN, and other backup
and recovery technologies.
Good experience and knowledge with Oracle with different Linux,
Solaris, HP-Unix, IBM-AIX and Windows Platforms.
Good experience and knowledge in Database Designing,
Installation, Cloning, Migration, Patching, Space management,
ASM, ADDM, AWR, Security management, Performance tuning
and Troubleshooting any inconsistencies in the database.
Very good experience and knowledge about Oracle Server
Internals.