SQL Server database Admin
Worked on the below: -> Security -> backup -> High Availability solutions -> Performance monitoring and resolving issues -> Database designing, data modeling
Sobre Mim
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. • Implemented and maintained Database mirroring Log Shipping as a Disaster Recovery Solution. • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers. • Experience in trouble shooting viewing error logs and application logs. • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. • Maintaining the database consistency with DBCC at regular intervals. • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications and rebuilding the indexes. • To analyze long running queries and tune the same to optimize application and system performance. • Involved in Weekly Change Management. • Monitored and modified Performance using execution plans. • Recovering the databases from backup in disasters.
$ 5 USD/h
NOVO FREELANCER!
