Lead Database
MTBC
مجموع سنوات الخبرة :15 years, 10 أشهر
Upgraded development, UAT & Production environments from SQL Server 2005 & 2008 to SQL Server 2012
& 2014.
Developed & implemented enterprise wise automated maintenance infrastructure.
Automated DBA’s daily tasks like Index rebuild & reorganization, and weekly maintenance for statistics
updates.
Installation, configuration, up-gradation and migration of systems.
Capacity planning for DB Servers, and recommendations for hardware upgrade, and change in architecture.
Designed & developed SSIS packages & ETL Scripts to complete the day to day tasks of DBAs and developers.
Managing deployments on development, staging and production environments.
Designed & implemented database backup & recovery SOP for all databases, i.e. Production and development.
Configured and administered Database replication with Mirroring
Configured Always on Availability Groups in a development environment as a business plan.
Implementing Point-In-Time Recovery solutions.
Disaster recovery of databases and SQL server.
Expert in implementing the auditing tools.
Implemented and administered replication on production servers between multiple datacenters spanning
different geolocations.
MTBC, 106-A/1 BLOCK-A
Configuration of monitoring tools for real-time analysis and to minimize the error rate.
Implemented solutions for performance improvement, & Rebuilding & monitoring the indexes at regular
intervals for better performance.
Implementation of horizontal partitioning on tables to gain performance and DB growth.
Implementation and administration of clustering and Database Mirroring.
Monitoring of replication status and backups through scheduled SQL Server agents.
Analysis of audit & Server Event logs for unusual events & failures.
Loading of data from other RDBMS to SQL Server using multiple tools.
Implemented Transactional Replication for Reporting purpose.
Designed and development of T SQL scripts to monitor the DB growth patterns, performance statistics and peak
hours’ trends.
MTBC, 106-A/1 BLOCK-A
Development and Administration in SQL Server.
o Backups
o Analyze and fine tune database using DBCC commands.
o Implementing and managing Triggers, Indexes, Views and Stored Procedures
o Taking and maintaining SQL Backups on Tape Drive.
o Ad Hoc reporting using T-SQL & Reporting Services SQL Server 2005/2008.
o Implementing and managing Triggers, Indexes, Views and Stored Procedures
Analysis of databases using SQL Profiler and Query Execution Plan
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Involved in new code base release to UAT and Production Environments.
Extensively worked on Enterprise Manager for managing the database.
Design and deployment of reports on Reporting Server using SSRS.
–