Trivandrum
5 hours ago
Lead II - Software Engineering
Strong experience in database (SQL Server & Azure SQL managed instance) performance troubleshooting, including query tuning, execution plan analysis, indexing, and stored procedure optimization.Ability to handle customer-reported DB performance issues and follow structured troubleshooting and root cause analysis approaches.Experience deploying and managing databases in cloud environments (AWS/Azure/GCP) with focus on security best practices.Good understanding of multi-tenant applicationsGood understanding of database security (access control, encryption, backups, auditing, role based access).

- Responsible for managing and maintaining the Microsoft SQL Server database environment. - Design, Data modelling, mentor and/or implementing database schemas, tables, indexes, and views, stored proc etc. for tuning and optimize data storage and retrieval. - Installing, configuring, and upgrading SQL Server instances - Guide multi-tenancy implementation, ensure the performance, availability, and security of the database. - Recommend solutions and/or resolve for data corruption, and connectivity errors. - Monitoring database performance, identifying bottlenecks, and implementing solutions to optimize query execution and resource utilization. - Implementing and maintaining backup and recovery strategies to ensure data integrity and availability in case of failures, DR on Azure SQL MI. - Implement and manage security measures, such as user authentication, authorization, row level security and data encryption, to protect sensitive data. - Implement and recommendations for HIPPA, PCI DSS, GDPR etc. - Maintaining documentation of database objects, procedures, and processes etc. - Maintain checklist, standards for database. - Review and provide feedback/recommendations on the artifacts and/or code produced by peers for improvements/optimizations.

Confirm your E-mail: Send Email