Server Administrator Job Vacancies in Gurgaon

Key Responsibilities:Database Design and Architecture:Design and implement SQL database structures to meet the organization's data storage and retrieval needs.Collaborate with software developers and stakeholders to understand data requirements and ensure efficient data modelling.Optimize schema design for data integrity, normalization, and performance.Database Performance Optimization:Identify and analyse performance bottlenecks and query optimization opportunities.Develop and implement strategies to improve database performance, including indexing, caching, and query optimization.Monitor and analyse database performance metrics, making recommendations for improvements.Query and Index Optimization:Analyse and optimize SQL queries to reduce execution times and resource consumption.Identify and create appropriate indexes to speed up data retrieval and processing.Provide guidance and best practices to application developers for writing efficient SQL queries.Data Migration and ETL:Plan and execute data migration and ETL processes, ensuring data integrity and performance.Optimize data transformation and loading processes for efficient ETL operations.Database Security:Implement and maintain database security measures to protect sensitive data.Audit and enforce data access controls and encryption as necessary.Backup and Recovery:Develop and maintain robust backup and recovery procedures to ensure data availability and integrity.Documentation and Training:Maintain detailed documentation of database structures, configurations, and performance optimization strategies.Provide training and knowledge transfer to team members and stakeholders as needed.Stay Informed:Stay up to date with the latest database technologies and trends to ensure the organization's databases remain competitive and efficient.

1. Work on administration of Windows Server assessments and backup monitoring2. Execute maintenance items out of hours (patching)3. Work on out-of-hours server reboots & checks4. Use the best practice customer environment assessment5. Schedule server assessments and review of Event Log (for MS like CS)6. Work on print server management7. Handle user and access management (password, user management, folder access, group policies, drive mapping, mailbox management, the delegation of rights)8. Handle endpoint antivirus management and updates9. Work on on-premises backup alert management and monitoring10. Handle change management11. Prepare and provide reports

The following are the requirements:1. Good knowledge of server management Tools-Solar Winds,Nagios,Zabbix, etc2. Must have knowledge of excel - Vlookup, Hlookup etc3. Must have the knowledge of operating system,Internet Browser,Virtual server InstanceSkillset Required: Understanding of reading performance of servers Ability to evaluate DB performance Reading and understanding log files Reading understanding stats and performance numbers Able to evaluate and raise an alarm in case of any issues noticed Working in a 24 x 7 environment is a primary requirement Good Analysis and reporting skills Good hands on with Excel. Experience in Product and Application Monitoring. Fair Knowledge of Server Monitoring

We are seeking a Windows Server Administrator to join our team in Greater Noida. This is a full-time position suitable for candidates with 0 to 2 years of experience, preferably holding a B.E. degree. Key Responsibilities:- Server Maintenance: You will monitor and maintain Windows servers, ensuring they are running smoothly and efficiently to support business operations.- User Management: You will create and manage user accounts, setting permissions and access levels to ensure security and appropriate access to resources.- Troubleshooting: You will diagnose and resolve server issues, helping to minimize downtime and ensure systems are working effectively.- Backup and Recovery: You will conduct regular backups of server data and assist in recovery procedures, ensuring critical data is protected.- System Updates: You will apply patches and updates to Windows server operating systems to keep them secure and up to date.- Documentation: You will maintain accurate documentation of system configurations, changes, and procedures for future reference and compliance.Required Skills and Expectations:Candidates should possess a foundational understanding of Windows server environments and basic networking concepts. Strong problem-solving skills and attention to detail are essential. Good communication skills are necessary to work collaboratively with team members and support users effectively. A proactive attitude toward learning new technologies and improving processes is highly valued. The role is office-based, so the selected candidate must be available to work onsite.

Database administration for various SQL Server versions 2008R2/2012/2014/2016 and mitigating Productionsupport. Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008R2/2012/2014/2016/2017. Analyzing query structure and performance related issues, Worked on various query optimization tasks with application teams, worked on clustered and non-clustered indexes. Worked on various issues for servers in Always on , analyzing sync up issues. Have skills to deploy package through ETL, troubleshooting job failure issues. Trouble shooting database consistency problems after analyzing logs and fixing those errors. Designed packages in ETL to automate and put sql server queried data to FTP server. Analyzing dead lock issues with help of trace and rectified them to improve performance. Worked on various replication technology i.e snapshot ,Merge and Transactional . Configured Mirroring and Log shipping for migrating large databases in shorter span of time. Worked on different issues Related to DB mail , SMTP server. Managing security related request with minimal rights to databases . Worked on different SQL Server hardening parameters. Migration of log shipped database server to new server