Oracle DBA & Developer is involved in both product development activities, with a clear focus on integration of Oracle into trovicor technology stack, as well as project activities, supporting field-deployed teams with performing delicate procedures on production databases.
RESPONSIBILITIES & MAIN DUTIES
- Participating in product development process and designing scalable database architecture with focus on Oracle
- Sharing DBA expertise with engineers installing trovicor systems at customers’ sites
KNOWLEDGE / EXPERIENCE REQUIRED
- At least 8 years of proven experience in Oracle administration
- High volume database development and administration
- Backup and recovery with Oracle RMAN
- Upgrade and patch process for the Oracle Database
- Scripting of SQL maintenance and installation scripts with Linux Bash and SQL*Plus
- PL/SQL development
- Development of data migration and ETL software
- SQL Reporting with advanced Oracle SQL Features
- Working with a entity-relationship model
- Linux Knowhow
- Oracle certification like the OCA or OCP
- Experience in virtualisation technologies (VMWare, Zen)
- Experience in developing Java applications on top of SQL databases
PERSONAL SKILLS REQUIRED
- Good interpersonal skills
- Team player but able to work on own initiative
- Flexible and adaptable
- Good written and oral communication skills
- Enthusiastic, self starter and highly self motivated
- Appreciation of cultural differences
- Attention to detail
ADDITIONAL SKILLS
- Design, develop and manage data on Cassandra cluster
- End-to-end performance tuning of Cassandra clusters
- Software patches and upgrades
- Capacity planning
- Cassandra connectivity and Security in AWS
- Monitoring & Troubleshooting
- Data Modeling, design & implementation
- Establishing and driving standards within the team
- Conducting Cassandra training
LANGUAGE(S)
Fluent oral and written English mandatory
REPORTING TO
Head of Integration
Based in Malaysia