SEROSOFT SOLUTIONS PRIVATE LIMITED
Location
Madhya Pradesh | India
Job description
Job Title: MySQL Database AdministratorLocation: Indore (Onsite)Experience: 4+ years Company's Overview:Serosoft, positioned as India's 9th fastest-growing technology company and a frontrunner in educational software, boasts a dynamic team comprising former I-Bankers, US graduates, and MBA professionals. As part of the esteemed 50-year-old Hindustan Group of Companies, we offer innovative and customized solutions that empower over 350 global institutions, fostering a culture of innovation in education. Our flagship product, ACADEMIA, an award-winning educational software, caters to diverse educational needs. ACADEMIA's Student Information System ensures precise institutional control through a user-friendly structure and consolidated reporting.Company's website: website: Glimpse of 2023: the role:India's leading Educational ERP Software company, a Deloitte Fast 50 Company and ET Growth Champion Serosoft is looking for an experienced Database Administrator. The ideal candidate will have 4+ years of relevant experience as a MySQL DBA who will be responsible for ensuring the Performance, Database Tuning, Database Clean-up, Database Migration, Database Availability, and Security of Clusters of MySQL Instances. The candidate will also be responsible for Orchestrating Upgrades, Backups, and Provisioning of Database Instances. The candidate will also work in tandem with the other teams, documentation, and specifications as required.Key Responsibilities:- Provision MySQL instances, both in Clustered and Non-Clustered Configurations.- Ensuring the Performance, Database Tuning, Database Availability, and Security of Clusters of MySQL Instances.- Development of Database Schema.- Development of ERD.- Find the Root Cause of Database related issues & Database Clean-up.- Migrating Data from Customer Database to Serosoft Product Database.- Prepare Documentation and Specifications.- 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.Skills and Qualifications:- Strong proficiency in MySQL database management.- 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.- Proficient in Database Clean-up and Migrations.- Knowledge of De-Facto Standards and Best Practices in MySQL.- Proficient in Writing and Optimizing SQL statements.- Proficient in Table Scan, Row Scan, Query Execution Plan, SQL Profiler, etc.- Should be able to decide when to create Views (Standard Views, Indexed views, and Partitioned views).- Knowledge of MySQL features, such as its Event Scheduler.- 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 SVN / Git.- DBA Certification would be an added advantage. (ref:hirist.tech)
Job tags
Salary