Job Responsibilities
* 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.
Skills Required
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.