DevOps Data Services Engineer

Singapore

Job Type

Full-Time

About the Role

The DevOps Data Services Engineer shall work closely with various Technology teams to deliver reliable, scalable and serviceable data services infrastructure to the various environments that implement in-house's product portfolio.

The role shall be highly technical and shall be responsible for research, design, implementation through automation, support and systems engineering assignments. A consistent approach to performance and measurement shall underpin all activities. Information security considerations shall also be a primary obligation of the role.

The role demands strong data organisation, data structure and data hierarchy knowledge and robust understanding of at least one of the RDMS listed below from the perspectives of the theory of operation and best-practice deployment and use. Infrastructure-as-code and deployment automation skills would be a bonus.

The incumbent will require strong communication and collaboration skills and the motivation to achieve results in a dynamic business environment.

Requirements

The activities of a DevOps Data Services Engineer include but are not limited to:

  • Continuously updating core knowledge and skills in the RDBMS of choice

  • Manage changes to DB infrastructure, server software and Altenar applications according to change management and testing procedures

  • Proactively monitoring long-term performance trends to anticipate when the limits of the current deployment will be reached and initiate capacity upgrades

  • Working with the different Technology teams to respond to events or incidents and bring them to an appropriate resolution

  • Proactively monitoring and testing the backup of online data and the ability to recover from partial or catastrophic failure

  • Participation in the Architecture Review process to ensure new initiatives or major changes to the Altenar product portfolio have Data Services representation at the inception phase

  • Participation in the research, test, design of new data services tools for online or warehoused data

  • Explore new technologies to help evolve data services in-house

  • Support activities related to data warehousing and business intelligence

  • Working in close collaboration with software development teams including code review

  • Owning the best practice use of database systems, including performance and information security aspects

  • Contributing to technology selection and standardization efforts

  • Scoping and estimation of tasks and effort required for your work

  • Adopting an internal service provider approach to data services to ensure reuse of developed practices and validated designs across the product portfolio where this is suitable

  • Contributing to the automation and reproducibility of database bootstrap and configuration deployment

  • Work across teams (with others such as the DevOps Toolchain engineer, infrastructure, security engineers and development team leads) to drive the most optimal solutions

  • Work in a fast-paced, dynamic, multinational, multicultural environment

  • Creating and maintaining documentation for the solutions provided


Experience / Skills Required:

  • Work with one or more of Microsoft SQL (2016-2019), PostgreSQL (10+) and MySQL both in-house or through CloudSQL offerings from major public cloud providers such as Google or Amazon

  • Experience in operating and the design of one or more of these RDBMS in a high-availability environment at considerable scale and throughout various operations of the lifecycle

  • Experience writing scripts, stored procedures, T-SQL queries

  • Experience in database optimization such as query / index tuning, storage

  • Formal training and/or certification in one of these RDBMS is highly valued

  • Being well-versed in the use of one or more general-purpose, document-based database such as MongoDB or Elasticsearch is highly valued

  • Prior direct or indirect involvement in data warehouse design, tool selection and support

  • Well-versed in scripting languages relevant to these data service technologies (PowerShell, Bash, or Python)

  • Familiarity or experience with Ansible is highly valued

  • Some experience in using Git version control in the context of configuration management

  • Experience and knowledge in the domain of server and storage hardware, logical volume management, IO performance and networked storage

  • Experience in the use of virtualization for databases

  • Experience with message queues such as NATS, RabbitMQ, Kafka is highly valued

  • Generic system administration experience in heterogeneous environments (Windows / Linux with RPM package management predominantly)

  • Understanding TCP / IP networking is valuable

  • Strong communication and collaboration skills

  • Excellent problem-solving skills

  • Strong research and validation skills

  • Strong coaching and presentation skills

  • Proficient in spoken and written English

  • Graduate-level education in Computer Science, Engineering or another relevant field