Senior Database Developer / DBA

  • Competitive + Benefits
  • London, England, United Kingdom
  • Permanent, Full time
  • Planet Payment
  • 28 Jan 19

This position will focus on Database Development activities with some DBA activities as well. You will provide technical support in developing and maintaining database applications and servers. There will also be a focus on optimising the database queries and managing the database servers.

High level activities:

  • Take over the knowledge and day to day maintenance of the platform’s DB HA
  • Maintenance of platform Databases , reviewing the Idera logs and addressing the issues and reporting the health of systems to the Enterprise Database Manager.
  • Audit controls monitoring and implementation related to platform
  • Archiving of data
  • Review and improve the performance of stored procedures in the platform’s reporting database
  • Work on projects related to the platform’s database​

KEY RESULT AREAS

  • Understand the business requirements and deliver the projects related to SQL server
  • Active monitoring and alerting of database servers
  • Take ownership of the database servers and ensure the servers are up to date with all service packs
  • Manage all database releases and patches
  • Self-motivated and directed, with keen attention to detail
  • Able to work in fast paced environment
  • Experience in developing programs in SQL server

KNOWLEDGE & EXPERIENCE

  • This position requires strong experience developing relational database applications with a primary focus on complex SQL joins, creating database objects like procedures, views, functions, good working knowledge on new SQL features provided in SQL Server 2016
  • Writing SQL statements for ad-hoc report generation
  • Develop and maintain reports using SSRS 2016
  • Develop and maintain SSIS packages to extract the data
  • Develop proactive relationship with system users and provide timely support when required with excellent communication skills
  • Has experience in managing DB servers that are hosted in cluster environment
  • Has experience in migration of SQL server 2008R2 to SQL server 2016
  • Has experience in setting up clusters with SQL always on features
  • Should be able to read, understand optimise the database objects
  • Manage production and test environments
  • Experience in an Agile environment desired


SKILLS 

  • Installation and configuration of SSDB, SSRS, SSIS and SSAS for SQL server 2012R2 and SQL server 2016
  • Experience implementing replication, High Availability (HA) and Disaster Recovery (DR) features (AlwaysOn, Log Shipping, Merge replication, Database Mirroring)
  • Experience with backup, restore and recovery models
  • Experience with SQL Server Audit feature
  • Experience with SQL Server jobs management
  • Developing reports using SSRS 2012R2 and above
  • Develop data driven subscriptions of reports
  • Experience in developing ETLs using SSIS
  • Strong T-SQL skills, optimization, performance tuning and debugging
  • Experience writing PowerShell scripts
  • Understanding of VMWare virtualisation environments
  • Understanding of Windows Server Operating System
  • Understanding of Failover Cluster feature
  • Understanding of Active Directory concepts
  • Experience in Agile methodologies
  • Bachelor’s degree