Experience: 2–6 years

Department: IT / ERP - Tana Bana ERP

Location: Jaipur

Role Summary-We’re looking for a hands-on SQL Server DBA to keep our core ERP (Microsoft Dynamics NAV 2013 R2 / Tana Bana) and reporting databases secure, fast, and reliably backed up

Key Responsibilities

- Installation & Configuration: Install, configure, and upgrade SQL Server instances (2016/2019/2022), apply patches/CUs, and maintain server configuration standards for HQ and branch servers.
- Backup & Recovery: Design and run backup schedules (full, differential, log), regularly test restores, and maintain a documented DR plan with defined RPO/RTO — critical for artisan, order & financial data.
- Performance Tuning: Monitor and optimize query performance, indexes, statistics, and blocking/deadlocks for high-volume ERP transactions (order entry, inventory, invoicing, artisan mapping) using execution plans, DMVs, Query Store, and Extended Events.
- High Availability: Set up and support Always On Availability Groups, log shipping, or replication for HQ + branch connectivity.
- Security & Access: Manage logins, roles, and permissions on least-privilege principle for Finance, Production, Supply Chain, Retail, E-commerce & Design teams. Maintain audit trails and support internal/statutory audits.
- Maintenance & Automation: Build SQL Agent jobs for index maintenance, DBCC CHECKDB, and cleanup. Automate routine tasks with T-SQL and PowerShell.
- ERP Database Support: Support the Microsoft Dynamics NAV 2013 R2 database — performance, locking issues, company/database copies for testing, month-end closing support, and upgrade/migration support.
- Data & Reporting Support:



Write and review stored procedures, views, functions. Support SSIS packages, SSRS reports, and Power BI data sources for management dashboards — rug inventory, production status, artisan-wise progress, export dispatch, and retail sales.
- Monitoring & Capacity Planning: Track disk, CPU, memory, and database growth (especially image-heavy rug catalogue & design data), set up alerts, and forecast storage needs.
- Documentation: Maintain server inventory, runbooks, change logs, and incident reports as per IT change control.

Required Skills

2+ years of hands-on SQL Server administration in a production workplace

Strong T-SQL: joins, CTEs, window functions, stored procedures, and query optimization

Solid grasp of backup/restore strategies and recovery models

Experience with indexing, execution plans, and troubleshooting slow queries and blocking

Working knowledge of SQL Server security, SQL Agent, and Database Mail alerts

Familiarity with Windows Server administration basics

Preferred Skills

- Experience supporting Dynamics NAV 2013 R2 or another ERP in manufacturing / export / retail setup
- SSIS, SSRS, or Power BI experience
- Always On AG, replication, or log shipping setup
- PowerShell / dbatools scripting
- Exposure to Azure SQL or cloud backups
- Microsoft certification (e.g., DP-300)

Qualifications

B.E./B.Tech/MCA/BCA or equivalent in Computer Science or IT.

Soft Skills

- Methodical about change control and documentation
- Able to explain technical issues clearly to non-technical users (Finance, Operations)
- Willing to provide occasional after-hours support for maintenance windows or critical incidents

📌 Database Administrator (MS SQL Server) (Jaipur)
🏢 Jaipur Rugs
📍 Jaipur