SENIOR DATABASE ADMINISTRATOR

Nexcel Computer Solutions; Manama; On-site; BHD 30,000 - 70,000; Full time

Job summary

An established industry player is seeking a Senior Database Administrator to oversee and maintain their Oracle RDBMS. This role involves creating and managing databases for various environments, ensuring optimal performance, and implementing security measures. The ideal candidate will have extensive experience in Oracle database administration, including installation, migration, and performance tuning. The organization values collaboration, and you will work closely with application developers and system administrators to ensure seamless database operations. Join a dynamic team that prioritizes innovation and excellence in database management.

Qualifications

• Minimum 7 years of experience in Database Administration in a 24x7 environment.
• Oracle Certified Database Professional is a must.

Responsibilities

• Creates and maintains all databases for development and production usage.
• Plans and implements backup and recovery of the Oracle database.
• Performs ongoing tuning of the database instances.

Skills

Oracle Database Installation

Database Migration

Database Administration

Performance Tuning

High Availability Environments

Oracle RAC

Backup and Recovery Technologies

Oracle Weblogic Server Administration

Database Design

Troubleshooting

Education

Bachelor’s in Information Systems

Master’s in Computer Science/IT

Oracle Certified Database Professional

Tools

Oracle 10g

Oracle 11g

Oracle 12c

Oracle Application Server

Oracle Grid Infrastructure

Oracle Enterprise Manager

RMAN

Job description

Job Description

To install, tailor and maintain the organization Relational Database Management Systems (RDBMS).

Roles and Responsibilities

1. Creates and maintains all databases required for development, testing, education, and production usage.
2. Performs the capacity planning required to create and maintain the databases.
3. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
4. Performs ongoing tuning of the database instances.
5. Installs new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
6. Plans and implements backup and recovery of the Oracle database.
7. Controls migrations of programs, database changes, reference data changes, and menu changes through the development life cycle.
8. Implements and enforces security for all of the Oracle Databases.
9. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
10. Puts standards in place to ensure that all application design and code is produced with proper integrity, security, and performance.
11. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
12. Evaluates releases of Oracle and its tools, and third-party products to ensure that the site is running the products that are most appropriate.
13. 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.
14. 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.
15. Enforces and maintains database constraints to ensure integrity of the database.
16. Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
17. Assists with impact analysis of any changes made to the database objects.
18. Troubleshoots problems regarding the databases, applications, and development tools.
19. Creates new database users as required.
20. Manages sharing of resources amongst applications.
21. The DBA has ultimate responsibility for the physical database design.
22. The Senior DBA should liaise with other members of the DBA Team and should mentor as and when required.

Educational Qualifications and 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 7 years of experience in Database Administration in a 24x7 environment.

Required Skills

1. Good experience and knowledge with Oracle database installation, migration, up-gradation, and administration (10g, 11g, 12c).
2. Very good experience and knowledge in implementations and upgrade projects of Oracle Application Servers and Oracle Database 10g/11g/12c with RAC.
3. Good experience and knowledge with Oracle 10g Application Server and Oracle Weblogic Server Administration.
4. Good experience and knowledge in Oracle Database 10g/11g/12c performance tuning.
5. Good experience and knowledge in high availability environments (using Oracle MAA) – Real Application Clusters (RAC) and Data Guard.
6. Good experience and knowledge with Oracle RAC and Oracle Grid Infrastructure.
7. Good experience and knowledge in Grid Infrastructure, OEM-Grid control, and Oracle Enterprise Manager.
8. Good experience and knowledge in Automatic Storage Management (ASM) and RAW Device shared storage in RAC environment.
9. Good experience and knowledge with RMAN and other backup and recovery technologies.
10. Good experience and knowledge with Oracle on different Linux, Solaris, HP-Unix, IBM-AIX, and Windows platforms.
11. 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.
12. Very good experience and knowledge about Oracle Server internals.