Database Administrator
CurrentResponsibilities Deploy and optimize new Microsoft SQL Server instances, including advanced features like AlwaysOn availability groups. Fine-tune SQL Server Agent tasks and maintenance plans for enhanced performance. Proactively monitor and troubleshoot maintenance tasks for uninterrupted operation. Collaborate on database backup, recovery, and disaster recovery planning. Configure and monitor database servers for peak performance, availability, and security. Creation and maintenance of Databases, creating Roles and managing user permissions. Expertise in T-SQL writing stored procedures, triggers, and functions. Manage and administer SQL Server database environments critical to financial operations, ensuring optimal performance, availability, and data integrity. Lead data migration projects from legacy systems to SQL Server, including mapping data structures, transforming data, and ensuring successful transition with minimal downtime. Implement and enforce database security policies and procedures to comply with industry regulations such as PCI DSS and GDPR. Conduct regular performance tuning and optimization activities to improve database performance and scalability using SQL Server inbuilt tools (Query Store, Extended Event, SQL server Profiler, SQL Server turning Advisor) Collaborate with development teams to design and optimize database schemas and queries for maximum efficiency. Perform database backups, restores, and disaster recovery planning to ensure business continuity. Create and maintain documentation for database configurations, procedures, and best practices. Hands-on experience in different modules from the core financial system, (MFS) Mobile financial system, ATM, (LMS) Loan Management System to Deposit Management System. Provide real-time issue resolution and problem-solving. Ensure 24x7 support for critical production systems.