Senior Sql Developer

Jibe Development Services; Navi Mumbai; Presencial; INR 1.800.000 - 2.400.000; Jornada completa

Descripción de la vacante

Jibe Development Services in Navi Mumbai seeks an experienced Database Administrator to manage MSSQL and MongoDB ecosystems, optimize queries, design scalable schemas, and ensure high availability.

You will work with cloud platforms (Azure/AWS), implement clustering, backups, and monitor performance, while participating in on-call rotations to support mission-critical services.

Formación

• 10+ years of MSSQL experience.
• 3+ years of MongoDB experience.
• Advanced knowledge of database structure and theory.
• Ability to analyze, optimize and refactor complex procedures.

Responsabilidades

• Tune SQL queries and optimize performance.
• Review code with development team.
• Configure SQL Server and plan capacity.
• Maintain high availability and disaster recovery.
• Participate in on-call rotation.
• Implement clustering, replication, log shipping.

Conocimientos

MSSQL

MongoDB

Database design

Query optimization

On-call support

Herramientas

Azure

AWS

PowerShell

Clustering technologies

Descripción del empleo

About Jibe

JiBe is a cloud based fully integrated ERP system for the shipping industry. Our goal is to allow shipping companies to improve productivity, efficiency and safety levels, while reducing costs. JiBe ERP enables increased automation and streamlining of processes, creating pre-defined workflows and reducing the usage of email and paper.

Role & responsibilities

• SQL query performance tuning, indexing, table level compression, table partitioning, table design.
• Code reviews with the development team.
• SQL Server configuration.
• Automation of existing processes.
• SQL Server diagnostics and identification of slowness.
• Resolving deadlocks root causes.
• Propose solutions and structure at the database level that will meet business and technical requirements.
• SQL server architecture design and capacity planning. Implementing Active/Active or Active/Passive clustering, complex data-center/database migration, database upgrades, automation of server monitoring, development, mirroring, log shipping and replication.
• High Availability: Clustering, Always-On, Log Shipping, Replication, Mirroring
• Security, Auditing, Encryption.
• This position requires involvement in an oncall rotation to provide timely support for missioncritical services.

Qualifications

• 10+ years professional experience with MSSQL.
• 3+ years professional experience with MongoDB
• Advanced knowledge of database structure and theory.
• Ability to analyze, optimize and refactor complex procedures and queries.

Preferred certification:

• MCSE in Data management and Analytics
• MCSA in Database Development
• MCSA in Developing Datawarehouse
• MCSA in Database Administrator
• MongoDB Associate Data Modeler
• MongoDB Associate Database Administrator
• MongoDB Associate Developer

• Deep understanding of supporting technologies around SQL Servers: Cloud technologies (Azure, AWS), Windows Power Shell, storage architectures and clustering.
• Specialized in SQL Server architecture and DBA work:
• Failover clustering: setup, validation, troubleshooting on-premises and cloud (AWS, Azure) instances and zero downtime approaches.
• Understanding disaster recovery and database backup procedures
• Ability to work independently with minimal supervision and assistance