Ankit Taliyan

Address: B-**, Paramount Golf Foreste, Greater Noida

Email: admft6@r.postjobfree.com ; Phone: 963-***-****

Seeking a challenging & growth-oriented career in software testing to utilize my profound analytical, technical and communication skills while being resourceful, innovative, and flexible.

Certifications:

Microsoft certified professional, Azure infrastructure specialist (AZ-100),

Administering SQL Server (70-462)

Summary

5.2 years of experience in Database Administration for very large and complex databases in SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012 SQL Server 2008 R2 and 2008.

Creation, Installation and patching database servers, migration, up gradation.

Expertise in configure and troubleshooting Always On

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Administering SQL Server High Availability and Disaster Recovery strategies.

Proficiency and expertise in Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Always ON and Database Mirroring.

Expertise in configuring SQL Server with minimum privileged access.

Expertise on SQL Server migration, up gradation.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Worked on virtual machine & compute instance (Create, edit, delete the VM’s in both classic & ARM models

Worked on networking part limited to virtual networks and global virtual networks.

Configuration of Azure storage account.

Configuration of Azure load balancer both internal and external and using Application using SSL Offloading.

Implementations of virtual machine scale set for auto scale of VM’s based on workload to save cost and achieve high availability.

Experience Summary

Presently working with Century Link Technologies, Noida as SQL Server DBA.

Previously worked in TCS, Noida as a SQL DBA (Feb 2016-Dec 2019)

Educational Qualification

2011– 15 Bachelor of Technology in Computer Science & Engineering from MIET Meerut.

2009 – 10 AISSCE, C.B.S.E Board, Studied English, Math’s, Physics, Chemistry, and PE.

2007– 08 AISCE, C.B.S.E Board, Studied English, Science, Math’s, Hindi and SST.

Organizational Projects

Century Link Technologies: (Current)

Project: CTL Internal

Team Size: 8

Role: SQL Server DBA

Project Synopsis: Telecom project having 800 Instance.

Roles and Responsibilities:

Always On configuration, troubleshooting.

SQL Server Installation, Migration, upgrades.

Troubleshoot performance problems and fine-tuning of databases.

To analyze long running slow queries and tune the same to optimize application and system performance.

To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 6 Terabytes to achieve maximum performance and uptime in production environment.

Support SSAS, SSIS, SSRS services.

Deployment of RDL, ETL,

Transferring the data (ETL) to Data warehouse by Integration Services.

TCS --- (Previous) ( Jan 2017-Dec 2019)

Project: EI LILLY

Team Size: 14

Role: SQL Server DBA

Project Synopsis: It’s a pharmaceutical project having 1500 Instance.

Roles and Responsibilities:

Tuning of SQL database for high performance.

Creation of VM’s, Database, Load balancer, traffic manager, Backup on Azure cloud.

Configuration of Storage account as per requirement.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Perform SQL Server service pack upgrades.

SQL Server Installation, Migration.

Migration of on premises data onto cloud.

Managing SQL database on Azure cloud (PAAS).

PERSONAL SNIPPETS

Date of Birth : Mar 02,1993

Marital Status : Single

Languages : English, Hindi

Contact this candidate