fbpx

Database Administrator

Full Time Phnom Penh Posted 3 weeks ago

Technology

Job Responsibilities

  • Provide technical support & analysis
  • Implement processes, procedures and standards that contribute to quality and scale
  • Conduct research and make recommendations for database performance tuning.
  • Design and implement short-and long-term project plans to make certain database server and storage capacity to meets existing and future requirements.
  • Responsible for implementing database solutions that provide availability, scalability, performance, recoverability, and security.
  • Ability to thrive in a changing environment, and effectively and efficiently manage time across multiple projects and responsibilities.
  • Technology executing, improve process (SLA) and project plan
  • Backup database, ensure database recoverability, high availability and performance.
  • Work with developer team for new data structure design and implementation for new application feature.
  • Support business intelligent team for report tuning, data loading (ETL).
  • Resolve problems in database bottleneck areas with approaches to wait event tuning, session blocking, SQL and index tuning, and SQL profiles.
  • Oversee the administration of user all user accounts, permissions, and access privilege in production database, data warehousing.
  • Participate in pre-scheduled 24x7x365 system on-call support.
  • Monitors of scheduled batch jobs and queues including any adhoc activities: run command line, shell scripts, SQLs, run scripts, monitor queues, connect to various servers, and verify the results,
  • Ensure security and audit compliance, and data synchronization between DC and DR.

Job Requirements

  • 2+ years of experience as an Oracle DBA or related field
  • Experience with Oracle 11g, 12C, 19c & Oracle RAC is required
  • Experience in DR setup in RAC and non-RAC environment on 12c and 19c
  • Experience in Capacity planning, Space management, Database upgrades/Migration data extraction.
  • Experience on oracle database administration in variety of environment (Exadata, RedHat, Window and Solaris) and Tuning memory & Tuning disk usage.
  • Experience in performance tuning and monitoring using various tools such as stats pack, TKPROF, SLQ TRACE and Explain Plan
  • Experience in various MML, configuration such. as OSB, NBU, SIMPANA ect.
  • Good understanding in PL/SQL and stored procedures development, shell scripting & SQL comfortable with the use of partitioning, materialized views, and analytic function and non A
  • Outstanding problem solving and analytical skill
  • Good communication skills
  • *Business understanding
  • The related industry, the understanding of company values & culture
  • Good communication skills, both verbal and written English
  • Excellence organization and time management skills
  • Having high level of confidentiality, integrity and business ethic
  • Ability to work under pressure and tight deadlines
  • Be detail oriented
  • Be able to carry out multiple assignments
  • Have effective coaching and mentoring guideline
  • Flexible with 24*7 environment including on call support as per requirement