Description
SQL Server DBA
Galway
6 Month Contracting Role
JOB PURPOSE
Our client hosts over 60 of their Services from Real Time database-backed web-applications to large financial databases. This DBA will take a lead role in designing highly available secure OLTP and large scale OLAP systems. The SQL Server DBA's role's primary focus is the management of the organization's Microsoft SQL Server and Azure databases.
COMPANY BACKGROUND
Financial Services Company specialising in Multi-Currency Payments, Tax Refunds and Credit Card Processing.
An industry pioneer, providing excellence in payment and tax refund services for Tourists, International Retail Companies and Banks employing more than 700 across 31 countries, with Regional Offices in all major European cities, Shanghai and Singapore.
KEY RESULT AREAS
- Subject matter expert on operational and technical aspects of database administration and evaluating new technologies.
- Working with Applications Teams to devise highly-available, good performing, secure and scalable database solutions
- Technical member of Project Team for SQL consolidation and data warehousing projects.
- Owning, tracking, managing, prioritizing and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
- Reviewing service related reports (eg database backups, maintenance and data processing jobs, monitoring availability and proactive alerts) on a daily basis to ensure service issues are proactively identified and resolved within established SLAs.
- Performing object level analysis and performance tuning on SQL.
- Maintaining data standards, database security and ensure full compliance with policies and procedures, including adherence to Data Protection and PCI.
- Suggesting areas for improvement in internal IT processes as they relate to database administration.
- Configuring and providing additional SQL Server component services as Reporting Services, Analysis Services and Integration Services.
- Change and Incident Management focus
- Ability to work with support ticketing systems
- Flexibility regarding hours of coverage may be required, given the dynamic growth rate of the company. Availability to work out of business hours.
KNOWLEDGE & EXPERIENCE
- Good verbal and written communication skills and the ability to interact professionally with a diverse group, IT staff, managers and subject matter experts
- Ability to perform Root Cause Analysis of problems in a complex environment and to provide effective solutions quickly and reporting of same.
- Self-motivated and ability to work on own initiative in a pressure environment.
- Ability to generate documentation and keep existing documentation updated
- Minimum of 3 years' experience of SQL Server Database Administration supporting live production databases
SKILLS
- SQL Server installation, administration and support from SQL Server 2008 up to SQL Server 2016
- SQL Server AlwaysOn, Log Shipping and Merge replication
- SQL Server performance troubleshooting
- SQL Server Backup and Recovery methodologies
- SQL Server Audit configuration
- Database Encryption
- SQL Server jobs management
- T-SQL programming
- SQL Server Reporting Server installation and support
- SQL Server Reporting Server report development
- SQL Server Integration Server installation and support
- SQL Server Analysis Server installation and support
- Azure SQL (PaaS) Database and SQL Server on Azure VMs (IaaS) administration
- Windows Server and Windows Failover Cluster configuration
- Windows Powershell Scripting
KEY COMPETENCIES
- Must be a good verbal communicator both face to face and over the telephone.
- Must be able to operate in a dynamic, fast moving Company with moving deadlines.
- Must have proven problem solving skills.
- Must be a team player who enjoys working in a fast growing company.