Sachin Kamthankar

Security

• Maintained Operating System Security
• Maintained SQL Server upgrades
• Followed the principle of least privilege
• Provided guidance on best practices for secure implementation of Transact- SQL code within applications.

High Availability

• Configured AlwaysOn Availability Groups for high availability solutions across multiple data centers.

Performance

• Monitored and optimized database performance using indexes, optimizing stored procedures and other techniques.
• Troubleshot complex SQL queries, monitored indexes to identify problems or potential improvement areas.

Maintenance & Optimization

• Migrated databases from older versions of SQL Server to newer versions with minimal downtime.
• Developed and implemented strategies to ensure data integrity, reliability, and availability.
• Designed databases in accordance with industry best practices for scalability, security, reliability, and performance.
• Automated daily maintenance tasks such as backups, database refresh, SQL Agents Job Failures, index maintenance, database checks etc.
• Automated routine tasks using PowerShell and SQL Scripts to streamline processes and reduce manual workloads.
• Researched new features available in the latest version of SQL Server software to determine their usefulness.
• Assisted with capacity planning efforts by forecasting usage trends based on historical data.

• Lead the DBA Team of 8 people working 24X7
• Executed various CSIs which delivered soft dollar and hard dollar benefits
• Involved in installation, Administration and Maintenance of SQL Server Instances
• Designed database Backup & Restoration Strategy, Security Standards, High-Availability as part Disaster Recovery Strategy for the Databases
• Worked on automating various day to day activities
• Setup Failover Clustering, Database Mirroring, Log Shipping and Replication
• Monitor and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning

• Monitored and maintained 200+ SQL servers collectively having ~6TB of data

• Responsible for database Index creation, Index removal, Index modification, File

group modifications, code optimization etc.

• Responsible for defining strategy to ensure the table Statistics and Indexes are

kept updated

• Automated the database maintenance activities through SQL Server Maintain

plans

• Monitoring and making recommendations for performance improvement in hosted

databases

• Involved in performance and tuning, identifying locking and blocking for long

running queries

• SQL server capacity planning at the Service Level

• Managing Incidents, Changes and Problem resolution for SQL related issues

• Responsible for maintaining the database standards set at the project level

• Basic exposure to the ETL processing and its performance improvement

• Contributed significantly in improving the overnight ETL performance

• Suggested various strategic improvements in the overnight ETL jobs

• Code review for SQL development/change by Development and Service team