Saidarao Ainala Email & Phone Number

Bengaluru, Karnataka, India

SSRS Object Space Growth Report:Designed an SSRS report focusing on object space growth within the database, providing insights for capacity planning and resource allocation.Disk Space and Database Monitoring:Monitored and addressed issues related to disk space and database free space reports, optimizing system performance and preventing potential disruptions.Weekend Scheduled Tasks Review:Reviewed and audited scheduled tasks over the weekend, identifying and addressing conflicts or errors to ensure smooth system operation.Patching Coordination with Application Teams:Coordinated with application teams for scheduled patching activities, maintaining system integrity and reducing vulnerability to security threats.

Installation, configuration, and maintenance of SQL Server instances and related components (Reporting Services, Integration Services).Monitoring and maintaining database performance and security, resolving issues, and ensuring data integrity.Designing and implementing backup and recovery plans, including disaster recovery testing.Managing database user accounts, permissions, roles, and access.Implementing high availability solutions like replication, mirroring, and clustering.Change control management, including reviewing and deploying scripts and changes.Developing and implementing consistent, reliable, and secure database policies and procedures.Providing technical support for application developers and users, including performance tuning.Creating and maintaining comprehensive database documentation, including backup and recovery procedures.Staying current with emerging technologies and trends in database administration, including cloud solutions, automation, and virtualization.Skills: Production Support, Database Monitoring, Team Leadership, Technical Documentation, SQL DBA, SQL Database Administration, SQL Clustering, Azure Infrastructure as a Service (IaaS), High Availability (HA), Delphix, Foglight.

Resolve daily tickets based on priority.Analyze recurring ticket trends.Manage user logins and permissions.Install and configure SQL Server versions.Apply patches and service packs in standalone and cluster environments.Perform database backups for protection.Monitor and resolve tempdb and log issues.Configure and monitor Database Mirroring and Log Shipping.Implement and maintain Mirroring and Log Shipping.Troubleshoot Always-On Availability issues.Attend daily calls, weekly TAB, and CAB meetings.Discuss open tickets and client changes.Experience in daily, weekly, and monthly checklist reporting.Upgrade SQL Server from 2008R2 to 2016.Automate details on DB size growth.SPACE management on production servers.Discuss open tickets in Daily Connect calls.Document/Reports: Acknowledge daily health check reports, weekly ticket audit, and highlights.