Remote Redshift DBA

Summary

emerchantpay is seeking a Database Administrator with experience in AWS Redshift or equivalent column store, PostgreSQL, data modelling, and ETL processes. The role involves deploying and administering AWS Redshift, handling database infrastructure, providing DB maintenance, optimisation, and best practices, and disaster recovery planning. Benefits include professional development opportunities, paid holidays, remote work, and a benefits platform.

Requirements

• 1+ year experience using AWS Redshift or another analytic column store (or equivalent knowledge)
• 3+ years experience with PostgreSQL
• Some experience with data modelling and optimisation, ETL processes
• Experience with other DB engines (MySQL, Oracle, SQL Server, etc) a definite advantage
• Familiarity and desire to work with the latest AWS cloud-based tools and services
• Highly proficient in spoken and written English
• Enthusiastic, hard-working, and motivated team player with excellent communication skills

Responsibilities

• Be part of a growing Data Analytics team
• Deploy and administer AWS Redshift, columnar data lake, and SQL query engine
• Handle provisioning, operation, monitoring, and troubleshooting of the database and data lake infrastructure
• Provide consistent DB maintenance, optimisation, and best practices to existing Redshift clusters, data lake, SQL engine, and reporting apps
• Provide Disaster Recovery (DR) planning and execution with RPO/RTO objectives and SLAs

Preferred Qualifications

• Experience with data analytics, business intelligence, data pipelines, warehousing & reporting, etc
• Experience with technologies like S3, Glue, QuickSight, Terraform, etc
• Previous experience in the payment industry

Benefits

• Fast-growing payment company
• Excellent working conditions, casual atmosphere, and state-of-the-art hardware
• Modern, challenging, constantly growing business
• Professional development - books, trainings, certifications, etc
• 25 days paid holiday, 1 day for every 2 years with us
• Fully distributed and remote
• Benefits platform containing many benefits to choose from