Smit

WORK EXPERIENCE flydocs india (owned by Lufthansa technik) Responsible for Configuration, maintenance and installation for database servers. Perform day-to-day Technical Support- Analyzing, Troubleshooting and Resolving Technical Problems related to database servers. Knowledge of MySQL Administration: CRUD operations, database user creation, dump/restoration, and creating indexes. Setting up and Managing MySQL Master-slave replication. Maxscale configuration for routing read and write MySQL traffic to slaves and master respectively. Creation of DR setup for critical database servers. Proactively monitor the disk utilization, load average, CPU utilization of database servers to prevent production outages. Perform database Backup, crash recovery, upgrades etc. Taking care of database archival process as per business policies. Performance tuning and query optimization. Monitoring performance of databases using PMM Database Performance Analyser. Automating and scheduling tasks using crontab. Knowledge of python and PHP scripting. Having exposure to Database capacity planning. Prepared various types of reports from the database as required by management. Experienced on working with production Servers and 24 x 7 On-Call environments. Good team player, with strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box. Ability to execute complex changes.