a
ankushd_07

Ankush D

@ankushd_07

MSSQL Database Admin

India
English, Hindi, Marathi
About me
I am a skilled Azure SQL Database Administrator with over 7+ years of experience in optimizing and securing Microsoft SQL databases. My expertise includes migrating on-premises databases to Azure environments, implementing high availability and disaster recovery solutions, and overseeing SQL Server installations and patching. I have a proven track record in configuring security policies and enhancing database performance while ensuring data integrity. If you need a professional who delivers results and enhances database functionality, I am here to help.... Read more

Skills

a
ankushd_07
Ankush D
Offline • 
Average response time: 1 hour

See my services

Database Administration (DBA)
I will do sql server migrations and infrastructure setup

Work experience

Cognizant

Database Administration

Cognizant • Full-time

Apr 2023 - Present3 yrs 3 mos

Performing assessment to current on-prem databases considering target environment as Azure cloud (Azure SQL Database, Managed Instance, Azure VM) with Data migration assistant (DMA) tool. Interacting with customer to get end to end information of database/application dependencies. Installing SQL server on Azure VM instance. Performed POC for database migration using data migration service (DMS) and Azure Data Studio (ADS) for Azure (PaaS/IaaS), database migration to azure managed instance with Log replay service. Migrating databases, sql agent jobs, logins from on-prem to cloud with backup restore method. Provided hyper care support once application is live from cloud server.

Tata_Consultancy Services

Cloud Engineer

Tata Consultancy Services • Full-time

Nov 2021 - Apr 20231 yr 5 mos

Creating EC2 instance and attaching it to specified VPC, subnet and security group. Creating and attaching EBS disk volumes as per requirement. Installing SQL server on AWS EC2 instance same like on-prem server. Migrating databases, sql agent jobs, logins from on-prem to cloud with backup restore method. Migrating on-prem database and application servers with AWS Application Migration Service (MGN).

Infosys

Database Administration

Infosys

Aug 2018 - Nov 20213 yrs 3 mos

Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Created new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering.