SQL Database Administrator

Designation

Job Location

About the Company

eSec Security Consultants Pvt. Ltd., a leading system integrator specializing in the supply, installation, testing, commissioning, and maintenance of IP-based surveillance systems CCTV, access control solutions, intrusion detection systems, AI/ML solutions and other advanced security solutions under the ICT digitization framework. eSec has successfully executed many projects nationwide, including Safe/Smart City initiatives and various large-scale government and enterprise projects. Our portfolio spans a wide range of sectors, including airports, corporate offices, renewable energy, power and transmission, ports, manufacturing, and educational institutions and many more.

Job Summary

The primary role of the System Administrator is to maintain, upgrade, and manage our software, hardware, and networks. The person should be able to diagnose and resolve problems quickly. This position aims to keep our technology infrastructure running smoothly and efficiently.

Roles and responsibilities

• Manage user accounts (create/ modify/ delete), permissions, and access rights to ensure appropriate access to resources.
• Install and configure operating systems, applications, and software updates to set up new hardware, including computing devices, servers, workstations, and peripheral devices.
• Oversee the functionality of network components such as routers, switches, and firewalls and ensure network file systems are correctly configured and accessible to authorized users.
• Provide technical assistance for hardware, software, and network-related issues.
• Server backup and recovery to prevent data loss.
• Implement and configure SQL Server Always On Availability Groups for high availability and disaster recovery solutions.
• Continuously monitor the health and performance of Always On Availability Groups, including the replication latency, data synchronization, and failover performance.
• Ensure minimal downtime and ensure high availability of critical databases.
• Configure and manage security settings for Always on Availability Groups, including encryption, authentication, and authorization.
• SQL Server Clustering: Understanding of Windows Server Failover Clustering (WSFC) as it relates to Always On configuration.
• Database Security: Experience in configuring SSL, encryption, and managing database security for Always on Availability Groups.
• Analyze existing SQL database/ queries for performance improvements.
• Regularly check system logs, CPU usage, memory usage, and network performance to ensure optimal functioning.
• Conduct regular security audits to identify vulnerabilities and ensure compliance with security policies.

Requirements

• 2+ years’ experience in system administration and SQL database
• Associate or Bachelor's degree in a related field
• Advanced knowledge of system vulnerabilities and security issues
• Excellent understanding of SQL database and Microsoft SQL Server.
• Strong proficiency in SQL and database concepts