【Role & Responsibilities】
This role is to spend more time on SQL statement, stored procedures, and database performance turning, but not on database administrative routines.
Most of the time DBA has to work with application team members during system design phase to provide best practice for DB performance and to advise necessary SQL statements or table / DB level adjustments for better performance based on production application or DB metrics.
DBA also contributes projects with following areas,
• Assist project manager in work package/component system design to make sure that quality metrics are met in terms of maintainability, reliability, scalability and resilience
• Perform 3rd level support during and after office hours to ensure soonest possible recovery time to service
• Constantly keep up to date with technological advancement and patterns and to ensure that skill sets are kept relevant in contributing to the development of better-quality products
• Work closely with project manager to highlight any unplanned utilization pattern which may include both under- and over-utilization
【Requirement】
• Strong DB skillsets, with high focus on Oracle and at least 3~5 years DB management hands-on and performance issue solving experience.
• Familiar with PLSQL.
• Understand NoSQL, such as MongoDB, Apache Cassandra, and Apache Ozone, will be a plus.
• Understand database engineering best practices.
• Experience in creating data models for RDBMS, and familiar with data modeling tools.
• Database server administration experience and have the basics of running database.
• Strong experience with database design and data architecture, store procedure development.
• Strong database/store procedure performance tuning, and optimization experience.
