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
Job Roles & Responsibilities
Administer the databases and Oracle Applications in Production, Test, and Development.
Monitor, manage and maintain the database and ensure optimisation of performanceResponsible 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 DatabasesApply 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 exercisesTo 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 requirementLiaising 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.