Senior DBA Support 5 views

Duties & Responsibilities
The DBA in this position will have passion for data and knowledge around Big Data and various databases. This position will bring expertise in building and maintaining databases environment. This role includes, expert escalation for troubleshooting production issues, assists in development lifecycle, stabilization and optimization, DB instance performance monitoring and tuning, continuous improvement, automation, partnering with Engineering on certification of platforms / versions / features, partner with Monitoring team to establish monitoring program, metrics & reporting, contributing to technical architecture and plan for the database space, and ensuring a high-level of reliability and availability for all database environments.

  • Work closely with programming staff on database design changes to meet business requirements.
  • Create models for new database development and/or changes to existing ones.
  • Design, architect, and build databases from determining business requirements.
  • Respond to and resolve database access and performance issues.
  • Write and troubleshoot complex stored procedures.
  • Develop and design database objects, such as tables, indexes, constraints, etc.
  • Organize and format data for efficient query and storage processes.
  • Modify existing databases and database implementations or direct programmers and analysts to make changes to optimize performance.
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Duties include performance analysis and tuning, index maintenance, and monitoring of data.
  • Perform database and software life-cycle activities to ensure highest level of system performance and availability and compliance with business requirements.
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Establish appropriate end-user database access control levels.
  • Schedule, plan, and document installation, operation, and testing of database environments.
  • Some on-call support will be required.
  • Primary on day to day schema changes and database maintenance
  • Help developers to optimize queries, stored procedure and database design
  • Assists in developing and implementing best practices for DR and Backups
  • Assists in evaluating and selecting equipment, services and vendors
  • Assist in Defining and implementing maintenance plan for the database systems

Qualification & Requirements

  • B.S in computer science, information systems or comparable field required
  • Minimum 1 years of experience as a Database Administrator with Postgresql. Preferred platforms include SQL Server, Oracle, MongoDB, MySQL and MariaDB.
  • 1 or more years of experience with Big Data software or Data warehousing.
  • Strong understanding of database structures, theories, principles, and practices.
  • Working technical experience with designing, building, installing, configuring and supporting database servers.
  • Hands-on database tuning and troubleshooting experience.
  • Experience with data processing flow charting techniques.
  • Solid understanding of database design principals
  • Solid understanding of query execution plans
  • Good SQL scripts skill including SPs, PSQL scripting
  • Good performance tuning skills
  • Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore, replication.

More Information

Only candidates can apply for this job.
Share this job
Company Information
  • Total Jobs 8 Jobs
  • Location Phnom Penh
  • Phone 016 777 983
Connect with us
Contact Us
https://www.cambodiajob.asia/main-javascripts/framework/functions/noo-captcha.php?code=868d1

ABOUT US

Cambodia Job is leading Cambodia’s premier job announcements. Find the best jobs with Cambodiajob.asia in Cambodia; sign up to receive daily jobs by email. Send your CV to Cambodia employers recruitment agencies.

CONTACT US

Building: #23 (KT Tower), St. 112, Sangkat Phsar Depo III, Khan Toul Kork, Phnom Penh, CAMBODIA.
Email: info@cambodiajob.asia

Tel: +855 77 268 005

        +855 10 761 126

 

More Details…