Prabhdeep Singh

Database Administrator @HCLTech

Calgary, AB, CA

Administer MS SQL Server databases, ensuring high availability, performance, and security for critical business applications in the energy sector.• Configure and maintain AWS RDS instances, including setting up read replicas to support scalable data access for analytics and reporting.• Perform database installations, upgrades, and patching to keep systems current and compliant with organizational standards.• Execute and monitor hourly database backups and restore processes to safeguard data integrity and enable rapid recovery.• Support database migrations from on-premises environments to AWS RDS, ensuring seamless transitions with minimal downtime.• Manage user access and permissions, implementing role-based security to protect sensitive data and meet compliance requirements.• Monitor replication performance using AWS CloudWatch (e.g, ReplicaLag), identifying and resolving issues to maintain data consistency.• Collaborate with cross-functional teams to troubleshoot and optimize database operations, contributing to system reliability and efficiency.