DATABASE ADMINISTRATOR

Job Description

To install, tailor and maintain the organization's 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.
• Installs 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.
• Provides technical support to application development teams, 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 the 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 problems regarding the databases, applications, and development tools.
• Creates new database users as required.
• Manages sharing of resources amongst applications.
• The DBA has ultimate responsibility for the physical database design.
• The Senior DBA should liaise with other members of the 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 a 24x7 environment.

Required Skills

#J-18808-Ljbffr