Sql fba

KOTISUBBARAYASASTRY CHATURVEDULA

Canton, MA ***21 +1-551-***-**** ***.******@*****.***

Professional Summary

SQL Server DB, Azure and SharePoint Architect / Lead / Consultant with 14+ years of experience in system design, development, analysis and implementation using Microsoft Technologies for enterprise applications.

Azure experience - extended working knowledge in cloud service, IaaS, worker role, service bus, queue, azure blob and table storages and API Management. Configured NSGs for two tier and three tier applications. Experience in integrating on premises servers to Azure. Configured VNETs and subnets as per the project requirement. Configure Azure blob storage and Azure file servers. Configured private and public facing Azure load balancers.

Skills

IaaS, PaaS, VM Migrations, VNet, Traffic Manager, Azure Cloud Services, SQL Azure, Active Directory, Data Factory, Power Shell, OMS, Security Center, Service bus, blob storages.

MS Servers: Windows 2019/2016/2012/2008

Linux: RedHat Linux 7

SharePoint: SharePoint 2019/2016/2013/2010, Office 365/SharePoint Online

SQL Servers: HA/DR Expertise in SQL 2019/2016/2014/2012/2008

ETL Tools: SSIS, SSAS, SSRS,

Monitoring Tools: SolarWinds Orion, SolarWinds DPA, SCOM, Azure Arc, Idera.

Ticketing Tools: Service Now, BMC Remedy, Manage Engine

Software Engineering Methodologies: Agile / SCRUM and Waterfall

Other tools / technologies: Power Shell, MS Visio, Azure AD Connect, VMware, IP Sub netting, DevOps, Metalogix, AvePoint, Sharegate, NetBackup and Rubrik

Project Management

Azure Data Store, Azure AD, Azure VMs

Teams, One Drive, Power BI.

Work History

SQL DB and Azure Architect, 04/2010 to Current

YASH Technologies – Boston, MA

SME in SQL Server Database Administration and Architecture worked in Different projects involving SQL Always on, HA/DR, Upgrades and Migrations of Enterprise landscapes to latest Version.

SharePoint Experience- SME in SharePoint worked on administration for SP2010 to 2019 and SharePoint online.

Migration of SP On-premises to Cloud.

Enterprise-level experience - Collaborating with large teams and involved in architecture of highly scalable, secure, distributed applications, aligned with company standards, process, methodologies, and best practices.

Process and Implementation - Experience implementing software throughout the SDLC process, deep firsthand experience of database, migration and implementation in Azure.

Ensured the responsible for overall technical quality, migration, deployment standards and architecture of the application.

Have good exposure to various domains like Life Sciences, Health Care, Manufacturing, Managing around 15 Virtual Machines in IAAS & 200 SQL Servers and 1800 databases on PAAS, supporting max size of 4 TB hosted in Microsoft Azure.

Analyzing the On-Premises environments using third party tools Cloud Recon and Map tools.

Migrating on Premises SQL Databases to SQL Azure using DMA & DMS(Offline & Online).

Configured SQL Server Always on HA/DR solutions for critical applications.

Perform Point in time recovery from Rubrik, Net backup tools as the business case arises.

Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

Collaborated with system architects, design analysts and others to understand business and industry requirements.

Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.

SR SQL DBA, 11/2009 to 02/2010

Future Focus Infotech – Hyderabad, India, Telangana, India

Worked as Sr SQL DBA for British Petroleum Project in Tata Consultancy Services.

System Analyst /SQL DBA, 07/2008 to 11/2008

Data Group Inc – Chicago, USA, USA

Worked as Sr.

SQL DBA for Grainger INC.

Installed and maintained MS SQL Server 2008 on Windows 2003 Server.

Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.

Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Configuring, tuning and optimizing SQL Server 2005.

Administrator tasks like managing users, roles and permissions on SharePoint Server 2007.

Performance testing on stored procedures, indexes, and triggers.

Software Engineer, 12/2006 to 02/2008

Satyam Computer Services Limited, Bangalore, DBA for Kennametal Inc

ADDITIONAL INFORMATION.

Valid H1B Visa till July 2021 with Approved I140.

Education

MCA (Master of Computer Applications): Computer Applications, 2004

Osmania University

Certifications

MCP ID 6765455

AZ 104 Azure Administrator

AZ 301 Azure Architect Associate

SQL 2012 DBA

SharePoint Administration 2007/2010

ITIL V2

Contact this candidate