Database Developer - SQL DBA

Information Technology Galway, Ireland


Description

 JOB PURPOSE
 
Provide technical support in developing and maintaining database applications and servers. Heavy focus on optimising the database queries and managing the database servers. It is a back office application build on Microsoft technologies using .Net and SQL Server 2008 R2.
 
COMPANY BACKGROUND
The Fintrax Group is a Financial Services Company that specialises in tax refunds, multi-currency payments, credit card processing and point of sale technologies. Employing over 800 people worldwide, Fintrax provides international shoppers, merchants, card acquirers and banks with an expanding range of services, increasingly leveraging the latest mobile technologies.
Fintrax works with some of the most desirable luxury and retail brands in over 30 countries. The company has been on a strong growth trajectory, experiencing growth in revenues of over 20% and growth in profitability of over 30% annually since 2011. This growth is set to continue and our plans are based on a strong business model underpinned by megatrends such as the expansion of middle classes in emerging markets, growth in international travel and increasing luxury consumption.

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
  • Could be able to work in fast paced environment
  • Have 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 2008 R2.
  • Write SQL statements for ad-hoc report generation
  • Develop and maintain reports using SSRS 2008 R2
  • 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
  • Have experience in managing DB servers that are hosted in cluster environment
  • Have experience in migration of SQL server 2008R2 to Sql server 2016
  • Have 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
  • Work in Agile environment
SKILLS

Essential 
  • SQL server 2012R2, SQL server 2016
  • 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
  • Working experience in excel using like Pivot etc
  • Experience in Agile methodologies
  • Bachelor’s degree 
Nice to have
  • Good to have exposure to database configuration tools like Red-gate, Idera and TFS
  • JIRA experience