AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF21058
profile image
Mandala V AXF21058 Active
SQL Server DBA in Hyderabad
Having 5+ years of Experience in Information Technology as MSSQL server DBA and Azure MSSQL database administrator in implementing and supporting Microsoft Enterprise SQL server Databases. Hands on experienced in MS SQL Server Installations, configurations, Performance Tuning, Backup and Recovery, Query Optimization, Disaster Recovery solutions of Always on High availability, mirroring, Replication and Security of database Servers.
Industries : Banking, Communications and Media
Share
Hire Mandala V
Download PDF
Availability
Full-time
Total experience
5 years
Technical skills
SQL Server DBA
5 Years & 1 Months
Azure SQL DB
5 Years & 1 Months
Performance optimisation
5 Years
High availability
5 Years
Azure Cloud
2 Years
SQL server dba , Azure sql dba
Projects
Citi bank
May-2019 to September-2022
Description
Dba related activities as part of day to day actions
Roles and Responsibilities
Provided 24*7 Support to Production Database servers for APAC, EMEA, NAM and LATAM region by Implementing Database change requests received from Developers through Change Requests/RTIM's/Incidents. Microsoft SQL server database administration experience in SQL server 2012/2014/2016/2019/2022. Experience in installations of SQL servers 2012/2014/2017/2019/2022 on new 32-bit and *64- bit operating system. Experience in migrating sql servers from older versions (2012/2014) to latest versions including 2019, 2022 and upgrading SQL server software to new versions and applying monthly service packs and patches in standalone and clustered servers. Proficient with SQL management studio, Enterprise manager, Query Analyzer, rescheduling Jobs with SQL server. Creating DB maintenance plans, rebuild/reorganize indexes & performing integrity checks. Highly proficient in database backups (Full/Log/Diff backups), Restore of Databases which participating in Mirroring/Always on availability, Recovery, linked servers and Database maintenance Plans. Experience with High Availability and Disaster Recoveries like Replication, Log Shipping, Mirroring and failover clustering. Proficient in implementing different types of Replication models like Snapshot, transactional and merge. Having knowledge in implementing Always On in SQL server 2012,2014,2016,2019. Involved in installing, configuration and maintenance of cluster in sql server 2012 in Active/Passive. Auditing database configuration and security configurations. Actively involved in system performance by tuning SQL queries and stored procedures by using SQL profiler, Database Engine tuning advisor, windows performance monitor, resource governor, data collection reports, DBCC, built-in performance report and activity monitor. Handled log suspend and shrinking of Db's, change the db options, performing instance failovers, creating database and managing free space. Worked on msaas server Restores/performance issues. Configuring database mail and managing operators.
Technologies: SQL server dba
Industry: Banking
Microsoft
October-2022 to May-2024
Description
SQL server database support for microsoft customers
Roles and Responsibilities
Working as a Azure support Engineer and providing the solutions on Azure Iaas SQL platform to MS customers 24/7 over cases, emails and chat support. Experience in troubleshooting various database related issues in multiple customer environments as part of day-to-day activities. Good Experience in deploying SQL vm on Azure, adding Iaas Extension to an existing vm, Experience in configuring single subnet and Multi subnet Always on High availability in SQL vm. Configuring automated backup and managed backups in SQL VM and resolving various backup related Issues. Importing and exporting Databases using .BACPAC methods from Paas servers and managed instances. Experience in SQL server version, edition upgrades and Downgrade. Knowledge on Distributed Availability group and recovering the databases from Disasters and rebuilding of master database. Experience in Log shipping, Database mirroring, transactional Replication and Always on availability groups. Handson experience in configuring and troubleshooting Database mail related Issues. Handling critical sql server performance issues involving slow Running queries, high CPU, Memory utilization and other resource contention, Application slowness due to sql server, disk performance. Troubleshooting various connectivity issues involving applications to sql server, remote sql server connections, between high availability nodes. Assisting customers when facing issues in installing and configuring sql server, Applying latest hotfixes and patches, Edition and version upgrades and downgrades. Troubleshooting configuration issues while building high availability environments involving creating Always on high availability groups, failover clustering, mirroring, replication. Handon experience in configuring and fixing load balancer and failover clustering issues. Having good knowledge on Azure sql server licenses (PayG, HA/DR, AHUB, MPN, software Assurance, CAL, BYOL) and assisting users in clarifying licensing queries in reducing the sql server license costs effectively. Good Experience in Analyzing different types of logs including sql server error, Agent, cluster logs, Event viewer - system, Application, security logs to provide RCA on various issues involving unexpected sql server shutdown, Failover, server slowness. Customer management and teaming skills, supporting customers on phone and written correspondence regarding technical questions and issues, having logical and critical thinking skills
Technologies: Azure sql dba
Industry: Communications and Media
Work history
Azure sql dba • October-2022 to May-2024
Description: Dba activities
Certifications
Azure fundamentals by Microsoft
2024
Education
Bachelors degree in Computer science
Andhra University
2016 to 2019
Language
English - Advanced