SQL Server Database Administrator - Indore, India - Ignatiuz Software Pvt Ltd

Ignatiuz Software Pvt Ltd

Verified Company

Indore, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

We are looking for an experienced MongoDB/SQL server DBA, who will maintain MongoDB/SQL databases while optimizing the performance, security, the availability of MongoDB clusters.

Must have 2 to 4 years of experience in database development using Mongo and SQL Server.
Understand and optimize query performance.
Maintain and configure MongoDB instances
Keep clear documentation of the database setup and architecture.
Write procedures for backup and disaster recovery.
Ensure that the databases achieve maximum performance and availability.
Design indexing strategies.
Configure, monitor, and deploy replica sets.
Upgrade databases through patches.
Create roles and users and set their permissions.
Creation of complex SQL stored procedures, explicit transactions, shredding and creation of XML and exception handling
Excellent understanding of T-SQL programming.
Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
Experience in Data Base as analysis, developing procedures, triggers, and Functions for largescale Business Applications.
Good Experience in SQL Query performance tuning for large datasets. Provides analysis, reporting, and data discovery services for end users.
Experience in Extracting, Transforming, and Loading (ETL) data from Excel, Flat files to MS SQL Server.