Summary
Overview
Work History
Education
Skills
Tools Used
Azure Experience
Timeline
Generic

PUNEETH KAVALI

Hyderabad

Summary

Efficient administrator having 5 years of experience and eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with strong work ethic.

Overview

5
5
years of professional experience

Work History

Database Administrator

Infinite Computer Solutions
07.2022 - Current
  • Working as Database Administrator (E2) in Infinite Computer Solutions
  • Project Client: Molina Healthcare
  • Modified databases to meet needs and goals determined during planning process.
  • Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.

Database Administrator Associate

Cognizant Technology Solutions
03.2020 - 07.2022
  • Worked as Database Administrator Associate in Cognizant Technology Solutions
  • Project Client: Sensyne Health
  • Managed Approximately 15 to 20 Client Requests Through Emails.
  • Monitored Server and Database Performances and reported to Senior Level

Database Administrator Associate

Optum Global Solutions
04.2019 - 03.2020
  • Worked as Database Administrator Associate in Optum Global Solutions.
  • Monitored Ticket Queue and Routed to concerned teams and Acknowledged Emails accordingly.
  • Generated Database health check Reports on Daily Basis to Maintain Database consistency.
  • Prepared PowerPoint Presentations, SOP's under Supervision of Senior Level Administrators.

Education

Bachelor of science - Computer Science

Adikavi Nannaya University
Eluru
04.2017

Skills

  • Installing, configuring, monitoring and troubleshooting SQL 2014 - SQL 2019
  • Applying Service Packs, Cumulative Updates, Hotfixes (GDR, QFE)
  • Creating databases and performing backups and its Restoration
  • Understanding of Server Roles, Database Roles and Permissions
  • Handling Orphan Users and working on IMPERSONATE permissions
  • Configuring Linked Servers between same/different SQL Server versions
  • Handling Master, Model, MSDB, TEMPDB and Resource DB corruptions
  • Configured SQL Server Event, Performance Condition and WMI alerts
  • Knowledge on HADR like Clustering, Always-On AG & Replication (Snapshot and Transactional)
  • Knowledge on Always-On AG on Windows Cluster
  • Knowledge on Advanced SQL Server Architecture (Relational & Storage Engine
  • Database Management
  • Backup and recovery
  • Database monitoring
  • Database Troubleshooting

Tools Used

  • Delphix - Delphix Masking Tool, Delphix Appliance Finder
  • Servicenow - I-Serve
  • SSMS

Azure Experience

  • Creating Azure Virtual Machines and Configuring Active Directory and installing SQL Server,
  • Configured Always-On AG with listeners in Azure VM's,
  • Knowledge in Configuring Azure SQL Databases using DTU and V-Core Models.
  • Knowledge in Taking DB Backups to Azure Storage Accounts/Blobs.
  • Knowledge in Taking Backups and restoring using BACPAC Method.
  • Knowledge in Configuring Geo-Replication and Failover Groups.
  • Knowledge in Elastic Concepts like Elastic Jobs, Elastic Queries.and Elastic Pools.
  • Knowledge on Configuring Alerts on Azure SQL Databases,
  • Knowledge in MI Architecture. Knowledge in Configuring Managed Instances.
  • Knowledge in Implementing Backup and Restores from MI to MI, Knowledge in Migrating DB's from On-Prem to Azure SQL Database/Managed Instances Through Azure Data Studio.
  • Knowledge in Migrating DB's from On-Prem to Azure SQL Database/Managed Instance through DMA Tool. Migrations done using import/Export wizard.

Timeline

Database Administrator

Infinite Computer Solutions
07.2022 - Current

Database Administrator Associate

Cognizant Technology Solutions
03.2020 - 07.2022

Database Administrator Associate

Optum Global Solutions
04.2019 - 03.2020

Bachelor of science - Computer Science

Adikavi Nannaya University
PUNEETH KAVALI