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.