- 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.
- Minimum Education: Bachelor’s in computer science or IT related.
- Coordination & Analytical skills
- Information security knowledge on systems
Experiences, Education and Skilled 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