Senior Oracle Developer
Resume:
Sugam Agarwal___________________________________________________________
Mobile: 977-***-****
E-Mail: *.*****@*****.***
In quest of assignments in the domain of Sql Server Database Management to deliver solution for complex technical requirement along Project Management
PROFESSIONAL ABRIDGEMENT
A dynamic professional with nearly 3 years of rich experience in Sql Server Database Management. Currently Associated with Zycus Infotech Pvt ltd., Mumbai as Database Administrator. Expertise in
Providing the support to development team, analyzing the performance of servers. Demonstrated abilities in
Analyzing information system needs, evaluating end-user requirements, troubleshoot for complex Sql server Problems. Deft at carrying out risk analysis, impact analysis, project review and documentation. Strong problem Solving & Technical Skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs.
CAREER CONTOUR
Since oct’08 Zycus Pvt. Ltd, Mumbai as Database Administrator
May’08 - Oct’08 Zenith InfoTech ltd as Database Administrator
Aug’07 – May’08 Sparsh Bpo, Gurgaon as Database Engineer
(Through Trimax Computers Ltd)
Core Competencies:
Sql Server Administration
Installation of Sql Servers.
Migration of Sql Servers Database.
Upgrading of Sql servers.
Recovery of Sql Servers as well as Databases.
Implementing new Service pack, hot fix, patches etc.
Creation of Logins and users.
Monitoring Sql server for any performance issues with the help of Profiler, perfmon, Server side trace.
Monitoring and creating indexes statistics.
Analyzing the Database what’s the causes and how can we resolve that.
Implementing Log shipping on Production Servers.
Creation of Backup and Recovery Strategies on Servers.
Document Disasters Recovery Solution for all of the servers.
Document all the Sql Server scripts that are used for user migration, Database restore, Space Management, Report Creation etc.
Automation all possible jobs related to Backup, Index Tuning, integrity checks, update statistics.
Creating Script of Functional Databases.
Maintaining the Job Failure and error log reports.
Implementing Database Mirroring and replication on development servers.
Developing application for checking Sql Server Analysis services
Migrating the whole sql server with 0 % downtime.
Creating backup script for Analysis services.
Creating spript to take backup ,rar and then import to our local server and also automate various
things in sql server.
Created dts packages for import and export.
Currently working on centralizing all the database backup files on single server.
Major Project Handled
Migration of Sql Servers Database from Sql Server 2000 to Sql Server 2005
Up gradation of Sql Server from Sql Server 2000 to Sql Server 2005.
Implementing the Log Shipping.
Implementing the Backup and Recovery Schedule on MySql Server.
Recovery of Corrupt Sql Server after Service Pack Sp3 Installation.
Resolving the Performance problem migrating the Sql Server files to other drives or other file groups.
Project Details
Company Name Zycus Infotech ltd.(Product Based company)
Clint Name In-house Database
Team Size 2
Project Details : Migration of Sql Servers Database from Sql Server
2000 to Sql Server 2005. Up gradation of Sql Server
From Sql Server 2000 to Sql Server 2005.
Implementing the Log Shipping.
Implementing the Backup and Recovery Schedule on
MySql Server.
Recovery of Corrupt Sql Server after Service Pack
Sp3 Installation.
Resolving the Performance problem migrating the Sql Server files to other drives or other file groups.
Company Name Zenith InfoTech Ltd.
Clint Name In-house working on project SAAZ
Team Size 4
Product User Sql Server Datacenter Edition
Project Details : Migration of Sql Servers Database from Sql Server
2000 to Sql Server 2005. Up gradation of Sql Server
From Sql Server 2000 to Sql Server 2005.
Implementing the Log Shipping.
Resolving the Performance problem migrating the Sql Server files to other drives or other file groups.
Company Name Spash BPO Gurgaon
Clint Name Working for many clients ICICI,XEROX,SBI etc
Team Size 4
Product User Sql Server 2000 Enterprise Edition
Project Details : Migration of Sql Servers Database from Sql Server
2000 to Sql Server 2005. Up gradation of Sql Server
From Sql Server 2000 to Sql Server 2005.
Implementing the Log Shipping.
Recovery of Corrupt Sql Server after Service Pack
Sp3 Installation.
Resolving the Performance problem migrating the Sql Server files to other drives or other file groups.
SCHOLASTICS
• B.Tech from Ajay Kumar Garg Engineering College. 2006
• 12th From Little Scholar School. 2001
• 10th From Krishna Public Collegiate. 1999
IT SKILLS
Platforms windows NT/2000/XP
Languages C, C++, Java/J2ee
RDBMS Sql Server 2000/2005, Ms Access, MySql Server (Basics)
Web Technologies HTML
Packages Microsoft Office (Excel, Word, Power Point)
Technical Skills
Sql Server 2005 and Sql Server Administration Skills.
PERSONAL FORTE
Date of Birth 22/08/1983
Address 2/503 Shri Swami Samarth Society near pawan bagh Malad (W) Mum.
Contact this candidate