Ibrahim Fazal

 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.