Beschreibung
Role: SQL DBA
Duration: 3 to 6 months
Location: Lausanne, Switzerland
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.