System Engineer (MS SQL) (Ref 26128)

Roles & Responsibilities

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

Tell employers what skills you have

Availability of Databases
Backup Procedures
Design
Performance Profiling
optimized SQL queries
Backup
Database Tuning
Optimisation Techniques
MySQL
Vulnerability Assessment and Penetration Testing (VAPT)
Microsoft SQL Server
Database Architectures
Cross Functional Team Building
Database Maintenance
DBMS
database backups