Senior Oracle Database Administrator

AVATAR TECHNO SERVICES PTE. LTD.; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

A technology services company based in Singapore is seeking an experienced Database Administrator to design and implement robust database solutions. The ideal candidate must possess a degree in Computer Science and have a minimum of 10 years of experience with Oracle and other RDBMS. Responsibilities include providing architectural oversight for implementations, assisting in automation activities, and mentoring team members. Strong expertise in performance optimization and tuning is essential.

Qualifications

• Minimum 10 years of experience in Database Administration.
• Experience with Oracle and other RDBMS.
• Hands-on with building databases and writing database code.

Responsibilities

• Design and implement database administration solutions.
• Provide architectural oversight for implementations and recommendations.
• Assist in automation activities throughout the project lifecycle.

Skills

Database administration solutions

Performance optimization

Query tuning

Technical documentation

Data modeling

Education

Degree in Computer Science/Information Technology

Tools

Oracle

Linux

Windows Server

Job description

Responsibilities

• Design and implement robust database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, multi-threading and parallelism, planning and implementing failover between database instances.
• Provide necessary architectural oversight for any implementation, recommendation or changes in supported environments initiated through periodic reviews, audits conducted by internal delivery assurance groups or by client initiated audits or requests.
• Assist in automation activities where‑ever possible from design through development and deployment
• Technical documentation skills
• Share domain and technical expertise, providing technical mentorship and cross‑training to other peers and team members
• Assist developers with complex query tuning and schema refinement
• Be part of new implementation projects and will be responsible to prepare the pre‑implementation plan for such projects - internal or external as may be required from time to time for implementation by the Implementation Teams
• Independently analyze, solve, and correct issues in real time, providing problem resolution end‑to‑end.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

Requirements

• Possess a Degree in Computer Science/Information Technology or related fields.
• Minimum 10 years of experienced in DBA who has worked on Oracle and any other RDBMS.
• Should have experience Installation, Administration and Troubleshooting in Operating Systems - Linux (RedHat, Fedora, CentOS) Windows Server
• Hands‑on experience in building database, writing database code like functions, procedures, stored procedures, triggers etc.
• Working experience on Oracle RAC & Data Guard is a must.
• Strong experience with performance optimization and tuning with database applications is a must
• Complete architectural knowledge on Oracle Database engines
• Strong knowledge of backups, restores, recovery models, database shrink operations, Clustering, Database mirroring, Replication
• Ability to detect and troubleshoot Oracle Server related CPU, Memory, I/O, disk space and other resource contention
• Exposure to large OLAP modeling, star schema is an advantage
• 8+ years of work experience with Oracle Data Guard
• 8+ years of work experience with Oracle RAC
• 8+ years of work experience with Database Administration