Consultant, Software Engineering; Speciality

Database Service Delivery Manager

Manage our databases, with a goal to deliver secure, scalable and resilient infrastructure and software deployment capability for global solutions.

Provide administration of production, pre-production, UAT and development database systems and assist in designing of the database tier for our global payments solution. Provide a robust, scalable and high performance production database environment working with system engineers, database developers and senior database administrator.

• Responsible for database design, performance tuning, query tuning and database operations.
• Responsible for installation, configuration, creation and administration of Cassandra, Elastic Search, Redis and other No
  
  SQL databases.
• Implement proactive monitoring of all databases to predict and diagnose the majority of problems before they impact application performance or user experience.
• Configure and manage replication (Master-Master, Master-Slave, cluster replication).
• Undertake periodic upgrades of database schema and perform testing and verification of released database schema upgrades.
• Support the installation and configuration of databases for high availability.
• Work on maintaining database security (roles, privileges, authentication).
• Create and maintain documentation, procedures and best practice guides for database deployment and maintenance.
• Work with development and other support teams to participate in release and change management processes to implement new features/functions as well apply mandatory patches or upgrades.
• Given the nature of the organization and the environment MPGS, the role may require out of standard hours work to minimize downtimes occasionally. The position will also require occasional periods international travel for training and business purposes, the successful candidate will possess a valid passport and be eligible for entry to the US, UK and Australia.

• Solid experience of Database (technical) Lead or Architect.
• Solid experience in any two of Cassandra, Redis, Elastic and tuning with extensive experience as a Database Administrator in medium or larger organizations.
• Highly proficient in SQL with a solid understanding of database concepts (e.g. entity-relationship modelling, nth normal form, Object-relational mapping).
• Thorough understanding and significant experience of database backup and recovery, performance monitoring and tuning, data manipulation and migration and advanced replication technologies.
• Experience with clustering configuration, setup and maintenance.
• Strong technical knowledge of database architecture, data storage and management principles, with experience using related technologies.
• Experience with high availability architectures.
• Exposure to or good experience within the financial services/payments industry environment.