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

Rabia Khan

Fredericksburg,VA

Summary

IT PROFESSIONAL / SQL /AZURE DATABASE ADMINISTRATOR Highly skilled, dedicated, and self-motivated, currently seeking a Database administrator position, that will utilize my work experience, organizational skills, educational background, expanded knowledge, that offer opportunities for personal and professional growth. Possesses over 5 years of professional experience in supporting databases and servers in IT department both on On-Premises and Azure SQL Environment. Experience in installation, configuration, backup, recovery, HA/DR solution like Replication, Always-On Availability Group, Clustering, Log shipping, Mirroring, Upgrading, Migration, Apply service pack / Patch Management, Troubleshooting, Supporting clients, Database Monitoring, Performance Tuning, Database Security, Database Development, Data Modeling, SSIS and SSRS.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Azure SQL DBA

Raleigh Insurance Group
01.2022 - Current
  • Design, implement, and maintain SQL Server databases to ensure optimal performance, availability, and security
  • Monitor database systems to identify and resolve performance issues, bottlenecks, and potential security vulnerabilities
  • Perform database backups, restores, and disaster recovery procedures to ensure data integrity and availability
  • Configure and maintain database replication, mirroring, and clustering for high availability and disaster recovery purposes
  • Develop and implement database maintenance plans to optimize performance and ensure data consistency
  • Collaborate with development teams to design and optimize database schemas, queries, and stored procedures
  • Evaluate and recommend database technologies, tools, and best practices to improve efficiency and scalability
  • Provide technical support and troubleshooting assistance to end-users and stakeholders as needed.

SQL Database Administrator

Custom Health Plans, Inc.
05.2019 - 12.2021
  • Install the server software
  • Configure database servers
  • Monitor and maintain system health and security
  • Database administration of SQL server databases
  • Install, maintain, and develop optimized databases
  • Strong Command of SQL, stored procedures, and triggers
  • Backups restore and recovery models
  • Always-on availability, SQL
  • Identifying and remediating server & database vulnerabilities
  • Advanced working experience in SQL Query optimization
  • SQL performance tuning and interpreting traces
  • SQL Server database administration versions 2016 or higher
  • Setup of database clusters, backup or recovery processes, and cloud database implementation
  • T-SQL scripting
  • SQL Server or other monitoring tools to troubleshoot issues and performance tuning
  • Experience in power shell and T-SQL scripting
  • Database software patching and day-to-day management
  • Support and refresh test environments to support business support needs
  • Manage SQL installations configured on the Microsoft Clustering platform
  • Configure new backups of databases using native SQL backups.

Education

Bachelors of Science -

Punjab University

Skills

  • Windows 2022
  • 2019
  • 2016
  • 2012
  • Active Directory
  • Windows XP/7
  • VMware
  • SQL Server 2019
  • 2014
  • 2008
  • MS Access
  • MySQL (501)
  • Transact-SQL
  • CMD
  • PowerShell
  • Red Gate
  • Windows Event Logs
  • Activity Monitor
  • SSRS (SQL Server Reporting Services/Server)
  • SSIS

Citizenship

US Citizen

Personal Information

Title: AZURE/SQL Server Database Administrator

Certification

  • Microsoft Certified: Azure Administrator
  • MCSA: Database Administration
  • Microsoft Certified: Azure Administrator Associate
  • Training on Database Availability group
  • Training on Database Log shipping, Mirroring, Replication, T-SQL
  • [Area of certification], [Company Name] - [Timeframe]

Timeline

Azure SQL DBA

Raleigh Insurance Group
01.2022 - Current

SQL Database Administrator

Custom Health Plans, Inc.
05.2019 - 12.2021

Bachelors of Science -

Punjab University
Rabia Khan