Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Synopsis
Certification
Websites
Timeline
Generic

Quaisar Rizwan

Ara

Summary

Results-driven SQL Server professional with over 12 years of experience, specializing in high availability and disaster recovery solutions. Expertise in T-SQL development and resource allocation, with a strong track record of collaboration. Supported more than 50 US clients, enhancing database performance and reliability.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Shift Lead/Shift Manager

Datavail Infotech Pvt Ltd
Bangalore
10.2016 - Current
  • Delivered 24/7 support for SQL Servers to over 50 US clients.
  • Collaborated with clients to prioritize and implement requests and changes.
  • Provided support via email, tickets, and bridge calls during deployments.
  • Installed, configured, managed, monitored, and troubleshot SQL Server environments.
  • Configured high availability and disaster recovery options such as log shipping and clustering.
  • Managed resource allocation and work queues during shifts while tracking DBA tasks and billable hours.

SQL Server Application DBA Level-2

SLK Software
Bangalore
09.2011 - 10.2016
  • Installation, upgrades & applying hotfixes / SP’s of SQL 2005, 2008 and 2008r2,2012.
  • Checking status of backups, troubleshooting failed backups & restoration of DBs.
  • Identifying and resolving Blocking and Deadlock issues.
  • Experience in Log Shipping and monitoring LS Jobs and troubleshooting.
  • DBCC commands to maintain Database Consistency.
  • Configuring Mirroring with Synchronous & Asynch Modes, troubleshooting out of sync.
  • Solved space issues like Log File Full, Data File Full & TEMPDB space issues.
  • Automation initiatives in SQL Server & PowerShell.
  • Installation of All SQL Servers versions including service packs.
  • In-Place Upgrades & Side-by-Side Migrations of SQL 2005/2008R2 to 2012/2014/2016.
  • Projects Supported1: ETL Projects and HP Quality Center

Education

B.E -

Nitte Meenakshi Institute of Technology
Bangalore
04.2011

H.S.C -

JPHS
02.2004

S.S.C -

JPHS
03.2002

Skills

  • SQL Server 2000 to 2022
  • Windows Server 2003 to 2012R2
  • Windows operating systems
  • Oracle database management
  • T-SQL development

Languages

  • English
  • Hindi

Personal Information

Date of birth: 02/12/88

Synopsis

  • Experience on different versions of SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014, 2016, 2017, 2019, 2022., Experience on Installing, configuring, managing, monitoring & troubleshooting SQL Server., Experience in configuring/implementing HADR like Log shipping, Mirroring & Clustering. Implement and maintain DB Security (creating Logins/Users, maintaining Roles/Securables)., Applying hotfixes, SPs and upgrading/migrating SQL from 2000/2005/2008R2 to 2012/2014/2016/2017/2019 and 2022., Involved in setting up SQL Jobs with SQL Agent for regular maintenance, Jobs and Alerts., Experience in tools like SQL Profiler, Perfmon for monitoring SQL Server performance., Good Communication skills, ability to work independently and learning new technologies., Providing 24/7 Support in a most challenging high and fast-paced Production Environment., Creating Azure Virtual Machines on Windows., Understanding of Regions, Availability Zones and Availability Sets., Working exposure to different types of Storage available (Blob, File, Queue, Table)., Understanding on Premium/Standard Storage accounts., Creating Shared Storage using File and sharing the files across multiple VMs., Understanding Azure Networking (VNets, Subnets, Private-Public IPs)., Managing Firewall (NSG) rules to VMs and following security norms of Organization., Creating/configuring Azure SQL Databases (PaaS/DBaaS)., Creating Server/Database firewall rules in Azure SQL Databases., Exporting BACPAC from Azure SQL Databases., Creating and configuring Azure SQL Database Managed Instance., Migrating On-Prem Databases to Azure SQL Databases (Singleton) using DMA., Exposure to DMA tools for On-Prem and Azure migrations., Having knowledge on Azure Elastic Pool Databases and Elastic Jobs & Queries.

Certification

  • Microsoft Certified: Azure Database Administrator Associate DP-300

Timeline

Shift Lead/Shift Manager

Datavail Infotech Pvt Ltd
10.2016 - Current

SQL Server Application DBA Level-2

SLK Software
09.2011 - 10.2016

B.E -

Nitte Meenakshi Institute of Technology

H.S.C -

JPHS

S.S.C -

JPHS
Quaisar Rizwan