Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$10 USD / hour
Flag of INDIA
mumbai, india
$10 USD / hour
It's currently 1:24 AM here
Joined October 1, 2014
0 Recommendations

Swapnil S.

@swapnilshrungare

0.0 (0 reviews)
0.0
0.0
0%
0%
$10 USD / hour
Flag of INDIA
mumbai, india
$10 USD / hour
N/A
Jobs Completed
N/A
On Budget
N/A
On Time
N/A
Repeat Hire Rate

Database administration- SQL Expert - Database Development

I am a talented and experienced Database Administration Administrator looking to be hired. I have many years of experience working in various facets like Database Administration, Database Development and Database Programming. I have earned a good reputation through working as a Database Development and a Database Programming for many companies world wide. I also have talent and expertise in eCommerce and SQL. You can count on me for your profitability. • Microsoft certified (MCSE, MCSA, MCTS) with more than 3.6 years of experience as SQL DBA (SQL SERVER 2000,2005,2008,2012,2014) • Perform installation, configuration and patching of SQL Server 2008 R2/2008/2005/2012/2014 in on premise as well as in Azure. • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks and SQL Server configurations. • Involved in planning, analysis and execution of many SQL database migration activities for various applications like AX, CRM, SharePoint and other customized applications. • Expertise with handling installation, configuration, applying service packs, hotfixes, Migration, and any security patches applicable to keep systems up to date. • Equally comfortable in installing, configuring and managing of SQL servers in standalone and failover cluster environment (Active/Active and Active/Passive). I have also installed, configured and managed SQL Azure (cloud environment). • Good experience in planning and implementation of SQL Server DR Environments using latest technologies like Always On, Database Mirroring, Log Shipping and SQL server Replications. • Managing over 200 SQL servers; and implementing standardization and robust backup mechanism using Team developed SQL tool. This tool takes care of monitoring and maintenance of all SQL servers and is fully configurable to adopt to each server configurations and requirements. The tool also alerts SQL team via email for any server/database level issues. • Hands on experience in logins and users management as per security and audit polices. • Good experience in providing 24 x 7 support on Production/UAT/Test and Development environment, On Call supporting, and managing 100% SLAs requirements for SQL Support team. • Daily monitoring of incidents, change requests & acting upon those pertaining to database issues/requests. • Creating Jobs, database maintenance plans and database mail setup as per the requirements.

Contact Swapnil S. about your job

Log in to discuss any details over chat.

Portfolio

1977563
1977563

Reviews

Changes saved
No reviews to see here!

Experience

MS SQL SERVER DBA

NDS Infotech
Aug 2014 - Present
• Daily SQL Server monitoring/maintenance tasks. • SQL migration Projects (from 2012, 2008 to 2014) • Regular SQL Backups and restoration activities • Installation and configuration of SQL Server • Applying latest Service Packs and hot fixes on SQL Servers • Implementing, Configuring and maintaining replication jobs • Managing SQL cluster and also providing suggestions to improve SQL performance in a cluster environment • Checking database consistency • Implementing maintenance plans for SQL Servers 2014,2012 , 2008 and 2005 • Development and code review for SQL development request/modules; which include TSQL, Stored Procedures • Active participation as application support team member i.e. providing server health check report, troubleshooting and responding to any reported client queries • Managing SLAs for SQL Server and Application Support tickets • Project related deployment activities within SQL server • Conducting knowledge transfer sessions for other members within/across team. • Successfully leading the Backend migration (SQL 2012 to SQL 2014) project for many applications.

MS SQL DBA

Igate global solution
Dec 2013 - Jul 2014 (7 months, 1 day)
• Daily SQL Server monitoring/maintenance tasks replication. • Regular SQL Backups and restoration activities • Monitoring and troubleshooting SQL server replication. • Managing SLAs for SQL Server and Application Support tickets • Migration of McDonalds delivery application data from MDS 1.0 to MDS 2.0

MS SQL DBA

Bombay stock exchange
Aug 2011 - Nov 2013 (2 years, 3 months)
• Performed installation & configuration of SQL Server 2008 R2/2008/2005/2000/2012. • Performed installation of SQL Server Service Packs and hot fixes • Database Users and login creation and permissions as per requirement. • Create Linked Servers to SQL Server and other databases. • Design database Backup and restoration Strategy as per the business requirement. • Monitoring database backup and other important maintenance tasks. • Monitoring the SQL Server error logs, application logs & troubleshooting backup failures if any. • From time to time recover the database to a specific point of time, as per requests. • Troubleshoot various problems that arise in a day-to-day work and fix the issues. • Managing and troubleshooting log shipping, and Mirroring process to keep the DR site updated. • Performing SQL server health checks • Developing SQL scripts for automating and maintaining SQL administration tasks • Periodic checking of all databases with DBCC commands for checking data consistency and integrity. • Rebuilding the indexes at regular intervals for better performance • Daily monitoring of incidents, change requests & acting upon those pertaining to database issues/requests. • Creating Jobs, database maintenance plans and database mail setup as per the requirements. • Installation of SQL SERVER to fail over cluster. • BCPDR Implementation (DR Drill): Planned and successfully implemented the BACKUP DISASTER RECOVERY PLAN between LIVE Trading and DR Server at different physical location, where LIVE Trading is carried out on DR Server instead LIVE Server, which include migrating of all various dept user to point to DR Location. • Log shipping Implementation: Successfully implemented high availability technique of Log Shipping between Production Server & Branch DR server.

Education

B.Sc.

University of Mumbai, India 2006 - 2011
(5 years)

Qualifications

Mongo DB For DBA

Mongo DB
2015
M102: MONGODB FOR DBAS http://university.mongodb.com/course_completion/ff442db3cf604fa9bf453df19741b91a

Microsoft Certified Professional

Microsoft
2014
Certification Number : F038-0681 Achievement Date : 10/17/2014 Certification/Version : Microsoft Certified Professional

Microsoft® Certified Solutions Expert

Micosoft
2014
Certification Number : F135-8772 Achievement Date : 12/24/2014 Certification/Version : Data Platform

Contact Swapnil S. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.