SQL Server DBA

Dublin  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

PRINCIPLE ACCOUNTABILITIES:

Administration of SQL Server

Server configuration
o Trace flags
o Server settings
o Security options

SQL Server best practices
o Memory settings
o Database design
o Index fragmentation
o Statistic

SQL Server maintenance
Installation of SQL Server
Server design

o Hardware requirements
Storage
Memory
NIC

Disaster recovery strategies
Point in time data restore
Log Shipping

High Availability options
Database mirroring

Troubleshooting various types of issues
Performance
Server Down
Connectivity
Misconfiguration
Blocking
Deadlocking
Data corruption
Additional topics of interest
Understanding T-SQL language, PowerShell
Windows 2008 R2 features (DFSR, Memory management, Virtualization)

Note: Should have EU passport and be ready to travel to US for transition for the first 2-3 weeks of contract.

Start date
n.a
Duration
Initially 5 months and extendable
(extension possible)
From
Blackapple Solutions Ltd
Published at
02.02.2013
Project ID:
483386
Contract type
Freelance
To apply to this project you must log in.
Register