Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Supported Customer service databases which are more than 2TB.
Implemented Log shipping and mirroring as a part of HA and DR.
Good hands On Log shipping and Mirroring.
Created AlwaysOn with two replica and three replica.
Performed patching to maintain current versions of SQL.
Responsibilities: Installing, configuring and administration of SQL Server Databases 2008/2012.
If you're in the construction business, you're probably familiar with our engineered lumber products, gypsum panels and other quality building materials.
If you're a consumer, you may recognize our household brands, such as Brawny® paper towels, Quilted Northern® bath tissue and Dixie® cups and tableware.
Georgia-Pacific is one of the world's leading makers of tissue, pulp, paper, packaging, building products and related chemicals.
SQL Server Database Administrator Deloitte - Rosslyn, WV
Complete Administration of MS SQL Server Databases is my primary responsibility Increased the Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients.
Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping, setting up servers from scratch on clustered environment, Linked servers.
Experience in Planning and executing disaster recovery (DR) exercises on the DR servers.
#Sql server business intelligence development studio 2015 upgrade#
Extensive experience in SQL server 2005 servers to 2008, SQL server 2008 servers to 2012 including Replication and clustered SQL Servers and as well as side-by-side upgrade process.
Expert in installation and configuration of MS SQL Server 2014/2012/2008/2005 Databases.
Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning.
Build Clusters 2 node and 3 node with Active -Active and Active- Passive.