Core Work over here:

• MySQL/MariaDB Database designing & Installation, Up-gradation, setting up Replication (Master-Master, Master-Slave, Master-Slave-Slave).
• PXC Cluster set-up and configuration.
• MongoDB Database Configuration(Replica-Set configuration) and Management, Backup & Recovery.
• Troubleshooting MySQL, PXC Cluster & MongoDB Replication errors.
• Backups and restoration using mysqldump or percona's xtrabackup utilities to take hot backups or normal cold backup procedure in maintenance window period.
• Table optimization and Query Optimization using MySQL utilities or Percona's latest pt-online-schema-change utility.
• Writing Shell Scripts for MySQL & MongoDB Backup/Restore procedures, Monitoring and Maintenance using tools like Zabbix, Nagios, Mytop etc..
• OrientDB Graph Database designing as per the requirement and setting up the same.

Currently working on Reliance Jio Network Automation Project. This Project deals with creating configurations for devices and pushing it automatically on them in order to activate the devices. We manage this data which is stored in MySQL/Percona Galera & MongoDB Databases. It has MySQL Master-Slave Replication set-up and many on Percona Galera Cluster. Large number of unstructured schemas are stored into MongoDB.

Major work on MySQL/MariaDB, Percona Galera & MongoDB Database Configuration, Management, Backup/Recovery & Troubleshooting tasks. Managing a MySQL database on AWS Cloud.

Responsibilities:

Handling multiple projects from different geographies. Currently working on building up MySQL NDB Cluster Set-Up(Enterprise Edition) single handed, This Project includes some servers having Tandem Database which replicates to MySQL Database. So learning more about Tandem during this activity. Handling a team of 4 MySQL DBA’s.

Core Work over here:

• Interacting with our clients and analyze their basic requirements, business requirements, type of applications (Website or Mobile apps) and recommend them the best system configuration that suits their business need.
• Worked on MySQL Enterprise Editions.
• MySQL Database designing & Installation, Up-gradation, setting up Replication (Master-Master, Master-Slave, Master-Slave-Slave).
• Troubleshooting MySQL and Replication errors.
• Database Performance tuning and Monitoring using MEM MEB tools.
• Creating Non-Functional documents for database inetgrity testing for the Project.
• Documenting Functional tasks into a Technical document and supply it to the team in order to allow them to read and work easily.
• Provide training to internal team members on MySQL and groom them.
• Taking Interviews for MySQL DBA requirements across multiple Projects.

Datavail is one of a leading DB service provider in USA and recently (2012) awarded India's No. 1 DBA firm. We have total 40+ US clients on MySQL each having 10+ MySQL Linux servers. We as a MySQL DBA suppose to take care of them. We do following core work:

Responsibilities:

• Daily Interaction: We interact with our clients and analyze their basic requirements, business requirements, type of applications (Website or Mobile apps) and recommend them the best system configuration that suits their business need.
• Daily server checks: Check host and MySQL statuses on each server on daily basis.
• MySQL Installation: Usually we do RPM and/or Binary MySQL/ Percona installation on Linux systems
• Backups and restoration: We either use mysqldump or percona's xtrabackup utilities to take hot backups or normal cold backup procedure in maintenance window period.
• Server optimization: We do server optimization at config. (my.cnf) level.
• Query optimization: We used to do query tuning as per client's demand or according to the slow query logs.
• Replication: We set MySQL replications (Master-Master, Master-Slave, Master-Slave-Slave)

Shell Scripting: We used to write shell scripts as per client's demand to automate some regular work (script to take backups, to check replication lags, to check host's disk space etc.)