MySQL/Linux Developer

Job Description
– Write queries and extract adhoc reports as per requirement
– Writing DB backup script and monitoring its execution.
– Monthly DB data archiving.
– Verifying monthly reports from backend DB
– Monitoring Web application and resolving any issue occuring on server.
– Monitoring Nagios and resolving issues.
– Proactively monitoring servers performance
– Create and modify shell scripts or applications to perform tasks
– Help team in identifying applicaiton issues on server level.
– Ability to read/monitor java applicaiton log files
– Ability to tune tomcat configurations.
– Identify opportunities for improved performance in SQL operations and implementations
– Oversee the operations of the production and staging environments databases
– 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
– Prepare documentations and specifications
– Profile server resource usage, optimize and tweak as necessary
– Additional responsibilities as assigned

Skills Required:
– Strong proficiency in MySQL database management and writing queries.
– Experience with replication configuration in MySQL
– Proficient in writing and optimizing SQL statements
– Familiarity with Casandra
– Proficient understanding of code versioning tools such as {{Git / SVN}}
– Hands on experience with MySQL
– Hands on experience in Linux administration
– Experience in writing shell Scripts.
– Familiarity with Java