Purpose
This role designs, configures, and manages databases to ensure the performance, integrity, security and accessibility of the customers' data.Key Missions
Within IDEMIA Public Security division / Travel & Transport, the candidate will be in charge of:
- Create and maintain all databases required for development, testing, and production usage including rollout and upgrade.
- Perform the capacity planning required to create and maintain the databases.
- Plan and implement backup and recovery of the databases.
- Execution of data migration jobs and scripts as required.
- Implement and enforce security for all of the Databases.
- Monitor and measure the performance and availability of database system proactively; daily check the scheduled database backups and jobs; implement corrective actions identified to improve performance and availability.
- Contribute to the creation and maintenance of disaster recovery plans.
- Determine and document DB policies, procedures and standards.
- Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
- Respond promptly to incidents, investigate and provide temporary &/or permanent solution of incidents escalated, provide timely status update to relevant parties.
- Participate in community sharing with other DBAs of IDEMIA Public Security division.
- Participate in system integration test, system validation test, load and performance test, and high availability test.
- Investigate on the issues by analyzing logs during test execution, report incidents through configuration management tool and monitor them until closure.
- Produce documents related to installation, testing or operational and administration.
- Provide training to customer and handover system to maintenance support team.
- Any other duties as assigned.
Profile & Other Information
- At least 5-10 years’ in depth Oracle Database / MQ SQL Database administration experience in an enterprise level environment
- Ability to perform both Oracle and Microsoft operating system performance monitoring and the necessary adjustments.
- Excellent knowledge of Oracle/MS SQL backup and recovery scenarios, high availability and replication technology.
- Experience in Oracle/MS SQL reporting, static gathering, tuning, and Windows/Unix/Linux shell script.
- A good knowledge of physical database design.
- Knowledge and experience of Oracle RAC (clusters), MS SQL Always ON.
- Knowledge of VEEAM Backup and Replication for databases
- Strong in Scripting (Perl, Bash, Power shell, python...) and Database (Oracle or SQL server…).
- Proficient in installation and configuration of system monitoring tools for database
- Produce documents related to installation, testing or operational and administration.
- Provide training to customer and handover system to maintenance support team.
- Implementation of Document and time series database like Elastic, Mongo etc. will be an added advantage.
- Implementation and maintenance experience in PostgreSQL DB will be an added advantage
- Bacherlor's degree in computer science or relevant discipline
- Advanced level of English
- Good communication skills