Nagaraju Ega

SQL Database Administrator

Cognizant Technology Solutions

06.2022 - Current

Performed root cause analysis for database system issues, ensuring minimal downtime.
Implemented server replication and maintained high availability environments.
Administered and monitored EMS server, BG status, and BW configurations.
Optimized query performance by reviewing execution plans and applying index changes.
Restructured and re-indexed databases for improved system efficiency.
Managed SQL patches, upgrades, and daily database maintenance tasks such as backups and log shipping.
Generated health and performance reports for review by senior IT personnel.
Provided database technical support and troubleshooting for end-user applications.
Managed SSL certificate renewals and Cloud SQL patching across multiple SQL servers.
Administered database permissions, inventory management, and decommissioning of SQL instances.
Led outage calls and provided 24/7 production support for SQL server issues.
Implemented disaster recovery plans, failover tasks, and real-time monitoring for database servers.
Assisted in the maintenance of SQL databases, including performance monitoring and troubleshooting.
Supported replication and failover testing to ensure system redundancy.
Managed daily backups, restoration processes, and log shipping.
Optimized database queries for reporting purposes.
Removing unwanted DB App in production servers.
Collaborated with senior administrators to implement security best practices for database systems.
Monitored server performance, space utilization, and identified potential bottlenecks.
Optimized the performance of an enterprise-level SQL Server database by redesigning schema structures, leading to a 25% reduction in query execution time.
Preparing monthly capacity sheets and review by senior management.
Having general knowledge working with windows servers.
Installation of Cloud SQL Patching Lastest Versions in SQL DB servers as per business requirement.
Stop and disable of SQL Instance, Decommission of SQL Instance.
Monitoring the security jobs created by application team.
Led the implementation of Always On Availability Groups in SQL Server to ensure high availability for critical production databases.
Participated in [relevant SQL or IT community events/meetups] to stay updated on the latest industry trends.
I have established commitment of meeting organizational goals and objectives.