SQL Database Administrator/SQL Server DBA

We are looking for SQL ADMINISTRATOr for an urgent opening with one of our esteemed clients.

JOB TITLE: SQL ADMINISTRATOR

LOCATION: DUBLIN, IRELAND

JOB TYPE: CONTRACT

JOB DESCRIPTION FOR SQL ADMINISTRATOR:

A Person with at least 5+ years of experience administrating and supporting Microsoft SQL Server.
Working experience with the latest versions of SQL Server (ie 2005, 2008 R2) as well as the following topics:

ADMINISTRATION OF SQL SERVER

- Server configuration
- Trace flags
- Server settings
- Security options

SQL SERVER BEST PRACTICES

- Memory settings
- Database design
- Index fragmentation
- Statistic

SQL SERVER MAINTENANCE

- Installation of SQL Server
- Server design
- 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)

ABOUT THE EMPLOYER

The employer is a multibillion dollar global IT Services company which specializes in providing IT services, outsourced research and development, infrastructure outsourcing, business process outsourcing (BPO) and business consulting services to many global Fortune 500 clients across various verticals like financial services, retail, transportation, manufacturing, healthcare services, energy and utilities, technology, telecom and media.

ABOUT US

Avance Consulting is one of the UK's fastest growing talent acquisition companies. Head quartered in London, we are a global reach agency with a large presence in UK, Europe, US and India.

If you are interested in this SQL ADMINISTRATOR opportunity, please APPLY NOW.