Damodara Reddy

+1-682-***-****

adzowd@r.postjobfree.com

PROFESSIONAL SUMMARY:

Overall 12+ years of Experience in Azure SQL Server Database Administration of 2019/ 2017/2016/2014/2012/20008R2 versions.

Hands-on experience in Database administration Azure SQL Databases and Azure SQL VM’s and Azure Devops

Experience in migrating SQL Servers from On-Prem to Azure including Standalone, Multi instance and AOAG Group servers.

Worked on SQL Server ORM reports

Strong knowledge on C# concepts and Dotnet framework

Experience in DevOps for Implementing Continuous Integration (CI) & Continuous Deployment (CD) using Azure DevOps Pipelines

Excellent working experience in Build automation and deployment automation tools.

Experience with Administrative work on Microsoft Azure and Team Foundation Server administration

Experience in Transaction replication, Always on Availability Groups, database migrations and database upgrades.

Experience with SQL Server 2019/2017/2016/2014/2012/20008R2/2008 installation and post configuration of SQL Server

Planned patching calendar for quarterly wise and executed SQL Server patching for all for SQL Servers.

Migrated critical SQL Servers from SQL 2012/2014/2016 to higher versions with minimal down time.

Proficient with SQL Server tools, including SSMS, DMA, Query Analyzer, Profiler, SQL Server Agent, SSRS and SSIS and Power Shell.

Proficient with database backups and recovery models.

Refreshing databases from Production to Stage and Development environments.

Worked on datacenter consolidation projects to minimize project costs.

Planning and migrated/upgraded 50+ SQL Servers from SQL Server 2012/2014 to SQL Server 2017/2019 in one year.

Implemented SQL Server Always ON Availability Groups for critical applications.

Configured and administration of database mirroring in SQL Server

Configure transaction replication for large SQL Server databases from database backup with minimal downtime.

Routine tasks: Monitoring and Maintaining the security, integrity, availability of Servers, monitoring SQL Server logs, jobs and database backups, performance tuning, building packages and responding to users and developer issues.

Hands on experience in user creation, permissions, and database backups on MySQL Servers.

Certifications & Trainings:

Microsoft Certified Professional on Windows Server 2003 (MCP 70-270)

Administering Relational Databases on Microsoft Azure (DP-300)

Microsoft Certified Technology Specialist (MCTS) – Administering Microsoft SQL Server 2012 Databases.

Microsoft Certified IT Professional (MCITP)- Database Administrator 2008

Microsoft Certified Technology Specialist (MCTS) - SQL Server 2008, Implementation and Maintenance.

TS: Microsoft SQL Server TM 2005 - Implementation and Maintenance

ITIL Foundation Certificate in IT Service Management.

B.Sc. (Bachelor of Computers)

Technical skill Set:

Microsoft Servers: Azure IaaS, Windows Server 2003/2008 R2/2012R2/2016, Microsoft SQL Server 2000 to 2017 and Azure DEVOPS

Services: ADS, DHCP, DNS, MSCS

Virtualization: Hyper-V, VMware

PROFESSIONAL EXPERIENCE:

EPSoft Inc (India & USA) July 2022 to Present

Client: CMS is a B2B central clearing house for the USA utility market

Environments worked: Production,Pre-Prod,Performance testing environment,SAT,FAT,DEV

Roles and Responsibilities:

Experience in installation of azure Devops on premise and Configuring the Azure

DevOps services on cloud along with code migration from TFS to Azure DevOps

Customization of Azure Templates as per the project needs, Installation, configuration

and Integration of SonarQube server in Azure pipelines.

Automated the installation, configuration and Deployment of Dynamics AX 2012, SQL

2016, SAG Web methods Stack using azure Devops Pipelines

Installation and Configuration of Build Server for Dynamics AX, SharePoint, .NET and

MTM and experience in creating Test cases, test planes and Setting up Lab

environment for execution of test cases

Imposing the Microsoft code analysis rule set along with build automation to check the

code quality

Deployment automation of Dynamics AX, SQL DB, SharePoint and .NET

technologies using PowerShell scripting

Technologies Used: Microsoft SQL Server, Azure DevOps, Microsoft Azure, TFS 2013, Release management tool, Dynamics AX2012, Share Point, .NET, Terraform, GIT, TFVC.

Accenture Sep 2017 – Jul 2022

Cloud Infrastructure Manager

Environments worked: Production,PRE-Production,UAT,TEST,DEV

Roles and Responsibilities:

Administrating and Managing 50000+ Windows servers.

Configured SCOM monitoring tool and Achieved 99.9 % uptime for all windows servers and Databases servers.

Resolved all P1 and P2 Incidents within SLA as per the customer SLA norms.

Resolved all service requests within SLA and created automation script for repeated requests to reduce the manual efforts.

Troubleshooted all application software installation issues and system slow ness issues

Migrating the VM’s from On-prem to Azure.

Configuring Azure backups and site recoveries.

Creating blobs and files in Storage Accounts and creating azure Key vault for storing certificates and passwords.

Creating Storage pools for 2016 Azure Cluster.

Enabling Public connectivity to the private network.

Configuring Load balancers though Azure traffic managers.

Providing support for Azure and Hyper-V Virtual machines.

Installing Regular monthly security patches.

Configure (ILB Internal load Balance) for IIS & SQL on Azure servers.

Performing Add, Grow, Luns and upgrading CPU RAM activities for Azure servers.

Recreating VM's and Migrating the Azure Servers to different cloud servers & Subscriptions.

Rebuild the Physical and virtual Windows servers 2008/2012/2012R2/2016.

Decommissioning the Physical, Virtual, and Azure servers.

Configure MSCS cluster and destroy the cluster.

Updating servers with the latest secure patches and hot fixes through IPAK.

Creating Shred Drives between two Virtual machines for cluster.

Experience on Hyper-V Host Configurations and builds.

Experience on In-place Upgrade on 2008 R2 and higher.

Providing support for Azure based VM’s creating new VM’s and modifying configuration of the VM’s as per request.

Creating and modifying DNS records.

Experienced on Data Center operations and windows operations.

Experience on Creating Changes and implementing the Changes.

Resolving ILO related issues and configuring HP ILO for Physical servers.

Creating New DHCP Scopes and Maintaining DHCP Scopes across all sites.

Review all customer change requests for standards compliance, and operational feasibility.

Gathering information on problems and identifying the root cause of the problem and then providing a permanent solution.

Scheduling activities with planned downtime and implementing critical changes on production servers.

Tech Mahindra Aug 2014 - Sep 2017

DBA Lead

Environments worked: Production,PRE-Production,UAT,TEST

Roles and Responsibilities:

Migrated 300 + SQL Servers from On-Prem to Azure including standalone,

multi-instance and Always On Availability Groups servers.

Keeping the SQL Server VM’s and Data disks in right server size

Move TempDB database to ephemeral disk.

Optimize TempDB db files, initial size and growth based on Azure Server SKU.

Select right Disk SKU for data, log and installer disks based IOPS and throughput.

Implement Host Cache for data disks < 4 TB drives and Write acceleration for log disks for

M-series VM for better performance.

Add SQL Servers to Logic Monitoring tool during post migration.

Update database backup path from On Prem NFS share to Azure Blob storage for full and log

backup jobs.

Plan and migrate AOAG SQL Servers and implement Load balancers in azure.

Support for SSIS Scale Out High Available (With AG and Cluster Service).

Update SSL Certificates for Standalone, Multi-instance, listeners and alias.

Update SQL Server Backup, Integrity Check, Index and Statistics jobs.

Verify Additional IPs added in Network Adopter and Azure for Multi instances.

Update and fix SPN’s issues for Named, Multi-Instances and Listeners

Update Cluster Same/Cross subnet thresholds for Cluster’s.

Update Read-Only Routing URL’s for AOAG Servers.

Update Min Memory, MAX Memory and MAXDOP.

Update New Azure IP’s in SQL Server Configuration Manager.

Verify and fix Linked servers post migration of SQL server to Azure.

Infosys Technologies Feb-2012 - Aug-2014

DBA Consultant

Environments worked: Production, PRE-Production, UAT,DEV

Roles and Responsibilities:

Providing Remote administration Support for Windows Servers 2003/2008/2012 and AD infrastructure.

Working on tickets and ensuring that the tickets are addressed within the SLAs.

Connecting to remote servers and resolving the entire database related issues.

Installing & Configuring SQL servers on new servers for New Projects.

Check consistency in the database using DBCC utility.

Monitoring servers and running daily checklist on servers.

Preparing handoffs and circulating on pending issues.

Backups and restores.

Restoring backups on Dev and test environments when ever required.

Configuring mirroring and resolving mirroring related issues.

Create the jobs and also maintain the jobs as daily basis as well as weekly basis.

Responsible for 24/7 production support.

Creating users, roles and giving appropriate permissions to the members as part of the security implementation.

Performing Hardening/Health checks of windows servers, VM Hosts and AD health checks to secure them tightly according to customer security guideline.

Performing firmware upgrade on windows servers when required by doing proactive monitoring.

Building up DELL and HP severs remotely through ILO\DRAC and doing server refresh activity like upgrading OS.

Creation of new MSCS for WIN2K3/WIN2K8/WIN2K8R2 & WS2012 (Multi node and Multi Site).

Adding new node to MSCS for the existing MSCS Cluster.

Works with vendors like HP, Microsoft to achieve defect resolution

Based on the customer requirement need to work on DNS mappings, modifying CNAME records.

Working with different Datacenter Site services teams across the global to resolve the issues.

Upgrading VMs from 2008 R2 OS to Windows 2012 server OS.

Creating Virtual machines on Host through Hyper-V, deploying Guest OS, service packs, IIS on VM’s, Moving Vim’s from one host to other host by using SCVMM.

Virtual machine deployment/maintenance/troubleshooting (Hyper-V).

Implementing live migrations on VMS from One Host to other Hosts.

Managing and maintaining all Virtual Machines using Hyper-V Management Console.

Checking performance test on Hyper-V Virtual Machines and pulling reports on daily Basis

Migrating VMs from standalone Hosts to Clustered hosts as per the resource requirement.

Performing LUN addition, Lun expansion and deletion operation on servers.

Creating New DHCP Scopes and Maintaining DHCP Scopes across all sites.

Mahindra Satyam Dec 2010 - Feb-2012

DBA Specialist

Environments worked: Production, PRE-Production, DEV

Roles and Responsibilities:

Trouble shooting VPN related issues.

Adding user into RSA server and given permeations to user provide access to user for VPN login

Mapping soft and hard tokens to user IDs

Attending sev2 Incident calls.

Monitoring the server’s network devices through Site Scope, whatsup gold tool.

Installation of Network Clients, Regular Updating of Virus Scanner, downloading and updating.

Hardware and Software Troubleshooting, Installation/Up gradation of Operating Systems.

Applying service packs, critical updates and security patches to all NT based client computers using Software Update Server (SUS).

Extending support to the network infrastructure and Maintaining LAN including hubs, Switches, Modems, Network cables etc.

Wipro Technologies Dec 2006 - Dec-2010

System Administrator

Roles and Responsibilities:

Installing, Configuring, Managing SQL server 2008 and 2012

Installing, Configuring, Managing Replication, Log shipping and Cluster.

Monitoring Database & providing 24X7 Support to critical application database

Monitoring & configuring Jobs, Maintenance plans etc.

Performance monitoring, user creations and Configuring permissions depending on the requirements.

Backup and restoring Databases.

Resolving issues based on requests by help desk tool within SLA

Setup and maintain Project documentation and standards.

Backup the SQL Server transaction log.

Monitor Windows 2000 and SQL Server counters in System monitor to ensure optimal performance.

Track Locking, blocking, deadlocks, long-running queries, and high-resource queries.

Perform full / differential database backups of all system and production databases on Weekly and Monthly basis.

Remove extra space from log and data files on Weekly basis.

Perform a complete restore of all monthly system and Production database backups on Test Machine.

Perform DBCC CHECKDB on all restored system and Production databases.

Monitoring the transactions in SQL Server, using traces and stores them into tables to check the abnormal transactions and Locks.

Page and Row level compressions

Contact this candidate