Database Administrator 2 Job in Bengaluru at Cashfree Payments

Cashfree is hiring for the role of Database Administrator 2!

Responsibilities of the Candidate:

• Responsible for supporting and maintaining real-time mission-critical and decision-support databases in a highly available heterogeneous environment.
• Work in a collaborative team environment where changes are reviewed and communicated with all members.
• Drive projects from start to end by collaborating with all stakeholders and making sure no/minimal business impact.
• Handle user requests in terms of complex query analysis, online schema changes, and ensuring DB Policies are followed in terms of Analyzing slow query Backups, Data retention/archive, Tuning applications for DB endpoints on Prod and non-prod Environments
• Install, configure, and upgrade database software and stable monitoring to ensure system stability.
• Archive data from primary databases to archive locations. Perform schema data refreshes

Requirements: 

• 2+ years of combined hands-on experience in database administration of MySQL and MongoDB.
• Must have worked on MySQL versions 5.7+ and MongoDB versions 4+
• Hands-on experience on AWS Cloud Database service RDS.
• In-depth knowledge of MySQL InnoDB engine.
• Mongo Replication Cluster setup and maintenance with making sure 5 nines.
• Good in Query tuning, and development tasks (writing/reviewing Queries and functions in MongoDB & Stored Procedures, Triggers, Functions for MySQL).
• Backup (Full & incremental & differential) / Online schema changes / Archival methodology.
• 2+ years experience with Linux, including experience writing scripts.
• Experience with MySQL Replication configuration (Master/Slave), setup and maintenance.
• Good understanding of logical and physical modeling of databases.
• Any working experience in Redshift is a plus (but not mandatory) Other AWS services experiences e. g., Document DB, DMS, S3, etc. are a plus.