| Over Six years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
|
| Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2000.
|
| Experience in upgrading SQL Server from version 2000 to 2005.
|
| Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005.
|
| Good experience with SQL Server 2005 online Indexing and Recoveries features.
|
| Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
|
| Experience in Data Migration Management.
|
| Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
|
| Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
|
| Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
|
| Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
|
| Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
|
| Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
|
| Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
|
| Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
|
| Experience in applying patches and service packs to keep the database at current patch level.
|
| Experience in migrating packages from DTS to SSIS.
|
| Good experience with Analysis Services, Reporting Services, and SQL Server Clustering. |
TECHNICAL SKILLS |
Operating Systems: | Windows 2000/2003 Server, Windows 95/98/XP/NT |
Databases: | MS SQL Server 7.0/2000/2005, Oracle8/9i |
Languages: | T-SQL, PL/SQL, C, C++, and Core Java JDK 1.1 |
SQL Server Tools: | Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS) |
Report Tools: | MS Reporting Services, SAS |
Data Migration: | MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard |
Database Modeling & Other Tools: | ERWIN 4.x, Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare, SQL Trace |
Great goods from you, man. I have understand your
ReplyDeletestuff previous to and you're just extremely magnificent. I actually like what you have acquired here, really like what you are stating and the way in which you say it. You make it enjoyable and you still take care of to keep it smart. I can't wait to read much more from you.
This is really a terrific web site.
Feel free to surf to my webpage - Resting metabolic rate calculator
Hello! This is kind of off topic but I need some advice from an established blog.
ReplyDeleteIs it very hard to set up your own blog? I'm not very techincal but I can figure things out pretty quick. I'm
thinking about making my own but I'm not sure where to begin. Do you have any tips or suggestions? With thanks
Take a look at my blog post Home Staging MN
I really love your blog.. Excellent colors & theme. Did you create this
ReplyDeleteamazing site yourself? Please reply back as I'm planning to create my own website and would love to find out where you got this from or what the theme is named. Thanks!
Look at my blog: 1285muscle reviews