Govardhan Reddy K Email: adl0hl@r.postjobfree.com
MS SQL DBA Mobile: +91-630*******
Professional Summary:
Total 3.7 years of comprehensive IT experience with involvement in all phases of SQL server database administration and acquired knowledge on Azure (PaaS &IaaS) cloud administration.
Experience with various version of Microsoft SQL server including SQL server 2008\2008R2 \2012\2014, SQL server 2016 and Azure PaaS and IaaS.
Responsible for managing, troubleshooting and provide solutions for monitoring alerts with in
specified SLA period.
Handling user raised requests and database enhancement deployments.
Installation and configuration of various version of SQLDB Engine SSRS SSAS.
Applying SQL server patches and hotfixes on both standalone and cluster servers.
Managing migrations of SQL instance from lower version to higher versions and editions upgrades.
Design and Implement Database and user security policies.
Monitoring and handling space management.
Ability to manage if databases are more than 5 TB in Size.
Exposure on configuring, monitoring and troubleshooting Transactional Database Replication.
Implementing various high availability solutions like Always ON availability groups and SQL Clustering.
Ability to detect and troubleshoot SQL server performance issues related CPU, memory, I/O and
other resource bottlenecks.
Exposure on Transparent Data Encryption (TDE), Always Encrypted and Dynamic Data Masking (DDM) encryption futures.
Handling migration of databases from On-premises to Azure cloud. And exposure on active
Geo-Replication.
Collaboratively working with database developers and other technical teams resolving technical
issues related to the design, analysis, administration & support of database applications in
development, test and production environments.
Technical Knowledge:
Skill Type
Skill Name
Database
SQL Server 2008/2008R2/2012/2014/2016 and Azure PaaS and IaaS.
Ticketing and Backup Tools
Service now & Veritas Netbackup
Operating System
Windows 2003, 2008, 2008 R2, 2012, 2016 Servers
Professional Experience:
Working as MS SQL DBA Consultant for Moonstone Info Tech Pvt. Ltd. since October 2017.
Certifications:
Microsoft Certified Technology Specialist of SQL Server (70-432) Certification.
ITIL Foundation Certification in IT Service Management.
Academic Qualification:
Graduation: B.Tech -Bachelor of Technology,JNTU University,Hyderabad, 2017.
Roles and Responsibilities in Moonstone:
Responsible for managing, troubleshooting and provide solutions for monitoring alerts and user raised requests within specified SLA period on both on-premises and Azure cloud environments.
Hosting all series of steps, packages and releases for database enhancement deployments.
Accountable for SQL Server SSAS SSRS installation and configurations.
Applying SQL patches and security updated on different SQL versions including Cluster & AG servers.
Migrating and Upgrading SQL servers from lower versions to higher versions.
Checking the status of backups, troubleshooting and provide solutions on backup failures and If required recover the databases from available backups on tape by using third party tool like Veritas Net Backup.
Performing database refresh activities from production environment to non-production environment.
Design and Implement database and user security policies.
Monitoring and handling space management.
Designing and supporting high availability SQL Server solutions that include Clustering, Replication & Always ON Availability Group.
Accountable for renewal of SQL service accounts password and SSL certificates.
Configuring Transparent Data Encryption (TDE) to protect data by encrypting the physical files of the database at rest.
Configuring Always Encrypted for encrypting sensitive individual columns data at rest as well as in-transit completely.
Creating and monitoring weekly index and update statistics SQL agent jobs.
Provisioning Azure SQL Database, granting access based on constructed security policies.
Configuring Azure high availability futures like Active Geo-Replication.
Migrating on-premises database to Azure.
Adding databases into Elastic Pools and performing service and performance tier scaling based on requirements.
Configuring Dynamic Data Masking (DDM) to prevent unauthorized users to access\viewing certain types of sensitive information.
Troubleshooting SQL server performance issues related to CPU, memory, I/O and other resource bottlenecks.
Personal Particulars:
Name as in passport : Govardhan Reddy Kondreddy
Gender : Male
Nationality : Indian
Marital Status : Single.
Languages Known : English &Telugu.
Permanent Location : Andhra Pradesh.
Current Location : Bangalore, Karnataka.
Contact Number : +91-630*******
Acknowledgement:
I hereby declare that statements made are true and correct to the best of my knowledge and belief.
Place:
Date: Signature
(Govardhan Reddy K)