SQL Server and Oracle DBA

6/2007 – 4/2017

 Extensive experience in installing, configuring, managing, monitoring and troubleshooting different flavors of SQL Server - 2000, 2005, 2008, 2008 R2 on both Cluster and Stand-alone Environment.
 Installation and admin support for Microsoft Business Intelligence products such as SSRS, SSAS, SSIS.
 Has performed Migration activities between different version of SQL Server, i.e. SQL 2000 to SQL 2005, SQL 2005 to SQL 2008 R2 (Side by Side / In place upgrade)
 Database migrations from Oracle 9i, 10g to SQL Server 2012 and 2016 using SQL Server Migration Assistance for Oracle.
 Managing and monitoring Database servers.
 Monitoring the servers by accessing remotely
 Active directory user management, replication and monitoring.
 Configuring and maintaining the high availability concepts (Log shipping and Mirroring) and Replication
 Creating cluster SQL servers and configuring for Always On technologies.
 Checking the status of Backup troubleshooting the failed backups and Restoration of databases.
 Ensuring data consistency in the database through DBCC commands
 Adding users in the database and granting permissions.
 Scheduling jobs alerts in SQL Server.
 Handling various issues from the users regarding the data entry errors in the database.
 Experience in handling Production Servers having different size of databases in each server spread across various locations.

Oracle Database, SESAM/SQL Server