Sql Server Management

DEBOBRATA SARKAR

Mobile: +918*********/+919********* ~ E-Mail: ***************@*****.***

* ***** ** ** ******** that including 3 years experience in SQL Support and 2 years in Technical Support

• 3 Years Experience in database administration work with Microsoft SQL Server 2005, 2008.

• Adept in installation and configuration, maintenance and troubleshooting of SQL Server 7.0,2000,2005,2008 and user management on multiple platforms.

• Experience in MS SQL Server upgrades from 2000 to MS SQL server 2005 and 2008.

• Managing Disk Space Utilization, Monitoring jobs and Performed Test on Disaster Recovery plan.

• Worked in Application environment that includes Production (24x7), QA and development SQL Server.

• Hands on Experience in index performance tuning, stored procedures, triggers, Linked Server, and Report Server.

• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

• Responsible for the management of the database performance, backup, replication, capacity and security.

• E-Certification done on RDBMS Concept & Computer fundamental on Windows XP.

• Technically accomplished professional with 2 years of experience in Software Maintenance and Installation of hardware & software.

• Created DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0.

• Enterprising leader with excellent analytical, organisational and interpersonal skills.

Areas of Exposure

Database Maintenance

• Experience in MS SQL L2 support activities like creating users, assigning responsibilities, changing profile options, application security etc.

• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.

• Writing code and creating jobs to automate repetitive tasks.

• Good Understanding of Database architectures and Experience in troubleshooting issues.

• Performing Security Health Checks and Database Refreshes.

• Good knowledge in Windows operating system and ability to drill down database performance issues.

• Interacting with customers to resolve application issues. Providing 24x7 supports by being on-call and resolving any critical issues faced by support team in the application.

Hard Ware & Network Maintenance

Installing, Configuring and troubleshooting in Windows (2000, 2003, XP).

Support & maintenance of the application running on the server.

Ensuring system service performance, and handling emergency circumstances and providing solutions for quick recovery from emergency situations.

Providing 97% uptime of servers by troubleshooting networking problems to ensure minimum downtime & maximum availability of network.

Career Scan

Emar Solutions Pvt Limited. Bangalore SQL DBA JULY’11 – Till Date

Attainments:

• Adept in installation and configuration, maintenance and troubleshooting of SQL Server 7.0,2000,2005,2008 and user management on multiple platforms.

• Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0.

• Managing Hard disk Space Utilization, Monitoring jobs and Performed Test on Disaster Recovery plan.

• Managing the database performance, backup, replication, capacity and security.

• Coordinating with Client and onsite DBA for support. Attending Meetings with Client Counter Parts and ensuring quality support.

Project/Client : ADCB

Duration : JUL 2011 – Till Date

Role : MS SQL DBA

Environment : Windows.

Responsibilities:

Monitoring and troubleshooting login issues. Managing database security and creating and assigning appropriate roles to users, managing user privileges.

Implemented database refresh with backups and Performed Backup and recovery.

Daily monitoring includes checking whether all databases are running, disk space availability, checking for errors in log.

Worked with Global Wealth Management - With a 24/7 support DBA team of overall 6 members supporting from different location with more than 25+ servers.

Coordinating with Client and onsite DBA for support. Attending Meetings with Client and ensuring quality support.

Net Scout Technologies. MUMBAI SQL DBA Consultant JAN’11 – JUNE’11

Attainments:

Installation of Servers on Windows environment. Configuring SQL Server to achieve the best performance.

Checking Alert Log Files and Make necessary actions to rectify.

Performing the logical backups using Export and Import utilities.

• Monitoring and optimizing the performance of the database. Maintained the documents and create Audit reports for the end-users. Interacting with customers to understand and resolve their issues.

• Experience in handling both Production and Non Production Instances.

• Created, modified, maintained and optimized SQL server database.

• Responsible for the management of the database performance, backup, capacity and security.

Project/Client : Kotak Securities and Investments

Role : MS SQL DBA Consultant

Duration : Jan 2011 – July 2011

Environment : Windows.

Responsibilities:

• Installation of Servers on Windows environment and Configuring MS SQL Server to achieve the best performance.

• Performing the logical backups using Export & Import utilities and Checking Alert Log Files and make necessary actions to rectify.

• Monitoring the performance of the database and disk space availability.

• Attending Meetings with Client and ensuring quality support. Adhering to the SLA’s specified by the client.

• Attending Client meetings and discussing the extracted reports from the Security Health Checks.

• Providing Knowledge transfer to new resources joined in team.

NIIT. BOKARO Technical Infra Administrator JUL’09 -NOV’10

Attainments:

Maintained 97% uptime of servers. Effectively resolved network issues within TAT (1 day).

Successfully completed Trainer exam (FACT).

Maintained the Data Base and create reports for the based on different criteria.

Responsible for the management of the database performance, backup, capacity and security

Received appreciation from NIIT for quality training provided.

Segregate as per the organisation?

Entrusted with additional responsibility:

o Installing and maintaining Hardware (IBM X3400 server) and software.

o Taking back up of databases (MS-SQL 2005) on daily basis.

o Monitoring Memory Management, CPU utilization, Log Management, Disk Space Management.

o Configuring LAN in the same infrastructure.

o Handling and maintaining data on Encore VISTA.

NIIT, GIRIDIH Software Trainer NOV’07-MAR’09

Attainments:

Installation of OS (i.e. windows 2000, XP) and maintenance of hardware & Network.

Provide training of Micro Soft Technologies like (C#.NET, MSSQL 2000 server).

Trained for up coming technologies and products in NIIT.

NIIT, BHADRAK Software Trainer JAN’07-JUN’07

Attainments:

Provide training of Micro Soft Technologies like(C#.NET, MSSQL 2000 server).

Trained for up coming technologies and products in NIIT.

Education

Pursuing MBA (IT) from Symbiosis.

GNIIT (Diploma in Software Engineering) from NIIT in 2008.

B.Com (Accountancy) from Burdwan University in 2005.

Technical Skills

Operating Systems Windows 2003 server, 2000, XP

DBMS / RDBMS MS SQL Server 2000 & 2005, 2008, DTS, MS Access 2000, XML.

Personal Vitae

Date of Birth: 19th October 1982.

Languages: English, Hindi and Bengali

Address: C/o Asok Kumar Sarkar, Debibarpur, Shyamsundar, Burdwan – 713424, West Bengal.

Pass port: yes

Contact this candidate