Required Consultant Senior Database administrator in India

₹75000-150000 INR

Closed

Posted

over 3 years ago

₹75000-150000 INR

Paid on delivery

Role & Responsibilities: 1`. Installing and Configuring SQL Server and Azure SQL Server. 2. Configured Always on in Azure SQL servers. 3. Migrating databases from 2012 to 2014 and 2012 to 2017. 4. Experience in configuring, monitoring and troubleshooting on Mirroring, Log Shipping and Replication, Mirroring, Clustering and Always On. 5. Monitoring the backup jobs from Microsoft Application Tools. 6. Configuring alerts to get the status of Mirroring and Log Shipping to mails. 7. Involved in DR-Drill activities. 8. Managing Security (Creating users, logins and roles, granting permissions) 9. Performance Monitoring and tuning. 10. Upgrade the SQL server from 2008R2 to 2014 server in cluster environment. 11. Configured the Always On setup in Azure servers. 12. Database refresh from Production to Testing Environment. 13. Migrating user databases from SQL Server to Azure SQL Server. 14. Scheduling jobs in SQL server and ran the manual re-index on user databases. 15. Identifying the long running quires and fixing them. 16. Monitoring the Performance of the servers from Microsoft Tools. 17. Working on disk space issues and performance issues. 18. 24 x 7 on call duties, Attend all times in case of emergencies.

MySQL

Microsoft Azure

Microsoft SQL Server

Database Administration

Project ID: 28989637

About the project

4 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹179,514 INR for this job

@kundansql

Hi there! I saw your project and I found some of the job responsibilities are related to my skill-set. I can analyse the prod box running SQL Server (version 2008-2019) to find the route cause of performance problem, problematic SQL Queries and fix them permanently. I can also do some work related to SQL Server Administration like automate backup and transaction log, create maintenance job, configure SQL Server for higher throughput. About me: I'm SQL Server Performance and Emergency Expert; with 5+ years of professional experience in 4 different high performance OLTP system and 4 freelancing projects. About SQL Server Performance: It's hard to make our server 100x faster - but it's really easy to make our database design and queries suddenly 100x more efficient. Fixing queries and tables and indexes is indeed hard work - but it's totally worth it. Warm regards, Kundan (Remote consultant)

₹120,000 INR in 30 days

5.0

(3 reviews)

2.7

@kallol29

Hi Team Myself is having 15 years + experience in different databases like Oracle, Sql server , Mysql, Mariadb, Cassandra, CouchDB , PostgreSQL etc . I am having experience it work in Project as well as Operation team . I can work with this project . For more information, please do contact me in chat .

₹155,556 INR in 30 days