Oracle Database Administrator

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 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.