Cashfree - Senior Database Administrator - MySQL/MongoDB

Full–time
Job Description : Responsibilities : - You are responsible for supporting and maintaining real-time mission-critical and decision-support databases in a highly available heterogeneous environment.- You will work in a collaborative team environment where changes are reviewed and communicated with all members.- Should 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 queries Backups, Data retention/archive, Tuning applications for DB endpoints on Prod and non-prod EnvironmentsRequirements : - 3+ 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.- Understand, Analyze & Ability to tune MySQL and MongoDB queries.- 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, and Functions for MySQL).- 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- 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 over 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. is a plus