Microsoft SQL-Server (MS SQL)
Back up / Recovery
Projekt‐ & Berufserfahrung
Scope Group, Berlin, Berlin
IT & Entwicklung
7/2017 – 10/2019Tätigkeitsbeschreibung
Sr. SQL Database Administration at Scope Group, Berlin, Germany
1. Working as a Senior Database Administrator
2. Administrating more than 12 database servers.
3. Established Agile process and prepared technical database documentation.
4. Performing database migration, database job scheduling, backup, clustering, Log shipping, replication, troubleshooting Performance Tuning
Tool Used: Jira, MS SQL Server 2016|2017, Azure Database and Spotlight and lite speed backup tools
Datenbankadministration, Microsoft SQL-Server (MS SQL)
Ingram micro India Pvt. Ltd, Mumbai, India, Mumbai
11/2014 – 5/2016Tätigkeitsbeschreibung
700 SQL server with 400+ production instances, UAT and development environment
Most of the production servers are on windows cluster.
Databases are on different SQL version i.e. SQL 2000,2005,2008,2012, 2014
Databases sizes varying from 1 MB to 2 TB GB
Installing SQL server on windows cluster environment, upgrades, migration of
Installation SQL Server database, applying service pack and hot fix on servers.
Planning for Disaster recovery, capacity, and availability.
Creating and managing various SQL Server and database alerts via spotlight.
Installing SQL and windows patch for server with SQL databases
Follow ITIL process for incident, change and problem management
Microsoft SQL-Server (MS SQL), Datenbankadministration, ITIL
Tata Consultancy Services (TCS), Pune
7/2014 – 10/2014Tätigkeitsbeschreibung
Working in project transition team for SQL database, Involve in Knowledge Transition for
Part of KA, shadow support, reverse shadow support and quality golden gate check.
Knowledge acquisition from client to understand the client environment, process, database
Preparing the SOP, use case and presentation.
Understanding the work flow, application and escalation matrix.
Knowledge of remedy tool, Ignite performance tool and backup tools.
Microsoft SQL-Server (MS SQL), Datenbankadministration, QoS (Quality of Service), Prozessoptimierung
Capgemini Consulting India Pvt. Ltd., Mumbai
8/2010 – 6/2014Tätigkeitsbeschreibung
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
Microsoft SQL-Server (MS SQL), Datenbankadministration, ERP Beratung (allg.), ITIL, Change Management
Altisource Business Solution, Mumbai
2/2010 – 7/2010Tätigkeitsbeschreibung
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), Datenbankadministration, MS Office (Anwenderkenntnisse)
Zenith Infotech PVT LTD, Mumbai
11/2007 – 2/2010Tätigkeitsbeschreibung
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
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), Datenbankadministration