SQL Server DBA

DBA multi-SGBD
expert database in a production environment

Context
Within an Engineering team Databases DBA responsible for Oracle, MySQL and SQL Server databases, responsible for defining the rules relating to the DBMS, approve requests to create databases, ensure the operational maintenance of those -Ci, monitor trends and develop the necessary infrastructure to deploy them, save them and supervise.

Location: Paris Region (92)

Duration: Contract until end of 2015

Mission/Tasks

- Manage incidents, changes, MCO, Support N2/N3 all Oracle databases, MySQL, SQL Server and MongoDB
- Optimize Incident Management
- Strengthen the team with your skills on MySQL and MongoDB technologies
- Participate in the development of Shell Scripts administration and industrialization
- Participate in the development of the Intranet DBA (PL/SQL, PHP, Javascript)
- Optimize administrative procedures and industrialize
- Optimize backup management
- Optimize Change Management

Implementation of solutions and appropriate resources, monitoring and reporting on the progress of the project:

- Optimization Report + solutions Incident Management: 31/03/2015
- Optimization Report + solutions on the management of change: 30/06/2015
- Optimization Report + solutions on managing backups: 30/09/2015
- Optimization Report + solutions on the administration on a large scale: 31/12/2015
- Comprehensive review unified base DBMS solutions: 06/30/2016

Skills/Abilities Required:

- ADVANCED KNOWLEDGE OF MYSQL AND REPLICATION TECHNOLOGIES, MYSQL CLUSTER, MONGODB AND LINUX
- developing advanced level of Shell and PHP scripts
- Good knowledge of Oracle technologies and SQL Server
- a first experience in wide production environment

Are a plus:

- Administration of backup (RMAN, MySQL backups ...)
- tuning SQL queries (hints, map)
- HTML, Javascript, PL/SQL

Reactive profile, rigorous, with good interpersonal skills
comfortable with linux, MySQL, Shell, PHP: mongodb cluster and oracle
SQL Server industrialization and automation script

ADMINISTRATION
BD: CONTROL
System Administration: KNOWLEDGE

LANGUAGE:
SHELL: Expertise

SYSTEMS:
Linux: MASTER
UNIX: KNOWLEDGE
SOLARIS: KNOWLEDGE

DATABASE:
MySQL: Expertise
SQL SERVER: KNOWLEDGE
Oracle: KNOWLEDGE

WEB:
PHP: KNOWLEDGE
JAVASCRIPT: Beneficial

METHODOLOGY:
HTML: Beneficial

NETWORKS/PROTOCOLS/SECURITY:
TCP/IP: KNOWLEDGE