Madan Kotha
SRE/Devops
Hyderabad
Summary
Over 8 years of IT experience in progressive, professional experience in DevOps and Software Configuration
Management which includes Build setup, Continuous Integration, Source Code Management
process setup.
• Hands on experience with design and implementation of Continuous Delivery and/or DevOps
solutions.
• Hands on experience with ICM and Monitoring for DevOps solutions.
Overview
4
4
years of post-secondary education
Work History
SRE
MicrosoftIntune
- Worked on Service Fabric Cluster(SFX) Daily maintenance of cluster Monthly cluster deployments Monthly branching activities Daily activities of checking nodes, applications, system services Worked on disk space issues Worked on AMD migration
AML Engineer
AML STUDIO
- Worked on Azure ML SDK release management
- Provided support on customer facing issues like CI, Notebooks, kernel & different versions of python
- Worked on AzureML product development & support
- Worked on customer, non customer & public SDK pipelines
- Worked on ICM portal investigating different ICM root causes & transferring to concern team
- Worked on different user errors & fixing bugs in releases
- As part of release management daily checking version Incompatible issues for SDK
- Investigated pipeline failures & updated PowerShell scripts based on subscription & storage accounts
- Updated pipelines deprecated python version with latest version
- Creating CI, replicating customer issues & fixing issue
- In SDK release checking whether all packages are updated in conda environment or not
- SDK release planning & documentation
- Experience in trouble shooting CI , storage account if customer is not able to access
- Investigating Root cause for failing Notebooks in different pipelines
- Acknowledging & troubleshooting ICM as per SLA
- Checking for failed notebooks ICM is created or not & assigning to concern team
- For customer related ICM creating postmortem report
- Worked on different CI, kernels & testing based on customer requirement
- Based on customer requirement testing in JupyterLab, VScode & Notebooks
- Announcing in all SDK team channels about release cut one week before release
- Troubleshooting failed pipelines & debugging whether it is failed by incompatible issue & raising PR & merging in next release
- Worked in Customer with CI quota related Issues.
SQL DBA Consultant/Azure Database Engineer
Window server Catalogue
- Worked on stored procedures as well as analyzing & debugging existing stored procedures
- Worked on Application Insights, Azure Monitoring & key vaults
- Query optimization & performance tuning
- Preparing Suggestion Documents to improve quality of application
- Reviewing of functional specification documents
SQL DBA Consultant/ Azure database Engineer
Certiview IT & Management Solutions - C2 Essentials, Inc.
- As primary SME responsible for taking care of incoming ICM incidents and driving them to resolution
- Goal is to ensure that every issue reported is resolved
- Also, I am handling critical storage production live traffic 500 (+) servers with 10(+) TB size databases
- Good at Manage hosting plans for Azure Infrastructure, implementing & deploying workloads on Azure virtual machines (VMs)
- Expertise in Always on and all high availability solution
- Expertise in Microsoft Azure Cloud Services (PaaS & IaaS), Application Insights, Azure Monitoring, Key Vault and SQL Azure
- Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.
- Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) Migrating on-premises SQL Server Database to Azure (Iaas) Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets
- Designed VNets and subscriptions to conform to Azure Network Limits
- Exposed Virtual machines and cloud services in the VNets to the Internet using Azure External Load Balancer
- Create Azure VMs and install SQL and configured AG
- Migrated SQL on-prem servers to Azure Iaas SQL 2019
- Supports deployments and troubleshooting for applications and systems
- Also maintaining INT and PRODUCTION infrastructure
- Handled Full Software Development Life Cycle (SDLC) from inception to delivery of product including requirements gathering, functional specification, design, estimation, implementation, debugging and documentation
- Capacity Planning, Storage Planning, Hardware Upgrade’s and Preparing Estimates for Database, table size growth
- Azure -Design, implement and manage virtual networking within Azure and connect to on-premises environments, configure Express Route, Virtual Network, VPN Gateways, DNS and Load Balancers
- High Availability, Disaster Recovery, Business Continuity
- Setting up SQL Server Availability groups, Clustering, Log shipping, Replication and performing periodic database maintenance tasks
- Database Administration, Platform Upgrade, Installing/deploying IIS services and Windows 2008,2012, 2016 & 2019 SQL server 2008,2012,2014,2016 and 2019 installation and management.
Sr. SQL DBA Consultant/ Azure database Engineer
Certiview IT & Management Solutions -LM Wind Power
- Working as 24X7 Production Database support
- Supporting 500+ servers Production/Cert and Pre-Production Environments
- Expertise in Always on and all high availability solution
- Worked on Migration from 2000 and 2005 to 2012, 2014,2016
- Worked on database architectural design and performance assessments and security
- Performance SLAs including design, unit testing and release management Worked on Mirroring, Log shipping
- Deployed SSIS packages
- Deployed SSRS reports rdl files
SQL Server DBA(Production & Application Support)
Lince Soft Solutions - Alerus Financial
- Experience in Incident and release management team
- Worked on encryption and clustering technologies
- Worked on application user requests on Cert, test, and pre-production environments
- Worked on CR deployment on Production environments
- Installing and configure SQL Server 2012, 2008 and SQL Server 2005
- Worked on snapshot and transitional replication
- Worked on Replication techno
Sr. SQL Server DBA
Lince Soft Solutions - Client : Bank Of America (BOA)
- Working as 24X7 Production Database support
- Supporting 500+ servers Production/Cert and Pre-Production Environments
- Worked on Release management team for production and pre-prod deployments
- Worked closely with dev team for deployment and execute scripts and deploy packages
- Worked on Migration from 2000 and 2005 to 2012, 2014
- Worked on database architectural design and performance assessments and security
- Performance SLAs including design, coding, and unit testing and release management
- Configured Always on, Mirroring and log shipping and fixed ssues
- Experience in Incident and release management team
- Worked on encryption and clustering technologies
- Worked on application user requests on Cert, test and pre-production environments
- Worked on CR deployment on Production environments
- Installing and configure SQL Server 2012, 2008 and SQL Server 2005
- Worked on snapshot and transitional replication
- Worked on Replication techno Rebuilding Indexes, Update statistics if required
- Automated database maintenance with Maintenance Plan
- Implementing Server level, database level, Login and User level security
- Using 3rd party tool SQL lite speed to take and restore database backups
- Checking status of backups and troubleshooting failed backups and restoration of databases
- Updating with latest service packs and hot fixes
- Ensuring Data consistency in database through DBCC commands
- Experience in maintaining large database of size 2.2TB
- Ensuring high availability of database by configures and monitors Database Mirroring
- Monitoring all servers by using third party tool SQL Diagnostic Manager
- Worked on High availability always on and mirroring
- Created DR Design doc, PPT and checklist
- Installing SQL 2012 in Disaster Recovery Environment
- Applying database patches in all environments.
Education
B.Tech - Computer Science And Programming
LBRCE
Vijayawada 09.2004 - 06.2008
Skills
SRE/Devops/MLEngineer/SQLAdmin
Azure SQL, QL Server2019, 2016,2012, 2008,2005, 2000 and 70, Oracle 9i, MS-Access
Toolsandtechnologies
SQL Server 2017 & 2019 upgrade advisor, Visual Studio, SQL management Studio, Profilers, VMware Workstation and Hyper-V, SQL Server Reporting, Windows 7, Windows 10, Windows Server 2012/2016/2019, Azure portal, Microsoft SQL Server, Azure SQL, MS Access, ICM
Timeline
B.Tech - Computer Science And Programming
LBRCE
09.2004 - 06.2008
SRE
MicrosoftIntune
AML Engineer
AML STUDIO
SQL DBA Consultant/Azure Database Engineer
Window server Catalogue
SQL DBA Consultant/ Azure database Engineer
Certiview IT & Management Solutions - C2 Essentials, Inc.
Sr. SQL DBA Consultant/ Azure database Engineer
Certiview IT & Management Solutions -LM Wind Power
SQL Server DBA(Production & Application Support)
Lince Soft Solutions - Alerus Financial
Sr. SQL Server DBA
Lince Soft Solutions - Client : Bank Of America (BOA)
Similar Profiles
Nidhi ShreeNidhi Shree
Business Development Associate at Acuite Ratings and Research LimitedBusiness Development Associate at Acuite Ratings and Research Limited
Suraj AkulaSuraj Akula
Data Engineer at Modak Analytics, SyngentaData Engineer at Modak Analytics, Syngenta
Rajesh ViswanadulaRajesh Viswanadula
Senior Software Engineer at FactSet Research Systems IncSenior Software Engineer at FactSet Research Systems Inc