Lead Database Administrator
Wipro Technologies
مجموع سنوات الخبرة :16 years, 10 أشهر
SQL Server Database Administration Profile:
• Installation of SQL Server 2005 and SQL Server 2008 R2 Multi Instance Failover Clusters in Production, DR and Test Environments.
• Installation of Multiple SQL Server Versions within the Same Windows Server Cluster (SQL Server 2005 with SQL Server 2008R2)
• Up-gradation of SQL Server 2005 to SQL Server 2008 R2 in Production, DR and Test Environments.
• Installation of Stand Alone SQL Servers, Applying Service Pack/Hot fix.
• Database Back-up and Restoration, setting Database Recovery Model as per Business requirement.
• Configuring and Monitoring Log Shipping.
• Configuring and Monitoring Database Mirroring.
• Configuring and Monitoring Database Replication.
• Performed Performance monitoring with DMVs.
• Configuring Perfmon Counters and Real-time Perfmon Counters.
• Configuring and Monitoring Database Maintenance Plans.
• Configuring Database Mail Profile, Account and Operator to Configure Email Alerts.
• Checking the Database Integrity using DBCC.
• Detach /Attach databases for purposes of upgrading and creation of development environments.
• Performing SQL Server/Database/Security Migrations.
• Transferring of Data between SQL Servers with Import/Export Wizard.
• Creating/Modifying SSIS Packages with Business Intelligence Development Studio.
• Import/Export of SSIS packages in Integration Services.
• Creating Tables, Views, Stored Procedures, Functions, Cursor and Database snapshots.
• Creating/Managing Indexes, Rebuild/Reorganize of Indexes to ensure Database Performance.
• Monitoring Service accounts and changing passwords at regular interval of times.
• Managing User Security by creating Login, Users, Groups and assigning SQLServer/Database Roles.
• Involved in Design and Development of Disaster Recovery Plan.
• Managing Database Alerts.
• Monitoring SQL Server Logs and Analyzing Security Events.
• Monitoring System and Application Events.
• Creating Backup devices and Linked Servers.
Couchbase NoSQL Server Administration:
• Couchbase Server is an Open-Source, distributed, NoSQL, Document Oriented Database for latency sensitive, Interactive, Always-On (24*7) Applications.
• Administration of Server through Web URL.
• Creating and Maintaining Data Buckets.
• Backup and Restore of Data Buckets from Linux Server.