Ramakrishnan Padmanaban

Experience

• 

  Wipro Technologies

  Dec 2012 - Apr 2016

  Support Engineer

   Resolving the platform level issues within the SLA Completing the customer’s data and deployment requests within the SLA Monitoring the production environment servers according to the customer request. Generating reports periodically to the concerned team on the key performance indicators and server health check. Planning and fixing the appropriate dates for Disaster recovery activity every year and also implementing our part for the activity. Planning the maintenance activity in production as well as test servers during the weekends once the business people are agreeing with the downtimes. Installing adapters, hot-fixes, service packs, certificates in the servers whenever necessary for sever maintenance as well as on customer requests. Assisting the OS support teams in updating the security patches for server compliance every month. Troubleshooting with Splunk dashboard and application logs. Working Splunk monitoring dashboard and coding for automated periodical reports. Responsible for sharing design with the team and guiding them in build and unit testing.  Setting up servers according to the requirement. Setting up Always ON HA, Clustering configuration and SQL installation. Port enabling according to the architecture provided and the requirement from development team with the necessary IRMC approvals. Going forward for necessary certificate registrations and DNS creations, ADFS configurations and RAVA tests. Resolving the server and DB related issues. Show less

• 

  Tata Consultancy Services

  May 2016 - now

  Database Administrator

  Maintaining Log shipping, Mirroring and Clustering in SQL 2008 \ 2012\ 2014Maintaining Replication which includes transaction replication and snapshot replicationMigrated SQL Server from 2005 to 2008, 2012 and 2014 versionsPerform and monitor daily database operations and did the set-up of backup schedulesDesigned backup and restoration jobs for all production databasesAccomplished rebuilding snapshot and transactional replication for the reporting databasesDesigning Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.Fine-tuning stored procedures using execution plan in T-SQL for better performancePerformed the Setup and Monitoring the status of Maintenance jobs which are scheduled to run daily and on weekends (tasks like rebuilding indexes, Shrink Database, and Database complete backup)Monitored SQL Server services status, Application log, Jobs, SQL Server Logs, Dead locks/BlockingMonitoring of Disk space where physical databases are storedCreated users and gave appropriate PermissionsDeployed SSIS packages and scheduled SQL Agent jobsResolved performance issues and daily backup failuresPerformed a complete restore of all monthly system and Production database backups on Test MachineStreamlining the server/database level security by creating the Windows and SQL logins with the appropriate server/database roles and object level permissionsReviewed Database Scripts from the development team before releasing them into the ProductionResponsible for General Database Administration and Performance tuning Show less