Oracle consultant

INFRASOFT TECHNOLOGIES PTE LTD; Singapore; On-site; SGD 50,000 - 75,000; Full time

Job summary

A technology services provider in Singapore seeks an experienced Database Administrator to manage Oracle databases and applications. Responsibilities include database administration, performance optimization, and client support for backup and recovery. Candidates should have a Bachelor's degree in Computer Science or a related field, along with experience in Oracle products and PL/SQL. Strong analytical, leadership, and communication skills are essential for this role.

Qualifications

• Experience with Oracle products and database management.
• Strong proficiency in PL/SQL and shell scripting.
• Excellent coordination and analytical skills.

Responsibilities

• Administer databases and Oracle Applications in all environments.
• Ensure optimization and performance of databases.
• Support clients in backup and recovery operations.

Skills

Oracle Databases

PL/SQL

Microsoft SQL Server

Customer focus

Analytical skills

Interpersonal skills

Leadership

Education

Bachelor’s in Computer Science or IT

Job description

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.