Server Administrator Job Vacancies in Delhi

Profile : System AdministratorExperience: 1-3 YearsBudget: 3-4 LPAResponsibilitiesPerform server administration tasks (ex: user/group, security permissions, group policies, print services); research event-log warnings and errors; and monitor resources to ensure that systems architecture components work together seamlesslyMonitor data-center health using existing management tools, and respond to hardware issues as they arise; help build, test, and maintain new servers when neededMaintain internal infrastructure requirements, including laptop and desktop computers, servers, routers, switches, firewalls, printers, phones, security updates; support internet, intranet, LANs, WANs, and network segmentsAssist the help desk and other teams with troubleshooting to identify root cause, and provide technical support when neededPerform routine and scheduled audits of all systems, including backups.

Good Experience in maintaining the production servers of multiple environments. Creating new users on SQL server and Managing SQL Server Security. Experience in Database backup and disaster recovery procedures. Test backups to ensure we can meet the business Recovery Time Objectives (RTO)Experience in Replication (Mandatory) Having knowledge of Bulk Data Merging using SQL Server Import or Export. Wizard or writing queries on SQL Server query window Creating and maintaining databases. Monitoring, troubleshooting, and optimizing SQL Server performance. Having knowledge of SQL Profiler to check the Execution Plan, Performance Monitor. Monitored server performance, database, and transaction log growth, and error logs. Help the database query developers on technical issues, i.e., writing queries like join or subquery, triggers, cursors, store procedures. Have Experience of indexes. Review and optimize SQL queries, store procedures, views, and triggers to help developers to achieve maximum efficiency and scalability. Auditing of DML commands on SQL servers and individual database/s. Troubleshoot SQL Server service outages as they occur, including after- hours and weekends Configure SQL Server monitoring utilities to minimize false alarms Creating the configuration Document for the database environment Candidate should have good hands-on experience in SQL Data analysis using queries as well as using Microsoft Excel. AWS RDS (database services) All High availability concepts like log shipping, Replication, Mirroring, Always ON, Clustering. Strong knowledge on Performance tuning Knowledge on .net application projects and connection strings Profiler and DTA usage and importance Carry out Defragmentation, Memory management, data migration, server upgrades Applying patches on existing or new SQL servers Work from home