Database Engineer
Emp. Type: EC
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 support
Must have:
3+ years of robust and relevant experience.
Hands-on experience with SQL Server Always On Availability Groups (administration and troubleshooting)
Strong expertise in SQL Server Performance Tuning (query optimization, execution plan analysis, indexing, and troubleshooting)
Hands-on experience in SQL Server Migration activities (server/database migrations, version upgrades, and cutover support)
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 support
Must have:
3+ years of strong and relevant experience.
Hands-on experience with SQL Server Always On Availability Groups (administration and troubleshooting)
Strong expertise in SQL Server Performance Tuning (query optimization, execution plan analysis, indexing, and troubleshooting)
Hands-on experience in SQL Server Migration activities (server/database migrations, version upgrades, and cutover support)
📌 Database Engineer (Pune)
🏢 NCSi
📍 Pune