MySQL Developer

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.

Job Profile/ Responsibilities:

  • Help write and optimize in-application SQL statements
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Provision MySQL instances, both in clustered and non-clustered configurations
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Profile server resource usage, optimize and tweak as necessary
  • 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
  • Knowledge of de-facto standards and best practices in MySQL
  • Proficient in writing and optimizing SQL statements
  • 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. (if required)
  • 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 / CVN / SVN etc.)
  • Strong proficiency with SQL and its variation among popular databases
  • Experience with some of the modern relational databases
  • Skilled at optimizing large complicated SQL statements
  • Knowledge of best practices when dealing with relational databases
  • Capable of configuring popular database engines and orchestrating clusters as necessary
  • Capable of troubleshooting common database issues
  • Familiar with tools that can aid with profiling server resource usage and optimizing it
  • Deliver bug free, high quality work in optimum time.
  • PHP coding along with MYSQL with object oriented techniques.
  • Ensure the written code meets software requirements and behaves as the developer intended. Must unit test and provide error free work.
  • Client handling will be a part of the profile at some level.
  • Clean, protocol-based code level documentation within code as well as in tandem with technical documentation being prepared for the project.
  • Escalate any technical issue to immediate supervisor in the event of not understanding the problem.
  • Daily meeting with Team Lead and other team mates where Team Lead allocates the tasks and discuss the work details/daily priorities.
  • Monitoring self- efficiency and ensuring it is above 85%
  • Deliver bug-free, high quality work in optimum time.
  • Bug tracking and bugs resolutions
  • Write “clean”, well-designed code along with commented code where required.
  • Produce detailed code documentation where required.
  • Load testing of the code developed.
  • Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality.
  • Collaborate with other team members and stakeholders
  • Contribute in all phases of the product development lifecycle.
  • Follow industry best practices for development.
  • Develop and deploy new features to facilitate related procedures and tools if necessary.
  • Keen observer and should give valuable suggestions to Teammates and Lead.
  • Daily meeting with Team Lead and other team mates where Team Lead allocates the tasks and discuss the work details / daily priorities.
  • To deliver the tasks by meeting the timelines framed by Team Lead.
  • To help and guide team mates where ever and when-ever required related to Project work
  • To give worthy suggestions to Team Lead regarding the Project and its betterment
  • To acknowledge the emails from Lead, PM and team mates.
  • To update the Team Lead personally by the day end regarding the work and status update.
  • Should be very good at multitasking and should be able to work on many projects simultaneously.
  • Regularly submit End-of-Day (EOD) reports by email on the prescribed format.