
Database Administrator
Salary undisclosed
Checking job availability...
Original
Simplified
As a Database Administrator, you will be a part of a growing international team based in Kuala Lumpur Center supporting various database flavours ( eg: Oracle, PostgreSQL) on Google and Azure clouds. We are seeking candidates with wide range of expertise and skills in database field such as day-to-day administration, performance tuning, monitoring and SQL programming know-how. Preference will be given to overlapping skills across database flavours and Cloud support experience. If necessary, you will help application responsible to migrate away from Oracle to PostgeSQL on Cloud ( eg. CloudSQL) or from Sybase to Oracle or PostgeSQL on Cloud. Responsibilities - Database Administration support with main focus on Oracle and PostgreSQL in Cloud ( Google or Azure ) - Database Maintenance, housekeeping, troubleshooting. - Identify and resolve database performance issues, including tuning SQL queries, optimizing indexing, and implementing necessary database changes. - Incident, problem and change management of database-related incidents and problems, both in collaboration with other technical teams. - Provide operational support, including capacity planning, system performance analysis, and resource utilization monitoring. - Develop and maintain documentation related to database administration procedures, configurations, and troubleshooting steps. - Installation, configuration and lifecycle migrations/upgrades and patch management - Conduct ongoing monitoring and proactive management of database systems to ensure high availability and performance. - Support database backup and recovery activities, ensuring appropriate backup strategies and disaster recovery plans are in place. - SQL (PLSQL) database programming - Unix, PHP, python shell scripting - Support migrations from Oracle to PostgreSQL platform in cloud ( eg: CloudSQL) - Participate in an on-call rotation schedule to ensure 24/7 availability and response to critical incidents. - Ensure compliance with data protection regulations. Essential Skills: - Sufficient and proven experience in Oracle and PostgreSQL, in particular: - Good familiarity with cloud platforms (Azure and Google) - Database Administration, backup/recovery and Monitoring of Oracle 19c and PostgreSQL ( eg. CloudSQL PaaS) - Problem analysis resolution and error debugging including skills in raising support requests with vendors. - Database performance tuning (configuration related and application code tuning) - Database installation and configuration - Oracle's HA availability solutions (Data Guard and RAC) - RMAN backup and recovery and RMAN cloning and duplication - Data transfer/extract features ( eg Oracle’s expdp/impdp and similar tools in PostgreSQL) - Space management analysis and object reorganization - Oracle's ASM filesystem management and it's database - Database patching and migrations - Database user management (authorisation and authentication) - Oracle OEM installation and registration of targets and their OEM monitoring - Analysis of database performance reports - Advanced Unix shell scripting, PHP or Python programming skills - Advanced SQL (PLSQL) database programming (stored procedures , functions and packages) - Comprehensive knowledge in database security. - Support databases in Google Cloud Platform and on Microsoft Azure Additional preferred Skills (technical, methodology and business): - Knowledge of at least two of the following technologies: Sybase ASE, Cassandra, Redis Cache is a plus. - Knowledge in Oracle’s APEX setup and programming - Knowledge in Oracle 23c is preferred - Experience in software methodology, processes and quality assurance - Knowledge in the area of IT security - Profound interest in new technologies and self-motivated troubleshooting Personal Skills: - Goal-oriented and organised working methods - Good analytical skills - Critical Skills/Work Attitude - English language skills - Teamwork - Cloud technology knowledge