Oracle / MS SQL Database Administrator

• Providing 24x7 operation support on all the Production, Test and Development databases;
• Performing Installation, Configuration, Upgrade, and Migration of Databases;
• Troubleshooting and resolving database availability, connectivity, performance issues, and security issues;
• Troubleshooting application related issues, timeouts, deadlocks, and maintaining application performance;
• Ensuring all databases are backed up to meet the business’s Recovery Point Objectives (RPO) and Recovery time Objective (RTO);
• Performing database restores as needed, either in production or to refresh Test/UAT/ACC environment databases;
• Monitoring alerts dashboard and incident ticket queue to troubleshoot and resolve database issues;
• Configuring database monitoring using third party tools and reducing false alarms;
• Working on documenting database environments and standard operating procedures.

Required:

• B.S in Computer Science, Information Technology, Electrical Engineering or equivalent technical training and experience;
• 5 years of experience in managing all aspects of SQL Server/Oracle database administration;
• Experience with SQL server 2008R2/2012/2014/2016 (including HA-DR solution), very good knowledge and troubleshooting skills are required;
• Experience with Oracle 11.2/12.1/12.2 is required;
• Good knowledge & troubleshooting skills in Oracle DBMS 12c, 18c (including RMAN, Data Guard, RAC, ASM) – at least 3 years’ experience;
• Must be familiar with Always On availability group operations;
• Must be familiar with Multitenant (pluggable database), Data Guard, RAC architectures;
• Good knowledge in database daily operations (monitoring, backup, Installation, configuration, tuning, users mgt, security roles);
• English is mandatory.

Desirable:

• Experience with SSRS/SSIS, PowerShell, TDE;
• Knowledge of 1 other database (MySQL, PostgreSQL, DB2);
• SQL, PL/SQL knowledge;
• French.