- High Point, NC, US
- £6 /hr
- Available now
Over 10 years of IT experience in MS SQL Server administration.
Working as a senior database adminitrator in the current project. Worked on setting up SQL Azure, implementingmore...Over 10 years of IT experience in MS SQL Server administration.
Working as a senior database adminitrator in the current project. Worked on setting up SQL Azure, implementing DR/ high availability solutions and best practices etc.
Worked as a project leader and release manager of a CRM product.
Excellent interpersonal and communication skills that allow me to communicate with stakeholders in Application Development, Network and Storage teams.
Experience in migrating databases to SQL Azure and also configured replication from on-premises to Cloud.
Experience in implementing Audit and security tools such as AppDetective and Imperva SecureSphere.
Experience in implementing and using tools such as Redgate SQLMonitor, HP SiteScope and Talisma CRM
Experience in implementing and using tools such as PowerCampus and MS Dynamics
Written PowerShell script to check the free disk space of databases on multiple servers, moving sql servers to home node after patching a cluster node etc.
Configured and maintained High Availability and Disaster Recovery Solutions such as Database Mirroring, Log-Shipping and different types of Replication Methods like Snapshot and Transnational replication.
Automated many SQL server Agent jobs such as backups, restores, performance monitoring, configuring alerts and maintenance plan and running them on a daily / weekly basis.
Worked on database security - created user logins, roles, policies and granted the necessary privileges and monitored for any Security issues such as any failed logins and any violation in the policy by reviewing the SQL server Error Logs.
Experience in migrating/ upgrading from SQL server 2000 to 2005 and 2008, SQL server 2005/ 2008 R2 to 2008/ 2012 and 2014, using In-place and side-by-side upgrade process.
Extensively used the native tools like Database Tuning Adviser, SQL Server Profiler, Performance
Database Administrator Onsite Lead