18 years of Sr. Certified SQL Server DBA available Immediately

[Jay Chauhan]

Here are the details of my available consultant.
Please revert back to me for resume in Word Format and Contact details.
Please feel free to call/email me for further information.


Thanks,
Jay Chauhan
cyberThink Inc
===================================================================
Sr. Certified SQL Server DBA
Availability           : Immediate
Present Location       : IL
Location               : Open

SUMMARY OF QUALIFICATIONS:
•    Over EIGHTEEN Years of experience in IT Industries out of which more than TEN Years of experience on MS SQL Server 2005/2000/7.0 Database Administration on MS Windows 2003/2000/NT 4.0.
•    Microsoft Certified Database Administrator (MCDBA) (MS SQL Server 7.0/ 2000).
•    Microsoft Certified Professional (MCP ID).
•    Extensive experience in MS SQL Server Database Administration including Planning, Installation, Deployment/Implementation, Advanced Configuration of MS SQL Server 2005/2000/7.0 as per Microsoft Operation Framework (MOF) guidelines. Experience of Installation of SQL Server 2005.
•    Experience in planning and implementing Security Model for specific business environment using MS SQL Server on Windows 2000/NT 4.0.
•    Experience in using Native Tools for Performance Tuning and Monitoring of MS SQL Server 2000/7.0. Experience in Data transfer and Transformation using tools like DTS, BCP.
•    Expertise in MS SQL Server databases backup/restore, disaster recovery and service packs installation strategies.
•    Extensive Experience in setting up SQL Server Databases in a lab environment and duplicate the functionality of the SQL Server in Development, Test/Acceptance and Production environment.
•    Experience in Designing and implementation of Performance Tuning and Maintenance plan.
•    Experience in Creation and maintenance of Databases, creating Roles and managing user permissions, Backup and Restore activities, Resolving deadlocks.
•    Good understanding of planning and implementing the Replication of MS SQL Server Databases.
•    Experience in conversion of dBase and FoxPro databases to SQL Server databases.
•    Experience in Up gradation/Migration of MS SQL Server 7.0 to MS SQL Server 2000.
•    Experience in Migration of dBase to MS SQL Server 7.0.
•    Understanding of Log Shipping in Microsoft SQL Server 2000.
•    Good understanding of Cluster Servers.

CERTIFICATIONS:
•    Microsoft Certified Technology Specialist (MCTS) (MS SQL Server 2005)
•    Microsoft Certified Database Administrator (MCDBA) (MS SQL Server 7.0/ 2000).
•    Microsoft Certified Professional (MCP ID).

TECHNICAL SKILLS:
Operating Systems:     MS Windows 2000/NT4.0 server, MS Windows 2000/NT 4.0/XP/9.x clients.
DBMS:     FoxPro, dBase with Clipper.
RDBMS:    MS SQL Server 2005/2000/7.0
Network Protocols:     TCP/IP on Windows 2000/NT 4.0.
Tools:     Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Database Maintenance Plan Wizard, Data Transformation Services (DTS), Bulk Insert and BCP.
Hardware:    Compaq Servers with dual 1.8 GHz Intel processors, 4GB RAM, RAID 1 and 5 HDD.
Languages:    T-SQL, COBOL.

PROFESSIONAL EXPERIENCE:

Feb’08 – Current                                                                 State Farm Insurance              
SQL DBA                                    Bloomington, IL
Achievements:
•    Day-to-day Technical Support on MS SQL Server 2005 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered) for Production/Test/Dev environment..
•    Handling SQL Server area for multiple ongoing Infrastructure projects like Vendor Contract Management, Witness and upgrade from SQL Server 2000 to SQL server 2005.
•    Implemented C2 like auditing and integration with Intrust application along with SQL 2005 SSRS.
•    To ensure all scheduled administrative jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.
•    Technical support to users for various purposes like Access change, performance issues and storage space managements on RAID/SAN drives.
•    Prepare RCA (Root Cause Analysis) using Profiler Trace, System monitor/Perform on counters with System Monitor on various issues for MS SQL Server.
•    Participate in Evaluation of existing setup/configuration and prepare/implement possible improvements for MS SQL Servers in (Clustered/non-clustered) environments used for as various applications. Recommend possible remedies for better performance and giving thought processes for upcoming SQL Server 2008.
•    Work in cooperation with developers/team for achievement of efficient database access for applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.  

Platform/Tools Used:
    Operating Systems    : MS Windows Advanced Server 2003, MS Windows XP Client
    RDBMS                        : MS SQL Server 2000 Enterprise and Developer Edition
Tools                           : SSMS, BIDS, SQL Server Surface Area Configuration, SQL Server Configuration
              Manager, Database Engine Tuning Advisor, SQL Server 2005 Profiler, SSIS, Enterprise
              Manager, Query Analyzer, System Monitor/Performance Monitor, Event  Viewer,
              SQL Profiler, DTS, Ticketing software