MS SQL Database Administrator

5/2016 – 12/2016

Initial planning and discovery of databases under the scope of migration.
Technical strategies on Migrating the MSSQL 2008 and 2014 .
Build and implementation MSSQL 2008 and MSSQL 2014,2016 servers.
Migrations and installing SSRS and SSIS as per Client Requirement.
Installing MSSQL server instances on cluster setup.

Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL-Server (MS SQL), Administration von Datenbanken

3/2015 – 3/2016

Initial planning and discovery of databases under the scope of migration.
Preparation and ownership of Solution Design Documents
Technical strategies on upgrading from MSSQL 2000 to MSSQL 2014
Build and implementation that included, building MSSQL 2008 and MSSQL 2014 servers.
Migrations and upgrades to latest version
Cross platform Migrations , Oracle 10g to SQL SERVER 2008 database Migration with SQL server Migration Assistant.
Installing MSSQL server instances on cluster setup.

Microsoft SQL-Server (MS SQL)

3/2012 – 2/2015

Performing daily DB Backups through SSMS as well as TSQL.
Migrating Databases between SQL Server 2000, 2005, 2008 and Restoring database from disk or third party tool (TSM or Legato).
Database creation and configuration, SSIS and DTS packages.
Day to Day DBA tasks of handling user's permissions and disk space issues on Production and Semi-Production Servers
Worked extensively on SQL Server Job Troubleshooting.
Developed SQL Scripting for monitoring the servers (Backup, Disk space, Log file, offline Databases etc).
Experience on SQL Server Up gradation and Migrations.Good Knowledge in Installation, configuration, maintenance, monitoring and troubleshooting SQL Server 2000, 2005,
2008, R2.
SQL Server Mail Configuration for customers.
Created various technical documents on issues faced.
Good experience in SQL clusters installation and troubleshooting.
Configuring / troubleshooting all high availability SQL Server solutions including Log shipping, Mirroring, Replication and SQL Server clustering.
Troubleshooting of blocking and Deadlocks in SQL server
Self-motivated and technically proven individual of around 3.5 years of progressive experience within the IT arena

Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL-Server (MS SQL)