G.AKSHAYA REDDY

Over 7+ years of professional experience as a SQL Server Database Administrator, managing and supporting large-scale database environments in production, development, and testing settings. Skilled in installation, configuration, upgrades, and migrations across SQL Server versions 2012–2022. Proven expertise in implementing high availability (Always On, Clustering, Log Shipping, Mirroring) and disaster recovery (DR) solutions to ensure business continuity. Experienced in backup and recovery strategies, performance tuning, and query optimization using tools like SQL Profiler, DMV, and Execution Plans. Adept at automating maintenance tasks, creating SQL Agent jobs, and performing database health checks to maintain optimal performance. Strong knowledge of security administration, including user access management, auditing, and encryption. Collaborated with development teams to design efficient databases, troubleshoot production issues, and improve performance. Provided 24x7 production support, ensuring system stability, high availability, and data integrity in mission-critical enterprise environments.

Project #1: Analyst Contracting Management System (ACMS)

Description:
ERP-based system that automates project cost estimation, asset tracking, and financial reporting with built-in accounting and analytics.

Roles & Responsibilities:

• Installed, configured, and upgraded SQL Server 2012–2017 in production and development environments.
• Planned and executed database migrations (2012 → 2014, 2016 → 2017) ensuring zero downtime.
• Designed and implemented Disaster Recovery (DR) using Log Shipping, Replication, and Always-On AG.
• Automated Full, Differential, and Log backups via Maintenance Plans and LiteSpeed, reducing manual work by 40%.
• Conducted performance tuning and query optimization to improve system response by 30%.

Project #2: Fixed Asset Management System

Description:
Enterprise-wide fixed asset tracking and depreciation management system for monitoring, auditing, and reporting physical and software assets.

Roles & Responsibilities:

• Installed and configured SQL Server 2012/2014/2016 editions across Production and UAT environments.
• Managed SQL Server upgrades and migrations ensuring 100% data consistency.
• Implemented Always-On AG and Mirroring for HA and automatic failover.
• Configured Transactional Replication and Log Shipping (Standby Mode) for DR purposes.
• Automated maintenance tasks – integrity checks, index rebuilds, backup verification, and statistics updates.
• Tuned queries, stored procedures, and triggers reducing execution times by up to 30%.
• Troubleshot and resolved blocking, locking, and deadlock issues in production environments.
• Created and customized SSRS reports for business and operational analysis.
• Implemented role-based access control (RBAC) for improved security compliance.
• Collaborated with Dev and QA teams for database refreshes, restores, and testing.
• Provided 24x7 production support ensuring SLA compliance.
• Implemented SQL Server Security Policies with principle of least privilege.
• Configured and monitored Database Mail, SQL Agent Jobs, and Alerts for proactive error management.
• Delivered 24x7 production support, maintaining data integrity and system availability.
• Configured Always-On Availability Groups (AOAG) in clustered environments for high availability.