SUMMARY:

• 6 years of IT experience in the field of Confidential Soft SQL Server Database administration.
• Experience in administering MS SQL 2000/2005/2008.
• Excellent experience in installation, configuration, database design (logical/physical).
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005.
• Experience in replication, log shipping setup and mirroring setup and troubleshooting.
• Experience in installing MS SQL multiple instances in windows cluster environment.
• Experience in SQL security management.
• Maintained over 3000 productions and pre - production and UAT servers and high availability (HA) of 24x7 production servers.
• Experience in handling 3+TB databases.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008.
• Experience in working with Confidential global clients and customers and handling high priority production issues over Email/phone.
• Managing projects within the Software Development Life Cycle (SDLC) and Project Planning and Implementation phase on all aspects of the engagement.
• Worked as Tier 3 support level and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 DB support team.
• Working and providing solutions on customer escalations
• Coordinating with business users for UAT and client acceptance for bug fixes in production environment
• Working with Confidential global customers and handling priority customer issues through SOC and worked with MSE.
• Experience in working with Incident and problem management tickets.
• Always try to achieve 100% SLA.
• Experience in assigning & reviewing tasks and imparting training & technical guidance to team members.
• Experience in providing database support for various escalations from different regions.
• Building and configuring production servers and installing the application, patches and fixes.
• Installed Service Packs & IPAKs (Service Pack with Hot fix) and MS SQL 2005.
• Handled Mission Critical servers including Confidential ’s customer and revenue data servers.
• Experience in writing batch scripts.
• Experience in Troubleshooting and resolving databases and server issues.
• Experience in TCP/IP, DNS and connectivity issues.
• Experience in SAN and Networking.

SKILLS / TOOLS:

Databases: MS SQL Server 2000/2005 & 2008

SQL Server 2000 Tools: Enterprise Manager, DTS, Query Analyzer, Client Network Utility, Server Network Utility, Profiler, Index Tuning Wizard

SQL Server 2005 & 2008 Tools: Query Editor, SQL Profiler, Database Engine Tuning Advisor, SSMS, SSIS, SSRS, SSCM, SQL Server Surface Area Configuration.

SQL Server Third Party Tools: Quest SQL Lite Speed 4.7

Programming Languages: SQL, T-SQL, HTML, VBScript, VB 6.0.

Front End Tools: MS Office 2000/2003/2007 , MS Visio, MS Project.

Servers: Windows Computer Cluster Server

Operating Systems: MS Windows Server 2003/2008 Standard/Enterprise Edition, Windows NT 4.0 Work Station/ Enterprise Edition, Windows XP Professional, HP Unix (DBA Level)

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Environment: SQL Server 2008

Responsibilities:

• Supporting 400+ servers for MS AdCenter Production/Sandbox and Pre-Production Environment.
• Supporting mission critical 3+ TB databases
• Installing SQL 2005/2008 in Production & Pre-Prod servers.
• Applying database patches in all the environments.
• Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment using DOS batch script with PsExec and Robocopy utilities.
• Handling multiple instances failover SQL cluster for SQL 2005 on Windows 2003.
• Handling multiple instances failover SQL cluster for SQL 2008 on Windows 2008
• Planned Disaster recovery with SQL 2008 Compression feature.
• Coordinating with Dev team and fixing issues on production.
• Handling DB Security issues.
• Configured database backups using SQL LiteSpeed.
• Setting up Log shipping & Replication.
• Rebuilding Indexes, Update statistics if required.
• Setting up SQL 2005 Dashboard reports for centralized monitoring.

Confidential

Developer

Environment: UNIX, Informix4gl

Responsibilities:

• Involved in migration from informixDB to SQL server
• Design and develop programs, debug identification, tagging and tracking applications.
• Perform verification and validation of all software systems.
• Interact with project team members relating to project status and results.
• Coordinate with developers on all processing issues.

Confidential

Support Engineer

Environment: Windows XP, .Net, Sql Server 2000 & 2005

Responsibilities:

As an SQL Server technical support engineer for Confidential, I was responsible for the following:

• Providing consultation on SQL Server to our vendors.
• Installing, configuring, administering and securing our as well as our clients' production servers.
• Troubleshooting performance issues.
• Implementing and administering database replication between SQL Server databases.
• Creating jobs to automate repetitive tasks.
• Upgrading and upsizing databases from earlier versions to the latest versions.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Ensuring high customer satisfaction rates.
• Working with issues which are very time consuming and complex.
• Researching customer problems and filing bugs.
• Participate actively in Confidential internal discussion forums to help Confidential employees in resolving the issues.
• Good knowledge on SQL server 2005 features like partitioning, logshipping, clustering etc..
• Implemented the following automation tasks in C#.net
• Written application in C#.net where we get automatic mail when ever sync fails between MS and vendors. Before doing this, we supposed to check the sync manually for all vendors for every 3 hours.
• Whereas this application checks the sync for every hour and sends us the mail whenever sync breaks. Due to this our initial response time has increased.
• Written application in C#.net where it extracts the files from Dublin location, it will take the location by querying the DB and copies the files into my local machine. Before using this application we supposed to copy the files from different Dublin locations and provide the files to vendors, which is very time consuming.
• After implementing this application most of our manual work has reduced and we can provide the files to requester as quickly as possible.
• Created a dashboard in SharePoint which is used to display the weekly, monthly bug report. For this we have written a C# code which is used to fetch the data from MS DB and copies into our local DB. We written a view and implemented SQL conditions in that view to display the data in excel sheet depending on the condition, we used pivot tables to do this. Finally, we used this excel sheet in SharePoint site to display the data.