Setup, administer and support MySQL/Mongo databases servers for Production, QA and Development.
Responsibilities
Monitor databases for performance, bottlenecks and other issues, identify and deploy solutions.
Perform appropriate backup, restoration and upgrades of database servers.
Create / refine database complex, indexes, stored procedures & data mining
Proactively monitor the database systems to ensure secure services with minimum downtime
Good Understanding of Replication, Unix Shell Scripting
In-depth knowledge of concepts and experience writing SQL and the ability to analyze, diagnose and tune database queries and performance overall at all associated layers (database, network, server, disk, etc)
Provision MySQL instances, both in clustered and non-clustered configurations.
Profile server resource usage, optimize and tweak as necessary.
Monitor and maintain the existing database infrastructure via auto scaling, automated alerts dashboards
Aid in re-configuring existing architecture and database structure to allow for rapid deployments to new countries.
Requirements
Having Knowledge of other NoSQL databases like Mongodb, Postgresql, Cassandra (will be plus)
Experience with dedicated MySQL database administration tasks including backup and recovery, monitoring, security and data-related maintenance
Experience with large-scale, complex distributed Linux / Unix applications
Experience in performance tuning and database monitoring tools
Experience in Replication / Clustering / Tuning/ Sizing and Monitoring
Experience working in a Linux server environment (OS admin experience a plus)
Experience writing, maintaining and documenting scripts to achieve technical and business objectives.
Exceptional problem-solving expertise and attention to detail
Candidates must have the ability to complete tasks with very little supervision and superb ability to work well with others in a team environment