Twelve plus years of IT experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2005, MS SQL Server 2000, 7.0 in Production, Test, Development Replication& Cluster Server Environments. Ø Expertise in installation, upgrade and configuration of MS SQL Server and databases in clustered and unclustered environments.
Ø Excellent knowledge in Performance tuning using various SQL Server Commands and DTA (Database Tuning Advisor)
Ø Design and document Logical and Physical data models using various tools like ERWin and Visio.
Ø Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement.
Ø Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
Ø Experience in migration of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS and SSIS.
Ø Experience with SQL Server 2005, DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
Ø Excellent knowledge in system tables and system stored procedures using T-SQL.
Ø Designing and documenting of SQL Server Strategies and plans for DR, Change control management and security policies.
Ø Creation and maintenance of databases, creating roles and managing user permissions.
Ø Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
Ø Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional in 2005 environment.
Ø Experience in using tools like SQL Profiler, Windows Performance Monitoring utility and performance counters for monitoring and Tuning MS SQL Server Performance, Idera Diagnostic manager, Quest Spotlight and NetIQ
Ø Expert in using Third Party backup solutions for MS SQL Server like SQL Litespeed.
Ø Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking.
Ø Experience in installation and configuration of Cluster SQL Server in Active/Passive in SQL Server 2000/2005.
Ø Experience in SQL Server Reporting Services (SSRS).
Ø Overall understanding and knowledge on implementation of Log shipping for DR solutions in MS SQL Server 2000/2005.
Ø Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and DTS.
Ø Experienced in managing systems and staff in high-availability environments across multiple data centers in compliance with Sarbanes-Oxley, SEC, NASD and other regulations.
Ø Good knowledge on Database Designing, Data warehouse design.
Ø Experience in working with Windows 2000/2003 Enterprise Server and Windows NT Server - Installation and Administration
Ø Knowledge in documentation of backup and recovery strategies for production environment.
Skill Levels
1. Very Little Experience – Have used it some before. Could easily learn more about it if needed.
2. Little Experience -Have used it on a daily basis some time in the past, or have just used basic Features.
3 .Experience – Average familiarity with the technology. Use it somewhat regularly. Maybe thoroughly trained in the technology, but without a great deal of experience.
4. Strong Experience – Use it on a daily basis. Proficient in the use of the technology.
5. Very Strong Experience – Expert in the technology. Train peers in certain aspects of the technology.
Skill Level Matrix:
SQL Server 7.0 | 5 | Data Warehouse | 5 |
SQL Server 2000 | 5 | Log shipping | 5 |
SQL server 2005 | 5 | T-SQL | 5 |
All types of Replication | 5 | Stored Procedure | 5 |
Database Maintenance | 5 | Import, Export, DTS | 5 |
Communication & Technical Knowledge | 5 | Creating Jobs and Alerts | 5 |
SQL Server Administration | 5 | Performance Tuning | 5 |