Job Description

:

Experiences, Education and Professional Qualification

To have some experience working with the below products.


Oracle Databases (EBS & Non EBS Databases) Oracle Enterprise Manager Oracle Application Server Oracle e-Business Suite Oracle Golden Gate / Label Security / Data Masking / Oracle encryption Oracle SOA / Web logic Other Oracle related Product PL/SQL and shell scrip programming Microsoft SQL Server Databases My SQL Databases

Competency and Skill Set

Minimum Education: Bachelor's in computer science or IT related. Coordination & Analytical skills Proficient in English, both verbal and writing Customer focus Interpersonal and communication skills Good time management Leadership (for DBA Manager) Information security knowledge on systems

Job Roles & Responsibilities

Administer the databases and Oracle Applications in Production, Test, and Development.
Monitor, manage and maintain the database and ensure optimisation of performance Responsible for the installation / migration or upgrade of databases based on Client's requirement. Responsible for the hardening of Database in accordance with Client company policies, processes, and guidelines. Coordinate with Client's data centre team and business application team to perform the monthly maintenance activity. Provide technical database administration support to the application developers and business super users. Monitor several database components through Oracle Enterprise Manager (OEM) and resolve issue identified. Clone Oracle Databases and Non-Oracle Databases Apply patches to Databases and applications based on Client's requirement. Troubleshoot problems related to applications and databases and provide support including tar logging. System health check and data management - defragmentation, export/import, relocation of data files, and database refreshes. To support the Client in the backup and recovery of databases and applications. Participate in and support Client in scheduled DR exercises To change password periodically for default database users used by Oracle application as Client's security policies. Housekeeping of databases and applications in scope as per Client's policies. Configuring of OEM alerts for Databases. To support client on program deployments and code migrations. Provide necessary documentations as per Client's requirement Liaising and working with Oracle Customer Success Services team to support Client projects and initiatives. Prepare weekly and Monthly report. * To participate in Oracle Cloud migration and Oracle upgrade projects, providing support in database administration activities according to project schedule.