System Engineer (MS SQL) (Ref 26128)

Responsibilities • Design, implement, and maintain scalable and efficient databases to support application requirements. • Optimize SQL queries and database performance by analyzing execution plans and indexing strategies, conduct tuning of database as needed. • Plan, configure and test regular database backup, recovery processes, and disaster recovery. • Monitor database health and performance, proactively identifying and resolving bottlenecks and issues. • Troubleshoot complex SQL queries and provide solutions to improve execution speed and resource usage. • Collaborate with development and operations teams to ensure database reliability and availability. • Maintain documentation for database architectures, backup procedures, and maintenance schedules. • Hardening and provide rectification of Vulnerability Assessment and Penetration Test • Support other systems, especially interfaces that use data storage. • Stay updated with the latest trends and best practices in database technologies and performance tuning. • Ensure security best practices in database management and access control. Requirements • Proven experience as a Systems Engineer or Database Engineer with a focus on SQL databases • Strong expertise in database design, normalization, and optimization techniques. • In-depth knowledge of SQL Server, MySQL, PostgreSQL, or other relational database management systems. • Proficient in reading and interpreting SQL query execution plans to optimize query performance. • Experience with backup, recovery, and maintenance of large-scale databases. • Strong communication skills to work effectively with cross-functional teams. Licence no: 12C6060