Logo freelancerCách Hoạt ĐộngTìm công việc Đăng Nhập Đăng Ký Đăng dự án
KHÁM PHÁ
Microsoft SQL Server SQL T-SQL (Transact Structures Query Language)
Profile cover photoundefined
Bạn đang theo dõi .
Lỗi khi theo dõi người dùng.
Người dùng này không cho phép người dùng khác theo dõi họ.
Bạn đã theo dõi người dùng này rồi.
Gói thành viên của bạn chị cho phép 0 lượt theo dõi. Hãy nâng cấp lên ở đây.
Đã bỏ theo dõi người dùng thành công.
Lỗi khi bỏ theo dõi người dùng.
Bạn đã đề xuất thành công
Lỗi khi đề xuất người dùng.
Đã xảy ra lỗi. Hãy làm mới trang và thử lại.
Đã xác thực email thành công.
Avatar người dùng
$60 USD / giờ
Cờ của INDIA
nagpur, india
$60 USD / giờ
Hiện ở đây là 3:01 SA
Đã tham gia vào ngày tháng 12 14, 2016
0 Khuyến nghị

Devendrakumar S.

@dhanuitdevendra

annual-level-two.svgverified.svg
4,9 (7 nhận xét)
5,4
5,4
$60 USD / giờ
Cờ của INDIA
nagpur, india
$60 USD / giờ
100%
Công Việc Hoàn Thành
100%
Đúng Ngân Sách
100%
Đúng Thời Hạn
33%
Tỉ Lệ Thuê Lại

DBA & Data Architect

Hello, Don't get caught up between the terms Relational or Non-Relational, SQL or NoSQL, On-Premise or Cloud, LatestBuzzWord. If the database doesn't fulfill business needs it's useless. I invite you to discuss your database problems with me. Please schedule a [30 min] One-on-One here. It's FREE. Thanks, Devendra Shirbad DBA & Data Architect 09.00 am – 06.00 pm (Mon – Fri) India --------------------------------------------------------------------- ### Summary ### * DBA & Data Architect with 19 years of experience * Independent Consultant with 9 years of experience * Hands-on data-centric projects * Ex-Microsoft Tier 3 Support Engineer for SQL Server * Certified DBA for SQL Server and 4 other databases ### Top Qualities ### * Straight talk * Minimalist * Goal-oriented ### Tech. Skills ### * Expert: Microsoft SQL Server * Advanced: Oracle, MySQL, PostgreSQL, MongoDB, Vertica, Erwin * Intermediate: Windows, Linux, AWS, Azure, Docker * Basic: Java, .Net, C++ ### Work Experience ### * DBA & Data Architect at Self-employed [2014 - Present] * DBA & Data Architect at Permanent/Full-time [2004 - 2013] ### Work Preference ### * Remote only
Freelancer Microsoft SQL Server Professionals India

Liên hệ Devendrakumar S. về công việc của bạn

Đăng nhập để trao đổi thông tin chi tiết thông qua chat.

Mục portfolio

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

Nhận xét

Đã lưu thay đổi
Hiện 1 - 5 trong số 7 nhận xét
Lọc nhận xét theo: 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
Cờ của Abdul B. @abasita
4 năm trước
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
Thêm 1
Avatar người dùng
Cờ của Asp Global T. @iamcjones
4 năm trước
5,0
$500,00 USD
Very knowledgeable completed task quickly. Thanks
SQL MySQL Amazon Web Services Database Administration
Thêm 1
K
Cờ của Robert M. @kd4pbc
5 năm trước
5,0
$500,00 USD
Thanks great job
SQL Microsoft Access MySQL PostgreSQL Microsoft SQL Server
K
Cờ của Robert M. @kd4pbc
5 năm trước
5,0
$25.000,00 JMD
Result was what we expected
SQL Software Testing Database Administration
Avatar người dùng
Cờ của Asp Global T. @iamcjones
5 năm trước

Kinh nghiệm

DBA & Data Architect

Self-employed
thg 9 2013 - Hiện tại
http://devendrashirbad.in

DBA & Data Architect

Permanent/Full-time
thg 6 2004 - thg 9 2013 (9 năm, 3 tháng)
* DBA & Data Architect at Permanent/Full-time [2004 - 2013]

Học vấn

Master of Business Administration (MBA) - Information Technology

Nagpur University, India 2005 - 2007
(2 năm)

Bachelor of Commerce (BCom) - Computer Applications

Nagpur University, India 2002 - 2005
(3 năm)

Bằng cấp

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

Nội dung đã đăng

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

Liên hệ Devendrakumar S. về công việc của bạn

Đăng nhập để trao đổi thông tin chi tiết thông qua chat.

Xác thực

Freelancer Ưa Thích
Đã Xác Thực Danh Tính
Đã Xác Thực Thanh Toán
Đã Xác Thực Điện Thoại
Đã Xác Thực Email
Đã Kết Nối Facebook

Chứng chỉ

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%

Các kỹ năng hàng đầu

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

Xem Các Freelancer Tương Tự

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

Xem Các Trường Hợp Tương Tự

Microsoft SQL Server
SQL
T-SQL (Transact Structures Query Language)
Người dùng trước
Người dùng kế tiếp
Đã gửi lời mời thành công!
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.