Archive: DBA and SQL

Budget By arrangement

Posted: 5 years ago

Closed

Description: I am looking for a Freelancer on contract basis for one of our client in North America .Below are the details and description of works.Need to start Immediately. Let me know your interest.

• Expertise in backup/recovery, installation, configuration, troubleshooting.
• Monitoring and maintenance of production, test and development environments.
• Exposure to Database Mirroring, Log Shipping and Clustering.
• Implementing Database Security, administering user access permissions, roles and privileges.
• Managing Security (Creating users, logins and roles, granting permissions).
• Having experience on large size production Databases.
• Experience in client/server connectivity, Query Optimization, Performance Tuning.
• Monitoring free space, Database Performance and optimizing performance.
• Good experience on Clustering on SQL Server 2008,2012,2014 and 2016
• Daily activities include monitoring Database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.
• Good experience in resolving blockings and Deadlock Issues by using SQL commands.
• Checking daily error log file and troubleshooting accordingly.
Experience on performing migrations (also in-place) from SQL Server2008 to 2012
Skills:
Microsoft SQLServer,database,integrated development environment (IDE),performance tuning,test driven development (TDD),troubleshooting