Oracle database administrator

Oracle database administrator

Aryan Solutions Pte Ltd
5-10 years
8000 - 10000 SGD

Job Description

Responsibilities:
  • Part of the project DevOps team to take on the exciting and challenging role of delivering and maintaining a large-scale project using AGILE software development methodology.
  • Work with the application development team to define the application data model and work on tuning and optimizing database related operation.
  • Provides production support and responsible for the resolution of database related issues and duty rotation for after-office-hours support.
  • Provides support to application team on database related matters (e.g. data patching, application deployments, extracting data from database for reporting)
  • Plan and strategize data mapping for migration of data from legacy systems to support the deployment of the project, ensuring no data loss during conversion.
  • Review data mapping/conversion/integration specs between systems to ensure appropriate mapping quality and adherence to modelling strategies.
  • Ensures timeliness and accuracy of data sync during co-existence with legacy systems.
  • Responsible for developing and maintaining database-related codes / scripts such as data sync scripts, data masking scripts, stored procedures etc.
  • Ensure database services and servers availability
  • Install and configure Oracle Database and associated products
  • Provide operational support including
  • Ensuring Oracle database patches are performed in accordance to the patch release cycle
  • Reviewing and maintaining of database accounts
  • Monitoring and optimising database performance, such as optimising queries, creating indexes etc.
  • Configuring RMAN backup on database
  • Ensuring Oracle database is hardening in accordance to standards

Requirements:
  • Degree or Diploma in Computer Science, Computer or Electronics Engineering, Information Technology or related disciplines
  • At least 3 years of working experience with Oracle 12c database or above in an Oracle RAC Active-Active environment setup, including setting up and managing the environment.
  • Experience in working with ETL and data co-existence technology with legacy systems.
  • Experience in Oracle 18c will be added advantage.
  • Experience with DB audit and security will be added advantage
  • Experience with RDS will be added advantage
  • Experience with Oracle database on Solaris Cluster setup will be added advantage.
  • Expected to acquire some domain knowledge to develop and maintain the stored procedures, data masking scripts and data sync script
  • Experience with MS SQL will be added advantage
Interested candidates, please share your resume at [Confidential Information] or call at 6708 7429 for a confidential discussion.

Aryan Solutions is an ISO 9001:2015 & ISO/IEC 27001:2013 Certified Technology Consulting & Staffing Company that specializes in providing Technology solutions, Search, Staffing & Managed Services to Local and Multi-national Companies within APAC, SEA, Australia & Japan who are leaders in Financial Services, Hedge funds, Asset Management, Telecommunication, Information Technology, Manufacturing and Government & Public Sector. Aryan Solutions is headquartered in Singapore with offices in the USA (NJ), KL (Malaysia), Hyderabad & Lucknow (India). We have a team highly experienced Consultants working across the Region covering Singapore, USA, Malaysia, Indonesia, HK, China, Australia & Japan.

Our staff augmentation and managed services make business evolve them into a global enterprise. We specialize in providing Technology solutions, Managed Services, Staffing & Search Services to Local and Multi-national Companies within APAC, SEA, Australia & Japan who are leaders in Financial Services, Hedge funds, Asset Management, Telecommunication, Information Technology, Manufacturing, and Government & Public Sector.

Our India Operations are now ISO 9001:2015 Certified.

Company Registration No. 200823066N
License No.: 13C6405

Similar Jobs

People Also Considered

Career Advice to Find Better