DBA Engineer

The candidate must be able to provide expertise in database design, configuration, maintenance and administration for both deployment and maintenance projects and ensures performance, integrity, security and accessibility of customer's data. The candidate participates in the realization of all database systems in a complex IT systems technology in the field of biometrics applied to security or border control applications.

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.

• 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