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