Job Description

Who we\xe2\x80\x99re looking for

We\xe2\x80\x99re looking for a seasoned and technical cloud database Engineer to be part of the Enterprise Cloud Infrastructure SRE Team and be part of the multi-year cloud transformation program that we have embarked upon. We require someone who has in-depth experience of engineering and integrating platforms and services on public cloud and has worked with development and business agile teams on successful, medium-large scale, cloud database migrations. We are looking for a passionate infrastructure and cloud advocate who understands infrastructure, development and cloud best practices, industry trends, modern technologies and new ways of working.

About Schroders

We\xe2\x80\x99re a global investment manager. We help institutions, intermediaries and individuals around the world invest money to meet their goals, fulfil their ambitions, and prepare for the future. We have around 5,000 people on six continents. And we\xe2\x80\x99ve been around for over 200 years but keep adapting as society and technology changes. What doesn\xe2\x80\x99t change is our commitment to helping our clients, and society, prosper.

The base

This role will be based in Singapore from our central business district office in CapitaGreen.

The team

You will be part of the Global Database Team within the Enterprise Cloud Infrastructure SRE Team, which is responsible for managing both on-premises and cloud database infrastructure. You will be a Cloud Database Engineer within the Databases Team who are subject matter experts for database technologies. You will engineer, build and support a best-in-class cloud database platform and service offering, and work with multiple development and business teams to onboard and migrate applications to Azure from inception to production go live. You will join a highly technical team who are mainly focused on cloud, who are integral to a successful cloud adoption and migration programme over the coming years.

What you\xe2\x80\x99ll do

• Engineer a best-in-class cloud database service offering
• Engineer and integrate cloud database solutions & services to industry best practice with scalability, fault tolerance, highly resilient, highly secure, observability, and simplicity in mind
• Run proof of concepts for new cloud database services or cloud third party tooling
• Work with InfoSec colleagues to review and enhance the Azure security posture
• Devise innovative ideas for solving hard technical problems involving distributed systems, scale and security and translate these ideas into designs and implementation
• Work with peers across the virtual cloud team to understand cloud service or enhancement priorities
• Work closely with development teams to help them through the cloud journey, evaluate and identify new cloud service requirements, and engineer and implement globally
• Work with developers to achieve the most optimal database performance and concurrency, by applying adequate indexing strategies and queries tuning techniques
• Identify, triage, and constantly automate and evolve the platform by pushing for change that improves reliability, operability and developer experience
• Every week solve exciting new challenges with an amazing team and technology stack
• Employ exceptional problem-solving skills, with the ability to see and solve issues before they affect business productivity
• Engineer solutions that are fully automated using infrastructure-as-code and integrated in the CI/CD toolchain

The knowledge, experience and qualifications you need

• Minimum 8 years as a SQL database engineer
• Certified in Microsoft Azure Administrator and minimum 2 years on Azure cloud database engineering
• Experience with modern DevOps or Infra-As-Code
• Experience with MS SQL 2005 \xe2\x80\x93 2019 and onwards
• Experience with SQL query/workload performance tuning/troubleshooting
• Experience with partitioning, In memory OLTP, Resource Governor, Query Store, SSRS and SSIS
• Experience with High Availability using SQL AlwaysOn Availability Groups and Failover Clustering Instances
• Experience of delivering improvement through debugging code and optimising queries
• Experience with creation and development of scheduled database maintenance routines
• Experience with Active Directory in relation to databases (least privilege access concept)
• Experience with in-depth technical knowledge of PowerShell, TSQL scripting and automation in relation to databases
• Experience with managing large SQL databases (10TB+)
• Experience with in-depth knowledge of security and vulnerability-based approach to security hardening
• Understanding of the importance of metrics and statistics when measuring database performance and capacity
• Experience working with development/delivery stakeholders on cloud application migrations or large scale/complex infrastructure initiatives
• Infra knowledge on Virtualisation, Database, Networks, Windows, Linux, Storage
• Understanding of PaaS, Infra-As-Code, Compliance-as-Code, and when/how to use & enable
• Experience with modern engineering and agile practices as well as shift left CI/CD
• Experienced with scripting and/or ideally one language, (e.g., PowerShell, TSQL, Python, .NET, Nodejs, Ruby, Java)
• Experience collaborating with multi-disciplinary teams of business analysts, developers, infrastructure engineers, data scientists, and subject matter experts
• Understanding of broader cloud ecosystem including Cloud Computing Technologies, business drivers and leading-edge cloud emerging technologies and trends.
• Solid interpersonal and communication skills and the ability to self-manage
• Vendor relationship management experience

The knowledge, experience and qualifications that will help

• Working knowledge of Oracle, MySQL, PostgreSQL, MariaDB database engine
• Working knowledge of Azure: Cosmos DB, MySQL Flexible, PostgreSQL Flexible database engine
• Working knowledge of AWS: Aurora, DynamoDB database engine
• Experienced in designing, engineering, and implementing cloud database solutions on Azure/AWS RDS
• Hands on experience of designing, engineering, supporting Kubernetes
• Experience of cloud transformation and change programs across technology organizations
• Cloud database certifications for at least Azure SQL (AWS RDS beneficial)
• Understanding of Google Cloud Platform, Alibaba Cloud
• Understanding Cloud Service capabilities and relative strengths (AWS, Azure, GCP, Ali)
• Passionate about building and delivering services via APIs
• Experience with modern DevOps tooling (e.g., GIT, Azure DevOps, Terraform, Azure ARM, Jenkins, Ansible, Puppet, Docker, Kubernetes)
• Knowledge of database backup solutions, including native cloud backup options
• Experience with Power BI, Azure Power Platform
• Experience working in the financial sector

What you\xe2\x80\x99ll be like

• A passionate engineer/technologist
• An engineer who has the hunger and desire to learn new technologies
• An advocate of cloud, cloud adoption and cloud transformation
• Someone who embraces collaboration and change

We recognise potential, whoever you are

Our purpose is to provide excellent investment performance to clients through active management. Diversity of thought facilitated by an inclusive culture will allow us to make better decisions and better achieve our purpose. This is why inclusion and diversity are a strategic priority for us and why we are an equal opportunities employer: you are welcome here regardless of your age, disability, gender identity, religious beliefs, sexual orientation, socio-economic background or any other protected characteristics

*Salary expectations of candidates will be considered when assessing suitable candidates. Due to the high volume of applicants, only shortlisted candidates will be contacted.

Job Reference: SIN01963

.

Schroders