Surya prakash

I am responsible for end-to-end support for various Database Technologies.
 Guiding a team with complex technical problems with highly scalable and reliable solutions.
 I am a Microsoft Certified Azure Solutions Architect Expert, with hands on experience in
Azure Administration, Architecting Azure Solutions and Cloud Migrations.
 Hands on Experience in Cloud Migrations from On-premises to Azure PaaS, IaaS.
 Good experience with complex database infrastructures both On-premises and Cloud.
 I am an expert in SQL Database Administration, SQL Performance Tuning, Microsoft Azure
Administration, Azure SQLDB, Microsoft Azure Architecting Solutions, IBM DB2, Hadoop,
SAP Hana, IBM Infosphere Data Replications, SSRS, PowerBI etc.
 

3 + years as People Manager, managing a Team of DBAs with below responsibilities.
 Managed both Technical and People development aspects for a small Team of 4 DBAs.
 Managing day to day Operations, Maintenance activities, technical discussions, Escalations,
Service Delivery.
 Conducting appraisals discussion for my reports and representing them during discussion
with Higher management and HR.
 Managing Shift rotations / Leaves /On-Call / Escalations.
 Headed Innovation circle on an account level to drive Innovation / Process Improvements
across multiple teams.
 Implemented Industry Best practices to improve SLA, Metrics and Monitoring capabilities,
improved productivity, Automation.
 Collaborated with multiple engineering teams on cross functional requirement.
 Conducted Interviews to attract best talent / negotiations.

Technical Expertise.
 I am responsible for end-to-end support for various Database Technologies.
 Guiding a team with complex technical problems with highly scalable and reliable solutions.
 I am a Microsoft Certified Azure Solutions Architect Expert, with hands on experience in
Azure Administration, Architecting Azure Solutions and Cloud Migrations.
 Hands on Experience in Cloud Migrations from On-premises to Azure PaaS, IaaS.
 Good experience with complex database infrastructures both On-premises and Cloud.
 I am an expert in SQL Database Administration, SQL Performance Tuning, Microsoft Azure
Administration, Azure SQLDB, Microsoft Azure Architecting Solutions, IBM DB2, Hadoop,
SAP Hana, IBM Infosphere Data Replications, SSRS, PowerBI etc.
3 + years as People Manager, managing a Team of DBAs with below responsibilities.
 Managed both Technical and People development aspects for a small Team of 4 DBAs.
 Managing day to day Operations, Maintenance activities, technical discussions, Escalations,
Service Delivery.
 Conducting appraisals discussion for my reports and representing them during discussion
with Higher management and HR.
 Managing Shift rotations / Leaves /On-Call / Escalations.
 Headed Innovation circle on an account level to drive Innovation / Process Improvements
across multiple teams.
 Implemented Industry Best practices to improve SLA, Metrics and Monitoring capabilities,
improved productivity, Automation.
 Collaborated with multiple engineering teams on cross functional requirement.
 Conducted Interviews to attract best talent / negotiations.
Microsoft India Pvt Ltd
Support Engineer Data Platform - Nov2021 – Till Date – SQL Server DB and Azure DB Product Support.
Roles and Responsibilities.
 Engaging with Microsoft SQL Product group and filing bugs and feature requests for SQL
Server and Azure SQL DB.
 Privileged to be one of the limited number of engineers globally trained to support customers
using these products and directly engaging with product team to improve these new products.
 Experienced in troubleshooting and resolving highly complex SQL Server Issues on OnPrem,
Azure Virtual Machines and Azure SQLDB - PaaS for Customers around the Globe.
 Resolving SQL Server Performance Issues and providing recommendations based on SQL
Dump & Memory Dump Analysis.
 Providing Advisory assistance on Highly Complex Design Solutions for Newly created SQL
Environment or Migrations.
 Trained to use large variety of Tools to resolve customer issues like Azure Data Studio,
PSSDIAG, SQL Nexus, PerfMon, Profiler, Extended Events, ProcMon, SQLDiag etc.
 Handling large scale SQL Server Environments of Customers with database sizes over 20 TB.
 Handling Escalation calls, Mentoring and Trainings peers with less experience.
 Participated in Hackathon 2022 and Won Disability Contest Award for 2022.
Deloitte India Pvt Ltd
Database Technical Specialist - Jun2018 – Nov2021
Roles and Responsibilities.
 Begin a Database Technical Specialist, I was responsible for end-to-end Database Solutions for our Business Unit.
 As an Assistant Manager, I was also responsible for Handled a small team of 4 DBA’s who were reporting to me directly. I was looking after their Career Growth, Mentoring, Leaves Management and Appraisal Discussion with HR team etc.
 Managed 200+ Application Databases with various Database Technologies like SQL Server, SAP Hana, Hadoop, Azure SQL DB and Managed Instance etc. with sizes ranging up to 20 TB.
 Guiding a team with complex technical problems with highly scalable and reliable solutions.
 IBM Infosphere Data Replication Tool Configuration & Troubleshooting for replicating data from SQL Server to Hadoop Databases.
 Migrated On-Prem Database to Azure Infrastructure.
 Automating tasks using Azure Dev-Ops and CI/CD Pipeline.
 Basic hands-on experience on Creating and Managing PowerBI reports.
Accenture Services Pvt Ltd
Solutions Architect - Jun2015 - Jun2018 - Schlumberger Client
 Worked from Client location – Dubai for a year, supporting all their SQL Server Infrastructure and coordinating with offshore team in India.
 Reviewed SQL Server Environments for 200+ Client application and tune their systems for better performance and sustainability.
 Performed SQL RAP as a Service (RaaS) on many environments and implemented recommendations to mitigate the RISK and Health Factors.
 Worked with Microsoft Consultants visiting Client on RaaS remediation and on highly complex architectural solutions.
 Migration of existing applications to Azure (PaaS & IaaS) and GCP (Google Cloud).
 Expertise in implementing and troubleshooting SQL Server AlwaysOn High Availability, SQL Clustering, Mirroring, Log Shipping and Replication.
 Implemented database backup strategies and recovery scenarios based on the application team requirement and criticality.
Tech Mahindra
System Engineer - Jun2012 - May2015 – Microsoft Client
 As a SQL Server Database Administrator, I was responsible for managing and maintaining SQL Server Environments.
 Setup and maintain of SQL failover Cluster 2008/2008R2.
 Maintained/Implemented database backup strategies and recovery scenarios.
 Optimized SQL Server environment for better performance and fine-tuned queries.
 Involved in some development activities and release deployments.
 Also provided support as Applications Database Administrator.
Apollo Health Street
Sr. Technical Consultant - Feb2011 - May2012 – Allscripts Client
 As a Sr Technical Consultant, I supported a client in Health Care Industry. My responsibility is to maintain their SQL Server Databases and perform upgrades to database components with their application.
Microsoft SQL Server Capabilities:
 Specialized in Microsoft SQL Server Database Administration, Configuration, Maintenance of SQL Servers of all versions from V 2008, 2008 R2, 2012, 2014, 2016, 2017 and 2019.
 Experience in implementing High Availability (HA) techniques such as Always-ON Availability Groups with multi-subnet and Geo-Cluster, SQL Clustering.
 Extensively worked on SQL RAP as a Service (RaaS), a tool from Microsoft to analyze the SQL Server Environment for Health and Risk related issues.
 Worked with Microsoft Consultants visiting Client on RaaS remediation and on highly complex architectural solutions.
 Specialized in SQL Server Memory & CPU Architecture, SQL Server Log Architecture, and Index Optimization.
 Experience in implementing Policy Based Management to enforce compliance conditions, Security restrictions and evaluate these policies against multiple environments using CMS (Central Management Server).
 SQL Server auditing using CDC (Change Data Capture), DML Triggers, Profiler and Extended Events.
 Experience in performing patching activity and Service Pack upgrades.
 Experience in implementing Disaster Recovery (DR) techniques such as Log shipping, Mirroring, Replication.
 Experience in writing basic TSQL code for SQL Development.
 Configuration, Maintenance and Management of HA/DR for DBs on Azure SQL.
 Implementation of Security and Role Based Access Control for Azure Resources.
 Good Understanding on SQL Licensing cost and their usage.
 Perform system optimization and improvement planning including but not limited to SQL Server database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning ensuring maximum performance. Develop and implement security policies.
 Maintain and improve database deployment and update processes. Ensure Compliance in related task.
Microsoft Azure Capabilities:
 Hands on experience in Implementing Azure SQL, IaaS, PaaS, and Managed Instances
 Good Understanding on various Cloud Technologies w.r.t Design and Implementation
 Experience in Migrating On-Premises Infrastructure to Azure.
 Experienced in creation and usage of ARM Templates in Azure.
 Automating tasks using Azure Dev-Ops and CI/CD Pipeline.
 Hands-on experience in provisioning and configuration of SQL Azure and Azure MI.
 Hands-on Experience in performing data migrations upgrades/modernizations, performance tuning on IaaS and PaaS Managed Instance and SQL Azure.
 Configuration, Maintenance and Management of HA/DR for DBs on Azure SQL.
 Implementation of Security and Role Based Access Control for Azure Resources.
 Experienced in using Azure Data Lake, Data Factory, Data Bricks, Azure Synapse.
Tools Knowledge:
 Azure Data Studio, PSSDIAG, SQL Nexus, PerfMon, Profiler, Extended Events, ProcMon
 IBM Infosphere Data Replication Tool Configuration and Troubleshooting.
 Basic knowledge on PowerShell Scripting, Windows Servers, IIS, DataStage, PowerBI etc.
 Basic knowledge on Hadoop Tools: BigSQL, Ambari, HDFS, Hive etc.

Bachelore of Technology in Information Technology from JNTU - Hyderabad, INDIA. 

From 2005 to 2009 - Graduated with 70% Marks.