Database Administrator

Description

1.Experience in in MySQL, MongoDB, Elastic or similar technologies.
2. Strong knowledge in MySQL database management, Relational schema definitions, Integrity constraints, Replication cluster, Log management to identify quickly the database issues.
3. Strong understanding of MySQL database fundamentals and query optimization i.e Query plan analysis, Full table scan optimizations, Query worker analysis, Query caching, Complex SQL queries with multiple joins, Views and stored procedures etc.
4. strong knowledge of MySQL databases for Concurrency and lock performance monitoring, Wired Tiger for Mongo, Global Locks and Locks.
5. Experience related to performance tuning i.e Clustered and Non clustered Indexing, Sharding and Partitioning concepts, Versioned data rows and periodic data archival from transactional tables
6. Knowledge in SQL procedure, view, 3 tier database Architecture"