System Engineer (MS SQL)

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