EXPLORE

Database Administration Database Programming eCommerce Microsoft SQL Server SQL
Profile cover photo
User Avatar

Swapnil S.

@swapnilshrungare

0.0
0

0.0

0.0

0%

Database administration- SQL Expert - Database Development

$10 USD / Hour

Flag of

India (6:42 AM)

Joined on October 1, 2014

$10 USD / Hour

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.

Verifications

Portfolio

Portfolio

1977563
1977563
Reviews
0 Reviews

No reviews to see here!

Experience

MS SQL SERVER DBA

Aug, 2014 - Present

11 years, 11 months

NDS Infotech

Aug, 2014 - Present

11 years, 11 months

• 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.

Aug, 2014 - Present

11 years, 11 months

MS SQL DBA

Dec, 2013 - Jul, 2014

7 months

Igate global solution

Dec, 2013 - Jul, 2014

7 months

• 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

Dec, 2013 - Jul, 2014

7 months

MS SQL DBA

Aug, 2011 - Nov, 2013

2 years, 3 months

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.

Aug, 2011 - Nov, 2013

2 years, 3 months

Education

University of Mumbai

2006 - 2011

5 years

B.Sc.

Flag of

India

2006 - 2011

5 years

Qualifications

Mongo DB For DBA

2015

Mongo DB

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

2015

Microsoft Certified Professional

2014

Microsoft

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

2014

Microsoft® Certified Solutions Expert

2014

Micosoft

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

2014

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)