Beschreibung
Role: SQL DBA
Location: Lausanne, Switzerland
Duration: 6 months
JD - SQL DBA
Strong experience in Database Administration in SQL Server.
Experience in troubleshooting and resolving database issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Database mirroring, Replication and High Availability strategies for MS SQL environments.
Ability to identify and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
Experience in implementing operational solutions with SQL Server 2008.
SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).
SQL Development- experience in creating database architecture with associated schema as part of a software design process.
Knowledge of how indexes, index management, integrity checks, configuration, patching.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.