Database Administrator

Spis; Khordha; On-site; INR 600,000 - 900,000; Full time

Job summary

Saiparamount is seeking a skilled database engineer to manage MySQL, MongoDB and Elastic databases. You will optimize queries, design replication and sharding strategies, and contribute to a robust 3-tier architecture.

The role requires hands-on experience with relational and NoSQL databases, performance tuning, and a focus on data integrity. Join our team in Odisha to drive scalable data solutions for enterprise applications.

Qualifications

• Experience with MySQL, MongoDB and Elastic or similar technologies.
• Deep knowledge of query optimization, replication, sharding, and 3-tier architecture.
• Strong understanding of MySQL fundamentals, query planning, and complex SQL.
• Experience with indexing, locking, and performance tuning.

Responsibilities

• Manage MySQL, MongoDB and Elastic databases.
• Optimize queries and monitor replication, sharding, and 3-tier architecture.
• Ensure data integrity and performance across clusters.
• Handle index and cache tuning for high throughput.

Skills

MySQL

MongoDB

Elasticsearch

Education

MCA

B.Sc/M.Sc (IT)

Any Graduate

Job description

Qualification MCA, B.Sc/M.Sc (IT), Any Graduate & Above

Role Overview

Manage MySQL, MongoDB, and Elastic databases with deep knowledge in query optimization, replication, sharding, and 3-tier architecture.

• 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.

Educational Qualification & Experience

MCA, B.Sc/M.Sc (IT), Any Graduate & Above — Minimum 2-4 years relevant experience.