Mysql Database Administrator | Cloudops DBA

Job Description We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters 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. Responsibilities Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization. Prepare documentations 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 MySQLs underlying storage engines, such as InnoDB and MyISAM Experience with replication configuration in MySQL(Master slave, Master-Master) Knowledge of de-facto standards and best practices in MySQL Create and Manage MySQL users with proper permissions. Proficient in writing and optimizing SQL statements. Automate day to day regular tasks. Strong knowledge in MySQL Binlog and point in time recovery. Tuning MySQL servers configurations as per the workload. Decent experience in Linux Administration. 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 (Git / Mercurial / SVN) The below qualifications are adds Plus: Public cloud platform (AWS/Azure/GCP). Knowledge in AWS RDS and Aurora. Python scripting. Query Tuning.