Anabil Saha

SQL Server Administration:

• Installed and configured SQL Server 2016–2022 on both physical servers and virtual machines in clustered environments.
• Architected and managed Always On Availability Groups over Windows Failover Clustering in active-passive setups.
• Segregated large-scale storage (up to 32TB) using SAN LUNs for optimal performance and backup/restore operations.
• Configured and monitored backups, recovery models, and maintenance plans (DBCC, index rebuilds, statistics update).
• Automated daily DBA tasks and health checks using PowerShell and T-SQL scripts.
• Conducted performance tuning using execution plans, Query Store, Extended Events, and dynamic management views.
• Managed user access, security auditing, and permissions as per compliance and best practices.
• Executed side-by-side and in-place upgrades for SQL Server with minimal downtime.
• Supported developers in query optimization and deployment activities across UAT and production environments.

PostgreSQL Administration:

• Installed, configured, and maintained PostgreSQL databases on Linux environments.
• Performed routine backups, point-in-time recovery (PITR), and WAL archiving for PostgreSQL instances.
• Tuned PostgreSQL performance through configuration parameter tuning (shared_buffers, work_mem, etc.) and vacuum strategies.
• Managed replication (streaming replication, logical replication) and failover scenarios using tools like pg_basebackup, repmgr, and Patroni.
• Wrote and optimized complex SQL queries and PL/pgSQL procedures for reporting and batch processing jobs.
• Performed migration from MS SQL Server to PostgreSQL for select workloads using tools like pgLoader and SQL Server Migration Assistant (SSMA).
• Created monitoring dashboards and alerts for PostgreSQL using pgAdmin, pg_stat_statements, and custom scripts.

• Installed and maintained SQL Server 2012/2014 instances across development, staging, and production environments.
• Designed and implemented Log Shipping and Database Mirroring solutions to ensure high availability and disaster recovery readiness.
• Configured and managed SQL Agent Jobs, scheduled maintenance plans, and custom alerts for proactive issue detection.
• Performed regular backup and recovery operations, including full, differential, and transaction log backups.
• Tuned long-running and high-cost queries using execution plans, indexing, and query rewriting strategies.
• Conducted database refreshes across environments for development and QA purposes.
• Implemented role-based security policies, auditing login activities and permission changes.
• Actively monitored and analyzed deadlocks using SQL Profiler and Extended Events, and collaborated with developers to resolve root causes.
• Supported development teams by reviewing and optimizing stored procedures, views, and complex queries.
• Maintained comprehensive documentation of server configurations, DR procedures, and troubleshooting guides.

• Provided technical support for in-house and client-facing applications, ensuring minimal downtime and quick issue resolution.
• Acted as the first point of contact for application-related incidents, performing root cause analysis and coordinating with development teams.
• Managed and monitored SQL Server databases, ensuring availability and performance of critical systems.
• Performed daily health checks on SQL Server instances, including backups, job status, and disk space monitoring.
• Assisted in query optimization and troubleshooting slow-performing reports and data extraction tasks.
• Executed ad-hoc SQL queries and generated data extracts for business and operations teams.
• Monitored SQL Server error logs, and worked with senior DBAs to address deadlocks, blocking, and other issues.
• Supported deployment activities, including data migration and database changes across environments.
• Documented standard procedures, troubleshooting steps, and escalation paths for support operations.

• Provided product support and consultation to Banking Correspondents.
• Managed team members to achieve given targets as per as matrices.
• Designed and deployed reports using SSRS.
• Developed database objects, including tables, views using SQL.
• Performed Database Administration activities for DB Security such as creating logins, users, roles, and assigning permission to them.
• Performed Backup and Restore of databases.

• Designed and developed coding, debugging for project Aebis & IBS.

• Performed resource planning and coordinated for application migrations with project managers, application and web app teams.

• Performed database designing, support, troubleshooting, planning and migration on MS SQL and MY SQL.

• Performed duties for requirement gather and documentation.