SQL Server DBA

SQL Server DBA Image
SQL Server DBA




Ref: E6228EOG

Job Description

Dublin based utilities clients requires a SQL Server DBA to join their team on a permanent basis.

Job Responsibilities

  • Manage SQL Server databases
  • Configure and maintain database servers and processes
  • Monitor system’s health and performance
  • Ensure high levels of performance, availability, sustainability and security
  • Analyze, solve, and correct issues in real time
  • Provide suggestions for solutions
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with query tuning and schema refinement
  • Provide 24/7 support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours

Experience Required

  • Minimum of 5 years’ experience with Database Administration / Development for Microsoft SQL Server (2005,2008 and 2012).

Essential and Desirable Skills

  • Experience in troubleshooting and resolving database problems.
  • Experience in managing multiple clustered SQL server databases on shared storage.
  • Experience with backups, restores and recovery models.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server including log shipping and clustering.
  • Excellent Knowledge of indexes, index management and statistics.
  • Experience of Database design (normalization, experience with VLDB management).
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with Reporting and Analysis Services and working with BCP.
  • Experience with SSIS packages development and deployments.
  • Experience with SQL Server database table Partitioning.
  • Experience with distributed queries / federated tables.
  • Proven experience using T-SQL and query optimization.
  • Experience in implementing operational automation using scripts, including PowerShell.
  • Experience working with Windows server, including Failover clustering and Active Directory.
  • Mysql knowledge will be additional advantage
  • Experience in designing optimized disk configurations.
  • Good working knowledge of TCP IP and DNS.
  • Good communication and documentation skills.

Educational Requirements

  • Third level degree in a related subject.

Working Hours & Benefits

  • 37.5 Hours per week
  • Annual leave
  • Pension
  • Healthcare contribution

How to Apply

If you are interested in this role, then please Apply along with your updated CV and I will be in touch with you to discuss your application in more detail, otherwise feel free to connect with me by whichever medium you are most comfortable with be that Linkedin, Email or Telephone. Remember we have limited our site to a maximum of 200 Jobs so if this Role is not a 100% match to your requirements please be sure to connect with us as we will most likely have another role which you may find more suitable.

Apply for Job

Not what you're looking for?

If this isn't the job for you then why not reach out to one of our consultants today and send us your CV so we can find the one that is?

Reach out to a Consultant