16 Sep
|
Nway Technologies
|
Indore
16 Sep
Nway Technologies
Indore
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 workplace 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
📌 SQL DBA (Indore)
🏢 Nway Technologies
📍 Indore