Thetchina Moorthy Email & Phone Number

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

 Accountable for the activities associated with creation and migration of databases and updatingthe service pack and deployment planning. Installation and Configuration of MS SQL Server 2008R2/2012 and security settings for standaloneservers. Coordinating with testing of database and performance. Handling the execution of DBA maintenance plan for MS SQL Server (DBCC, updating indexstatistics, monitoring database and disk space) In charge for the operations allied with scheduling and managing jobs on MS SQL Server. Responsible for the management of primary & secondary server and performing log shipping. Replication Implementation and troubleshooting. Implemented Replication Between SQL Server and Sybase (Heterogeneous replication) Monitoring of Batch Processing on Database, Hard disk Space Utilization, Memory Usage, severitylevel and CPU Utilization Providing recommendation on system configuration changes to enhance the performance and running trace and create standard reports on query performance Involved in the database security (Enabled Audit Trail on Production Server) Set up database Backup jobs for more efficient recovery by setting up Full/Differential Backup andmore frequent Transaction Log Backup for more dynamic databases. Schedule SQL Agent jobs in shrinking fast growing log files, deleting junk records or old logins,updating statistics, and checking integrity of databases. Create and schedule stored procedures as jobs to check SQL Server Error Logs and identify issues. Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing,Contained Databases. Monitoring constant growth of databases and transaction logs, change of server configurationdatabase settings, and schemas for possible issues. Monitoring Server Performance and improving them as and when required. Implementing the High Availability solutions like log shipping, Replication and Mirroring.

Chennai, Tamil Nadu, India

SQL Migration, SQL Server DBA

Chennai, Tamil Nadu, India

 Installed configured and migrated SQL Server /2008/2008R2/2012/2014/2016/2017/2019 on windows2008/2012/2016 applied service packs and security hot fixes for all servers. Involved in development activities including hardware installation & configuration and participated indatabase design, architecture, and SQL scripting. Administration and maintenance of MS SQL databases hosted on Corporate Data Center Servers. Worked in Client Place On-site for Data Migration and for designing Server Architecture. Managing SQL Server Security, Managing Database Permissions. Monitoring database performance and manage Database locks/processes etc. Communicating with customers for fast resolution of the issue. Configured and maintained Replication & Mirroring architecture to provide backup server solution for 3environments. Implemented transactional replication for data refresh and resolving the latency issues. Upgraded SQL Server 2008/2012/2014/2016 Created Database Maintenance Planner for the Performance of SQL Server which covers DatabaseIntegrity Checks, Update Database Statistics and Re-indexing.

Bachelor Of Engineering - Be, Mechanical Engineering, 1St Class

Higher Secondary, Computer Science, 94%

Activities and Societies: School Pupil leader Active member at NSS Won zonal level throw ball tournament One of the 5 members from school.

Sslc, 96%

Activities and Societies: Won zonal level throw ball tournament U16 Category