Oracle Database Administrator

Tech Aalto Pte ltd; Singapore; On-site; SGD 89,000 - 156,000; Full time

Job summary

Tech Aalto Pte Ltd in Singapore is seeking an experienced Oracle Database Administrator to manage a large, complex production DB environment across multiple databases globally. You will troubleshoot, design, implement, and optimize Oracle solutions and collaborate with infrastructure and developer teams.

The role emphasizes performance tuning, backup and recovery, data security, and adherence to SLAs. Candidates should have strong Oracle skills, RMAN, Data Guard, Data Pump, and RAC experience,

Qualifications

• Experience with design, modelling and performance tuning of Oracle databases.
• Strong backup and recovery experience with RMAN and Data Guard.
• Experience with Oracle RAC and ASM in production environments.
• Linux operating system experience.

Responsibilities

• Design, develop, implement, and maintain core Oracle applications and SQL/PLSQL processes.
• Ensure database availability and security standards.
• Monitor performance and capacity; optimize architecture.
• Execute data migration jobs and support hardware sizing for DBs.
• Create and maintain disaster recovery plans and backup strategies.
• Document DB policies, procedures and standards.

Skills

Oracle Database Administration

Performance tuning

Backup and recovery

Capacity planning

DB clustering

Education

Oracle Certified DB Professional

Tools

Data Guard

RMAN

Data Pump

Golden Gate

Oracle RAC (ASM)

Job description

Job Description

Oracle Database Administrator

The Position We are seeking a professional DBA with the technical skills and knowledge that extends across Application/ Server/ Storage/ Network technologies to administer a large, complex production DB environment and troubleshoot and provide system level guidance/ solutions. The role also performs effective centralized database administration for multiple databases globally. This includes Oracle databases for production, testing, and staging environments across the company. This opportunity will suit an Oracle DBA who enjoys providing technical guidance and who can play a key role in supporting and driving forward our database developments. We’re looking for people who work quickly, are competitive self-starters, smart and do what is needed.

• Design, develop, implement, and maintain our core Oracle applications. Maintain our SQL / PLSQL processes.
• Ensure DB availability. Proactively manage and maintain security standards and controls.
• Actively seek to optimize and simplify our architecture.
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Assist the infrastructure team in sizing hardware used for the DB. Support and collaborate with product developers.
• Contribute to the creation and maintenance of disaster recovery plans. Create a reliable backup strategy.
• Ensure database backups are appropriately. executed and periodic restorations are exercised to ensure backup quality.
• Determine and document DB policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
• Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur

• Ideally Oracle Certified DB Professional, experience with Oracle, preferably in a lead role. Experience should include
• DB design (modelling and normalization), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
• Operating system experience in Linux.
• Oracle management tools (Data Guard, RMAN, Data pump, Golden Gate).
• Partitioning, Architecture design principles.
• Good problem solver focused and dedicated developer with ability to work on your own as well as with a team.
• Hands on experience with DB standards and end user applications-translating capacity requirements into infrastructure deployment technology.
• Strong practical experience of ORACLE in a production RAC (ASM) environment
• Must be a self-starter with a strong attention to detail.