Sanjeev Krishnan

Sql Dba @Fino Payments Bank Ltd

Mumbai, IN

Handling change management of production databases. Monitoring of Backups, scheduling, creation of linked server. Performance Tuning of Production databases. Capacity planning for disk space management for data & log files. Carrying out DR drill activity. Proactive daily checks. Responding to monitoring alerts. Database Server Configurations & maintenance. Recommendation of best practices to improvements in the current operational process. Identifying blocking happening & resolving the same within the defined SLA. Analysis the Backup strategy in use. DTS & SSIS package deployment on production servers. Implement/Configure of Log Shipping for DR purpose. Creating Database snapshots for Reporting purposes. Monitoring/configuring Snapshot & Transactional Replication Implementing & Configuration of SSRS. Managing SQL database & Log files Rebuild, Reorganize of Indexes. Checking of Database Consistency on the Production DB. Setting up Database Mail Monitoring Log shipping for Production/DR site. Migration of SQL server instance/ Databases Disaster Recovery Planning & Testing Collecting SQL performance counters for performance problems/trending Detect DB blocking Issues, large queries Database Maintenance Plans & Backup File Management Identifying Bottlenecks in the database. Auditing SQL server permissions & Rights on the instance/DB level Performing Archival of data. Setting up jobs for ETL process Identifying missing indexes & fragmentation level of DB. Troubleshooting replication & Log shipping related failures. Monitoring High CPU queries & providing resolution.