Freelancer logo How It Works Browse Jobs Log In Sign Up Post a Project
EXPLORE
Microsoft SQL Server SQL T-SQL (Transact Structures Query Language)
Profile cover photoundefined
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 user.
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
$60 USD / hour
Flag of INDIA
nagpur, india
$60 USD / hour
It's currently 10:55 AM here
Joined December 14, 2016
0 Recommendations

Devendrakumar S.

@dhanuitdevendra

annual-level-two.svgverified.svg
4.9 (7 reviews)
5.4
5.4
$60 USD / hour
Flag of INDIA
nagpur, india
$60 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
40%
Repeat Hire Rate

Database Consultant (18 years, 38 projects)

### Summary ### + 18 years experience as DBA & data architect + 8 years experience as an independent consultant + 38 data centric projects + Certified DBA - SQL Server, MongoDB, HP Vertica + Ex-Microsoft CSS [SQL 3T] ### Top Qualities ### + Straight talk + Minimalist + Goal-oriented ### Tech. Roles ### + Data Architect + Database Administrator + Database Consultant ### Tech. Skills ### + Primary: SQL Server (2000 and later), T-SQL + Secondary: Oracle, MySQL, PostgreSQL, MongoDB, Vertica, Erwin + Other: Windows, Linux, AWS, Azure ### Work Experience ### + Database Consultant @ [login to view URL] [2014 - Present] + DBA & Data Architect @ Many [2004 - 2013] ### Work Preference ### + Remote only
Freelancer Microsoft SQL Server Professionals India

Contact Devendrakumar S. about your job

Log in to discuss any details over chat.

Portfolio Items

Title: [1-day-delivery] Troubleshoot SQL Server backup and restore operations
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Backup, Restore
Description: You want to troubleshoot and fix SQL Server backup and restore operations.
+ Backup and restore operations take a long time
+ Issues that affect database restoration between different SQL Server versions
+ Backup job issues in Always On environments
+ Media-related errors when you restore a database from a backup
+ Backups fail because of permissions issues
+ Backup or restore operations that use third-party backup applications fail
+ Miscellaneous issues


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1 database
+ Fixed-price: $100


### Work Breakdown ###
+ Troubleshoot the long running Backup and restore operations
+ Troubleshoot database restoration between different SQL Server versions
+ Troubleshoot issues in Always On environments
+ Troubleshoot media-related errors
+ Troubleshoot permissions issu
[1-day-delivery] Troubleshoot SQL Server backup and restore
Title: [1-day-delivery] Troubleshoot orphaned users (SQL Server)
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Connectivity
Description: You want to troubleshoot and fix orphaned users (SQL Server).


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1-10 logins
+ Fixed-price: $100


### Work Breakdown ###
+ Detect Orphaned Users
+ Resolve an Orphaned User


### Out of Scope ###
+ Root Cause Analysis (RCA)


### Deliverable(s) ###
+ Quick fix only
+ The user should get mapped to the logins.


### Prerequisite(s) ###
+ Database server access
+ Screen sharing, if applicable
[1-day-delivery] Troubleshoot orphaned users (SQL Server)
Title: [1-day-delivery] Troubleshoot Full-Text Indexing
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Full-Text Indexing
Description: You want to troubleshoot and fix Full-Text Indexing.
+ The full-text index exceeds the limit for the number of rows that can be contained in a full-text catalog.
+ A clustered index or full-text key index on the table being indexed gets altered, dropped, or rebuilt.
+ A hardware failure or disk corruption results in the corruption of the full-text catalog.
+ A file group that contains the table being full-text indexed goes offline, or is made read-only.


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1 server
+ Fixed-price: $100


### Work Breakdown ###
+ Examine the full-text population(crawl) log.
+ Analyze and fix the underlying issue.


### Out of Scope ###
+ Root Cause Analysis (RCA)


### Deliverable(s) ###
+ Quick fix only
+ The full-text index population should complete without issues.


### Prerequisite(s) ###
+ D
[1-day-delivery] Troubleshoot Full-Text Indexing
Title: [1-day-delivery] Troubleshoot database mail issues in SQL Server
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Database Mail
Description: You want to troubleshoot and fix database mail issues in SQL Server.


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1 server
+ Fixed-price: $100


### Work Breakdown ###
+ Verify that database mail is enabled
+ Verify that users are properly configured to send mail
+ Verify that database mail is started
+ Retry mail delivery


### Out of Scope ###
+ Root Cause Analysis (RCA)


### Deliverable(s) ###
+ Quick fix only
+ You should be able to send email with database mail.


### Prerequisite(s) ###
+ Database server access
+ Screen sharing, if applicable
[1-day-delivery] Troubleshoot database mail issues in SQL Se
Title: [1-day-delivery] Troubleshoot connectivity issues in SQL Server
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Connectivity
Description: You want to troubleshoot and fix SQL Server connectivity issues.
+ A network-related or instance-specific error occurred while establishing a connection to SQL Server
+ "Cannot generate SSPI context" error when using Windows authentication to connect SQL Server
+ Troubleshooting "Login failed for user" errors
+ Timeout expired messages when connecting to SQL Server
+ An existing connection was forcibly closed by the remote host
+ Users may not be able to connect remotely to SQL server using TCP/IP protocol
+ The certificate received from the remote server was issued by an untrusted certificate authority error when you connect to SQL Server


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1-10 logins
+ Fixed-price: $100


### Work Breakdown ###
+ Verify that the instance is running
+ Verify that
[1-day-delivery] Troubleshoot connectivity issues in SQL Ser
Title: [1-day-delivery] Troubleshoot cluster service fails to start issue
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Cluster Service
Description: You want to troubleshoot and fix cluster service fails to start issue.


### Management ###
+ Fixed-time: 1 working day(s)
+ Fixed-scope: 1 cluster service (non-prod)
+ Fixed-price: $100 ($500 for production server)


### Work Breakdown ###
+ Check the ports that the cluster service uses
+ Run the cluster validation tool
+ Check the security policies that might affect the cluster node
+ Temporarily disable firewalls
+ Check the network hardware and software for issues


### Out of Scope ###
+ Root Cause Analysis (RCA)


### Deliverable(s) ###
+ Quick fix only
+ The cluster service should start and run as expected.


### Prerequisite(s) ###
+ Database server access
+ Screen sharing, if applicable
[1-day-delivery] Troubleshoot cluster service fails to start

Reviews

Changes saved
Showing 1 - 5 out of 7 reviews
Filter reviews by: 5.0
$3,575.00 USD
Very satisfied with Devender's work, he pulled us through some very tough situations. I will hire him again should there be a need. and Highly recommend him.
.NET Azure Network Administration Microsoft SQL Server
A
Flag of Abdul B. @abasita
3 years ago
4.0
$300.00 USD
It was a pleasure working with Dev, looking forward to continuing working with dev. we got our project done on time with a professional top notch service!
SQL MySQL Amazon Web Services Database Administration
+1 more
User Avatar
Flag of Asp Global T. @iamcjones
3 years ago
5.0
$500.00 USD
Very knowledgeable completed task quickly. Thanks
SQL MySQL Amazon Web Services Database Administration
+1 more
K
Flag of Robert M. @kd4pbc
5 years ago
5.0
$500.00 USD
Thanks great job
SQL Microsoft Access MySQL PostgreSQL Microsoft SQL Server
K
Flag of Robert M. @kd4pbc
5 years ago
5.0
$25,000.00 JMD
Result was what we expected
SQL Software Testing Database Administration
User Avatar
Flag of Asp Global T. @iamcjones
5 years ago

Experience

Database Consultant

devendrashirbad.in
Sep 2013 - Present
http://devendrashirbad.in

DBA & Data Architect

Many
Jun 2004 - Sep 2013 (9 years, 3 months)
DBA & Data Architect @ Many [Jun 2004 - Sep 2013]

Education

Master of Business Administration (MBA) - Information Technology

Nagpur University, India 2005 - 2007
(2 years)

Bachelor of Commerce (BCom) - Computer Applications

Nagpur University, India 2002 - 2005
(3 years)

Qualifications

Microsoft Certified IT Professional - Database Developer

Microsoft
2010
Microsoft Certified IT Professional - Database Developer

Microsoft Certified IT Professional - Database Administrator

Microsoft
2010
Microsoft Certified IT Professional - Database Administrator

Publications

LinkedIn

LinkedIn
https://www.linkedin.com/in/devendra-shirbad

GitHub

GitHub
https://github.com/Devendra-Shirbad

MongoDB University

MongoDB University
https://university.mongodb.com/certified_professional_finder/certified_professionals/143421

SQL Server Central

SQL Server Central
https://www.sqlservercentral.com/forums/user/devendra-dev-shirbad

Credly

Credly
https://www.credly.com/users/devendra_shirbad/badges

Contact Devendrakumar 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

Certifications

sql-server-2.png SQL Server 2 90% SQL_3.png SQL 3 87% preferredfreelancer-1.png Preferred Freelancer Program SLA 1 87% sql-server-3.png SQL Server 3 77%

Top Skills

Microsoft SQL Server 6 SQL 4 T-SQL (Transact Structures Query Language)

Browse Similar Freelancers

Microsoft SQL Server Professionals in India
Microsoft SQL Server Professionals
SQL Developers
T-SQL Developers

Browse Similar Showcases

Microsoft SQL Server
SQL
T-SQL (Transact Structures Query Language)
Previous User
Next User
Invite sent successfully!
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
There is no internet connection
Loading preview