Projekt‐ & Berufserfahrung
6/2007 – 4/2017Tätigkeitsbeschreibung
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