Job id : 42380

Senior Database Engineer

Senior Database Engineer

  Pune
   Mastercard        Pune
  4 hours ago      27 Applied
Job details

Job Type

  Full Time

Functional Area

Software Development,Database Administrator/ Data warehousing

Industry

Banking/Financial Services/Insurance

Education

Not Specified

Experience Required

  4 - 8 Yrs

Skills Required

   postgres,reddis,nosql databases,cassandra,elastic

Job Description

Job Posting Title

Senior Database Engineer

Job Description Summary

Database Service Delivery 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

Role

• Responsible for installation, configuration, creation and administration of Postgres, Reddis and NoSQL 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 organisation and the environment MPGS, the role may require out of standard hours work to minimise 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

All About You

• Solid experience in anyone of Postgres, Cassandra, Reddis, Elastic and tuning with extensive experience as a Database Administrator in medium or larger organisations.

• 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

• Experience in implementation & support of NoSQL technology (Cassandra)

• Exposure to or good experience within the financial services/payments industry environment (e.g Banking, Credit Card Scheme)

• Experience with web technologies and Unix shell scripting

• Bachelor’s Degree or the equivalent qualification/industry experience within IT/eCommerce

• Any Enterprise Database certification is a desirable qualification

• Hands on approach to problem solving

• Strong communication skills both written and verbal coupled with strong problem-solving skills

• Exposure and practice with any or all of the following is a plus: Remedy, Jenkins, ITIL, CMM,Six Sigma, Agile, Scrum, and Kanban

• Positive attitude with the ability to adapt and be flexible within a fast-paced environment