SQL Database Administrator

NWAY TECHNOLOGIES PVT. LTD.
Nway Technologies is a leading ERP product-based company providing digital solutions for Construction ERP, Transport, Cotton, Real Estate, Mall Management, Website Development, and other enterprise solutions. Our Construction ERP helps organizations manage their complete project lifecycle, including Project Management, Finance, Purchase, Inventory, Plant & Machinery, HR & Payroll, and other critical business processes.
Website: www.nwaytech.com
Position - SQL Database Administrator (SQL DBA)
Experience - 4-8 Years
Job Location - Indore, Madhya Pradesh
Employment Type - Full-Time
About the Role
We are seeking an experienced SQL Database Administrator (SQL DBA) to manage, monitor, secure, and optimize Microsoft SQL Server environments supporting mission-critical business applications. The ideal candidate will be responsible for ensuring database availability, backup reliability, performance optimization, security compliance, and proactive monitoring across multiple production databases.
Key Responsibilities
Manage and maintain a SQL Server environment hosting multiple client databases
Perform daily restore validation to ensure backup integrity and disaster recovery readiness
Run and monitor DBCC integrity checks across databases on a scheduled basis
Configure, automate, and maintain SQL Server Agent jobs for routine database operations
Develop and maintain data-masking procedures for non-production/test environments to ensure data security and compliance
Monitor and optimize database performance, including query tuning, index optimization, and execution plan analysis
Identify and resolve performance bottlenecks, blocking, and deadlocks proactively
Maintain backup and recovery strategy in line with business continuity requirements
Maintain database security including login/user/role management and access controls
Collaborate with development teams on database design, T-SQL scripting, and performance tuning
Document database processes, incidents, and standard operating procedures
Provide support for production issues, including on-call troubleshooting as required
Required Skills
Strong hands-on experience with Microsoft SQL Server (2016/2019/2022)
Proficiency in T-SQL, stored procedures, triggers, and dynamic SQL
Strong understanding of query optimization, indexing strategies, and execution plan analysis
Experience with SQL Server Agent job scheduling and automation
Solid understanding of backup/restore strategies, and database integrity validation
Familiarity with data masking/data security practices for compliance-sensitive environments
Knowledge of SQL Server security model (logins, users, roles, permissions)
Experience troubleshooting blocking, deadlocks, and performance bottlenecks
Working knowledge of high availability/disaster recovery concepts.
Preferred Skills
· Knowledge of SQL Server High Availability and Disaster Recovery (Always On Availability Groups, Log Shipping, Replication, Database Mirroring, or Clustering). · Experience with PowerShell scripting or SQL automation. · Exposure to performance monitoring and database administration tools. · Experience supporting enterprise-scale production environments.
Key Competencies
· Database Administration · SQL Server Performance Tuning · Backup & Disaster Recovery · Database Security · Monitoring & Automation · T-SQL Development · Root Cause Analysis · Production Support · Documentation & Process Management · Team Collaboration

Work arrangement
No