Database Platform Engineer in London, England - Mailing list pgsql-jobs

Our client, an asset management firm, in London, is looking for an 
innovative, driven self-starter engineer to join the Database Platform 
Team with a strong focus on automation and a broad knowledge of database 
technologies. The ideal candidate will have extensive experience with 
databases such as PostgreSQL and MongoDB as well as AWS managed database 
offerings. Operational knowledge in Linux and Python programming is also 
essential. The role involves designing, implementing, and managing 
database solutions that support our organization’s data management needs 
while ensuring high availability, performance and security as well as 
having a heavy focus on coding and automation. The candidate will embody 
a mindset of continuous learning and process improvement.

As a Database Platform Engineer you will be involved in:

• Design, implement, and manage database solutions across a variety of 
platforms including PostgreSQL, Snowflake, ClickHouse, SQL Server, 
Aurora, RDS, DynamoDB, and MongoDB.

• Develop the golden build for all PostgreSQL, ClickHouse, MongoDB, RDS, 
and Aurora installations, setting the standard for database excellence 
within the organization.

• PostgreSQL administration SME with 5+ years of experience managing 
PostgreSQL databases on-premise and on AWS.

• Develop and maintain automation scripts and tools to streamline 
database operations and processes.

• Ensure database systems operate efficiently, with high availability 
and performance.

• Implement and manage database security measures, including access 
controls and encryption.

• Collaborate with development teams to optimize database structures, 
queries, and indexes.

• Conduct regular database maintenance tasks, including backups, 
restores, and performance tuning.

• Monitor database systems to identify and resolve issues proactively.

To be considered a good cultural fit, you must be:

• An ambitious self-starter, hungry and driven to learn.

• A very strong and efficient communicator and collaborator.

• Able to multi-task and excel in a high-pressure, fast-paced trading 
environment.

• Work well under minimal supervision to complete projects and tasks on 
time.

• Able to think on your own to develop quick and sound solutions to 
complex problems.

• Strong desire to solve with automation and self-service.

• Willingness to participate in on-call rotation during off hours and 
weekends. Initially one week every five (will vary based on team size).

• Stay up to date with emerging database and automation technologies, 
trends, and evaluate their applicability to our environment.

• Quick learner.

To be considered a good technical fit, you must have:

• A minimum of 7 years of hands-on experience managing medium/large 
enterprise database platforms

• Expert knowledge of PostgreSQL features, functionality and 
optimization techniques including RDS and Aurora flavors

• Strong knowledge of at least at least one of MongoDB, DynamoDB, 
Redshift and Snowflake

• Operational Knowledge of SQL Server

• Strong knowledge of data modelling across different database systems

• Strong knowledge of Linux

• Experience using Python for automation tasks

• Experience with Infrastructure as Code tools, such as Terraform and 
Cloud Formation

• Experience running applications and databases in containers (Docker, 
Kubernetes)

• Experience with CI/CD platforms and automation of SDLC processes

• Experience in declarative automation tools such as Puppet and Ansible

Bonus points for:

• Knowledge of reporting solutions such as PowerBI or Tableau

• Experience managing OLAP database engines like ClickHouse, Druid or 
Apache Pinot

• Practical experience in the deployment and management of Apache 
Zookeeper or similar distributed coordinators

• Strong scripting knowledge of Powershell and Powershell Core

Proficiency in orchestrating and scheduling complex dataflows using 
Apache Airflow

Tom Morgan
Managing Partner
Pencom Systems, Inc.
phone:  212 671 1967
mobile: 917 742 7612
http://www.pencom.com/
http://www.linkedin.com/in/tommorgan1