1.1 Database Administration

Manage and maintain MSSQL database environments (SQL Server 2016/2019/2022)

Perform database installations, upgrades, migrations, and decommissioning activities.

Configure and maintain database security, backup, restore and recovery procedures.

Manage database users, roles, permissions, linked servers, SQL Agent jobs, and maintenance jobs.

Monitor database availability, storage, performance, and overall health

Support SQL Server hosted on cloud platforms such as AWS EC2 and SQL Server on Azure VM

1.2 Technical Support

Provide L2+ support for database-related incidents and service requests

Troubleshoot complex database issues and performance bottlenecks

Investigate blocking, deadlocks, connectivity issues, job failures, backup failures, disk space issues, and database corruption alerts

Collaborate with application teams, infrastructure teams, cloud teams, and vendors for issue resolution

Participate in on-call rotation for critical database support

Support DR drills, failover testing, and recovery validation

Perform incident analysis, root cause analysis, and provide technical recommendations

2.3 Performance Optimization

Conduct database health checks and performance tuning

Optimise SQL queries, indexes, execution plans, statistics, and database configurations

Analyse wait statistics, Query Store data,



expensive queries, I/O latency, CPU usage, memory pressure, and tempdb contention

Implement and maintain high availability and disaster recovery solutions

Capacity planning and resource management

Review database growth trends and provide recommendations for archiving, partitioning, storage planning, and scalability

Implement and maintain monitoring and alerting for performance, availability, capacity, backup status, and SQL Agent jobs

Develop automation using T-SQL, PowerShell, or other scripting tools to improve operational efficiency

2.4 Documentation Compliance

Maintain database documentation

Ensure compliance with security policies and industry standards

Support database audit, compliance, vulnerability management, access reviews, and remediation activities

Prepare technical reports, health check findings, incident summaries, and recommendations

Support change management activities, including risk assessment, implementation planning, validation, and rollback planning

DB Audit/compliance s

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Database Engineer (Pune)
🏢 NCS Group
📍 Pune