MS SQL Database Administrator

8/2010 – 6/2014

 Working on pre ERP processing production database, it is product based project support.
 Working on cluster Environment and Multi Instance Servers.
 User management: Assigning SQL server fixed Server / Database roles to logins and
granting permissions to the users.
 Performance optimization & troubleshooting by investigating through Locks, Blocking
Process, SQL profiler, SQL trace, Index health, update statistics.
 Disaster Recovery Planning: Implementing correct Backup Strategy as the customer
requirement & performing Restoration & point-in-time recovery in case of eventuality or
as per customer requirements.
 Change Management: Raising CR / Representing CR in TAB/CAB meetings /
implementing them successfully with in time limits.
 Security Management: Assessed the risks / security issues in the servers and escalated to
the client on a quarterly basis.
 Knowledge of and adhering to the ITIL processes like Change Management, Incident
Management in the Support Environment.
 Capacity Planning: Monitoring the growth of database to ensure the smooth running of
daily activities.

Microsoft SQL-Server (MS SQL), Administration von Datenbanken, Enterprise Resource Planning, ITIL, Change Management

2/2010 – 7/2010

 Extract data from data warehouse as par business requirements and generate the reports.
 Prepare detailed statistical reports in MS Access and MS Excel to track progress on
weekly, monthly and quarterly basis growth of customers.
 Review existing business procedures, recommend and implement changes.
 Work towards the atomization of day to day activities through innovative ideas to improve the efficiency and utilization.
 Responsible for setting preferences for various ad-hoc requests and distribution of tasks.
 Train new employees in using the existing system.

Microsoft SQL-Server (MS SQL), Administration von Datenbanken, MS Office (Anwenderkenntnisse)

11/2007 – 2/2010

 Installation and maintenance of SQL Server software on production/development Servers and clients
 Maintaining & managing, monitoring SQL server database
 Disaster recovery strategy design and implementation (Log Shipping)
 Performance Tuning and monitoring through SQL Server Profiler, System Monitor
(perfmon)
 Backup recovery strategy for all SQL Servers
 Creating, Attaching and Detaching, Restoring database
 Creating the logins, users as & when new resource allocated
 Conducting internal security audit for SQL server
 Managing privileges & rolls to ensure the application/database security
 Scheduling daily backup, and monitoring them to make sure they are executed without any errors.

Microsoft SQL-Server (MS SQL), Administration von Datenbanken