Profile Summary:

• Around 5+years of Relevant IT experience in web applications and database management;with 4+ years of experience as a SQL Server DBA.
• Proficiency in maintaining SqlServer 2000 and SqlServer2005 databases.
• Experience in design of databases and building referential integrity constraints.
• Done installation,configuration and maintenance in SQL Server.
• Good backend skills in creating SQL objects like tables,stored procedures,views,indexes,triggers,rules etc.
• Very good T-SQL programming skills.Experience in query optimization,performance tuning etc.
• Used query analyzer,SQL profiler,Execution plan,Performance monitor and DBCC commands.
• Has good knowledge in software development life cycle and excellent communication skills.
• Got a certificate from Microsoft for the completion of the project inventory management in .NET Technologies.
• Likes to work in a team with a competitive spirit to excel.
• Providing support on technical issues in SQL Server.

Professional Summary:

• Currently working as Senior Software Engineer in Confidential from Nov 2010 to Till Date.
• Worked as Technical Consultant in Confidential--Dubai from Nov 2009 to May 2010.
• Worked as SQL Server DBA/Programmer in Confidential--Visakhapatnam from Feb 2009 to Nov 2009.
• Worked as SQL ServerDBA/Programmer in Confidential--Visakhapatnam from Sep 2007 to Feb 2009.
• Worked as Programmer in Confidential- Visakhapatnam from Jul 2006 to Sep 2007.

Techinical Skills:

Databases : SQL Server2008/2005/2000,Oracle. MSBI : SSIS,SSRS,SSAS Technologies : Asp.Net 1.1/2.0/3.5. Operating Systems : Windows XP,Windows 7 /2003 Server Languages : VB.Net, C#.Net Internet Technologies : XHTML,HTML,JavaScript,XML,JQuery,Dhtml. GUI : .NET 2003/05, Dream Weaver. ERP : Navision,LS Retail Reports : Crystal Reports.

Credentials:

• Achieved First Class in Btech (Computer Science & Information Technology)

Project Profile:

Project #1 Title : AMO Employer : Confidential Period : Nov 2010 - Till Date Team Size : 4 Database : Sql Server 2005. Role : Database Adminstration

Description: The tool ATOM400 helps to migrate the Legacy Application(AS400) to .net environment.This tool helps to migrate all the files like .cbl,display,spool files . ...etc into corresponding .net enviroment,all the AS400 behaviors are emulated using the ATOM400 Framework.After Migrating the legacy application,the target applications runs in a web. Responsibilities:

• Installed & configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Participated in meetings impacting databases physical design.
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Database recoveries as per requirements.
• Conducted root cause and analysis for database incidents and problems.
• Developed & executed scripted changes requests in accordance with change control procedures.
• Set up Log Shipping, MSSQL Mail, SMTP.
• Providing production support for the database and application issues

Project #2 Title : Union Coperative Society Employer : Confidential Period : Nov 2009 - May 2010 Team Size : 4 Technologies used : LS Retail,Navision5.0(Dynamics) Database : Sql Server 2005. Role : Database Adminstration

Description: Confidential is a chain of Hypermarkets having 7 outlets in major residential areas in Dubai. It offers the best consumer products at the best prices that exceed the customer’s expectations, through an on going expansion, implementation of sophisticated and effective policies executed using the most modern technologies and advanced systems by outstanding national management. Ensuring the continuity of goods availability and good service by offering a wide range of goods with the highest quality, good inventory management and the monitoring of vendors performance to broaden the customers base to include all segments of the community. Responsibilities:

• Implemented database standards and naming convention for the database objects.
• Performing DBCC commands to check database consistency.
• Creating Database maintenance plans.
• Taking backups at regular intervals and storing them.
• Checking whether all scheduled jobs are running successfully or not.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Application and Database Maintenance.

Project #3 Title : Cramster Employer : Confidential Period : Feb 2009 - Nov 2009 Team Size : 2 Technologies used : ASP.NET 2.0, Vb.Net Database : Sql Server 2005 Role : Database Administration

Description: Confidential is a global study community comprised of students and teachers helping each other understand how to solve problems for mathematically-based subjects (e.g. Physics, Calculus, Stats, Chemistry, ME, EE, CS, etc). Cramster provides access to various types of study material (e.g. textbook solutions, topic notes, sample problems, practice exams) created by us, indexed from the web, or contributed by our members. As an online study group, Cramster fosters social learning through the Cramster Q&A board where members ask and answer questions moderated by Cramster Subject Matter Experts. Responsibilities:

• Responsible for installation and configuration of SQL Server 2005.
• Developing SQL Scripts for maintaining administration tasks.
• Updating latest service packs and security patches.
• Implementing stand by servers.
• Diagnosing problems using SQL Server profiler.
• Created database objects like tables,stored procedures,views,triggers for this project.
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
• Managed security by defining roles and rights.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Taking backups at regular intervals and storing them.
• Checking whether all scheduled jobs are running successfully or not.
• Application and Database Maintenance.
• Providing production support for the database and application issues.

Project #4 Title : Jagruti Foundation Employer : Confidential Period : Oct 2007 - Feb 2009 Team Size : 2 Technologies used : ASP.NET 2.0, C#, XHTML Database : Sql Server 2005 Role : Database Adminstration.

Description: Confidential is the organization dedicated towards holistic development of rural India for inclusive growth of the whole nation. It initiated a special project called National Skill Development program to develop competent manpower for the Hospitality and Tourism industry. The foundation aims to achieve its ultimate goal of inclusive growth by supporting the Hospitality & tourism industry with the required manpower as well as supporting the rural BPL family with the opportunity of dependable livelihood. Responsibilities:

• Responsible for installation and configuration of SQL Server 2000.
• Implementing Microsoft client/server products.
• Creating Clustered and Non Clustered Indexes and referential integrity constraints.
• Involved in user requirements,analysis,design documentation.
• Developed various T-SQL procedures for the application.
• Extensively used Enterprise manager,query analyzer and SQL Server Profiler.
• Created database objects like tables,stored procedures,views,triggers for this project.
• Implemented database standards and naming convention for the database objects.
• Creating Database maintenance plans.
• Taking backups at regular intervals and storing them.

Project #5 Title : Signup pages Employer : Confidential Period : Jan 2007 - Sep 2007 Team Size : 3 Technologies used : ASP.NET, C#.Net Database : Sql Server 2000 Role : Programmer

Description: The signup pages are designed to signup for the users in order to access the different programs like free softwares,players etc. It includes details like different packages and payment details. The users are registered based on their credit card transaction through payment gateways Responsibilities:

• Design the database management system.
• Implemented Ajax Technology according to the requirements.
• Implemented Fraudlabs Web service for Creditcard Validation.
• Designed User Controls for headers.
• Maintaining the application as per user requirement.
• Client side implementation and testing.
• Install configure and upgrade of SQL Server.

Project #6 Title : Members Area. Employer : Confidential Period : Oct 2006 - Jan 2007. Team Size : 4 Technologies used : ASP.NET, C#.NET. Database : Sql Server 2000 Role : Programmer

Description: Members Area Contains different Programs.It consists of two modules.

Module 1: User Users who are registered in the signup pages can access this site. The site consists of various free downloadable softwares, programs and movies which are updated frequently by the admin.

Module 2: Admin The admin panel of Members Area can monitor all the users and programs that are present in the database. Admin can change and alter all the data of registered and un-registered users and programs in the site.

Responsibilities:

• Developing the admin panel in the backend.
• Made many enhancements to the existing live portals.
• Performed Unit Testing
• Created Reports in the backend.
• Used visual source safe 6.0 as version control system.
• Application Maintenance.