|
|
|
|
Home > Computers & Programming > Databases > MS-SQL > SQLMaster
|
|
|
SQLMaster
|
|
|
Expert in:
MS-SQL
|
Rating:
|
|
Languages:
English
|
|
Designing and supporting high availability SQL Server solutions,Installation and upgrading MS SQL Server 2000, 2005,2008(Express,Standard, Enterprise),Provide support in produ
|
|
|
|
|
|
|
|
|
|
|
Degrees
|
|
MCA Masters in computers applications,
Microsoft Certifified Database Administrator,
Microsoft Certified Professional,
Microsoft Certifified system administartor,
CCNA (Cisco certified Network Associate)
|
|
|
My Expert Service
|
|
1 Installing and upgrading SQL Server 2000, 2005, 2008(Standard, Enterprise).
2 SQL Server upgradation with new service packs and hot fixes.
• Renaming a clustered instance of SQL Server.
• Microsoft SQLServer2000,2005 clustering active/passive, mirroring and Log shipping
• Recovery of Disk, after losing master database.
• Creating databases, resizing, and renaming Database.
• Creating Database users, granting user privileges to the databases.
• Shrinking databases and data files and log files.
• Attaching, Detaching of Databases from one server to other using Enterprise management.
• Rebuilding indexes with SQL Server Enterprise manager.
• Backup and restoring of SQL Server 2000, 2005and 2008 Databases.
• Assigning and deleting SAN drives to the database servers.
• Configuration of SQL Mail Integration to use SQL Server Mail to use SQL Server Agent, MS outlook.
• Tune a Database with Database Engine Tuning Advisor (DETA) and SQL Server Surface Area Configuration Manager.
• Creating and maintaining scheduled jobs, jobs notification, and Maintenance plans.
• Responsibility for setting up database mirroring over multiple servers.
• Designing and supporting high availability SQL Server solutions that include log shipping, mirroring.
• Creating and Maintaining DTS (Database Transformation services) and SSIS
(SQL Server Integration Services)
• Experience setting up all three replications environment with update transactions.
• Troubleshooting, resolving data integrity and SQL Server performance.
• Using SQL Profiler, query Execution plans, trace flags and Perfmon to aide in Troubleshooting.
• Tune a database using Database Engine Tuning Advisor (DETA).
• Provide support in production and testing environments testing environments set up in and Configuration.
|
|
|
Experience & Qualifications
|
|
Masters in Computer Sciences, 8years experience in IT field, including programming,and administration,and as working as A Database Consultant in Banking Sector.
|
|
|
Available Modes Of Communication
|
|
email/chat
|
|
|
|
|
Contact
SQLMaster
|
|
|
|
|
|
|