- 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.