Lead Db Developer Job in Yorshr

Lead DB Developer (Mumbai)

Posted On: 11th Aug 2021

One of our esteemed Clients is dealing in Finevest Services, They believe in providing financial access to the underserved customers with a range of product offerings and are a one stop solution for all your credit requirements, categorized and customized as per your needs, with 1800+ customers; 180+ employees. They are looking for an experienced MySQL database Developer who will be responsible for ensuring the performance, availability, and security of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required. Knowledge of AWS is preferred. Knowledge of Fintech Domain is a plus. Responsibilities: Be able to take a leadership role in design/architecture of the entire ecosystem of Database platforms over the cloud. Sound Knowledge of AWS with MySQL. Handle common database procedures, such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and tweak as necessary. Collaborate with other team members and stakeholders. Identify opportunities for improved performance in SQL operations and implementations. Oversee the operations of the production and staging environments databases, ensuring process align with release processes. Design, implement and monitor disaster recovery plans as it pertains to the production database environment. Perform technical troubleshooting to diagnose, isolate and correct data and database issues. Give design recommendations for database functions that meet business operating standards while improving the efficiency of business processes. Migration of PostgreSQL to MySQL or similar is a plus. Requirements: Strong proficiency in MySQL database management, extensive experience with RDBMS concepts, database architecture and SQL. Decent experience with recent versions of MySQL Understanding of MySQL s underlying storage engines, such as InnoDB and MyISAM Experience with replication configuration in MySQL Knowledge of de-facto standards and best practices in MySQL Proficient in writing and optimizing SQL statements Knowledge of MySQL features, such as its stored procedures, event scheduler, triggers. Ability to plan resource requirements from high level specifications Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.? Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases. Proficient understanding of code versioning tools such as?Git would be plus. Overview of DBA duties: Server startup/shutdown Mastering the mysqladmin administrative client Using the MySQL interactive client User account maintenance Log file maintenance Database backup/copying Multiple server setups Software updates and upgrades Server security Repair and maintenance Crash recovery Preventive maintenance Understanding the mysql server daemon Performance analysis