Raju Odela

Experience

• 

  Black Knight

  Sept 2011 - Dec 2015

  SQL Server DBA

  Concerned with installation, upgrade, configuration & performance tuning of MSSQL Server2008, 2008R2, Having Knowledge on Always on availability grouping & knowledge on SQL clustering in 2012 Performed backups, restore & refresh operations Created the followingo database, tableso Alerts & scheduled jobs Migrating & upgrading databases from MS SQL server 2005 to MS SQL server 2008/2008 R2& 2012 Conducting maintenance plans such as service packs, windows security patches and upgrade plans Implemented always on high availability grouping in DEV & UAT Servers Performing database server health check-ups on regular basis Worked extensively on Database space management, performance monitoring and alert management Administered the MSSQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups Scheduled the timely (hourly, daily, weekly) backup jobs for Databases & recommended backup strategies Performed restoration operations, refreshed the databases from higher environments to lower environments & vice-versa based on the requests Supervising and fixing database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases etc. Managing the Production database server during peak times Troubleshooting Web application timeout alerts, Server anomaly conditions, blockings, process utilization issues, network utilization issues, server connectivity issues. Troubleshooting issues related to SQL connectivity, app pool configuration, password expiry, network issues and performance issues like memory, processor usage on web and SQL servers. Supervising OS Related tasks like Rebooting Servers, analysing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc. Monitored the database server performance using DBCC Show less

• 

  Tata Consultancy Services

  Jan 2016 - Mar 2024

  SQL Server DBA
• 

  Tata Consultancy Services Limited (TCS)

  Apr 2024 - now

  SQL Server DBA