Naresh G Email & Phone Number

Hyderabad, Telangana, India

Hyderabad, Telangana, India

Contribution / Highlights: As a team member I was actively involved in the below phases of project: Upgradation of SQL server from 2005 to 2012, 2014, and 2016 versions, Creating Backup Policy Documents, Work closely with server and storage team concerning system resource usage and disk space allocation, system backups, and system performance based on Microsoft standards Database tuning and performance monitoring. Confirm that backups have been made and successfully saved to a secure location Find out the newly added databases and define the backup plan Monitoring the alerts and all backup jobs. Monitoring the Log shipping, mirroring, Always On high availability options Refreshing databases from production to Prod/Test/QA environments Installation & maintenance development/QA/production servers. Jobs scheduling, monitoring, and troubleshooting.Configuring Azure Services PaaS, IaaS, and Migrated databases from on-premises to Azure: Configured development and test environment on Azure. Experience in creating and monitoring Azure SQL Server databases. Configured and Maintained Elastic DB pools. Experience in configuring and monitoring Geo-Replication Configured failover groups to provide high availability for PAAS SQL Server. Experience working with Database Synchronizations using HUB-MEMBER Topologies. Experience in configuring backups and restoring the database from recovery vault. Configuring Server level and database auditing for SQL server. Experience in Configuring CPU, Disk, DTU usage alerts, and Monitoring for Azure SQL servers. Ability to select the correct tier for Azure SQL Databases. Experience in working with Performance Metrics and Plan Management Ability to working with multi-instance management. Configured server level and database level firewalls as per security compliance. Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNETS and subnets

India

Roles and Responsibilities: Working in rotational shifts and providing 24x7 dedicated supports for SQL live Servers (PROD, UAT and STAGE). Handling Incidents and implementing of Changes as per shift basis and giving appropriate shift handover to next shift people. Checking Hourly, Daily and Weekly capacity reports and correcting the problems. Monitor failed jobs daily and rerun the jobs manually depending upon necessity. Resolving the Net Backup failures with help of Net Backup team. Scheduling Full, Differential and T-log backup Jobs for newly created\migrated DB’s. Creating Logins, Users and Roles, and giving required permissions to them and troubleshooting of database connectivity problems. Troubleshooting of Disk Space, Tempdb, Data file and Log file related issues. Installation of SQL server 2012 and 2016, apply patches and perform post installations Perform database refresh regularly and perform post migration steps. Configuring high availability solutions Log Shipping and Mirroring and Troubleshooting of Log Shipping and Mirroring related errors. Improving efficiency of databases by creating maintenance plans for updating statistics, Integrity check, Reorganize\Rebuild indexes as weekly and monthly basis. To analyse long and slow running transactions and tune the same transactions to optimize application and improving the server performance. Identifying databases growth and suggesting to appropriate users for performing data purging or increasing size of the disks for future growth of databases. Monitoring and troubleshooting of Fragmentation levels, Blocking, Deadlocks, CPU and Memory related problems. Configure Database Mail and setting-up Notifications to appropriate groups and users. Switch over and switch back (Fail over and Fail Back) of SQL server services on cluster environments and stopping\Re-starting the SQL Server services when required.

Chennai, Tamil Nadu, India

Roles & Responsibilities: Installation and configuration of MS SQL Server 2008R2 and 2012. Administered the SQL Server by creating User Logins with appropriate roles and permissions. Monitored the issues like failed logins and resolved the issues by granting privileges to users. Protected databases by taking different kinds of Backups such as Full, Differential and Transactional log backups. Created Database Objects such as Tables, Indexes, Views and Stored Procedures. Solved production problems and performed Point in Time recovery. Scheduled Maintenance jobs for routine jobs and created Alert\Notification system. Involved in database migration and up gradation from SQL Server 2000, 2005 to 2008. Resolved Disk Space issues, growth issues and other issues related to database. Monitored and Resolved the Temp DB full and Transactional Log full issues. Changed the recovery models whenever necessary and accordingly. Maintained Database Consistency check using DBCC commands. Daily checking the assigned tickets and resolved the tickets depending on the priority level.

Pune, Maharashtra, India

Roles & Responsibilities:➢Involved in Installation and configuration of MS SQL Server 2000, 2005, 2008 and 2008 R2 in Windows environment.➢Applying SQL Server patches and hot fixes.➢Configuring and maintaining Database Backups.➢Responsible for setting up the Transaction Replication for the high availability purpose.➢Daily checking and resolving the tickets depends on the priority levels.➢Responsible for performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals.➢Daily monitoring the Database Space Management parameters, allocating the required space to databases, and suitably managing database growth.➢Installing the SQL server 2005/2008/2008 R2/2012 and applying the service packs.➢Enrolling users, controlling, and monitoring User Access to the database, and maintaining system security.➢Applying patches to Test/Dev/Production servers.➢Doing Weekly Refresh of Database from Production to Test Environment.➢Working on Log shipping and mirroring tickets.➢Able to perform the Failover and Failback activities in Cluster environment

Bachelor Of Science - Bs, Biotechnology

Intermediate, Biology/Biological Sciences, General, First