Database Administrator (Oracle & PostgreSQL) l KL & Penang
- Full Time, onsite
- Commerz Global Service Solutions
- Wilayah Persekutuan Kuala Lumpur, Malaysia
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 PostgeSQL 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
Education Qualifications:
- Official acknowledged University / College qualifications in any related studies
- Certified corresponding post education or training in database administration of various relational databases or NoSQL databases
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 PostgeSQL 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
Education Qualifications:
- Official acknowledged University / College qualifications in any related studies
- Certified corresponding post education or training in database administration of various relational databases or NoSQL databases
| Size | 201 to 500 |
| Industry | |
| Location | Kuala Lumpur, Singapore |
| Founded | Invalid date |