Database Administrator
DatabaseFull Time
Database Administrator
Experience2-4 years relevant experience
RemunerationAs Per Industry Standards
QualificationMCA, B.Sc/M.Sc (IT), Any Graduate & Above
LocationBhubaneswar, Odisha (On-site)
Role Overview
Manage MySQL, MongoDB, and Elastic databases with deep knowledge in query optimization, replication, sharding, and 3-tier architecture.
Roles & Responsibilities
- Experience in MySQL, MongoDB, Elastic or similar technologies.
- Strong knowledge in MySQL database management, Relational schema definitions, Integrity constraints, Replication cluster, Log management to identify quickly the database issues.
- 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.
- Strong knowledge of MySQL databases for Concurrency and lock performance monitoring, Wired Tiger for Mongo, Global Locks and Locks.
- 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.
- Knowledge in SQL procedure, view, 3 tier database Architecture.
Educational Qualification & Experience
MCA, B.Sc/M.Sc (IT), Any Graduate & Above — Minimum 2-4 years relevant experience.