Hele denne side er en annonce i samarbejde med Nortra Online.

Data Warehouse DBA

  • TransferMate
  • Remote (Danmark)
  • 23/05/2022
IT

Jobbeskrivelse

TransferMate Global Payments is one of the world's fastest-growing FinTech companies and is transforming the way businesses pay and get paid across international borders. We are a Globally Regulated, B2B Payments technology company, working with banks, companies and strategic partners, such as Wells Fargo, AIB and ING.


As TransferMate continues to grow rapidly, our people and teams are too! We are currently looking for a Data Warehouse DBA.

What you will be doing:

  • Contribute to the team’s data engineering and architecture best practice polices
  • Understand business goals, strategy and work with the senior architects to implement those into an appropriate technical solution while following best practices.
  • Architect and design a data warehouse solution with the support of the Software and AWS architect, lead by example and best practices.
  • Lead from the front with database mappings and transformations to the data warehouse.
  • Be a leader in database best practices, optimisations, indexing, performance in a hybrid environment. You will be working closely with the database architect to implement these items. With the focus on AWS cloud.
  • Contribute to architects in establishing and implementing a vision, road map, setting timelines for tasks and governance to ensure best practices and security to deliver a closed secure system.
  • Performance tuning and optimisation at ETL services, database, application PL/SQL.
  • Ensure that best data architecture principles and standards are integrated and followed for modelling, stored procedures, regulations, and security, among other concepts, to meet technical and business goals.
  • Continuously improve the quality, consistency, accessibility, and security of data activity across company needs.
  • Work with architects to make an impact in the migration of data from legacy systems to new solutions. (database-per-service approach).

Requirements

About you:

  • Experience in handling the delivery of data and information relating to the business intelligence
  • Design, develop and maintain data warehouse and analytics architecture to meet an enterprise's business analysis and reporting needs.
  • Working knowledge of Database/Data Warehouse functionality leveraging AWS
  • Experience in complete data modelling and data solution designs
  • Experience with data modelling and data warehousing
  • Experience with Redshift and Power-BI or other reporting tools
  • Hands-On experience with managing and implementations of databases.
  • 2+ years of overall experience in AWS databases, to include a minimum of 5 years of key data warehouse and database administration exposure and delivery of best practices.
  • Experienced working with AWS Redshift and transformation tooling related to ETL.
  • Familiar working with many database engines, with the focus on the latest technology – AWS Aurora, Serverless, MariaDB, Postgres and DynamoDB
  • Tuning databases for performance, size, application, indexing.
  • Experience in database security
  • Working on a database per service model approach from a legacy monolithic model.
  • Experience in migrating large database to new and improved designed systems.
  • Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
  • Review and clean up DDL structures across all databases, optimise queries and query plans.

Key Skills:

  • Data Warehouse Design
  • Data Warehouse ETL
  • Troubleshooting warehouse issue and mapping of objects
  • Support Database schema design
  • Support Database performance and optimization
  • Support Database migrations
  • Overseeing Serverless databases Aurora, MySQL, Postgres, DynamoDB, MariaDB to name the main ones.
  • Database security, Schema security, Masking, Scripting, Data Warehouse support, ERD, ETL tooling

Experience in:

  • Multiple highly available database environment
  • Experience in mapping complex data models
  • Flexible, team player, get it done personality.
  • Enable self-serve across the business through use of reporting and insight tools e.g. PowerBI
  • Experience with serverless architecture and serverless AWS database solutions (Aurora, DynamoDB, Redshift).
  • Familiar with AWS technologies and code pipeline updates to a database.
  • Excellent written and verbal communication.
  • Deep knowledge in Relational Databases (PostgreSQL preferable), Aurora, NoSQL and Data Warehouses.


Benefits

In our organisation, you will join enthusiastic and energetic colleagues who are ambitious, helpful and welcoming. You will also join a collection of award-winning companies which take career progression and corporate responsibility extremely seriously, all within a positive and friendly workplace culture.

Benefits

  • Competitive pay
  • Bonus
  • Health
  • Pension
  • Work flexibility

Additionally, we provide

  • An excellent benefits package includes a company pension scheme, Laya healthcare cover and life insurance.
  • We appreciate that our company growth and employee recognition go hand in hand, and we have multiple recognition programs in place including our Milestone Recognition Program, our Bright Ideas Program and our Employee All-Star Awards.
  • Recognised within the top 10 best workplaces in Ireland by Great Place to Work®, you will join an organisation that values and promotes a healthy mind, body and work-life balance through our renowned employee wellbeing program; GroupLife.
  • Additional perks include a flexible working schedule

Are you ready to take the next step in your career with an award-winning company? We will shortly be holding interviews for the role so apply today!