Oracle - MSSQL Database Administrator DBA
Posted on Dec 8, 2018 by ComTech Europe Limited
My client are looking for a driven colleague with expertise in Oracle and MSSQL database administration.
As a DBA, you will be part of a support team managing customers databases of all kinds (Oracle, MSSQL, DB2, MySQL, Postgresql, ) on different OS (Windows, Unix-like) in hosted environments. As a team member, you participate in the daily management activities of more than 500 databases. The team operates in a very challenging context within a leading-edge technology company (Exadata, ZFS, OVM, VmWare, Vmax, Vplex, Always On, )
5 years of experience in managing all aspects of SQL Server/Oracle database administration.
Experience with SQL server 2008R2/2012/2014/2016 is required.
Experience with Oracle 11.2/12.1/12.2 is required.
Must be familiar with Always On availability group operations
Must be familiar with Multitenant (pluggable DB), Dataguard, RAC architectures
English mandatory - French is an asset but not essential.
Very good knowledge & troubleshooting skills in MSSQL from 2008 to 2016 (including HA-DR solution)
Experience with SSRS/SSIS, PowerShell, TDE is a plus.
Good knowledge & troubleshooting skills in Oracle DBMS 12c, 18c (including RMAN, Dataguard, RAC, ASM, )
Knowledge of 1 other database (MySQL, postgres, DB2, ) is a plus.
Good knowledge in database daily operations (monitoring, backup, Installation, configuration, tuning, users mgt, security roles, )
Provide 24x7 operation support on all the Production, Test and Development databases
Perform Installation, Configuration, Upgrade, and Migration of Databases
Troubleshoot and resolve database availability, connectivity, performance issues, and security issues
Troubleshoot application related issues, timeouts, deadlocks, and maintain application performance
Ensure all databases are backed up to meet the business's Recovery Point Objectives (RPO) and Recovery time Objective (RTO)
Perform database restores as needed, either in production or to refresh Test/UAT/ACC environment databases
Monitor alerts dashboard and incident ticket queue to troubleshoot and resolve database issues
Configure database monitoring using third party tools and reduce false alarms
Work on documenting database environments and standard operating procedures