Database Administrator (MS SQL Server)

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 environment
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

Skills
SQL, Azure, Power BI, ERP, Documentation

Experience
2-6 yrs

Work arrangement
No