SQL Server Administrator Resume

SQL Server Administrator Resume

Santanu Kumar Panda
pandakumardba@yahoomail.com   
Mobile: +91- 9587845000                                                                


Objective:
Quest to work in a professional and competent atmosphere involving my enthusiasm, aided with my efforts contributing to growth of the organization, to strive and to achieve excellence in the area of work undertaken with honesty, commitment and dedication.

Summary of Skills & Experience:

IT Professional having Master in Computer Science, with  six years of  work experience in Database administrations, implementations and maintenance in mid and large enterprise on different domain with well aware of ITIL process(Incident,Change,Problem Management) and client facing skill.

Technical Skills:                                                                                                                                                             
C#, VB.Net, VB6.0, SQL Server 2000, 2005 and 2008, ASP.NET, HTML, XML, ASP, Ajax, JavaScript, Web Services, WCF, LINQ, Entity Framework

Educational Qualification:

1999 – 2003       :  B.E (I.T), First Class, Government S.K.S.J.T. Institute of Technology,
1998 – 1999     :  Higher Secondary (Mathematics + Biology), 80.5 %.
1997 – 1998         :  SSLC, 77.6%, Madurai.         

Organization:      Cognizant Technology Solutions

Duration        : December XXXX to Aug XXXX.
Profile         : Senior Database Administrator
Client          : Citi Bank N.A

Cognizant Technology Solutions, the global IT business of Cognizant Technology Solutions is a leading Information Technology, Consulting and Outsourcing company, that delivers solutions to enable its clients do business better. Cognizant Technology Solutions delivers winning business outcomes through its deep industry experience and a 360 degree view of “Business through Technology” – helping clients create successful and adaptive businesses. A company recognized globally for its comprehensive portfolio of services, a practitioner’s approach to delivering innovation and an organization wide commitment to sustainability.

Role & Responsibilities at Citibank projects:

Handling multiple projects for Citibank Clients.
Providing 24*7 supports for mission critical production Sql databases.
Installation of Sql Server manually and through TPM.
Providing High availability support and solution for critical databases.
Providing Disaster recovery plain and support(Mirroring, Log Shipping).
Automation of different administration tasks.
Cluster setup and maintenance.
Worked on Different Migration Project.
Backup and recovery plain.(Native and Third party)
Performance Tuning.
Report deployment through SSRS
Day to day resolving incident within defined SLA.
Taking part in Change management process and provide solution to existing and as well as new projects.
Basic project management skill.

Organization    : Accenture
Duration        : Oct XXXX to December XXXX.
Profile                 : Specialist
Client                  : Kotak Mahindra Bank and ACE Commodity Exchange

Accenture is a leading global Technology and IT Enterprise. accenture is one of India's original IT garage start ups. Its range of offerings span R&D and Technology Services, Enterprise and Applications Consulting, Remote Infrastructure Management, BPO services, IT Hardware, Systems Integration and Distribution of Technology and Telecom products in India. The accentureteam comprises 90,000 professionals of diverse nationalities, operating across 31 countries including 505 points of presence in India. accenture has global partnerships with several leading Fortune 1000 firms, including several IT and Technology majors. 

Role & Responsibilities at client side- Kotak Mahindra Bank & ACE:

Administrating Ms Sql Server (2000,2005,2008,2012) in production environments.
Day-to-day troubleshooting and resolving database issues.
Installation of Sql Server, hardening of database and applying   Service pack and hot fixes.
Capacity planning for database systems
UAT Refreshes, Database  purging, index rebuilding.
Backup  automation and monitoring  including daily database backup processes
Report Design and deployment.
Managing  and configuring disaster recovery plans for databases (Log Shipping & Mirroring)
Cluster setup and administration.
Monitor and optimize databases in Production Environment.
Create and administer automated SQL Server jobs, notification, alerts.
Database Migrations from different platform and versions.
Daily support, troubleshooting, monitoring, optimization and tuning of Sql server on production environments.


Organization    :    SNS Technologies
Duration        :    Feb XXXX to 0ct XXXX.
Profile                 :    Sql Server DBA
Client        :    IBM-Royal Bank of Scotland Project.

SNS Technologies. (http://www.snstech.com) SNS Technologies is the enterprise solutions, providing value-added services in diverse technologies to an international customer base. In an attempt to integrate the strengths of Thakral group’s geographic presence and extensive experience in IT product distribution, and to move up the value chain into higher value services across these countries, a strategic entity known as Raffles Solutions.

Role & Responsibilities at client side- Royal Bank of Scotland:

Administrating Ms Sql Server (7.0, 2000,2005,2008) in production environments.
Day-to-day troubleshooting and resolving database issues.
Installation of Sql Server, hardening of database and applying   Service pack and hot fixes.
Managing SQL Server Database security as per GSD.
Capacity planning for database systems
UAT Refreshes, Database  purging, index rebuilding.
Backup  automation and monitoring  including daily database backup processes
Managing  and configuring disaster recovery plans for databases (Log Shipping)
Cluster setup and administration.
Monitor and optimize databases in Production Environment.
Create and administer automated SQL Server jobs, notification, alerts.
Database Migrations from different platform and versions.
Daily support, troubleshooting, monitoring, optimization and tuning of Sql server on production environments
Raising and representing changes at CAB meets.

Organization    :    Sonata software
Duration        :    Oct XXXX to Feb XXXX.
Profile                 :    Sql Server DBA

sonata software (http://www.sonata-software.com)sonata software is an international company serving IT Service Providers worldwide. sonata software provides two separate and distinct services-a Managed Service infrastructure and a Business Continuity Solution.

Role & Responsibilities:

Administrating Sql Server 2000 and 2005 Database. (Installation, User Rights, Back Up & Recovery, Performance Tuning, Space Management)
support of Data Center in 24* 7 basis
Applying Service pack and hot fixes.
Manage SQL Server user security and permissions
Manage database files, file groups and space management.
Deployment in production from Development and testing server.
Stress Test on server using SQLIOSim.
Managing disaster recovery plans for databases (Log Shipping, Mirroring)
Monitor and optimize databases in Production Environment.
Create and administer automated SQL Server jobs, notification, alerts.
Creating some packages using Sql Server Integration Services.
Data Migrations from sql server 2000 to 2005.
Daily support, troubleshooting, monitoring, optimization and tuning of Sql server on production environments.                                     

Organization    :   Techno Brain
Duration        :   Aug. XXXX to Sep XXXX
Profile                 :   Database.

Techno Brain (www.technobraingroup.com) is one of India's most quality conscious and progressive footwear companies with nationally presence and having Data Centre in Inderlok, Hyderabad, India.

Job Activity.

Administrating Sql Server 2005 Database. (Installation, User Rights, Back Up & Recovery, Performance Tuning, Space Management)
Manage SQL Server user security and permissions
Manage database files on a RAID array
Daily backup restore operations and Job Monitoring.
Managing disaster recovery plans for databases(Log Shipping, Mirroring)
Monitor and optimize databases in Production Environment.
Better expose in writing TSql.
Managing and monitoring Replication.
Create and administer automated SQL Server jobs, notification, alerts.
Creating packages using Sql Server Integration Services.
Data Migrations.
Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments.
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

Software Skills:

Operating System: Dos, Unix,Windows NT, Windows 2003/2008
Languages: C, c#, vb.net, asp.net
Database: Ms Access, Ms Sql server 2000/2005/2008/2012
Script: Html, Java script, Xml
Tools: Red Gate, Litespeed, BPA, SqlIoSim, Profiler.

Strengths:
Fair to learn more in the field of Database Technology and master things thoroughly and quickly, to meet tight schedules and deadlines.

General Information:

Date of Birth (DD/MM/YYYY): 28/05/1982
Sex:  Male.
Marital Status: Married
Nationality: Indian.
Languages Known: English, Hindi, Oriya
Hobbies:  Chess, listening to music, surfing Net.       

0 comments:

Post a Comment