IBM Oracle E-Business Suite Database Administrator 

Romania, Bucharest 

194946437

Your Role and Responsibilities

Creates and maintains Oracle Databases and eBusiness Suite (eBS) . Administer and manage databases for eBusiness Suite (eBS) by implementing, configuring, cloning, troubleshooting issues and maintaining database systems. This includes monitoring database performance, troubleshooting issues, and ensuring data integrity and security. The role requires a strong understanding of database concepts, eBS architecture, and system administration principles.

Provide Database technical support in a timely manner (including SLA).

Ensure that the KPI’s are maintained according to the existing Service Level Agreement.

You shall administer and troubleshoot complex Oracle database systems and perform full database lifecycle management which includes: instalation & configuration, monitoring, patching, setting up the back-up and performance tuning for the said databases;

You will be involved in the Oracle EBS 12.2.x administration, patching, troubleshooting and configuring complex setup such as SSO integration, high availability, etc.

You will participate in the production support activities in order to ensure the performance tuning & troublesooting of complex queries / server performance issues

You will define and implement HighAvailability, DataGuard

You shall support the configuration and maintenance of our databases for our current applications/systems and also support other database config. activities;

You ensure the technical support of our databases together with our development and user support teams. You will also develop contingency plans in order to make sure our databases guarantee the smooth functioning of applications;

You will solve access problems to our DBs and also configure the layers of access granted to certain users;

You will support the configuration of certain reports and also make sure that our reporting services are running as intended.

Required Technical and Professional Expertise

• 5+ years of experience as an Oracle E-Business Suite Database Administrator, Responsible for database administration, production support, installation, configuration,
upgrades, patches, backup and recovery, database security, auditing and space management.

• Installation and configuration of Oracle Multitenant databases in LINUX environments.

• Installation, maintenance, platform migration, patching, upgrade and support for E Oracle E-Business Suite Release on large systems

• Understanding of data model for Oracle EBS Release 12.2 (or higher)

• Familiar with Oracle Weblogic Server and Oracle Fusion Middleware architecture

• Platform migration and OS upgrade(RHEL7 to RHEL8) for E-business Suite servers and Oracle Databases

• Planned and implemented Oracle RAC and Standby Databases Data Guard for
High availability and Disaster Recovery DR .

• Experience in upgrading the database and migration of the databases using
transportable database, tablespaces export/import, data pump utilities.

• Used Opatch utility for applying CPU and One-off patches RDBMS patch set
Upgrade PSU .

• Installed and configured Oracle Enterprise Manager Cloud Control and deployed
agent on managed targets.

• Good experience with Oracle Grid control, Oracle Enterprise Manager OEM ,
ASM, AWR, ADDM, Flashback Technology, SQL Tuning Advisor, SQL access
Advisor and Undo Advisor.

• Designed and implemented centralized backups and recovery strategies using
recovery manager RMAN .

• Expertise on performing cold backups, hot backups, advanced recovery methods
like PITR and TSPITR, flash back recovery.

• Cloning of the databases

• Experience in using SQL, PL/SQL stored procedures, indexes, materialized
views, shell scripting, partitioned and non-portioned tables, packages and
triggers for improved performance of the database.

• Performance Tuning: Experience in identified poor SQL statements using
EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.

• Expertise in maintaining Database Roles, Users using Security Compliance
Auditing.

• Experience in using the Oracle Support Metalink for Service Requests SR
database log files related performance issues, Remote Diagnostic Agent RDA .

• Involved in data modeling, logical and physical database designs and worked as
on-call support team member for administering OLTP 24X7 production
databases.

• Excellent communication skills, strong analytical logical abilities, problem solving
skills and fast learning.