Oracle Database Administrator

Experiences, Education And Professional Qualification

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