Summary
Overview
Work History
Education
Skills
Certification
Awards Recognition
Languages
Disclaimer
Timeline
Generic

Ankita Agrawal

Ranchi

Summary

3+ years of professional IT Experience as Database Administrator committed to work in a global competitive industry where my knowledge and skill set can be utilized and implemented efficiently with a motivating and challenging environment. Driven and highly enthusiastic person with a passion for embracing cutting-edge technologies and a proven track record of quick adaptation. Seeking a dynamic role where I can leverage my curiosity and love for learning to contribute to a progressive team.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Analyst 1 Infrastructure Services (MSSQL Database Administrator)

DXC Technology
Bangalore (Remote)
04.2021 - Current
  • Working in Database Leverage Team
  • Handling Change Management activities
  • Working on Problem Records (PR)
  • Handling Level1, L2, L3 and some extend of L4 issues related to SQL Server
  • Configuring the DBSPI for monitoring the databases
  • Working on monitoring as well as user raised Incidents
  • Migration of Databases
  • Having experience on Azure SQL Databases
  • Patching on SQL Server & SSMS
  • Working on all SQL environment (Production, Development, Test)
  • Developed and implemented database security measures to ensure data protection.
  • Installed, configured, and maintained SQL Server databases on Windows servers.
  • Configured user accounts, privileges, roles in the database server.
  • Developed and implemented strategies to ensure data integrity, reliability, and availability.
  • Performed daily maintenance tasks such as backups, restores and log shipping operations.
  • Implemented replication between multiple servers to ensure high availability of the system.
  • Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
  • Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
  • Deployed patches and upgrades according to established change management policies.
  • Performed root cause analysis when diagnosing issues with database systems.
  • Handling the responsibility of On-boarding and Off-boarding of resources
  • Team Management

Education

Bachelor of Science - Biotechnology

Amity University
Ranchi, Jharkhand
06-2021

Skills

  • Proficient in managing Microsoft SQL Server in any environment
  • Hands-on experience on end-to-end SQL Server Installation and SSMS Installation with its configuration
  • Installation, Administration and Maintenance of SQL Server Instances
  • Database creations and configuration - Azure SQL & On-Premise SQL
  • SQL Server Migration - Database Migration
  • Data Migration (From On Premise Database to Azure Database)
  • Patch management Expertise in Patching SQL Server with latest update
  • Expertise in mirroring, log shipping, maintenance plans and DR recovery strategies
  • Setup High-Availability as part of Disaster Recovery Strategy for the Databases
  • Good understanding of T-SQL
  • Strong knowledge of SQL Server database backup and recovery strategies
  • Expertise in handling critical errors on SQL Server with troubleshooting
  • Data Security
  • Root Cause Analysis
  • Performance Tuning

Certification

  • Trained on Microsoft SQL Server Administrator
  • Microsoft Certified Azure Fundamental
  • Amazon Certified Cloud Practitioner

Awards Recognition

  • 02/2022, FY22 Q3 Champs Award
  • 11/2022, H1 FY23 Collaborators Award
  • 02/2023, FY23 Q3 Champs Award

Languages

  • English
  • Hindi

Disclaimer

I hereby declare that all the above written information is true to the best of my knowledge & belief.

Timeline

Analyst 1 Infrastructure Services (MSSQL Database Administrator)

DXC Technology
04.2021 - Current

Bachelor of Science - Biotechnology

Amity University
Ankita Agrawal