Send me more jobs like this

Oracle DBA (Oracle Database Administrator)

Keywords / Skills : Oracle database administrator, Oracle DBA, Oracle Database Admin, Oracle Admin, Oracle Administrator

3 - 4 years
Posted: 2019-06-25

Industry
IT/Computers - Software
Retailing
Function
IT
Role
Database Administrator (DBA)
Education
Bachelors
Degree
Job Type
Contract tenure:
6-12 month
Posted On
25th Jun 2019
Job Ref code
11175
Job Description
We are hiring an ORACLE DBA in Hong Kong to work on a 6-months contract assignment.

Work Location: Shatin, N.T. (Hong Kong)​
Experience level: 3-4 years
Salary: HK$ 40,000 - 50,000 per month

Responsibilities:
  • Create upgrade and migration schedules and plans in a way so as to minimize the impact on production and mission critical systems
  • Improve application performance through regular Health Checks and Performance Tuning
  • Proactive on-going tuning of database objects and structures to improve operational efficiency
  • Analyze databases for worst performing SQL and coordinate with application support or development teams to tune application code
  • Set up, document, and execute procedures for regular tuning and maintenance of database structures according to service provider and industry best practices.
  • Management of database resources (assignment of tablespaces, space in HD, update system parameters, etc.)
  • Management of corporate monitoring tools: OEM, RMAN, SolarWinds, Toad, Oracle SQL Developer; monitoring of events associated with the applied technologies
  • User and Security management, Access review
  • Plan growth and changes (capacity planning)
  • Work as part of a team and provide 24x7 support when required
  • Database/Grid Patch Management and Version Control
  • Preferred managing the replication solutions with Data Guard / Active Data Guard / Far Sync
  • Report root cause and provide recommendations to ensure issue does not recur. Take all steps necessary to implement recommendations.
  • Coordinate with DB vendors for any Database related issues or patches, track issues through service calls and communicate users/business team on status.
  • Perform Vulnerability assessment test on the database and report the same with remedial measures. Maintain Minimum Security Baselines (MSB) as best practices for the organization.


Requirements
  • 3-4 years of Oracle Production support experience as ORACLE DBA (Oracle 9i, 10g/11g / 12c Oracle RAC) on Linux, AIX, Solaris and Windows platforms
  • Experience in Oracle Database installation, configuration, support
  • Oracle RAC installation, configuration, Support
  • Database creation, Database Estimation/Sizing, Licensing
  • Experience with Oracle Replication (Streams, Advanced replication, Materialized views)
  • Good knowledge and experience of Backup and Recovery – RMAN including exposure to plan and strategize backup and recovery operations
  • Good SQL and Shell scripting knowledge, cron jobs, dbms jobs
  • Excellent in Database (Primary/Standby) troubleshooting skills, Analyse SQL Query performance and Performance Tuning using AWR, ADDM
  • Oracle Enterprise Manager (OEM) configuration and troubleshooting
  • Sound knowledge of Oracle RAC clusters, ASM, Dataguard, 10g/11g/12c Grid control
  • Sound knowledge to co-ordinate with Oracle corporation support/ Metalink SR support
  • OCP 10g/11g/12c RAC and ITIL V3 Certification - preferred
  • Excellent & effective communication skills
  • Mandarin and English speaking skills
  • Cantonese language skills (good to have)

Benefits:
  • MPF
  • Medical Insurance
  • Paid Holidays (annual leave: 1 day per month)
  • Sick Leaves (2 days per month)


Similar Jobs
View All Similar Jobs